Duckaurore | Voilà, j'ai une base de données MySQL et un serveur d'application JBoss, mes fenêtres s'affichent toutes mais j'ai des problèmes sur certaines manips, il me met le msg suivant :
Citation :
2004-10-27 17:49:17,442 WARN [org.jboss.resource.adapter.jdbc.WrappedConnection] Closing a result set you left open! Please close it yourself. java.lang.Exception: STACKTRACE at org.jboss.resource.adapter.jdbc.WrappedStatement.registerResultSet(WrappedStatement.java:803) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:297) at mypackage1.ListeValeursSessionBean.ListeValeurs(ListeValeursSessionBean.java:108) at sun.reflect.GeneratedMethodAccessor77.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.invocation.Invocation.performCall(Invocation.java:345) at org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulSessionContainer.java:521) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185) at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105) at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:153) at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62) at org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSessionInstanceInterceptor.java:294) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624) at org.jboss.ejb.Container.invoke(Container.java:854) at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:155) at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104) at org.jboss.invocation.MarshallingInvokerInterceptor.invoke(MarshallingInvokerInterceptor.java:55) at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46) at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55) at org.jboss.proxy.ejb.StatefulSessionInterceptor.invoke(StatefulSessionInterceptor.java:106) at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86) at $Proxy97.ListeValeurs(Unknown Source) at mypackage1.ListeValeursSessionClient.ListeValeurs(ListeValeursSessionClient.java:48) at org.apache.jsp.ModificationDoc_jsp._jspService(ModificationDoc_jsp.java:108) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:44) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) 2004-10-27 17:49:17,442 DEBUG [org.jboss.ejb.plugins.StatefulSessionFilePersistenceManager] Attempting to remove; ctx=org.jboss.ejb.StatefulSessionEnterpriseContext@34d46a 2004-10-27 17:49:17,442 DEBUG [org.jboss.ejb.plugins.StatefulSessionFilePersistenceManager] Removal complete; ctx=org.jboss.ejb.StatefulSessionEnterpriseContext@34d46a 2004-10-27 17:49:47,472 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true 2004-10-27 17:49:47,472 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false 2004-10-27 17:49:47,472 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true 2004-10-27 17:49:47,472 ERROR [org.jboss.ejb.plugins.LogInterceptor] EJBException in method: public abstract mypackage1.ListeValeursSession mypackage1.ListeValeursSessionHome.create() throws javax.ejb.CreateException,java.rmi.RemoteException: javax.ejb.EJBException: Connexion à la base de données impossible : No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )) at mypackage1.ListeValeursSessionBean.setSessionContext(ListeValeursSessionBean.java:51) at org.jboss.ejb.StatefulSessionEnterpriseContext.<init>(StatefulSessionEnterpriseContext.java:54) at org.jboss.ejb.plugins.StatefulSessionInstancePool.create(StatefulSessionInstancePool.java:32) at org.jboss.ejb.plugins.AbstractInstancePool.get(AbstractInstancePool.java:146) at org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invokeHome(StatefulSessionInstanceInterceptor.java:112) at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) at org.jboss.ejb.SessionContainer.internalInvokeHome(SessionContainer.java:613) at org.jboss.ejb.Container.invoke(Container.java:876) at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:155) at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104) at org.jboss.invocation.MarshallingInvokerInterceptor.invoke(MarshallingInvokerInterceptor.java:55) at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46) at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55) at org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:169) at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86) at $Proxy96.create(Unknown Source) at mypackage1.ListeValeursSessionClient.ListeValeurs(ListeValeursSessionClient.java:47) at org.apache.jsp.ModificationDoc_jsp._jspService(ModificationDoc_jsp.java:109) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:44) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:169) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929) at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Thread.java:534) 2004-10-27 17:49:47,488 INFO [STDOUT] Erreur de liste de valeurs??? : EJBException:; nested exception is: javax.ejb.EJBException: Connexion à la base de données impossible : No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); - nested throwable: (javax.resource.ResourceException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] ))
|
Je crois que le problème vient de la classe suivante : (pourtant j'ai fermé les resultset)
Code :
- package mypackage1;
- import javax.ejb.*;
- import java.sql.*;
- import javax.sql.*;
- import java.util.*;
- import javax.naming.*;
- import java.util.Collection;
- import javax.ejb.ObjectNotFoundException;
- import java.sql.ResultSet;
- import java.io.*;
- import java.util.Vector;
- import java.rmi.RemoteException;
- import javax.naming.InitialContext;
- import javax.naming.NamingException;
- import javax.rmi.PortableRemoteObject;
- public class ListeValeursSessionBean implements SessionBean
- {
- private SessionContext context;
- private Connection connexionBD;
- private String dbName="java:DefaultDS";
- public void ejbCreate()
- {
- }
- public void ejbActivate()
- {
- }
- public void ejbPassivate()
- {
- }
- public void ejbRemove()
- {
- }
- public void setSessionContext(SessionContext ctx)
- {
- this.context = ctx;
- try
- {
- InitialContext ic = new InitialContext();
- DataSource ds = (DataSource) ic.lookup(dbName);
- connexionBD = ds.getConnection();
-
- }
- catch (Exception e)
- {
- throw new EJBException("Connexion à la base de données impossible : "+e.getMessage());
- }
- }
-
- public String RetourneRequete(String nomRequete) throws IOException
- {
- Properties props=new Properties();
- String val = null;
-
- try
- {
- FileInputStream in;
- in=new FileInputStream("H:\\Dev\\GestionBase\\src\\Requetes.properties" );
- props.load(in);
- in.close();
- val=props.getProperty(nomRequete);
- }
- catch(IOException ex)
- {
- System.out.println("ERREUR lors de la lecture : " + ex.getMessage());
- }
- System.out.println ("#################################################################" );
- System.out.println ("requete : "+val);
- System.out.println ("#################################################################" );
- return val;
- }
-
- public Collection ListeValeurs(String nomRequete, Vector param) throws ObjectNotFoundException, IOException
- {
- ResultSet rsListeValeurs;
- Vector listeValeurs = new Vector();
- PreparedStatement psListeValeurs;
- try
- {
- String requete = RetourneRequete(nomRequete);
- psListeValeurs = connexionBD.prepareStatement(requete);
- if(param!=null)
- {
- for (int i=0; i<param.size();i++)
- {
- String classeParam = param.elementAt(i).getClass().getName();
- if(classeParam.compareTo("java.lang.String" )==0)
- {
- psListeValeurs.setString(i+1, param.elementAt(i).toString());
- }
- if(classeParam.compareTo("java.lang.Integer" )==0)
- {
- psListeValeurs.setInt(i+1, param.elementAt(i).hashCode());
- }
- if(classeParam.compareTo("java.lang.Long" )==0)
- {
- psListeValeurs.setLong(i+1, param.elementAt(i).hashCode());
- }
- }
- }
-
- rsListeValeurs = psListeValeurs.executeQuery();
- System.out.println ("#################################################################" );
- //calcul du nombre de colonnes
- ResultSetMetaData rsmd=psListeValeurs.getMetaData();
- int nbColonnes = rsmd.getColumnCount();
-
- for(int i=1;i<=nbColonnes;i++){
- listeValeurs.insertElementAt(new Vector(), i-1);
- }
- while (rsListeValeurs.next()){
- int indiceColonne = 0;
- int indiceLigne = 0;
- while (indiceLigne < nbColonnes){
- ((Vector)(listeValeurs.elementAt(indiceColonne))).add(rsListeValeurs.getString(indiceLigne+1));
- indiceLigne++;
- indiceColonne++;
- }
- }
- System.out.println ("#################################################################" );
- System.out.println ("Liste valeurs : "+listeValeurs);
- System.out.println ("#################################################################" );
- System.out.println ("Liste valeurs param: "+param);
- psListeValeurs.close();
- rsListeValeurs.close();
-
-
- }
- catch (SQLException e)
- {
- System.out.println("################################################" );
- throw new EJBException("Liste valeurs " + e.getMessage());
- }
- if (listeValeurs.isEmpty())
- throw new ObjectNotFoundException("Aucune valeur trouvée." );
- return (Collection) listeValeurs;
- }
- private ContexteGestionBaseHome getContexteGestionBaseHome() throws NamingException
- {
- final InitialContext context = new InitialContext();
- return (ContexteGestionBaseHome)PortableRemoteObject.narrow(context.lookup("java:comp/env/ejb/ContexteGestionBase" ), ContexteGestionBaseHome.class);
- }
- private DocumentHome getDocumentHome() throws NamingException
- {
- final InitialContext context = new InitialContext();
- return (DocumentHome)PortableRemoteObject.narrow(context.lookup("java:comp/env/ejb/Document" ), DocumentHome.class);
- }
- private TypedocHome getTypedocHome() throws NamingException
- {
- final InitialContext context = new InitialContext();
- return (TypedocHome)PortableRemoteObject.narrow(context.lookup("java:comp/env/ejb/Typedoc" ), TypedocHome.class);
- }
- private CommuneHome getCommuneHome() throws NamingException
- {
- final InitialContext context = new InitialContext();
- return (CommuneHome)PortableRemoteObject.narrow(context.lookup("java:comp/env/ejb/Commune" ), CommuneHome.class);
- }
- private CoordonneeHome getCoordonneeHome() throws NamingException
- {
- final InitialContext context = new InitialContext();
- return (CoordonneeHome)PortableRemoteObject.narrow(context.lookup("java:comp/env/ejb/Coordonnee" ), CoordonneeHome.class);
- }
- private ListemotcleHome getListemotcleHome() throws NamingException
- {
- final InitialContext context = new InitialContext();
- return (ListemotcleHome)PortableRemoteObject.narrow(context.lookup("java:comp/env/ejb/Listemotcle" ), ListemotcleHome.class);
- }
- private PaysHome getPaysHome() throws NamingException
- {
- final InitialContext context = new InitialContext();
- return (PaysHome)PortableRemoteObject.narrow(context.lookup("java:comp/env/ejb/Pays" ), PaysHome.class);
- }
- private PersonneHome getPersonneHome() throws NamingException
- {
- final InitialContext context = new InitialContext();
- return (PersonneHome)PortableRemoteObject.narrow(context.lookup("java:comp/env/ejb/Personne" ), PersonneHome.class);
- }
- private RegionHome getRegionHome() throws NamingException
- {
- final InitialContext context = new InitialContext();
- return (RegionHome)PortableRemoteObject.narrow(context.lookup("java:comp/env/ejb/Region" ), RegionHome.class);
- }
- private EstdefiniparHome getEstdefiniparHome() throws NamingException
- {
- final InitialContext context = new InitialContext();
- return (EstdefiniparHome)PortableRemoteObject.narrow(context.lookup("java:comp/env/ejb/Estdefinipar" ), EstdefiniparHome.class);
- }
- private EstreconnuparHome getEstreconnuparHome() throws NamingException
- {
- final InitialContext context = new InitialContext();
- return (EstreconnuparHome)PortableRemoteObject.narrow(context.lookup("java:comp/env/ejb/Estreconnupar" ), EstreconnuparHome.class);
- }
- }
|
Qqun peut-il m'aider, SVP? ---------------
** Aurore **
|