Hello,
I need a little help
Hopefully I can give the info needed.
My servlets have been using this code I found a long time ago called
DbConnectionBroker
It works very well.
I have been trying to move to the db connection pool of tomcat.
They both use org.gjt.mm.mysql.Driver
But here
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Randy wrote:
Hello,
I need a little help
Hopefully I can give the info needed.
My servlets have been using this code I found a long time ago called
DbConnectionBroker
It works very well.
I have been trying to move to the db connection
some problem.
Thanks.
Avinash Arora
-Original Message-
From: Daxin Zuo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 4:45 PM
To: Tomcat Users List
Subject: RE: DB connection pool problem
Have you tried to put the configuration text in GlobalNamingResources
instead of context
, 2004 4:45 PM
To: Tomcat Users List
Subject: RE: DB connection pool problem
Have you tried to put the configuration text in GlobalNamingResources
instead of context block? To me, the message tells that the web.xml
and
java code is fine. The server.xml is not edited correctly.
in you server.xml, you
: Daxin Zuo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 4:29 PM
To: Tomcat Users List
Subject: RE: DB connection pool problem
You have to add
con = dataSource.getConnection();
after
dataSource = (DataSource)ctx.lookup(jdbc/conversion);
-Original Message-
From: Arora, Avinash
/conversion?
-Original Message-
From: Arora, Avinash [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 4:07 PM
To: Daxin Zuo; Tomcat Users List
Subject: RE: DB connection pool problem
Hi,
Sorry I was messing up my code by making several changes. If I add
that statement, I get
source object is
not null, Inside 1st try. Connection object found to be null, Connection
object is null]
Thanks.
Avinash Arora
-Original Message-
From: Daxin Zuo [mailto:[EMAIL PROTECTED]
Sent: Monday, May 03, 2004 3:34 PM
To: Tomcat Users List
Subject: RE: DB connection pool
).
-Original Message-
From: Arora, Avinash [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 2:52 PM
To: Daxin Zuo; Tomcat Users List
Cc: [EMAIL PROTECTED]
Subject: RE: DB connection pool problem
Hi friends,
Thanks for your previous feedback. After adding several
logging
, Inside 1st try. Connection object found to be null, Connection
object is null]
Thanks.
Avinash Arora
-Original Message-
From: Daxin Zuo [mailto:[EMAIL PROTECTED]
Sent: Monday, May 03, 2004 3:34 PM
To: Tomcat Users List
Subject: RE: DB connection pool problem
I have just created a pool
: RE: DB connection pool problem
I have just created a pool -- I hope it is really a pool. I used
jtds
jdbc driver to MS SQL Server on Windows. You may find some thing
similar.
Holp it helps.
1) bellow is the text in tomcat\conf\server.xml
GlobalNamingResources
Resource name=jdbc/DirectSQL auth
Message-
From: David Smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 1:35 PM
To: Tomcat Users List
Subject: Re: DB connection pool problem
Sorry about the last post. It's been a looonnng day and I didn't read
it very well :-(.
From what I see, you're comparing conn to null before
You have to add
con = dataSource.getConnection();
after
dataSource = (DataSource)ctx.lookup(jdbc/conversion);
-Original Message-
From: Arora, Avinash [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 3:54 PM
To: David Smith; Tomcat Users List
Subject: RE: DB connection pool problem
Hi,
I am also having the problem with the connection pools. Since I am
writing an application first time by using connection pools, I created a
test application DBTest. I edited my server.xml and web.xml (of my
application in following way--
#added to server.xml
Context path=/DBTest
Users List
Subject: DB connection pool problem
Hi,
I am also having the problem with the connection pools. Since I am
writing an application first time by using connection pools, I created a
test application DBTest. I edited my server.xml and web.xml (of my
application in following way--
#added
,
ResultSet.CONCUR_READ_ONLY );
rs = pStateSearch.executeQuery();
That's all.
-Original Message-
From: Arora, Avinash [mailto:[EMAIL PROTECTED]
Sent: Monday, May 03, 2004 3:10 PM
To: Tomcat Users List
Subject: DB connection pool problem
Hi,
I am also
Assunto: RE: DBCP could not obtain an idle db connection, pool
exhausted
Yes
I have closed ResultSet, Statement and Connection
Have you tried to close ResultSet, Statement and Connection after each
use?
-Original Message-
From: Galbayar [mailto:[EMAIL PROTECTED
How to solve this problem?
I'm using
Tomcat 4.1.27
J2SDK (build 1.4.1_03-b02
Tyrex 1.0
Commons DBCP 1.1
MySQL ConnectorJ version 3.0.8
My server.xml configuration
Context ...
Resource name=jdbc/sss auth=Container type=javax.sql.DataSource/
ResourceParams name=jdbc/sss
parameter
Have you tried to close ResultSet, Statement and Connection after each use?
-Original Message-
From: Galbayar [mailto:[EMAIL PROTECTED]
Sent: November 10, 2003 4:50 AM
To: Tomcat Users List
Subject: DBCP could not obtain an idle db connection, pool exhausted
How to solve this problem
Manager
Raynet IT Co.Ltd
Myanmar
Have you tried to close ResultSet, Statement and Connection after each
use?
-Original Message-
From: Galbayar [mailto:[EMAIL PROTECTED]
Sent: November 10, 2003 4:50 AM
To: Tomcat Users List
Subject: DBCP could not obtain an idle db connection, pool
an idle db connection, pool exhausted
How to solve this problem?
I'm using
Tomcat 4.1.27
J2SDK (build 1.4.1_03-b02
Tyrex 1.0
Commons DBCP 1.1
MySQL ConnectorJ version 3.0.8
My server.xml configuration
Context ...
Resource name=jdbc/sss auth=Container type=javax.sql.DataSource
org.apache.commons.dbcp.DbcpException
: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC]Unable
to connect. Invalid URL
The URL is invalid.
valuejdbc:microsoft:sqlserver://192.168.0.12:1433/Northwind/value
Here is the URL
On my servers, my devs are using:
Hello i am trying for using the Tomcat database conecition pool (dbcp)
against one SQL SERVER 2000 but i cannot connect always appears this error:
DBCP borrowObject failed: java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC]Unable to connect. Invalid URL.
I'm running Tomcat 4.1.18 with Struts (release version) on RedHat 7.3.
I'm connecting to a postgres 7.3.2 database (running on the same
machine) using the JDBC2 drivers. 1Gb of ram, with a decent processor.
I'm using the default struts database connection stuff. Here's the
struts DB config:
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
DBCP could not obtain an idle db
connection, pool exhausted errors ? I've stopped sending requests to the server but
the problem persists and it looks like I'll have to restart Tomcat.Surprised that the
pool didn't automatically reclaim connections.
Thanks, Stephen
valuejdbc:mysql://localhost:3306/javatest?autoReconnect=true/value
/parameter
Jake
At 02:54 AM 12/12/2002 +, you wrote:
Just wondering how I could have ended up getting DBCP could not obtain an
idle db connection, pool exhausted errors ? I've stopped sending requests
Just wondering how I could have ended up getting DBCP could not obtain an idle db
connection, pool exhausted errors ? I've stopped sending requests to the server but
the problem persists and it looks like I'll have to restart Tomcat.Surprised that the
pool didn't automatically reclaim
ended up getting DBCP could not obtain an
idle db connection, pool exhausted errors ? I've stopped sending requests
to the server but the problem persists and it looks like I'll have to
restart Tomcat.Surprised that the pool didn't automatically reclaim
connections.
Thanks, Stephen
jdbc:mysql://localhost:3306/javatest?autoReconnect=true
Jake
At 02:54 AM 12/12/2002 +, you wrote:
Just wondering how I could have ended up getting DBCP could not obtain an
idle db connection, pool exhausted errors ? I've stopped sending requests
to the server but the problem persists
? Then add ?autoReconnect=true to your url
parameter like this
url
jdbc:mysql://localhost:3306/javatest?autoReconnect=true
Jake
At 02:54 AM 12/12/2002 +, you wrote:
Just wondering how I could have ended up getting DBCP could not obtain an
idle db connection, pool exhausted errors ? I've
Hi
I am using Tomcat 4.1.12 on Win2k with SQL Server. I am using MS JDBC
driver.
I tried to implement Connection pool with DBCP.
When I do a getConnection(username,password) on the datasource I get a
UnsupportedOperationException.
Any ideas.
Thanks.
Srinath.
I'm trying to setup my Tomcat 4.0.9's JDNI DB connection pool, but I
can't get it to work
Here is what I've done so far
1. Move the Oracle Drivers (classes12.zip) into TOMCAT_HOME\common\lib
directory and rename it to classes12.jar
2. Added the following codes to my webapp's web.xml
resource
+@+databas
e)
Now I'm trying to setup my Tomcat 4.0.9's JDNI DB connection pool, but I
can't get it to work
Here is what I've done so far
1. Move the Oracle Drivers (classes12.zip) into TOMCAT_HOME\common\lib
directory and rename it to classes12.jar
2. Added the following codes to my webapp's web.xml
don't need the factory element.
Hope this helps,
Vance
- Original Message -
From: Isabel Lameda [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 03, 2002 8:50 AM
Subject: tomcat JDNI DB connection pool to Oracle
Anabody could help me, i´ve been trying to do this for days
ello,
As many people mentioned,thereisa
lot of confusionabout databse connection pooling in tomcat 4. I spent some
time trying all sorts of combinations (tyrex, dbcp, etc.) to get connection
pooling working because there is little documentation on this topic and the
products it uses. I got
PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Tuesday, March 05, 2002 3:38 PM
Subject: RE: DB Connection Pool
Why?
Because we just had a complete discussion of this topic. Between this
list
and others I subscribe to, I get hundreds of emails a day and I don't want
to wade through
I was of the impression that Tomcat had built-in connection pooling, but, unless I
misinterpret the recent postings on this site, it doesn't really 'work'.
Could someone please confirm/deny this for me. Connection pooling is very important
to one of my current projects, and I had hoped to use
If anyone is currently using a third-part pool that they are well
pleased with, I would greatly appreciate that information too.
We just finished this discussion. Please check the archive.
--
To unsubscribe: mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
I join in late, but I'm currently using CodeStudio Poolman for my
connection pool. You can customize it to provide object pooling too.
It works well for me.
Jim Urban wrote:
If anyone is currently using a third-part pool that they are well
pleased with, I would greatly appreciate that
Why? Jim, are you the owner of this mailing list?
Jim Urban wrote:
If anyone is currently using a third-part pool that they are well
pleased with, I would greatly appreciate that information too.
We just finished this discussion. Please check the archive.
--
To unsubscribe:
On 03/05/2002 02:59 PM, Lev Assinovsky wrote:
Why? Jim, are you the owner of this mailing list?
Actually, Lev, Jim is right: it's an established etiquette of public
mailing lists to first search for an answer in the existing
documentation before posting a question on the list. One of the
: Huy Tran [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Tuesday, March 05, 2002 9:54 AM
Subject: Re: DB Connection Pool
I join in late, but I'm currently using CodeStudio Poolman for my
connection pool. You can customize it to provide object pooling too.
It works well for me
No, Emir!
Sorry, I don't agree with you.
1. My post is not off topic
2. I spent few weeks working on the problem before my first post was done.
3. We discovered that the problem isn't that simple.
4. The famous book Professional JSP doesn't recommend to use any custom
pooling classes, as Jim
]
-Original Message-
From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
Sent: 5. mars 2002 20:46
To: Tomcat Users List
Subject: Re: DB Connection Pool
No, Emir!
Sorry, I don't agree with you.
1. My post is not off topic
2. I spent few weeks working on the problem before my first
(lev.getQuestion());
}
Good joke! Really!
Lev breaks out of the loop.
Have a good rest!
[EMAIL PROTECTED]
-Original Message-
From: Lev Assinovsky [mailto:[EMAIL PROTECTED]]
Sent: 5. mars 2002 20:46
To: Tomcat Users List
Subject: Re: DB Connection Pool
No, Emir!
Sorry, I
the owner of this mailing list?
No.
Jim
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
Of Lev Assinovsky
Sent: Tuesday, March 05, 2002 2:00 PM
To: Tomcat Users List
Subject: Re: DB Connection Pool
Why? Jim, are you the owner of this mailing list?
Jim
46 matches
Mail list logo