simple JDBC - File scenario -- jdbc adapter error

[Former Member]

hello all,

i am doing a simple jdbc to file scenario where i am reading just one record from table 1 with 2 fields and posting it as a file.

when i run the monitoring: in the adapter monitor i see the following error:

Sender Adapter v2108 for Party '', Service 'Manudev':

Configured at 2006-06-15 19:12:53 PDT

History:

- 2006-06-16 10:14:02 PDT: Retry interval started. Length: 30.000 s

- 2006-06-16 10:14:02 PDT: Error: Accessing database connection 'jdbc:oracle:thin:@:1521:' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@:1521:': SQLException: Io exception: The Network Adapter could not establish the connection

- 2006-06-16 10:14:00 PDT: Processing started

- 2006-06-16 10:13:32 PDT: Error: Accessing database connection 'jdbc:oracle:thin:@:1521:' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@:1521:': SQLException: Io exception: The Network Adapter could not establish the connection

- 2006-06-16 10:13:30 PDT: Processing started

*********************************************************

can anybody provide me any ideas:

as far the db connection parameters,i have mentioned:

jdbc driver : oracle.jdbc.driver.OracleDriver

connection: jdbc:oracle:thin:@<mvhscdevdb>:port:<systemid>

please advice

[moorthy · Accepted solution]

Hi Aarthi,

The connection string should be in the format,

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

More-

Hope this helps,

Regards,

Moorthy

Message was edited by: Krishna Moorthy P

[Former Member]

Hey Aarthi,

Please also check this :

http://help.sap.com/saphelp_nw04s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

Vara

[PLEASE REWARD FOR POSTING]