Iam getting problem in implementing Connection Pooling in Borland App server 4.5.1.The problem is
we used OracleConnectionPoolDataSource class as a DataSource classname for Driver DataSource and given the properties such as user,password,databaseName,serverName,portNumber,
driverType.we also created visiTransact DataSource with JNDI with datasource name as "serial://datasources/agdsdatasource". we are unable to get the Connection by using the following code in
jsp page.
<%
Context ctx=new InitialContext();
DataSource ds=(DataSource)ds.lookup("serial://datasources/agdsdatasource");
Connection conn=ds.getConnection();
%>
The error message is
Root cause:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:537)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:102).
AnyOne can help me out.
