How connect BI with Oracle DB

[Former Member]

Hi gurus,

I have a BI system in Iseries(DB4), I tried connect BI to Oracle Database with UD connect, I followed the UD conect GUIDE for BW 3.5, I used JDBC Driver Ojdbc6.jar.

I have a issue with the test JDBC connector.

http://<myserverBI>:50000/TestJDBC_Web/TestJDBCPage.jsp

I get the error

java.lang.UnsupportedClassVersionError: (oracle/jdbc/driver/OracleDriver) bad major version at offset=6

Exception id: [42003C008197020B0000000000001995000495444B967B67]

Thanks

William Neira

[Former Member]

Hi,

try with url-> jdbc:oralce:thin@<hostname>:1521:<SID>

1521 is default port (ask your db people port not alloted ,no firewall )

You can validate from below help documents

http://help.sap.com/saphelp_nw04s/helpdata/en/43/313c13198d0d26e10000000a1553f7/frameset.htm

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

Regards

Nagaraju

[Former Member]

Environment:

Our BI version is 7.01 , OS is iseries.

The target Oracle DB version is 11g(11.2.0.1.0, 64bits on AIX).

Configuration procedure :

1. Import Oracle driver "ojdbc6.jar" and create new driver which named "Oracle " under

JDBC Connector ->Runtime ->Driver in Visual Admin.

2. Jco RFC BI_J2EE and RFC TCP in SM59, the connection test is OK.

3. Connector container-> resource adapter ->add

library:ORACLE

4. Connector container-> Managed connection Factory -> Properties

DriverName: oracle.jdbc.OracleDriver

Password: ****

User:SIEC

URL: jdbc:oracle:thin@10.1.1.62:1522:SIEC

the error persist

java.lang.UnsupportedClassVersionError: (oracle/jdbc/driver/OracleDriver) bad major version at offset=6

Exception id: [42003C00819702E10000001A000019950004954808C45F78]

Thanks.

William Neira

[Former Member]

Hi,

Can you make sure DBSL patch is the latest one(you can check System-> status).

Also try to get more information from SM21logs & Event logs from OS side.

Regards

Nagaraju

[Former Member]

Thanks for your reply

I don't found DBSL patch

SM21 not get error.

[Former Member]

Hi ,

finally to help you, Can you make sure you have latest Java version (JDK).Also check JAVA_HOME variable properly set.

More over, you can exact error from oracle logs & event logs.

Still, if you get same error , validate JDK support with your OS.

Regards

Nagaraju

[Former Member]

JDK in my iseries DB4 is 1.4 and i am using JDBC Driver Ojdbc6.jar, in oracle page the OJDBC6 is compatible with JDK 1.6, the oracle DB is 10.2.0.1, It support JDK 1.5 and 1.6.

I should be update JDK in DB4??

can I use other JDBC Driver?

Regards

William Neira

[Former Member]

SOLVED!

My database is 11g, the JDBC Driver should be ojdbc6.jar, I download JDBC for DB 10g ojdbc14.jar. I load the driver and the connection works fine.

Many Thanks

William Neira