Please ignore my previous email. I am facing this problem but the program I sent does not reproduce the problem. I will try to create a reproducible example.
Regards ----- Original Message ----- From: "Dibyendu Majumdar" <[EMAIL PROTECTED]> To: "Derby Development" <[email protected]> Sent: Thursday, June 09, 2005 11:38 PM Subject: Network Client > Should this fail? > > package org.simplejta.tests.jta; > > import java.sql.DriverManager; > import java.sql.SQLException; > > import javax.sql.PooledConnection; > > import org.apache.derby.jdbc.ClientConnectionPoolDataSource; > > public class Temp { > > public static void main(String[] args) { > try { > Class.forName("org.apache.derby.jdbc.ClientDriver"); > DriverManager.getConnection("jdbc:derby://localhost:1527/tca"); > Class.forName("org.apache.derby.jdbc.ClientDriver"); > DriverManager.getConnection("jdbc:derby://localhost:1527/tca"); > > ClientConnectionPoolDataSource ds = new > ClientConnectionPoolDataSource(); > ds.setDatabaseName("tca"); > ds.setServerName("localhost"); // host with listening network > // server. > ds.setPortNumber(1527); // port of listening network server. > ds.setUser("app"); // Assign the user ID > ds.setPassword("app"); // Assign the password > PooledConnection con = ds.getPooledConnection(); // Create a > // Connection > // object > > } catch (InstantiationException e) { > // TODO Auto-generated catch block > e.printStackTrace(); > } catch (IllegalAccessException e) { > // TODO Auto-generated catch block > e.printStackTrace(); > } catch (ClassNotFoundException e) { > // TODO Auto-generated catch block > e.printStackTrace(); > } catch (SQLException e) { > // TODO Auto-generated catch block > e.printStackTrace(); > } > } > } > > The exception thrown is: > > org.apache.derby.client.am.DisconnectException: > java.security.PrivilegedActionException : Error opening socket to server > localhost on port 1527 with message : null > at org.apache.derby.client.net.NetAgent.<init>(NetAgent.java:113) > at > org.apache.derby.client.net.NetConnection.newAgent_(NetConnection.java:920) > at org.apache.derby.client.am.Connection.<init>(Connection.java:293) > at org.apache.derby.client.net.NetConnection.<init>(NetConnection.java:180) > at org.apache.derby.jdbc.ClientDriver.connect(ClientDriver.java:122) > at java.sql.DriverManager.getConnection(Unknown Source) > at java.sql.DriverManager.getConnection(Unknown Source) > at org.simplejta.tests.jta.Temp.main(Temp.java:27) > > The problem seems to be caused because of following being called more than > one: > > Class.forName("org.apache.derby.jdbc.ClientDriver"); > DriverManager.getConnection("jdbc:derby://localhost:1527/tca"); > > Regards > > Dibyendu > >
