Skip to Content
0
Former Member
Jun 16, 2006 at 05:32 PM

simple JDBC - File scenario -- jdbc adapter error

22 Views

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