Hi all,
I have sucessfully deployed data source for DB2.
I have also created DB2ConnectionFactory class:
public final class DB2ConnectionFactory {
| private static Connection connection;
| static {
| try {
| connection =
CachingServiceLocator.getInstance().getDataSource("java:/DataWeaverDS").getConnection();
| } catch (Exception e) {
| e.printStackTrace();
| }
| }
| public static Connection getConnection() {
| return connection;
| }
| }
well - it works i can connect to DB2 from my servlet but
after the response is sent to browser i recieve this message:
17:57:22,265 INFO [CachedConnectionManager] Closing a connection for you.
Please close them yourself: [EMAIL PROTECTED]
| java.lang.Throwable: STACKTRACE
| at
org.jboss.resource.connectionmanager.CachedConnectionManager.registerConnection(CachedConnectionManager.java:290)
| at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:417)
| at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
next WWW request fails because of already closed connection:
18:14:41,312 ERROR [STDERR] java.sql.SQLException: Connection handle has been
closed and is unusable
| 18:14:41,312 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:537)
| 18:14:41,312 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:524)
| 1
|
my DS looks like this:
<?xml version="1.0" encoding="UTF-8"?>
| <datasources>
| <local-tx-datasource>
| <jndi-name>DataWeaverDS</jndi-name>
|
<connection-url>jdbc:db2://localhost:50000/Test1:retrieveMessagesFromServerOnGetMessage=true;</connection-url>
| <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
| <user-name>****</user-name>
| <password>****</password>
| <min-pool-size>5</min-pool-size>
| <max-pool-size>20</max-pool-size>
| <idle-timeout-minutes>5</idle-timeout-minutes>
| </local-tx-datasource>
| </datasources>
is my data source definition missing something or is it my Java code?
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4024914#4024914
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4024914
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
