pandian66
Occasional Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: Not able to connect to Oracle from DataSource with type as JDBC
Richie and Rao , thanks for your follow-up, really appreciate your help. Rao , I am able to connect thru Toad. I was able to talk to my DB team and get the SID value for the DB being used and changed the connection string to use the SID value instead of the Service_name and now the connection is established So we can consider this issue as closed now Thanks Pandian4.1KViews1like0CommentsNot able to connect to Oracle from DataSource with type as JDBC
Getting the following error , when connecting to oracle DB in DataSource Step but its all good if I connect through Toad Can't get the Connection for specified properties; java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor Here are the details : DataSource : DataSource : JDBC Driver : oracle.jdbc.driver.OracleDriver Connection String : jdbc:oracle:thin:cmpvauto/PASS_VALUE@mydbserver:1521:mydb TNSNAMES.ORA Location : c:/app/user/product/11.2.0/client_1/network/admin Descrption : MYDB= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=mydbserver) (PORT=1521) ) (CONNECT_DATA= (SERVER=dedicated) (SERVICE_NAME=mydb) ) ) Toad Configuration SOFTWARE\WOW6432NODE\ORACLE (Oracle Root) ORACLE_HOME_NAME: ORACLE_HOME: ORACLE_SID: NLS_LANG: SQLPATH: LOCAL: Home directory does not exist! Home is not valid! SOFTWARE\WOW6432NODE\ORACLE\KEY_ORACLIENT11G_HOME1 ORACLE_HOME_NAME: OraClient11g_home1 ORACLE_HOME: C:\app\User\product\11.2.0\client_1 ORACLE_SID: NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252 SQLPATH: C:\app\User\product\11.2.0\client_1\dbs LOCAL: C:\app\User\product\11.2.0\client_1\Bin exists. C:\app\User\product\11.2.0\client_1\Bin is in PATH. Client DLL: C:\app\User\product\11.2.0\client_1\Bin\oci.dll Client Version: 11.2.0.1.0 Home is valid.Solved4.3KViews0likes3CommentsRe: Need to execute 2 test steps from the same test case in parallel.
Here is the use case When the soap request is sent the system is suppose to talk to an external system through MQ to get the response within the time out period In test environment the local PC acts as the external system consumes the MQ msg and does some file manipulation based on the MQ msg and post a response and application use the msg to send the soap response So once the request is submitted and response awaited I need to invoke a batch file which will invoke a java code to access MQ and do the file manipulation etc1.2KViews0likes0CommentsNeed to execute 2 test steps from the same test case in parallel.
I deed to execute 2 test steps from the same test case in parallel, the first one is a groovy script that will invoke a DOS batch file and the next one is an actual SOAP request. Could someone help me here please ?1.3KViews0likes3Comments