Error connecting to InstanceDB
Hi
I have been using JBoss to deploy an application in J2EE with Oracle as backend. The application established connections to InstanceDB and Oracle. Every thing was working fine.
Then we wanted to use an opensource Database. In this process I downloaded InstanceDB from Lutris site. I created the database in InstanceDB, outside JBoss (I mean not using the default database that comes with JBoss).
Then I copied the tables created from the DB into the instanceDB/tables directory in JBoss.
After this when I start JBoss. I get an exception as follows(mentioned below between **** ****). I tried various option I am aware of, like.........
Including JBoss-j2ee.jar in the classpath.
Including JBoss-j2ee.jar in the JBOSS_HOME in the JBoss\bin\run.bat.
Uninstalling InstanceDB created outside JBoss
Removing the tables copied inside JBoss-- instanceDB/tables directory.
Uninstalling jboss and reinstalling JBoss with the default implementation.
Again setting the classpath for the new installation
.........but the exception still remains.
Can someone tell me what could be the reason. And suggest what else I could do to get the application working as it orginally did.
*******
[HypersonicDatabase] Starting
[HypersonicDatabase] Database started
[HypersonicDatabase] Started
[XADataSourceLoader] Starting
[InstantDB] XA Connection pool InstantDB bound to java:/InstantDB
[Default] Enhydra InstantDB - Version 3.26
[Default]
[Default] The Initial Developer of the Original Code is Lutris Technologies Inc.
Portions created by Lutris are Copyright (C) 1997-2001 Lutris Technologies, Inc.
All Rights Reserved.
[Configuration] java.lang.NoClassDefFoundError: javax/transaction/xa/XAException
[Configuration] at org.enhydra.instantdb.db.Database.dbOpen(Database.java:311)
[Configuration] at org.enhydra.instantdb.jdbc.idbConnection.(idbConnection.java:79)
[Configuration] at org.enhydra.instantdb.jdbc.idbDriver.connect(idbDriver.java:40)
[Configuration] at java.sql.DriverManager.getConnection(DriverManager.java:517)
[Configuration] at java.sql.DriverManager.getConnection(DriverManager.java:199)
[Configuration] at org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADataSourceImpl.java:122)
[Configuration] at org.jboss.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnectionFactory.java:269)
[Configuration] at org.jboss.pool.ObjectPool.createNewObject(ObjectPool.java:842)
[Configuration] at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:587)
[Configuration] at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:538)
[Configuration] at org.jboss.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:178)
[Configuration] at org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:407)
[Configuration] at org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:107)
[Configuration] at java.lang.reflect.Method.invoke(Native Method)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Configuration] at org.jboss.configuration.ConfigurationService$ServiceProxy.invoke(ConfigurationService.java:836)
[Configuration] at $Proxy0.start(Unknown Source)
[Configuration] at org.jboss.util.ServiceControl.start(ServiceControl.java:81)
[Configuration] at java.lang.reflect.Method.invoke(Native Method)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
[Configuration] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
[Configuration] at org.jboss.Main.(Main.java:210)
[Configuration] at org.jboss.Main$1.run(Main.java:116)
[Configuration] at java.security.AccessController.doPrivileged(Native Method)
[Configuration] at org.jboss.Main.main(Main.java:112)
[XADataSourceLoader] Starting
*******