Configuring JDBC in AppServer 9
I have downloaded the entire AppServer 9 + Netbeans 5.5 Bundle (from netbeans.org) for MacOSX and I am trying to configure a connection pool for Oracle 8i.
I am following the steps in the Administration Guide about setting up a JDBC connection pool for 9i/10g (since there is no mention of 8i) and it does not work. Once I save the connection and try to ping it I get this error:
Operation'pingConnectionPool' failed in'resources' Config Mbean. Target exception message: Class name is wrong or classpath is not setfor : com.sun.sql.jdbcx.oracle.OracleDataSource
My settings are :
Resource Type : javax.sql.DataSource
Vendor : Oracle
Datasource Classname : oracle.jdbc.pool.OracleDataSource
Then for additional properties I set
user, password, SID, serverName, portNumber
The PDF makes mention of some files smbase.jar, smoracle.jar, smutil.jar. These 3 files do not exist at all in the app server distribution. I found mention in another thread that you have to get them from datadirect.com - which you have to buy. Not cool.
Can I use my oracle provided jdbc drivers?
