Thank you very much for your reply on Sunday.
The error is "Name jdbc is not bound in this Context" at ctx.lookup. In both
server.xml and web.xml, the type is
com.microsoft.jdbcx.sqlserver.SQLServerDataSource. Even I use the code:
envCtx = (Context) initCtx.lookup("java:comp/env");
ds = (ConnectionPoolDataSource ) envCtx.lookup("jdbc/daxin");
if (ds != null){
if(ds instanceof com.microsoft.jdbcx.sqlserver.SQLServerDataSource){
SQLServerDataSource temp =
(com.microsoft.jdbcx.sqlserver.SQLServerDataSource)ds;
con = temp.getPooledConnection("dzuo","dzuo").getConnection();
I got the same error. Besides jdbc, is there another name to use?
I am using jdbc driver, why
com.microsoft.jdbc.sqlserver.SQLServerDriver.class in the mssqlserver.jar is
not indicated in the configuration? Why the driverClassName and the type are
the same? Does it related to MS sql server installation? I installed the MS
SQL JDBCdriver's servise pack 1 and 2. Does it have effect?
My current configuration is based on the link you sent me in the first
email:
Server.xml:
... ...
<GlobalNamingResources>
... ...
<Resource name="jdbc/dbName" auth="container"
type="com.microsoft.jdbcx.sqlserver.SQLServerDataSource" />
<ResourceParams name="jdbc/dbName">
<parameter>
<name>factory</name>
<value>com.microsoft.jdbcx.sqlserver.SQLServerDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbcx.sqlserver.SQLServerDataSource</value>
</parameter>
<parameter>
<name>driverName</name><value>SQLServer</value>
</parameter>
<parameter><name>description</name><value>SQL Server
DataSource</value></parameter>
<parameter><name>serverName</name><value>"daxin"</value></parameter>
<parameter><name>portNumber</name><value>1433</value> </parameter>
<parameter><name>selectMethod</name><value>cursor</value></parameter>
<parameter><name>databaseName</name><value>pubs</value></parameter>
<parameter><name>user</name><value>"dzuo"</value></parameter>
<parameter><name>password</name><value>"dzuo"</value></parameter>
</ResourceParams>
......
</GlobalNamingResources>
... ...
</Engine>
</Service>
</Server>
web.xml:
....
<resource-ref>
<description>SQL Server DataSource</description>
<res-ref-name>"jdbc/dbName"</res-ref-name>
<res-type>com.microsoft.jdbc.sqlserver.SQLServerDataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
Looking forward to more instruction.
-----Original Message-----
From: Parsons Technical Services [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 02, 2004 4:07 PM
To: Tomcat Users List
Subject: Re: Please help on my DB pool problem --- I followed the
struction on the web
Try this code instead:
Context ctx = new InitialContext();
if (ctx == null) {
System.err.println("Conn.getConn ctx is null");
throw new Exception("Boom - No Context");
}
DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/dbName");
if (ds != null)
connection = ds.getConnection();
I run this from a class. I have several util classes that handle my database
queries and thus in my jsps and servlets I simly call the util class with a
simple string. But we'll save that for another time.
As for the code in the web.xml, it is fine.
Doug
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
