JDBC Connection using Oracle 10 JDBC Driver

building semantic layer
1

Hi All,

I am facing an issue with setting up a connection with Oracle 10g JDBC Driver Access Definition.

I keep on getting this error
CS: Java Class not found in classpath : com.businessobjects.connectionserver.java.drivers.jdbc.wrapper.JDBCWrapper

I have already corrected my jdbc.sbo setting and its Oracle 10g setting is

com.businessobjects.connectionserver.java.drivers.jdbc.oracle.OracleDriver


C:/oracle/product/10.2.0/client_1/jdbc/lib/ojdbc14.jar

oracle.jdbc.OracleDriver
jdbc:oracle:thin:@$DATASOURCE$:$DATABASE$

Oracle
oracle_jdbc.setup
oracle
oracle
oracle
oracle
Query,Procedures
oracle10,oracle,jdbc
/
Always
.

My oJDBC.Jar file is kept @ C:\oracle\product\10.2.0\client_1\jdbc\lib. I have already changed “/” with “” and vice versa. Restarted my entire system also. Not sure what to do next.

Best Regards,
Kapil Uppal

kapiluppal :india: (BOB member since 2006-06-15)

2

Hi

Did you manage to get this resolved? I am getting the same error message.

Thanks
rag1973

rag1973 (BOB member since 2010-07-08)

3

Anybody else with the same error and any known soultion ?

Regards,

Naresh Ganatra :us: (BOB member since 2004-04-09)

4

try this solution, worked for me.

  <Class JARFile="dbd_jdbc,dbd_oracle">com.businessobjects.connectionserver.java.drivers.jdbc.oracle.OracleDriver</Class>
  <JDBCDriver>
			 <ClassPath>

E:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar

oracle.jdbc.OracleDriver
jdbc:oracle:thin:@$DATASOURCE${:$DATABASE$}

bilearn (BOB member since 2010-01-30)