I am using Oracle 7.3 and Windows NT.
-----Original Message-----
From: Kevin Gilpin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 10:16 AM
To: Town
Subject: Re: Problem with Town's Connection Pooling
I'm sure they will want to know what database & operating environment you
are using
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 07, 2001 9:08 AM
Subject: Problem with Town's Connection Pooling
> Hi,
> I have been using Town's connection pooling for a while now. I have
> seen a recurring error appear randomly when getting connections from the
> connection pool. I get the following error:
>
> java.sql.SQLException
> java.lang.Throwable()
> java.lang.Exception()
> java.sql.SQLException()
> void com.workingdogs.town.DbConnectionBroker.run()
> void java.lang.Thread.run()
>
>
> This is the piece of code that i use to get a connection:
>
> try {
> this.broker =
> new DbConnectionBroker(
> this.driver,
> this.dbServer,
> this.userId,
> this.password,
> this.minConns,
> this.maxConns,
> this.logFile,
> this.maxConnTime);
> } catch (IOException ie) {
> ie.printStackTrace();
> }
> }
>
> public Connection getConnection() {
>
> return broker.getConnection();
>
> }
>
> I also do a freeConnection(conn). Initially that seemed to be the problem
> but i still keep getting the SQL Error.
> I have also noticed that sometimes doing a commit on the database
> manually causes this error to disappear. Could somebody help me out? Is
> there
> something specific that i should be doing to get rid of this error? Any
> and all help would be appreciated.
>
>
> Thanks,
> Sunitha
>
> ***************************************
> Sunitha Venkataraman
> G & R
> Telephone:(847)971-4340 (C)
> ***************************************
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
