java.lang.ClassNotFoundException: com.sap.portals.jdbc.oracle.OracleDriver

[Former Member]

any help why we get this error

java.lang.ClassNotFoundException: com.sap.portals.jdbc.oracle.OracleDriver

From EP using "System Administration" have created SYSTEM object with below details

Connection URL - jdbc:sap:oracle://xxxxxxxx:1521;SID=xxxxx

Driver Class Name - com.sap.portals.jdbc.oracle.OracleDriver

when test the connection getting "Connection successful" message.

In my JSP have below code to access this system

JDBCConnectionDriver conn = new JDBCConnectionDriver("com.sap.portals.jdbc.oracle.OracleDriver",Constants.DBCONNECTION_ORCL,Constants.DBUSERNAME_ORCL, Constants.DBPASSWORD_ORCL);

myConnection = conn.connect();

when run my JSP from logs getting above error? any advises on where I am doing wrong?

Thanks in advance!

[Former Member]

Hi Chakravarthy,

you can place jar file containing oracle driver in Java_Home\jre\lib\ext folder.

I think it will work.

[Former Member]

HI,

Place the oracle driver in the classpath , in the lib folder of the application...or in the lib folder of the server.

For use with JDK 1.4

ojdbc14.jar - JDBC classes (1,212,964 bytes) .

If this is helpful please give points.

Thanks

Ritu

Message was edited by:

Ritushree Saha

[Former Member]

Hi there,

The classNotFoundException means the JVM cannot find the class file for this particular class, it might be Inner Class also, Please give the appropriate jar file in the CLASSPATH. you can open the jar file and confirm thecorresponding class in present in it.

regards

Vivek Nidhi

[Former Member]

hi,

Place the jar containing the oracle driver in the project classpath and the jar in the lib folder of the application.

Please refer this to find the appropriate jar :

For use with JDK 1.4

ojdbc14.jar - JDBC classes (1,212,964 bytes)

ojdbc14_g.jar - JDBC classes with debug and trace(1,427,311 bytes)

ocrs12.jar - Additional RowSet support (37,761 bytes)

For use with JDK 1.2 and JDK 1.3

classes12.jar - JDBC classes (1,234,433bytes)

classes12_g.jar - JDBC classes with debug and trace (1,476,640 bytes)

classes12dms.jar - JDBC classes for use with Enterprise Manager (1,240,587 bytes)

classes12dms_g.jar - JDBC classes for use with EM and with debug and trace (1,483,154 bytes)

ocrs12.jar - Additional RowSet support (37,761 bytes)

nls_charset12.jar - Additional National Language character set support (1,848,170 bytes)

For use with JDK 1.1

classes111.jar - JDBC classes (1,063,074 bytes)

classes111_g.jar - JDBC classes with debug and trace (1,413,613 bytes)

nls_charset11.jar - Additional National Language character set support (1,847,214 bytes)

Please give points if this helps you to solve the problem

Thanks

Ritu

Message was edited by:

Ritushree Saha

[Former Member]

Hi,

check whether the jar file containing the class "com.sap.portals.jdbc.oracle.OracleDriver" is in java's build path.

Regards,

Beevin.