NoSuchMethodExeption:setURL while accessing MS-SQL 7.0

Hi I am J2EE Beginner, and trying to learn more using Sun One Studio.

I have environment like this.

- Windows XP

- MS-SQL 7.0

- J2SDK 1.4.2_02

- J2SDKEE 1.3.1

- Sun One Application Server 7

- Sun One Studio 5

I've been following an Example from Sun.(http://developers.sun.com/tools/javatools/documentation/s1s5/productappcli ent.html)

and I decided to use MS SQL instead of pointbase DB in the "2. Setting Up Database Connectivity" section.

So I made a connection, a Connection Pool, a DataSource, and a Persistent Manager.

at the first time I used free jTDS JDBC Driver. but I failed with NoSuchMethoudException:setURL

I tried another trial jdbc drivers GATE3 from sprinta and Jboss from New Atlanta

it works fine with default DB connection to pointbase

- Exception -

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: java.lang.NoSuchMethodException: setURL

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.util.Utility.invokeSetMethodCaseInsensitive(Utility.java:386 )

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.repository.JdbcConnectionPool.createDataSource(JdbcConnectio nPool.java:238)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.JdbcUrlAllocator.createResource(JdbcUrlAllocator.ja va:80)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.createSteadyResources(IASN onSharedResourcePool.java:856)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.initPool(IASNonSharedResou rcePool.java:416)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(IASNon SharedResourcePool.java:625)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(IASNonSharedRe sourcePool.java:520)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl .java:263)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.JdbcXAConnection.<init>(JdbcXAConnection.java :74)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.SystemJdbc10XaAllocator.createResource(SystemJdbc10 XaAllocator.java:52)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.createSteadyResources(IASN onSharedResourcePool.java:856)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.initPool(IASNonSharedResou rcePool.java:416)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(IASNon SharedResourcePool.java:625)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(IASNonSharedRe sourcePool.java:520)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl .java:263)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.SystemJdbcDataSource.internalGetConnection(SystemJd bcDataSource.java:226)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.enterprise.resource.SystemJdbcDataSource.getConnection(SystemJdbcDataSo urce.java:154)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.jdo.spi.persistence.support.sqlstore.ejb.TransactionHelperImpl.getConne ction(TransactionHelperImpl.java:171)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.jdo.spi.persistence.support.sqlstore.ejb.EJBHelper.getConnection(EJBHel per.java:169)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.jdo.spi.persistence.support.sqlstore.impl.SQLPersistenceManagerFactory. getDBName(SQLPersistenceManagerFactory.java:781)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.jdo.spi.persistence.support.sqlstore.impl.SQLPersistenceManagerFactory. getFromPool(SQLPersistenceManagerFactory.java:709)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.jdo.spi.persistence.support.sqlstore.impl.SQLPersistenceManagerFactory. getPersistenceManager(SQLPersistenceManagerFactory.java:598)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerFactoryImpl .getPersistenceManager(PersistenceManagerFactoryImpl.java:770)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at ProductInvServer.ProductInvBean_629131956_ConcreteImpl.jdoGetPersistenceManager (ProductInvBean_629131956_ConcreteImpl.java:713)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at ProductInvServer.ProductInvBean_629131956_ConcreteImpl.ejbFindByPrimaryKey(Prod uctInvBean_629131956_ConcreteImpl.java:363)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at ProductInvServer.ProductInvBean_629131956_ConcreteImpl_RemoteHomeImpl.findByPri maryKey(ProductInvBean_629131956_ConcreteImpl_RemoteHomeImpl.java:61)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at ProductInvServer._ProductInvHome_Stub.findByPrimaryKey(Unknown Source)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at java.lang.reflect.Method.invoke(Method.java:324)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.forte4j.j2ee.ejbtest.webtest.InvocableMethod$MethodIM.invoke(InvocableM ethod.java:231)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.forte4j.j2ee.ejbtest.webtest.EjbInvoker.getInvocationResults(EjbInvoker .java:96)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.sun.forte4j.j2ee.ejbtest.webtest.DispatchHelper.getForward(DispatchHelper.j ava:189)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at _jasper._dispatch_jsp._jspService(_dispatch_jsp.java:138)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.iplanet.ias.web.jsp.JspServlet$JspServletWrapper.service(JspServlet.java:55 2)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.iplanet.ias.web.jsp.JspServlet.serviceJspFile(JspServlet.java:368)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.iplanet.ias.web.jsp.JspServlet.service(JspServlet.java:287)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at org.apache.catalina.core.StandardWrapperValve.invokeServletService(StandardWrap perValve.java:720)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at org.apache.catalina.core.StandardWrapperValve.access$000(StandardWrapperValve.j ava:118)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at org.apache.catalina.core.StandardWrapperValve$1.run(StandardWrapperValve.java:2 78)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at java.security.AccessController.doPrivileged(Native Method)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 274)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 212)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:203)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.iplanet.ias.web.connector.nsapi.NSAPIProcessor.process(NSAPIProcessor.java: 157)

