JDBC Adapter

[angie....@opensky.com.co]

Hi all,

I'm trying to connect to a Oracle database through SEC-JDBC Adapter but I have the result attached.

I think the adapter is not running properly. Please see the screenshots.

Thanks for your help.

[Ankita Shrinath]

Hi Angie,

Thank you for contacting Fujitsu RunMyProcess Support.

Following are the changes you need to make in configuration DBAgent.config file 

Note that you must download the corresponding JDBC driver file.

1)Provide its path : (the path where JDBC driver file is present in your system).

2)the port:(1521).

3)and the name of the DB :(name of the DB you are using).

Please find the attached image. 

Running Adapter:

you can run the Adapter by executing the rmp-sec-dbConector.jar from the installed path :

java -jar JDBC.jar

For more ref please visit the link :

http://docs.runmyprocess.com/Integration_Guide/SEC/Adapters/JDBC

http://docs.runmyprocess.com/Integration_Guide/SEC/Installation_Guide

Regards,

Ankita

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+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://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/4e72e988-7a84-42d9-ba33-1051cdd877a6%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[angie....@opensky.com.co]

Hi Ankita,

Thanks for your answer, but we already done those steps. We downloaded the corresponding driver to Oracle 12C and made the changes in the config file (as you can see in a previous screenshot that I sent).

I appreciate if you can give us some example refering to a Oracle 12C database.

I send the config file.

Regards.

[Pankaj Kumar]

Hi Angie,

You are using Provider "BD Oracle (url not clear in screen-print) with port 1531)" and making post request. You need to make the post request to SEC Manager IP which is  127.0.0.1:4444 as per your shared scree-print.

Please make the post request to Manager Host with same query which is in curly braces.

If you still face problem, please share the logs with us which will be available on JDBC.jar running console window.

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+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://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/7b7827c6-0df9-4909-a4b3-9ce957681ccc%40runmyprocess.com.

[Shobhit Tripathi]

Hi Angie,

As per the JDBC.config file send by you please make sure that you have to use well structured JDBC config file to get connected. Like -

#DBAgent Configuration

ORACLE_12C = {"sqlDriver" : "oracle.jdbc.driver.OracleDriver", "sqlSource" : "jdbc:oracle:thin:@carina:1531:ORAPRU","sqlDriverPath" : "D:/\secrmp/\adapters/\JDBC/\ojdbc7.jar"}

where D: = Use your drive directory where you have installed you Adapter.

There might be the other reasons as well. Please make sure that you have followed mention points -

1. Please check the IP address/port or domain/port (where server has been installed) should be passed correctly and it should be enabled by your firewall network to access. (both side from client to server and server to client). Use- ping or telnet command to check.

2. It is recommended to use same path for both SEC agent and Adapter so that it will be easier to communicate.

3. Make sure that provided destination path for the adapter is properly structured. (In your case please try with the address like this in sqlDriverPath- D:/\SEC-RunMyProcess/\Adapters/\..... this is basically for Windows for escaping special characters).

4. Make sure that #DBAgent Configuration does not consist of any white spaces.

5. Once you initiated the adapter properly please check in the connector or browser (http://localhost:8080) that  SEC and JDBC Adapter is running and displayed.

If you still facing the same problem please share us the log report either from the Adapter console window or log file (you can get it from the SEC agent folder i.e. sec-agent-zicatela-->log-->ragent).

Hope this helps you. Do not hesitate to revert it back.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CADHrCazc2BgomMWdeTxVAxDxQwyt6SJQ%2BV6O-Qna58oCTrmtOg%40mail.gmail.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

--

Thanks & Regards,

Shobhit

Fujitsu- RunMyProcess

[angie....@opensky.com.co]

Thanks guys! Issue solved.

The initial problem was, as Pankaj said, that in the provider I had the ip from database server, so I changed it to the ip from sec manager server and the connection works ok. Next, I had to change de sqlSource to "jdbc:oracle:thin:@172.18.1.66:1531:ORAPRU"; I changed the host name to the ip from database server.

The sqlDriverPath it's ok, I'm working in a linux server.

Thanks so much for your help!