Beforehand, I apologise for this layman's question, which without any doubt has been asked a zillion times, but frankly even a topic-search didn't give me any usable hits.
The SAP-manual about creating an Oracle connection using the JDBC driver, states the following :
"JDBC Driver : Java class of the JDBC driver that the JDBC adapter must load to be able to access the driver. The specification varies according to the JDBC driver; see material from the respective provider for exact details."
That's interesting, but does anyone know what driver this could be for an Oracle-environment 9.2.0.5 running with Linux SuSe?
Thanks in advance.
Andre Jongerden.
Hi Andre,
The class you need in the integration builder for the JDBC driver is oracle.jdbc.driver.OracleDriver. After entering this class the adapter will work fine.
For the connection string you can use the following example:
Listener port of Oracle DB :
1521 Hostname where Oracle DB is running : p71214(req3server1)
Database ID of Oracel DB (SID) is: req3
db.connectionURL=jdbc:oracle:thin:uid/pwd@p71214:1521:req3
Best regards,
Alwin
Add a comment