[03/Dec/2003:15:31:25] WARNING ( 1900): CORE3283: stderr: at com.iplanet.ias.web.WebContainer.service(WebContainer.java:598)

[03/Dec/2003:15:31:25] SEVERE ( 1900): RAR5027:Unexpected exception in resource pooling

com.sun.enterprise.resource.PoolingException

at com.sun.enterprise.resource.JdbcUrlAllocator.createResource(JdbcUrlAllocator.ja va:100)

at com.sun.enterprise.resource.IASNonSharedResourcePool.createSteadyResources(IASN onSharedResourcePool.java:856)

at com.sun.enterprise.resource.IASNonSharedResourcePool.initPool(IASNonSharedResou rcePool.java:416)

at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(IASNon SharedResourcePool.java:625)

at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(IASNonSharedRe sourcePool.java:520)

at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl .java:263)

at com.sun.enterprise.resource.JdbcXAConnection.<init>(JdbcXAConnection.java :74)

at com.sun.enterprise.resource.SystemJdbc10XaAllocator.createResource(SystemJdbc10 XaAllocator.java:52)

at com.sun.enterprise.resource.IASNonSharedResourcePool.createSteadyResources(IASN onSharedResourcePool.java:856)

at com.sun.enterprise.resource.IASNonSharedResourcePool.initPool(IASNonSharedResou rcePool.java:416)

at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(IASNon SharedResourcePool.java:625)

at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(IASNonSharedRe sourcePool.java:520)

at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl .java:263)

at com.sun.enterprise.resource.SystemJdbcDataSource.internalGetConnection(SystemJd bcDataSource.java:226)

at com.sun.enterprise.resource.SystemJdbcDataSource.getConnection(SystemJdbcDataSo urce.java:154)

at com.sun.jdo.spi.persistence.support.sqlstore.ejb.TransactionHelperImpl.getConne ction(TransactionHelperImpl.java:171)

at com.sun.jdo.spi.persistence.support.sqlstore.ejb.EJBHelper.getConnection(EJBHel per.java:169)

at com.sun.jdo.spi.persistence.support.sqlstore.impl.SQLPersistenceManagerFactory. getDBName(SQLPersistenceManagerFactory.java:781)

at com.sun.jdo.spi.persistence.support.sqlstore.impl.SQLPersistenceManagerFactory. getFromPool(SQLPersistenceManagerFactory.java:709)

at com.sun.jdo.spi.persistence.support.sqlstore.impl.SQLPersistenceManagerFactory. getPersistenceManager(SQLPersistenceManagerFactory.java:598)

at com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerFactoryImpl .getPersistenceManager(PersistenceManagerFactoryImpl.java:770)

at com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerFactoryImpl .getPersistenceManager(PersistenceManagerFactoryImpl.java:660)

at ProductInvServer.ProductInvBean_629131956_ConcreteImpl.jdoGetPersistenceManager (ProductInvBean_629131956_ConcreteImpl.java:713)

at ProductInvServer.ProductInvBean_629131956_ConcreteImpl.ejbFindByPrimaryKey(Prod uctInvBean_629131956_ConcreteImpl.java:363)

at ProductInvServer.ProductInvBean_629131956_ConcreteImpl_RemoteHomeImpl.findByPri maryKey(ProductInvBean_629131956_ConcreteImpl_RemoteHomeImpl.java:61)

at ProductInvServer._ProductInvHome_Stub.findByPrimaryKey(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sun.forte4j.j2ee.ejbtest.webtest.InvocableMethod$MethodIM.invoke(InvocableM ethod.java:231)

at com.sun.forte4j.j2ee.ejbtest.webtest.EjbInvoker.getInvocationResults(EjbInvoker .java:96)

at com.sun.forte4j.j2ee.ejbtest.webtest.DispatchHelper.getForward(DispatchHelper.j ava:189)

at _jasper._dispatch_jsp._jspService(_dispatch_jsp.java:138)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.iplanet.ias.web.jsp.JspServlet$JspServletWrapper.service(JspServlet.java:55 2)

at com.iplanet.ias.web.jsp.JspServlet.serviceJspFile(JspServlet.java:368)

at com.iplanet.ias.web.jsp.JspServlet.service(Js

[03/Dec/2003:15:31:25] WARNING ( 1900): Cannot get database metadata: database product name.

java.sql.SQLException: com.sun.enterprise.repository.J2EEResourceException

java.lang.NoSuchMethodException: setURL

at com.sun.enterprise.resource.SystemJdbcDataSource.internalGetConnection(SystemJd bcDataSource.java:252)