File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
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!
 
GeeCON Prague 2014
 
subject: DBCP could not obtain an idle db connection