| Author |
DB problems in JBoss-2.4.10_Tomcat-4.0.6
|
Hiram Walker
Greenhorn
Joined: Jun 07, 2004
Posts: 1
|
|
Hi, I'm having some problems with jboss and the conection to an oracle 7.3 database. I have a simple helloworld application with a jsp, a servlet and a ejb, which connect to the database. When I start jboss with the run_with_catalina option, I get the following exception in the log: [15:35:15,010,XAConnectionFactory] Starting [15:35:15,170,ObjectPool] Adding pool: OracleDB, GC enabled: false [15:35:15,230,OracleDB] XA Connection pool OracleDB bound to java:/OracleDB [15:35:15,230,XAPoolDataSource] Closing DataSource [15:35:15,230,XAPoolDataSource] Binding to JNDI name null [15:35:15,230,ObjectPool] Removing pool: OracleDB [15:35:15,230,OracleDB] Stopped java.lang.RuntimeException: Could not create connection at org.jboss.pool.ObjectPool.createNewObject(ObjectPool.java:1027) at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:677) at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:252) .............. [15:35:15,280,ConfigurationService] Unexpected error java.lang.RuntimeException: Could not create connection at org.jboss.pool.ObjectPool.createNewObject(ObjectPool.java:1027) at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:677) at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:252) at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:455) at org.jboss.util.ServiceMBeanSupport.start ............... I'm using the embebed tomcat JBoss-2.4.10_Tomcat-4.0.6, and win 98. Here are some settings: ---------------------jboss.conf----------------------- <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar" CODEBASE="../lib/ext/"> <ARG TYPE="java.lang.String" VALUE="StaffingDB"> <ARG TYPE="java.lang.String" VALUE="oracle.jdbc.xa.client.OracleXADataSource"> </MLET> --------------------jboss.jcml-------------------------- <mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider"> <attribute name="Drivers">oracle.jdbc.driver.OracleDriver</attribute> </mbean> <mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=OracleDB"> <attribute name="PoolName">OracleDB</attribute> <attribute name="DataSourceClass"> org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl </attribute> <attribute name="URL"> jdbc racle:thin:@172.16.254.5:1521:msal:ORCL </attribute> <attribute name="JDBCUser">default</attribute> <attribute name="Password">default</attribute> <attribute name="MinSize">2</attribute> <attribute name="TransactionIsolation"> TRANSACTION_SERIALIZABLE </attribute> </mbean> -------------------jndi.properties------------------------- java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory java.naming.factory.url.pkgs=org.jboss.naming rg.jnp.interfaces All this files in the catalina/conf directory. And I put classes111.zip in lib/ext directory. I've set all enviroment variables, and if i run the example without connecting to the database I had no problem, but when I try to connect, I got the following error: [15:35:39,950,STDERR] java.lang.NullPointerException [15:35:39,950,STDERR] at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:249) [15:35:39,950,STDERR] at Sample.prueba.processRequest(prueba.java:61) [15:35:39,950,STDERR] at Sample.prueba.doPost(prueba.java:118) [15:35:39,950,STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) Well, thanks to all in advance, Hiram.
|
 |
 |
|
|
subject: DB problems in JBoss-2.4.10_Tomcat-4.0.6
|
|
|