| Author |
Message
|
| marco |
 Posted: Wed Sep 16, 2009 6:52 am Post subject: SQL Server Polling |
 |
|
Apprentice
Joined: 16 Feb 2004
Posts: 46
|
Hi,
I have a request to pull data from an MS SQLServer 2005 table.
Has anybody done this before ?
I'm trying to create an Adapter config using CWYBC_JDBC.rar, but I have no luck in this approach.
The idea is to get 10.000 records from the table, so I'm geussing the DatabaseRetrieve node is not a good option.
Any thoughts maybe on doing it with a JavaCompute node ?
I have a WBIMBv6.1 running on WMQv7
Rgds |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Sep 16, 2009 7:02 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
I'm confused.
You can use standard Broker facilities to access SQLServer databases.
Are you trying to *initiate* a flow when a row is added to a table?
There's nothing wrong with processing 10,000 rows, as long as you do them one at a time and carefully. |
|
| Back to top |
|
|
| WMBDEV1 |
| Posted: Wed Sep 16, 2009 7:03 am Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
|
| Back to top |
|
|
| marco |
| Posted: Wed Sep 16, 2009 7:06 am Post subject: |
|
|
Apprentice
Joined: 16 Feb 2004
Posts: 46
|
Tx for the fast reply !
I will get around the triggering issue for sure. I'm not really trying to initiate it from a SQL Event (would be interesting if it was possible though)
what standard broker facilities are you aiming for ? |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Sep 16, 2009 7:07 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| marco wrote: |
| what standard broker facilities are you aiming for ? |
I'm aiming you at the Info Center on the ESQL "SELECT" statement. |
|
| Back to top |
|
|
| marco |
| Posted: Thu Sep 17, 2009 1:53 am Post subject: |
|
|
Apprentice
Joined: 16 Feb 2004
Posts: 46
|
Ok,
just to make sure I got this right.
1. create ODBC connection to MS SQLServer Db
2. mqsisetdbparms
3. SELECT or PASSTHRU in ESQL.
What would be the difference in doing this with JDBC and JavaCompute ?
Would it be worth the effort to check ? Does anybody have experince with this ?
M |
|
| Back to top |
|
|
|
|
