Inavlid Datasource Reference (Naming Exception)

[shonvon ton]

Hi..
I am trying to connect to a database on sql server 2005 via tomcat. My entries in the server.xml are as below:

  Resource auth="Container" name="jdbc/sql_2005" type="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
		<ResourceParams name="jdbc/sql_2005">
			 <parameter><name>factory</name><value>com.microsoft.sqlserver.jdbc.SQLServerDataSourceObjectFactory</value></parameter>
		<parameter><name>driverClassName</name><value>com.microsoft.sqlserver.jdbc.SQLServerDriver</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>MyServer</value></parameter>		
		    <parameter><name>portNumber</name><value>1433</value></parameter>
			<parameter><name>selectMethod</name><value>cursor</value></parameter>
			<parameter><name>databaseName</name><value>MyDatabase</value></parameter>
			<parameter><name>user</name><value>MyUserName</value></parameter>
		    <parameter><name>password</name><value>MyPassword</value></parameter>
			<parameter><name>loginTimeout</name><value>3000</value></parameter>
		</ResourceParams> 
.
.
.

<Resource auth="Container" name="jdbc/global_" type="com.microsoft.pool.PoolDataSource"/>
		<ResourceParams name="jdbc/global_">
			<parameter><name>factory</name><value>com.microsoft.pool.PoolDataSourceFactory</value></parameter>
			<parameter><name>className</name><value>com.microsoft.pool.PoolDataSource</value></parameter>
			<parameter><name>description</name><value>MS_SQL_Pool_DataSource</value></parameter>
			<parameter><name>poolName</name><value>globalpool</value></parameter>
			<parameter><name>maxConnections</name><value>100</value></parameter>
			<parameter><name>minConnections</name><value>1</value></parameter>
			<parameter><name>checkEvery</name><value>20000</value></parameter>
			<parameter><name>idleTimeout</name><value>50000</value></parameter>
			<parameter><name>dsJndiName</name><value>jdbc/sql_2005</value></parameter> <!-- 2001 -->
		</ResourceParams> 
.
.
.
<ResourceLink global="jdbc/sql_2005" name="jdbc/sql_2005" type="com.microsoft.sqlserver.jdbc.SQLServerDriver" />  

Its throwing the following:
javax.naming.NamingException: Invalid DataSource reference.
at org.apache.naming.NamingContext.lookup(NamingContext.java:799)
at org.apache.naming.factory.ResourceLinkFactory.getObjectInstance(ResourceLinkFactory.java:93)
at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source)
at org.apache.naming.NamingContext.lookup(NamingContext.java:789)
at com.microsoft.pool.JNDITool.getDataSource(JNDITool.java:47)
at com.microsoft.pool.PoolDataSourceFactory.getObjectInstance(PoolDataSourceFactory.java:32)
at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:140)
at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source)
at org.apache.naming.NamingContext.lookup(NamingContext.java:789)
at org.apache.naming.factory.ResourceLinkFactory.getObjectInstance(ResourceLinkFactory.java:93)
at javax.naming.spi.NamingManager.getObjectInstance(Unknown Source)
at org.apache.naming.NamingContext.lookup(NamingContext.java:789)
at com.microsoft.pool.JNDITool.getPoolDataSource(JNDITool.java:101)
at com.microsoft.pool.PoolHandler.createPool(PoolHandler.java:48)
at com.microsoft.pool.PoolHandler.init(PoolHandler.java:72)

I am using the sqljdbc.jar and it is in place. Its throwing exception while doing subcontext lookUp for jdbc/sl_2005.
Please help me out here. Is there any other jar that i have to use! or am i missing something in the config?

Thanks,

[shonvon ton]

Its throwing exception while doing subcontext lookUp for jdbc/sql_2005. (Sorry for the typo error)

[Jan Cumps]

This is a Tomcat configuration question. I moved the topic to our Tomcat forum.