aspose file tools
The moose likes JDBC and the fly likes DBCP could not obtain an idle db connection Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "DBCP could not obtain an idle db connection" Watch "DBCP could not obtain an idle db connection" New topic
Author

DBCP could not obtain an idle db connection

Ilja Smoli
Ranch Hand

Joined: Dec 02, 2001
Posts: 64
Hello
Tomcat 4.1 gives me this exception "DBCP could not obtain an idle db connection" when i try to get connection from jndi datasource with Oracle 10g.
I succesfully did dbcp connections many times before with mysql, so this is not my first experience. I tried to play with resource params but didnt work out. Any ideas?
my server.xml file:

thx in advance...
Ilja Smoli
Ranch Hand

Joined: Dec 02, 2001
Posts: 64
Argh...
Spent few hours on this problem.
Tomcat documentation has mistake.
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html
In oracle example, url for connecting is:
<parameter>
<name>url</name>
<value>jdbcracle:thin:myschema@127.0.0.1:1521:mysid</value>
</parameter>
Which is wrong, correct one is: jdbcracle:thin:@127.0.0.1:1521:mysid
without myschema!
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: DBCP could not obtain an idle db connection
 
Similar Threads
Very slow to hook up to MySQL db
Please Help! I Do Not See the Problem. Tomcat Connection Configuration Problem!
Connection pooling using Tomcat
Configuring a MySQL DataSource in Tomcat5
Tomcat 5.5.9 admin and Datasources