Hi
I've posted a solution see "Generic DataSource Resource Factory
Available. JDBC Data Source" on the tomcat user maillist. I used the
datadirect ConnectJDBC as I found the Microsoft implementation was very
poor. The Microsoft JDBC is just an older version of ConnectJDBC which
datadirect felt was'nt going the right direction.
Tony
----- Original Message -----
From: "John McAuley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 2:17 AM
Subject: JNDI lookup connection datasource microsoft sql server
Hi folks,
I am trying to use Microsoft's jdbc driver for ms sql with Tomcat and am
running into trouble with the JNDI lookup method. I look for a datasource
and get null. If I use the class.forname method the driver is found and
works perfectly but I am unable to get it working with the JNDI look up,
This is very frustrating and seems to crop up a couple of times with fellow
users. Any thoughts ??
Help much appreciated.
John
Server.xml
<Context path="/tools" docBase="tools" debug="0" reloadable="true">
<Resource name="jdbc/ToolsDB" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/ToolsDB">
<parameter>
<name>user</name>
<value>user</value>
</parameter>
<parameter>
<name>password</name>
<value>password</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:microsoft:sqlserver://IP-ADDRESS-of-server:1433</value>
</parameter>
</ResourceParams>
</Context>
web.xml
<resource-ref>
<description>
Resource reference to a factory for java.sql.Connection
instances that may be used for talking to a particular
database that is configured in the server.xml file.
</description>
<res-ref-name>
jdbc/ToolsDB
</res-ref-name>
<res-type>
javax.sql.DataSource
</res-type>
<res-auth>
Container
</res-auth>
</resource-ref>
Code Snippet
Context ctx = new InitialContext();
Context envCtx = (Context)ctx.lookup("java:comp/env");
out.println("Got first context.");
NamingEnumeration enum
=ctx.listBindings("java:comp/env/jdbc");
while( enum.hasMore() ) {
out.println("Binding: " +
((Binding)enum.next()).toString() + "<br>");
}
DataSource ds =
(DataSource)envCtx.lookup("jdbc/ToolsDB");
out.println("Got the second context." + "<br>" +
"<br>");
if (ds != null)
{
out.println("Getting the connection from the
context.");
Connection connection = ds.getConnection();
}else{
out.println("not working");
}
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
