SEC-JDBC Adapter installation for oracle db

[johnsont...@gmail.com]

Hi support,

I am now testing to install the SEC JDBC Adapter by accessing data stored in my local system oracle database.
The SEC installation is ok. The Protocol Manger and SEC Connector Agent is installed and tested without any problem.
Then I refer to the JDBC adapter installation and configure the JDBC adapter. But my dbagent is configured for oracle 10g database. I can start the JDBC adapter and from the SEC-Manager status test, I can see that the Protocol JDBC that I configured is registered.

However, when I use a connector to test, this JDBC adapter shows the Process result in error as below:
{"SECStatus":400,"error":"java.sql.SQLException: Listener refused the connection with the following error:\nORA-12505, TNS:listener does not currently know of SID given in connect descriptor\nThe Connection descriptor used by the client was:\nlocalhost:1521:orcl\n"}

In the JDBC adapter command prompt where the JDBC adapter is started, it also shows the error message:
java.sql.SQLException: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descript
or
The Connection descriptor used by the client was:
localhost:1521:orcl

It is strange that there is no "orcl" oracle instance in my system and I have not config the "orcl" db and I cannot find where this setting comes from in my server. However, the error message shows that the Connection descriptor use this "orcl".

Attached is the doc to show all the setting screen capture and the error message found.
Would you please advise?

Best regards,
Johnson

[Pankaj Kumar]

Hi Johnson,

Please try 

jdbc:oracle:driver_type:[username/password]@//host_name:port_number:SID




In jdbc.config file

jdbc:oracle:thin://localhost:1521:GVA913

where GVA913 is SID.

Though I was not able to test this configuration on my end, bit it seems its a jdbc configuration issue.

Please refer to below link for reference:-

http://docs.oracle.com/cd/E17781_01/appdev.112/e18805/getconn.htm#TDPJD138

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/73e09900-a9c8-4f0e-abfb-7c80014c4978%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[johnsont...@gmail.com]

Hi Pankaj,

Thank you for reply.
I finally got the solution after referring to the reference and your answer.
In the jdbc.config file, the "sqlSource" should be typed as below:
"jdbc:oracle:thin:@localhost:1521:GVA913"

The @ must be added in front of the host_name, and the // should be omitted. The [username/password] can be optional to add as it is defined in the POST body.
(If the @ sign is added but the // is still there, I still got another error message "Network adapter error".)
After I changed to the above, the JDBC Adapter can work now and I can get the SELECT result from the db.

Thank you for help

Johnson