DataSource config problem :(

[maninder s batth]

Hi
i spent 7 hours trying to figure out the problem, but no luck, anyone with leads pls help!!!!!
i have following data source configuration in server.xml
<Resource name="jdbc/NPGnomonDB" auth="Container" type="javax.sql.DataSource" />
<ResourceParams name="jdbc/NPGnomonDB" >
<parameter><name>factory</name><value>com.ddtek.jdbcx.sqlserver.SQLServerDataSource</value></parameter>
<parameter><name>DatabaseName</name><value>some_Db</value></parameter>
<parameter><name>Password></name><value>sa</value></parameter>
<parameter><name>ServerName></name><value>1.1.1.3</value></parameter>
<parameter><name>User</name><value>sa</value></parameter>
</ResourceParams>
and my web.xml has
<resource-ref>
<description>
Data Source
</description>
<res-ref-name>
jdbc/NPGnomonDB
</res-ref-name>
<res-type>
javax.sql.DataSource
</res-type>
<res-auth>
Container
</res-auth>
</resource-ref>

The class com.ddtek.jdbcx.sqlserver.SQLServerDataSource does implements javax.sql.DataSource

in my source code i have following lines
Context iCtx = InitialContext();
Context ctx = (Context) iCtx.lookup("java:comp/env");
DataSource ds = (DataSource) ctx.lookup("jdbc/NPGnomonDB");

and i get the following error

javax.servlet.ServletException: javax.naming.NamingException: Could not create resource factory instance, com.ddtek.jdbcx.sqlserver.SQLServerDataSource
at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:146)
at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:312)
at org.apache.naming.NamingContext.lookup(NamingContext.java:834)
at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
at org.apache.naming.NamingContext.lookup(NamingContext.java:194)


Any leads ??





--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>