can't retrieve data from table when connect RMP with local sql server 2005

[shi-qin...@lafarge.com]

Hi,

I need to connect RMP with local sql server 2005 database. After installed SEC, JDBC and created the provider and connector, I can't get the table's records when click the launch test.The result is just below:
1 The SEC-ProtocolManager is running!
2 Registered Protocols
3 JDBC

Any help about this? Thanks in advance.

[Takafumi Hoshino]

Hi,

It seems you are almost there!

Can you look at this section in detail?

http://docs.runmyprocess.com/Integration_Guide/SEC/Adapters/JDBC#running-and-testing-the-adapter

The connector METHOD should be set to POST and that JSON should be set in CONTENT.

Best regards,

Taka

--
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/b79ce5e1-045a-476b-aebd-13554b3636d2%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

--

---------------------------------------------------

Taka Hoshino

Fujitsu RunMyProcess

+1-(408)-940-6873

Google Account: thos...@runmyprocess.com

[Shi-Qing Cheng]

Hi Taka,

Thanks for your help. But I didn't find where to set the method to POST and CONNECT in the connector. Thanks for further advice.

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/6hvqtw4quA8/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 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/CAEYDksi83HTVkgfJKSZGdhLFtmx4%3DrBu0wNYiMY8yN8OrKJMkA%40mail.gmail.com.

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

--

Best Regards,

Cheng,Shiqing  成世清
ChongQing BU
Tel:+86-023-63201052
Cell:(0)18696667880
Address: 重庆北部新区青枫北路18号  拓展区A3栋6楼
         6th floor,Phoenix House A, NO.18 of Qingfeng North Road, New Economic Development Zone,Chongqing401121,P.R.China
Postal code:401121

 

[Takafumi Hoshino]

Right, so in Provider set the protocol to HTTP, not RDCP.

Then you will see these options, and everything should work for you.

You are using latest SEC agent and Manager and JDBC adaptor, right?

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

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

[Shi-Qing Cheng]

Hi Taka,

Yes, I used the latest SEC agent, manager and JDBC for SQL server.

Is the below information correct when using sql server? Thanks again.

{

"protocol":"JDBC",

"data":{

    "DBType":"sqlserver",

    "sqlUsername":"sa",

    "sqlPassword":"1234",

    "sqlStatement":"SELECT * FROM mydatabase.customer Limit 10"

    }

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAEYDksiSW8d%2BtHCNRD91OZu6r%2BbO0NB3eA_tr3%2BNhC4oqFTTsg%40mail.gmail.com.

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

[Takafumi Hoshino]

Yes, looks okay.

Below is brief explanation, hope it helps.

{

"protocol":"JDBC", == yes, right

"data":{

    "DBType":"sqlserver", == this is what is written in "JDBC.config" file, the first word in each line.

    "sqlUsername":"sa", == this is database user name

    "sqlPassword":"1234",== this is database password

    "sqlStatement":"SELECT * FROM mydatabase.customer Limit 10" == this is SQL statement, looks okay but check if table exist.

    }

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/CAHj72krn_Du7P1z4YhiifyQ4PswdCH5%2Bcbv_sTs3eX0%3D1cV6Bg%40mail.gmail.com.

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

[Shi-Qing Cheng]

Hi Taka,

I tried. It seems it doesn't work. The result is below:

The connector is configured as below:

script:

{

"protocol":"JDBC",

"data":{

    "DBType":"SQLSERVER_2005",

    "sqlUsername":"sa",

    "sqlPassword":"lafarge.1234",

    "sqlStatement":"SELECT * FROM mydatabase.customer Limit 10"

   }

}

Thanks for your kind support!

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

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