problem in connecting to external database through sunone studio 5

Hi,

I am trying to connect to either MySQL (which is on my local system), or ORACLE which is on other server. I followes the article:

Connecting to External Databases With Sun ONE Studio 5 and Sun ONE Application Server 7

http://developers.sun.com/tools/javatools/tips/tip03-08-22.html

But it is giving me the same errors fro the both. Like these. I installed the respective drivers for the databases in the studio/lib/ext/ driectory. . According to my understanding of the error messages it is saying that, it cannot detect the vendor type name.

If some body can help, that would be greatful

Thank you very much.

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: java.lang.ClassNotFoundException: oracle.jdbc.pool.OracleDataSource[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1 443)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1 287)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.util.Utility.loadClass(Utility.java:425)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.repository.JdbcConnectionPool.createDataSource(JdbcConnectio nPool.java:232)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.JdbcUrlAllocator.createResource(JdbcUrlAllocator.ja va:80)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.createSteadyResources(IASN onSharedResourcePool.java:856)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.initPool(IASNonSharedResou rcePool.java:416)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(IASNon SharedResourcePool.java:625)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(IASNonSharedRe sourcePool.java:520)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl .java:263)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.JdbcXAConnection.<init>(JdbcXAConnection.java :74)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.SystemJdbc10XaAllocator.createResource(SystemJdbc10 XaAllocator.java:52)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.createSteadyResources(IASN onSharedResourcePool.java:856)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.initPool(IASNonSharedResou rcePool.java:416)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.internalGetResource(IASNon SharedResourcePool.java:625)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.IASNonSharedResourcePool.getResource(IASNonSharedRe sourcePool.java:520)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.PoolManagerImpl.getResourceFromPool(PoolManagerImpl .java:263)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.SystemJdbcDataSource.internalGetConnection(SystemJd bcDataSource.java:226)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.enterprise.resource.SystemJdbcDataSource.getConnection(SystemJdbcDataSo urce.java:154)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.jdo.spi.persistence.support.sqlstore.ejb.TransactionHelperImpl.getConne ction(TransactionHelperImpl.java:171)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.jdo.spi.persistence.support.sqlstore.ejb.EJBHelper.getConnection(EJBHel per.java:169)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.jdo.spi.persistence.support.sqlstore.impl.SQLPersistenceManagerFactory. getDBName(SQLPersistenceManagerFactory.java:781)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.jdo.spi.persistence.support.sqlstore.impl.SQLPersistenceManagerFactory. getFromPool(SQLPersistenceManagerFactory.java:709)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.jdo.spi.persistence.support.sqlstore.impl.SQLPersistenceManagerFactory. getPersistenceManager(SQLPersistenceManagerFactory.java:598)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.jdo.spi.persistence.support.sqlstore.impl.PersistenceManagerFactoryImpl .getPersistenceManager(PersistenceManagerFactoryImpl.java:770)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at JAdminEntityBeans.samoraBean875074947_ConcreteImpl.jdoGetPersistenceManager(sam oraBean875074947_ConcreteImpl.java:479)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at JAdminEntityBeans.samoraBean875074947_ConcreteImpl.ejbCreate(samoraBean87507494 7_ConcreteImpl.java:197)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at JAdminEntityBeans.samoraBean875074947_ConcreteImpl_RemoteHomeImpl.create(samora Bean875074947_ConcreteImpl_RemoteHomeImpl.java:26)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at JAdminEntityBeans._samoraHome_Stub.create(Unknown Source)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at java.lang.reflect.Method.invoke(Method.java:324)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.forte4j.j2ee.ejbtest.webtest.InvocableMethod$MethodIM.invoke(InvocableM ethod.java:231)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.forte4j.j2ee.ejbtest.webtest.EjbInvoker.getInvocationResults(EjbInvoker .java:96)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.sun.forte4j.j2ee.ejbtest.webtest.DispatchHelper.getForward(DispatchHelper.j ava:189)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at _jasper._dispatch_jsp._jspService(_dispatch_jsp.java:136)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.iplanet.ias.web.jsp.JspServlet$JspServletWrapper.service(JspServlet.java:55 2)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.iplanet.ias.web.jsp.JspServlet.serviceJspFile(JspServlet.java:368)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.iplanet.ias.web.jsp.JspServlet.service(JspServlet.java:287)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at org.apache.catalina.core.StandardWrapperValve.invokeServletService(StandardWrap perValve.java:720)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at org.apache.catalina.core.StandardWrapperValve.access$000(StandardWrapperValve.j ava:118)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at org.apache.catalina.core.StandardWrapperValve$1.run(StandardWrapperValve.java:2 78)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at java.security.AccessController.doPrivileged(Native Method)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 274)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 212)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:203)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:505)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.iplanet.ias.web.connector.nsapi.NSAPIProcessor.process(NSAPIProcessor.java: 157)

[10/Oct/2003:11:13:29] WARNING ( 3760): CORE3283: stderr: at com.iplanet.ias.web.WebContainer.service(WebContainer.java:598)

[10/Oct/2003:11:13:29] SEVERE ( 3760): 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 JAdminEntityBeans.samoraBean875074947_ConcreteImpl.jdoGetPersistenceManager(sam oraBean875074947_ConcreteImpl.java:479)

at JAdminEntityBeans.samoraBean875074947_ConcreteImpl.ejbCreate(samoraBean87507494 7_ConcreteImpl.java:197)

at JAdminEntityBeans.samoraBean875074947_ConcreteImpl_RemoteHomeImpl.create(samora Bean875074947_ConcreteImpl_RemoteHomeImpl.java:26)

at JAdminEntityBeans._samoraHome_Stub.create(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:136)

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(JspServlet.java:287)

at javax.servlet.http.HttpServlet.servi

[10/Oct/2003:11:13:29] WARNING ( 3760): Cannot get database metadata: database product name.java.sql.SQLException: com.sun.enterprise.repository.J2EEResourceException

java.lang.ClassNotFoundException: oracle.jdbc.pool.OracleDataSource

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