| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Business Object for Retrieving all table records |
« View previous topic :: View next topic » |
| Author |
Message
|
| alihshahin |
 Posted: Wed Jun 28, 2006 12:28 am Post subject: Business Object for Retrieving all table records |
 |
|
Newbie
Joined: 03 Jan 2006
Posts: 2
|
hi ,
I have a JDBC adapter for ORACLE.
I need help for business object definitions in order to retrieve all the records of a table(select * from table)
thanks. |
|
| Back to top |
|
 |
| thomeck |
| Posted: Wed Jun 28, 2006 5:48 am Post subject: |
|
|
Apprentice
Joined: 07 Apr 2006
Posts: 30
Location: Germany
|
Hi,
mhh I don't know wether it works with the JDBC-Connector...
because the Connector builds the sql statement like select attribute1, attribut2, ... from table where ident = ...
I think it will be better if you are working with a database connection pool.
-create a pool like dbConnPool
-then you can use the pool, something like:
CwDBConnection dbConnect = null;
dbConnect = getDBConnection("dbConnPool", false);
dbConnect.beginTransaction();
dbConnect.executeSQL("SELECT * FROM table");
...
Does this help you? |
|
| Back to top |
|
|
| veggiehui |
| Posted: Wed Jul 05, 2006 4:51 pm Post subject: |
|
|
Novice
Joined: 22 Mar 2006
Posts: 18
|
| But as I know,It seems WBI doesn't support ORACLE's Connection Pool. |
|
| Back to top |
|
|
| vk |
| Posted: Wed Jul 05, 2006 5:29 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
You can read all records from the table by defining a Wrapper BO and Child BO. The key field for the Wrapper BO should be present as a foreign key in the Child BO which will correspond to the actual table.
The key field for the Wrapper BO should be inserted into the Event Table. The connector will then read all the records from the table and send a single message to the Delivery Queue having the Wrapper BO attributes at the top level and all the records in the table as inner repeating elements in the XML.
Regards,
VK. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
