JDBC Receiver Adapter to connect to oracle

[rahul_kharya]

Hi all,

We are configuring communication channel for receiver JDBC Adapter to connect to oracle dataabase. The status is red in the Adapter monitor and it says that

"Receiver Adapter v1027 for Party '', Service 'MQ':

Configured at 23:31:45 2006-12-12

Processing Error: Accessing database connection 'jdbc:odbc://172.20.36.170:1521;DatabaseName=RTPOC failed: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Addtional information: JDBC driver 'oracle.jdbc.driver.OracleDriver' loaded successfully, additional driver information:

Available JDBC drivers:

oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

sun.jdbc.odbc.JdbcOdbcDriver, 2.1 JDBC compliant

I guess there is some error in the connection url....could someone give us the exact syntax of Connection url.

Regards

[Former Member]

Hi,

Try this...

jdbc:oracle:thin:@172.20.36.170:1521:RTPOC

Regards,

Uma

[rahul_kharya]

Hi,

I tried and it is giving as "'jdbc:odbc:thin:@172.20.36.170:1521:RTPOC' failed: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name too long"

Regards

[bhavesh_kantilal]

Rahul,

What is the driver name you have given in the Receiver JDBC adapter?

IS it <b>oracle.jdbc.driver.OracleDriver</b>?

Regards,

Bhavesh

[rahul_kharya]

Hi Bhavesh,

I tried with both drivers. sun.jdbc.odbc... as well as oracle.jdbc.driver.

Its returning the same error.

Regards

[Former Member]

Hi,

Try this too:

Driver: oracle.jdbc.driver.OracleDriver

Connection Url: jdbc:odbc:thin:@172.20.36.170:1521:RTPOC

or

Driver: oracle.jdbc.driver.OracleDriver

Connection Url: jdbc:odbc:oci8:@172.20.36.170:1521:RTPOC

Regards,

P.Venkat

[bhavesh_kantilal]

Hi

to access oracle database you should use the oracle driver.

The url should be as shown by Uma in her reply,

jdbc:oracle:thin:@<IP adress>:<listener port>:<instance name (database name)>

Just make sure the the database name is correct.

Regards,

Bhavesh

[rahul_kharya]

Do i need to create a datasource with the name as thin???

How do i check whether the driver is present or not?

[Former Member]

>>Available JDBC drivers:

oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

The msg shows you have the jdbc drivers deployed. The problem is with the URL

Regards,

Jai Shankar

[rahul_kharya]

Hi all,

someone please clarify me. I have a datasource called "OracleDSN" in system 172.20.36.239 which has oracle client(RTPOC) in it.

So i gave my connection url as

jdbc:odbc:OracleDSN:@172.20.36.239:1521:RTPOC.

it still says that datasource name is too long..

Please help us out.

Regards

[bhavesh_kantilal]

Hi,

Did you try this URL ?

<b>jdbc:oracle:thin:@172.20.36.239:1521:OracleDSN</b>

Regards,

Bhavesh

[rahul_kharya]

Hi Bhavesh,

i got an " ERROR: Attempt to access JDBC connection failed with "No suitable driver" with the connection URL you specified.

Regards