Hello,
I want to use connection pool built-in Tomcat 4 for connection to InterBase (FireBird)
database server. I use interclient or JDBC driver for FireBird. When I create one new
connection for each servlet, it's always allright.
Example:
DataSource dataSource = new interbase.interclient.DataSource();
Connection con=null;
this.loadProps();
try{
dataSource.setNetworkProtocol("jdbc:interbase:");
dataSource.setServerName(props.getProperty("server","localhost"));
dataSource.setDatabaseName(props.getProperty("name","aumanie.gdb"));
dataSource.setPortNumber(3060);
dataSource.setLoginTimeout(10);
dataSource.setSweepOnConnect(false);
con = dataSource.getConnection(props.getProperty("user","sysdba"),
props.getProperty("password","masterkey"));
} catch(SQLException se) {
System.err.println("Vyjimka pri pripojovani k databazi: " se);
return;
}
But when I setup datasource (&connection pool) in admin console and in servlet i get
datasource, DB server shuts down by running ds.getConnection() "command" always. This
is the same for InterBase and FireBird server and JDBC client.
Please, is there someone, who use combination Tomcat4 & IB & connection pool ? I need
some help or example.
Thank you very much !
Pepa Pecinovsky
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
