Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DBCP could not obtain an idle db connection

 
Ilja Smoli
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic