Datasource connection pooling problem
anil
i have been trying to use Datasource connection pooling using Borland
App Server 4.5, but when i try to get the connection from a jsp page,
i get a
"Exception:java.sql.SQLException: No suitable driver" exception.
what might be the problem? can anybody help me out.
i have searched the groups for an answer and tried the ways they said,
but in vein.
i'm able to get the DataSource object in the jsp. but, when i call the
getConnection() on the datasource, i get the exception.
i am not using any ejb.
i am using Oracle 8.1.6
i have the classes12.zip in the classpath.
the jndi-definitions.xml is given below for reference.
am i missing anything here?....please help
-------------------------------------------------------------------
<?xml version="1.0"?>
<!DOCTYPE jndi-definitions PUBLIC "-//Borland Corporation//DTD
JndiDefinitions//EN"
"http://www.borland.com/devsupport/appserver/dtds/jndi-definitions.dtd">
<jndi-definitions>
<visitransact-datasource>
<jndi-name>serial://datasources/testVisiOracle</jndi-name>
<driver-datasource-jndiname>serial://datasources/testOracle</driver-datasource-jndiname>
<property>
<prop-name>connectionType</prop-name>
<prop-type>Enumerated</prop-type>
<prop-value>Direct</prop-value>
</property>
<property>
<prop-name>dialect</prop-name>
<prop-type>Enumerated</prop-type>
<prop-value>oracle</prop-value>
</property>
</visitransact-datasource>
<driver-datasource>
<jndi-name>serial://datasources/testOracle</jndi-name>
<datasource-class-name>oracle.jdbc.pool.OracleConnectionPoolDataSource</datasource-class-name>
<log-writer>False</log-writer>
<property>
<prop-name>user</prop-name>
<prop-type>String</prop-type>
<prop-value>abcd</prop-value>
</property>
<property>
<prop-name>password</prop-name>
<prop-type>String</prop-type>
<prop-value>abcd</prop-value>
</property>
<property>
<prop-name>databaseName</prop-name>
<prop-type>String</prop-type>
<prop-value>training</prop-value>
</property>
<property>
<prop-name>serverName</prop-name>
<prop-type>String</prop-type>
<prop-value>ntsrv100</prop-value>
</property>
<property>
<prop-name>portNumber</prop-name>
<prop-type>Integer</prop-type>
<prop-value>1521</prop-value>
</property>
<property>
<prop-name>driverType</prop-name>
<prop-type>String</prop-type>
<prop-value>thin</prop-value>
</property>
</driver-datasource>
</jndi-definitions>
------------------------------------------------------------------
thanQ
anil