Hi,

I am migrating my application from tomcat 4 to tomcat 6.0. But the data 
sources are not being created. 


I have configured the datasources in the server.xml as follows: 
Im trying to connect to sql server 2005. 


server.xml
<Resource name = "jdbc/sql_2005" 
                auth = "Container" 
                type = "com.microsoft.jdbcx.sqlserver.SQLServerDataSource" 
        />

 <Resource name = "jdbc/global05" 
                auth = "Container"
                type = "com.microsoft.pool.PoolDataSource" />
 
<ResourceParams name="jdbc/sql_2005" >
 
            <parameter><name>serverName</name>
            <value>NYCITASD074</value></parameter>
 
            <parameter><name>portNumber</name>
            <value>1433</value></parameter>
 
            <parameter><name>databaseName</name>
            <value>FBRAE_GLOBAL</value></parameter>
 
            <parameter><name>factory</name>
 
<value>com.microsoft.jdbcx.sqlserver.SQLServerDataSourceFactory</value></parameter>
 
            <parameter><name>driverClassName</name>
 
<value>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</value></parameter>
 
            <parameter><name>loginTimeout</name>
            <value>3000</value></parameter>
 
            <parameter><name>selectMethod</name>
            <value>cursor</value></parameter>
 
            <parameter><name>driverName</name>
            <value>SQLServer2005</value></parameter>
 
            <parameter><name>description</name>
            <value>SQL 2005 datasource</value></parameter>
 
            <parameter><name>user</name>
            <value>user-id</value></parameter>
 
            <parameter><name>password</name>
            <value>password</value></parameter>
 
        </ResourceParams>
 
        <ResourceParams name="jdbc/global05" >
 
            <parameter><name>factory</name>
 <value>com.microsoft.pool.PoolDataSourceFactory</value></parameter>
 
            <parameter><name>className</name>
            <value>com.microsoft.pool.PoolDataSource</value></parameter>
 
            <parameter><name>poolName</name>
            <value>2005pool</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>
 
            <parameter><name>description</name>
            <value>MSSQL_Pool05</value></parameter> 
        </ResourceParams>

</GlobalNamingResources>

  <!-- Define the Tomcat Stand-Alone Service -->
  <Service name="Tomcat-Standalone">

 

 

    <!-- Define an AJP 1.3 Connector on port 8009 -->
        <Connector port="8009" protocol="AJP/1.3" 
                           redirectPort="8443"
                           address="10.152.35.166"
               minProcessors="5" 
               connectionTimeout="20000"
               maxProcessors="50" 
               acceptCount="10" 
               enableLookups="false"
               tomcatAuthentication="true" debug="0"/>
 <Engine name="Standalone" defaultHost="localhost" debug="0" 
jvmRoute="dw05926usi1s" >
 <Realm className="org.apache.catalina.realm.JAASRealm" appName="websso" 
 
userClassNames="com.db.websso.providers.authentication.tomcat.WebSSOUserImpl" 
 
 
roleClassNames="com.db.websso.providers.authentication.tomcat.WebSSOGroupImpl" 
 
        debug="99" />

<ResourceLink name="jdbc/sql_2005" global="jdbc/sql_2005" 
type="com.microsoft.jdbcx.sqlserver.SQLServerDataSource"/>
            <ResourceLink name="jdbc/global05" global="jdbc/global05" 
type="com.microsoft.pool.PoolDataSource"/>
            <ResourceLink name="jdbc/sql_05" global="jdbc/sql_05" 
type="com.microsoft.jdbcx.sqlserver.SQLServerDataSource"/>
            <ResourceLink name="jdbc/fbrae05" global="jdbc/fbrae05" 
type="com.microsoft.pool.PoolDataSource"/>
        </Context>

      </Host>
 
I am getting the following error: 


PoolName = 2005pool PoolJndiRef = jdbc/global05
Init Param: jdbc/global05
javax.naming.NamingException: Cannot create resource instance
                 at 
org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:142)
                 at 
javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
                 at 
org.apache.naming.NamingContext.lookup(NamingContext.java:793)
                 at 
org.apache.naming.NamingContext.lookup(NamingContext.java:140)
                 at 
org.apache.naming.NamingContext.lookup(NamingContext.java:781)
                 at 
org.apache.naming.NamingContext.lookup(NamingContext.java:153)
                 at 
org.apache.naming.factory.ResourceLinkFactory.getObjectInstance(ResourceLinkFactory.java:97)
                 at 
javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304)
at org.apache.naming.NamingContext.lookup(NamingContext.java:793)
                 at 
org.apache.naming.NamingContext.lookup(NamingContext.java:140)
                 at 
org.apache.naming.NamingContext.lookup(NamingContext.java:781)
                 at 
org.apache.naming.NamingContext.lookup(NamingContext.java:153)
                 at 
com.microsoft.pool.JNDITool.getPoolDataSource(JNDITool.java:103)
                 at 
com.microsoft.pool.PoolHandler.createPool(PoolHandler.java:48)
                 at 
com.microsoft.pool.PoolHandler.init(PoolHandler.java:75)
                 at 
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
                 at 
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
                 at 
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
                 at 
org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
                 at 
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
                 at 
org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
                 at 
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
                 at 
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
                 at 
org.apache.catalina.core.StandardService.start(StandardService.java:516)
                 at 
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
                 at 
org.apache.catalina.startup.Catalina.start(Catalina.java:593)
                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native 
Method)
                 at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                 at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:597)
                 at 
org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
                 at 
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
java.lang.NullPointerException
                 at 
com.microsoft.pool.JNDITool.getPoolDataSource(JNDITool.java:123)
                 at 
com.microsoft.pool.PoolHandler.createPool(PoolHandler.java:48)
                 at 
com.microsoft.pool.PoolHandler.init(PoolHandler.java:75)
                 at 
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
                 at 
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
                 at 
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
                 at 
org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
                 at 
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
                 at 
org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
                 at 
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
                 at 
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
                 at 
org.apache.catalina.core.StandardService.start(StandardService.java:516)
                 at 
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
                 at 
org.apache.catalina.startup.Catalina.start(Catalina.java:593)
                 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native 
Method)
                 at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                 at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:597)
                 at 
org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
                 at 
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)


Please advise as to what could be wrong since im using the server.xml that 
i was using with the tomcat 4. 

Thanks,
Aparna


=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you