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.
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.