SAP - xMII and Oracle 8i database connection

[Former Member]

Hello everybody.

Help pls:

what is the format of the serverURL ?

which driver schould i use for the connection? oracle.jdbc.driver.OracleDriver oder sun.jdbc.odbc.JdbcOdbcDriver? what is the difference?

Thanks

[Former Member · Accepted solution]

Hi Emile,

You need to use oracle.jdbc.driver.OracleDriver for Oracle database. For third party database you need to use sun.jdbc.odbc.JdbcOdbcDriver other than Oracle and SQL.

Thanks,

Rajesh

PS : Please award points if answer is useful.

[Former Member · Accepted solution]

Thanks.

How about the serverURL params?

Emile

[Former Member · Accepted solution]

Hi Emile.

The JDBC drivers shipped with SAP xMII include those for Oracle, SQL Server, and ODBC. As specified by the ones before me, you need to use the "oracle.jdbc.driver.OracleDriver", being specifically designed to work with Oracle 7 and higher. The other driver you specified is used to access the Oracle server through ODBC connections. It's slow, as compared to the first mentioned one, so you do not want to use it.

The connection string has to look like the example in manual : "jdbc:oracle:thin:@hammer1:1521:ORC1". In this example, the Oracle server located on a machine named "hammer1" will be connected to via TCP/IP port 1521, to an Oracle instance named "ORC1". You can replace these values with your own values.

We can discuss the methods of opening a connection using the Oracle JDBC OCI driver (1), or the thin driver (2) as recommended by the xMII documentation.

1. When using the OCI driver, the database can be specified using the TNSNAMES entry in the tnsnames.ora file. For example, to connect to a database on a particular host as user oratest and password oratest that has a TNSNAMES entry of oracle.world, you use the following connection string: "jdbc:oracle:oci8:@oracle.world". Both the ":" and "@" are mandatory.

2. When using the JDBC thin driver, the TNSNAMES entry cannot be used to identify the database. There are two ways of specifying the connect string in this case, namely,

<b>

a) Explicitly specifying the hostname, the TCP/IP port number, and the Oracle SID of the database to connect to. This is for thin driver only.

For the explicit method, use the following connection string to connect to a database on host [training] where the TCP/IP listener is on port [1521], the SID for the database instance is [Oracle]: "jdbc:oracle:thin:@training:1521:Oracle". Both the ":" and "@" are mandatory.

</b>

b) Specify a Net8 keyword-value pair list.

For the Net8 keyword-value pair list, use the following connection string:

"jdbc:oracle:thin@(description=(address=(host=training)(protocol=tcp)(port=1521)) (connect_data=(sid=Oracle)))".

This method can also be used for the JDBC OCI driver. Just specify oci8 instead of thin in the above keyword-value pair list.

In the examples above, you have the xMII manual version with strong characters.

However, before getting excited using the THIN CLIENT DRIVER please explore the new realm of JDBC connectivity. I still get some errors (e.g. E/A-Exception: The Network Adapter could not establish the connection ..) if two applications try to connect simultaneously to the oracle server. And if the exception has occurred once I can only fix the problem by restarting the oracle 8i (8.1.7) listener.

[Former Member · Accepted solution]

Hi Paul thanks for u´r response.

I did exactly what u said but i can´t get the connection.

Protocol Log File:

FATAL : Connector : Unable to create connection pool for My Server_Name: java.lang.ClassNotFoundException: oracle/jdbc/driver/OracleDriver

ERROR : ConnectionPool : Error loading JDBC driver, java.lang.ClassNotFoundException: oracle/jdbc/driver/OracleDriver

so what can be the reason?

Emile

[Former Member · Accepted solution]

Hi Emile,

In the place of the Oracle database name, which name you gave there. Its not the name of the database. I also did that mistake once. I think its instance name. Please confirm with your oracle DB guys about this one, that what they use if they want to access Oracle database other than the name of the database.

Thanks,

Rajesh

[Former Member]

Emile,

Check out this in the xMII Help Documentation:

http://<servername>/LighthammerCMS/Help/Connectors/IDBCConnector.htm

Depending on the version of the Oracle DB, you may have to use a different Oracle JDBC driver. xMII ships (or use to) with two Oracle DB drivers. If you notice any date issues with your query results, look into the other driver.

[Former Member]

Hi Ryan,

Thank´s 4 u´r response.

Emile

[Former Member]

Hi,

If you r using oracle database the parameters need to be set are:

jdbcdriver name:like ex: oracle.jdbc.driver.OracleDriver

server package like ex:com.lighthammer.Illuminator.connectors.IDBC

password for the user

server url:like jdbc:mysql://mysqlServer/UserDatabase

if u need additional info plz revert back