File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JBoss and the fly likes DB problems in JBoss-2.4.10_Tomcat-4.0.6 Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » JBoss
Reply Bookmark "DB problems in JBoss-2.4.10_Tomcat-4.0.6" Watch "DB problems in JBoss-2.4.10_Tomcat-4.0.6" New topic
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"> jdbcracle: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.namingrg.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
 
Threads others viewed
BMP JBoss - Oracle Connections through DataSource
jboss, datasource naming and lookup error
No Suitable driver
Oracle connection with JBOSS problem.
Port 2.2 to 2.4 Database Error
WebSphere development made easy
without the weight of IBM tools
http://www.myeclipseide.com