Forum Discussion
Tareque
17 years agoOccasional Contributor
Hi Ole,
From an earlier post i found that we have to specify the url in the following format
jdbc:oracle:thin:scott/tiger@10.185.13.128:1521:ora9i
I have done the same now in my DataSource
jdbc:oracle:thin:FAST/FASTER@10.185.13.128:1521:dtwd
but i am getting IO error
Tue Mar 11 14:36:49 EDT 2008:ERROR:java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
This is not a network issue as I am able to access the DB using a groovy script.
def sql = groovy.sql.Sql.newInstance("jdbc:oracle:thin:@10.185.13.128:1571:dtwd", "FAST", "FASTER", "oracle.jdbc.pool.OracleDataSource")
Can you please tell me how i can use this sql connection that I have created in the groovy script in the DataSource Step.
From an earlier post i found that we have to specify the url in the following format
jdbc:oracle:thin:scott/tiger@10.185.13.128:1521:ora9i
I have done the same now in my DataSource
jdbc:oracle:thin:FAST/FASTER@10.185.13.128:1521:dtwd
but i am getting IO error
Tue Mar 11 14:36:49 EDT 2008:ERROR:java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
This is not a network issue as I am able to access the DB using a groovy script.
def sql = groovy.sql.Sql.newInstance("jdbc:oracle:thin:@10.185.13.128:1571:dtwd", "FAST", "FASTER", "oracle.jdbc.pool.OracleDataSource")
Can you please tell me how i can use this sql connection that I have created in the groovy script in the DataSource Step.