Some questions about JDBC

[jess...@gmail.com]

Hi,

I'm trying a JDBC connector, at present I have a problem with the SEC and I can not test it.
For this reason I would like test JDBC connector in local, i.e. only I want to know the necessary parameters for to invoke, in command line, JDBC.jar.

Other question, in this url: http://docs.runmyprocess.com/User_Guide/Development_Environment/Toolbox/My_Connectors/Connectors

I can see how to configure RDCP provider and in this support I've seen snapshot like (image attached), but I don't know where is this configuration in RMP IDE.

I need some help.

Thank you and regards,

Jessica

[Pankaj Kumar]

Hi,

To connect to local db, using RDCP provider, you need to setup SEC. I have highlighted the text below in blue from User Guide.

User name
Id : Unique ID of the service. The ID is generated and cannot be modified.
Provider url : Address to access server where JDBC connector is set up. It can be localhost if using Secured Entreprise Connector

SEC - JDBC Adaptor reference link:-  http://docs.runmyprocess.com/Integration_Guide/SEC/Adapters/JDBC

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 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/513f31d2-a0da-4f72-8460-1aac4032d127%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[jessi mj]

Then is not possible to test JDBC.jar without to setup SEC previously ?, but it's a .jar I can execute it ( java -jar JDBC.jar). Maybe, I can to put some parameters in command line, like the port.

My other question was: 

I can see how to configure RDCP provider and in this support I've seen snapshot like (image attached), but I don't know where is this configuration in RMP IDE.
​

Thanks again and regards,

Jessi

You received this message because you are subscribed to a topic in the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/S1HP0-mYkNI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to supportforum...@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/CADHrCaxMNMcmvqZe6Fm%2BNin%2BDKFAJch96j1mj6Kd820hZ-Hn5w%40mail.gmail.com.

[jess...@gmail.com]

Hi again,

I have another question. Is it possible to connect rmp with a local DB with https protocol, or is necessary to use rdcp protocol?

Because I have configured a provider with https and I would like to use it.

By the way, I found the configuration of the connector for rdcp provider.

Thanks and regards,

Jessica

[Pankaj Kumar]

Hi,

You can create mysql adaptor and access the database from RunMyProcess by http post request.

Reference link:-

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

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

Jessica

--
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 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/076d0e48-2a1e-49b7-9deb-69cbf013a1b2%40runmyprocess.com.

[jess...@gmail.com]

Ok,

thank you for the reply, but, Is it possible to call JDBC.jar with eclipse. I'd try it before using it from RMP. Other possibility could be to call JDB.jar from command lines adding the necessaries parameters( but I don't know).

Can you help me?

Regards,

Jessi

[Pankaj Kumar]

Hi,

You can connect to mysql database by Eclipse using JDBC jar and mysql connector jar. However to integrate RunMYProcess to your Database, you need to use Secure Enterprise connector (SEC).

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/7d883f7d-7ee8-4c1f-b45c-016e99d9c178%40runmyprocess.com.

[jessi mj]

Hi and thanks for your reply,

but I have another question, if I import JDBC.jar and mysql-connector.jar in a java project, how I can to use this classes? Because I don't see the implementación. Inside of JDBC.jar there are a package named:  org.runmyprocess.sec. then for test this JAR also is necessary to have SEC, no? 

Maybe, I  have to create a different project instead of java project, or is necessary to import more libraries, or... I don't know.

Can someone help me? 

Regards,

Jessi

You received this message because you are subscribed to a topic in the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this topic, visit https://groups.google.com/a/runmyprocess.com/d/topic/supportforum/S1HP0-mYkNI/unsubscribe.
To unsubscribe from this group and all its topics, send an email to supportforum...@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/CADHrCawQhNtApTe2yCkRpL%2BhYNrPGiqu1MLvUSkriKV30cfs%3Dg%40mail.gmail.com.

[Pankaj Kumar]

Hi Jessica,

In JDBC.jar, JDBC.class file method, connection to database is as follows:-

 private Connection getConnection(String userName, String password, String sqlSource, String sqlDriver, String driverPath) throws Exception {

        this.LOG.log("Connecting to " + sqlSource, Level.INFO);

        Connection conn = null;

        Properties connectionProps = new Properties();

        connectionProps.put("user", userName);

        connectionProps.put("password", password);

        URL[] urls = new URL[1];

        File f = new File(driverPath);

        urls[0] = f.toURL();

        URLClassLoader ucl = URLClassLoader.newInstance(urls);

        Driver driver = (Driver)Class.forName(sqlDriver, true, ucl).newInstance();

        DriverManager.registerDriver(new DriverShim(driver));

        conn = DriverManager.getConnection(sqlSource, userName, password);

        this.LOG.log("Connected to database", Level.INFO);

        return conn;

    }

Here, string sqlSource is the database address either it is local machine or remote server, also kindly do not relate this jar to Java™ JDBC API jar provided by Oracle which consist mainly two package "java.sql" and "javax.sql" and database driver is implementation of this API.

org.runmyprocess.sec.SECLogManager.JDBC class inside uses the JDBC API for connection and executing query, this class converts the resultset to JSONObject by resultSet2JSONObject method.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAFDDfvAZZLH8%3D1p6GJsHq%3Dnp37fw4K13sznQRMueTX8AuSkL3Q%40mail.gmail.com.