Jakarta Connection Pool Problem

J

JavaEnquirer

No problems using the DBCP pool programmatically and getting
connections. Problems start when attempting to use a jocl file. Just
can't seem to work out what form the url should take. I'm using SQL
Server and Microsoft's driver. Consider this snippet from the Jakarta
jocl example:

<!-- the first argument is the ConnectionFactory -->
<object
class="org.apache.commons.dbcp.DriverManagerConnectionFactory">
<string value="jdbc:some:connect:string"/>
<object class="java.util.Properties" null="true"/>
</object>

I've tried all of the following in desperation for the URL (i.e. string
value=" ):

jdbc:microsoft:sqlserver://server:1433/testDB;User=blah;Password=blah
jdbc:microsoft:sqlserver://server:1433//testDB;User=blah;Password=blah
jdbc:microsoft:sqlserver://server:1433\\testDB;User=blah;Password=blah
jdbc:microsoft:sqlserver://server:1433;Database=testDB;User=blah;Password=blah
jdbc:microsoft:sqlserver://server:1433;Database=testDB;User=blah;Password=blah

Any ideas?? Any DBCP examples specifically for the Microsoft JDBC
driver. If it matters, I'm not using Tomcat.

Many thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,898
Latest member
BlairH7607

Latest Threads

Top