(re-post from the Installation and Configuration forum)
Need help to get JBoss 3.2.3/Tomcat 5.0.16 to connect to an external hsqldb 1.6.1
database running on port 8887. I've searched the forums, but didn't find any solutions.
I added a my-hsqldb-ds.xml(see below) to my jboss server deploy directory, copied the
hsqldb.jar from my hsqldb 1.6.1/bin to my jboss server/lib, also tried removing the
existing hsqldb-ds.xml and the hsqldb-plugin.jar None of them worked !!
The data source showed up in jmx-console, but the Servlet fails to get connection from
the data source. The stack trace in listed below.
What have I missed in the configuration ? Thanks in advance for your help.
my-hsqldb-ds.xml:
<local-tx-datasource>
<jndi-name>MyHsqlDb</jndi-name>
<connection-url>jdbc:hsqldb:hsql://127.0.0.1:8887</connection-url>
<driver-class>org.hsqldb.jdbcDriver</driver-class>
<user-name>xxx</user-name>
xxx
</local-tx-datasource>
Stack trace:
WARN [http8080-Processor24] connectionmanager.JBossManagedConnectionPool.[] Jun/08
09:11:50 - Throwable while attempting to get a new connection:
org.jboss.resource.JBossResourceException: Could not create connection; - nested
throwable: (java.sql.SQLException: No data is available)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:160)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:477)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:213)
at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:496)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:425)
at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:318)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:477)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3837999#3837999
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3837999
-------------------------------------------------------
This SF.Net email is sponsored by: GNOME Foundation
Hackers Unite! GUADEC: The world's #1 Open Source Desktop Event.
GNOME Users and Developers European Conference, 28-30th June in Norway
http://2004/guadec.org
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
