Pooled Connection exception 
Author Message
 Pooled Connection exception

My setup is jConnect 5.5, Sybase 11.9.2, JDK 1.3.1_03 and file based JNDI.
Using the combination of

import com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource;
import com.sybase.jdbc2.jdbc.SybDataSource;

for pooled connections. But when I tried to get the connection, I got the
following exception. If I dont "chain" the two DS, I can get Connection via
ConnectionPoolDataSource.getPooledConnection().getConnection() fine.

Upon further examination, it appears what I
set in SybDataSource.setDataSourceName(JNDI_For_Pooled_DS) is ignored.

Please help.
********************
java.sql.SQLException: JZ006: Caught IOException:
java.net.UnknownHostException: null
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:485)
at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:2961)
at com.sybase.jdbc2.tds.Tds.login(Tds.java:339)
at
com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:213)
at
com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:193)
at
com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:172)
at
com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:124)
at
com.sybase.jdbc2.jdbc.SybDriver.createConnection(SybDriver.java:533)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:473)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:505)
at
com.sybase.jdbc2.jdbc.SybDataSource.getConnection(SybDataSource.java:217)



Mon, 15 Nov 2004 22:27:45 GMT
 Pooled Connection exception

My setup is jConnect 5.5, Sybase 11.9.2, JDK 1.3.1_03 and file based JNDI.
Using the combination of

import com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource;
import com.sybase.jdbc2.jdbc.SybDataSource;

for pooled connections. But when I tried to get the connection, I got the
following exception. If I dont "chain" the two DS, I can get Connection via
ConnectionPoolDataSource.getPooledConnection().getConnection() fine.

Upon further examination, it appears what I
set in SybDataSource.setDataSourceName(JNDI_For_Pooled_DS) is ignored.

Please help.
********************
java.sql.SQLException: JZ006: Caught IOException:
java.net.UnknownHostException: null
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:485)
at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:2961)
at com.sybase.jdbc2.tds.Tds.login(Tds.java:339)
at
com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:213)
at
com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:193)
at
com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:172)
at
com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:124)
at
com.sybase.jdbc2.jdbc.SybDriver.createConnection(SybDriver.java:533)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:473)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:505)
at
com.sybase.jdbc2.jdbc.SybDataSource.getConnection(SybDataSource.java:217)



Mon, 15 Nov 2004 22:29:31 GMT
 Pooled Connection exception

Quote:

> My setup is jConnect 5.5, Sybase 11.9.2, JDK 1.3.1_03 and file based JNDI.
> Using the combination of

> import com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource;
> import com.sybase.jdbc2.jdbc.SybDataSource;

> for pooled connections. But when I tried to get the connection, I got the
> following exception. If I dont "chain" the two DS, I can get Connection via
> ConnectionPoolDataSource.getPooledConnection().getConnection() fine.

> Upon further examination, it appears what I
> set in SybDataSource.setDataSourceName(JNDI_For_Pooled_DS) is ignored.

        I don't know Java or jConnect so I can only guess. Since its happening
        at connect time could it be that something needs to be set up first
        and isn't?

        Regardless, you might have better luck trying the jConnect newsgroups
        at Sybase's own newsserver forums.sybase.com. It also won't hurt to
        check if you require an EBF for your version of jConnect.

-am     ? 2002



Tue, 16 Nov 2004 17:23:59 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. connection pooling - to pool or not to pool

2. connection pooling exception

3. connection pooling exception

4. Java connection pooling vs oracle connection pooling

5. ODBC Connection Pooling Vs OLE DB Resource Pooling

6. ODBC Connection Pooling Vs OLE DB Resource Pooling

7. ODBC Connection Pooling Vs OLE DB Resource Pooling

8. ODBC Connection Pooling Vs OLE DB Resource Pooling

9. OLEDB Resource Pooling (database connection pooling) without MTS

10. connection pooling, "use msdb" ruins connection

11. TCP/IP Connection to SQL fails/Connection Pooling


 
Powered by phpBB® Forum Software