JDBC Connections - groovy script
I created groovy scipt for Oracle db connection. I call the script in Project LoadScript as def racdb = new JDBCConnections(log) def sql = racdb.Connections() log.info(sql) How do I access s...
Forum Discussion
Hi Ole,
We are currently using clsutered database (Oracel RAC) and was unable to configure database conection from SOAPUI JDBC connections.
I have copied ojdbc6.jar under SOAPUI_HOMe/bin/ext and restarted the soapui, and selecting "Oracle thin/oracle.jdbc.driver.OracleDriver" from driver drop down and giving host, port, DB user, DB password and service name as ., but we don't have SID rather we have service name. but gettign error as "Can't get the Connection for specified properties; java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))"
Please let us know how to configure cluster database connections and what .jar files need to be copied under /bin/ext folder? my connection-url looks like as below:
jdbc:oracle:thin:@(description=(address_list=(load_balance=on)(failover=on)(address=(protocol=tcp)(host=hostname)(port=1521)))(connect_data=(service_name=servicename)(failover_mode=(type=select)(method=basic))))
We use JDK1.6 in my project.
Thanks
Raju
We are currently using clsutered database (Oracel RAC) and was unable to configure database conection from SOAPUI JDBC connections.
I have copied ojdbc6.jar under SOAPUI_HOMe/bin/ext and restarted the soapui, and selecting "Oracle thin/oracle.jdbc.driver.OracleDriver" from driver drop down and giving host, port, DB user, DB password and service name as ., but we don't have SID rather we have service name. but gettign error as "Can't get the Connection for specified properties; java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))"
Please let us know how to configure cluster database connections and what .jar files need to be copied under /bin/ext folder? my connection-url looks like as below:
jdbc:oracle:thin:@(description=(address_list=(load_balance=on)(failover=on)(address=(protocol=tcp)(host=hostname)(port=1521)))(connect_data=(service_name=servicename)(failover_mode=(type=select)(method=basic))))
We use JDK1.6 in my project.
Thanks
Raju