| Author |
Message
|
| sirisha.n |
 Posted: Sun Apr 27, 2008 11:48 pm Post subject: update a table using JDBC Adapter |
 |
|
Apprentice
Joined: 25 Feb 2008
Posts: 27
|
Hi,
I want to update a table(db2) with some parameters which are coming from MB flow.
the flow is some thing like blow.
MB flow -----------------> JDBC Adapter -----------------> DB2
(sends parameters) (configuring connector ) (Table updation )
I mentioned MB flow's output Queue as connector's Request Queue and i also written a simple select query as a value to PING QUERY property of connector.
it doesn't work.
do i required to do any other configuration.
 |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Sun Apr 27, 2008 11:51 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
did you go through the JDBC adapter PDF.
Did you configure the BO
did you configure the Connector.
dont know what verb you have used in the connetor
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| sirisha.n |
| Posted: Mon Apr 28, 2008 2:03 am Post subject: |
|
|
Apprentice
Joined: 25 Feb 2008
Posts: 27
|
HI,
I have gone through Adapter PDF.
The output of MB flow is a BO.
configuring the connector means, I mentioned MB flow's output Queue as connector's Request Queue and i also written a simple select query as a value to PING QUERY property of connector.
please correct me if i am wrong.
the verb i used is 'Create',i hard coded it in esql.
thanks |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Mon Apr 28, 2008 2:22 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
run visual connect to test the same,
and let us know the error you are getting. check the adapter logs too
make sure the event tables are polling by the connector too.
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| sirisha.n |
| Posted: Mon Apr 28, 2008 3:23 am Post subject: |
|
|
Apprentice
Joined: 25 Feb 2008
Posts: 27
|
Hi,
I am getting following exception if i run connector and placing data in the queue.
[Time: 2008/04/28 07:13:05.844] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: REQJmsThreadPool.thread11 (#1301089172)] [Type: Error] [MsgID: 9064] [Mesg
: Message received is not of the type (Text, Object) expected for the current en
cryption settings. Message ID: ID:414d512041737369676e5f514d2020200d6b154820044b
06]
[Time: 2008/04/28 07:13:05.844] [System: Server] [Thread: REQJmsThreadPool.threa
d11 (#1301089172)] [Type: Error] [MsgID: 84017] [Mesg: Unable to deliver the mes
sage to the Queue. Reason: java.lang.ClassCastException: com.ibm.jms.JMSBytesMes
sage]
[Time: 2008/04/28 07:13:05.844] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: REQJmsThreadPool.thread11 (#1301089172)] [Type: Error] [MsgID: 9061] [Mesg
: Caught JMS error. Reason: javax.jms.JMSException: java.lang.ClassCastException
: com.ibm.jms.JMSBytesMessage.]
[Time: 2008/04/28 07:13:05.844] [System: Server] [Thread: REQJmsThreadPool.threa
d11 (#1301089172)] [Mesg: [Type: Fatal Error] [MsgID: 17056] [Mesg: Failed to es
tablish connection to messaging system.] ]
thanks.... |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Mon Apr 28, 2008 4:08 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| sirisha.n wrote: |
[Th
read: REQJmsThreadPool.thread11 (#1301089172)] [Type: Error] [MsgID: 9064] [Mesg
: Message received is not of the type (Text, Object) expected for the current en
cryption settings. Message ID: ID:414d512041737369676e5f514d2020200d6b154820044b
06]
|
The message that you are pushing to the queue doesn't match with the BO that you have imported to WBIMB
check that first....
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| sirisha.n |
| Posted: Mon Apr 28, 2008 10:21 pm Post subject: |
|
|
Apprentice
Joined: 25 Feb 2008
Posts: 27
|
Hi Gaya3,
As you said, i just placed a simple XML in the queue and i run the connector with simple select query.
now i am facing following exception:
[Time: 2008/04/29 02:19:59.188] [System: Server] [Thread: REQJmsThreadPool.threa
d1 (#1287422410)] [Mesg: java.lang.NullPointerException
at CxCommon.Messaging.ClientPacketSyncDrvFormatter.receiverCallback(Clie
ntPacketSyncDrvFormatter.java:981)
at CxCommon.Messaging.jms.Receiver.processAdmin(Receiver.java:1426)
at CxCommon.Messaging.jms.Receiver.processMsg(Receiver.java:375)
at CxCommon.Messaging.jms.Receiver.access$900(Receiver.java:66)
at CxCommon.Messaging.jms.Receiver$ThreadCallBackImp.callback(Receiver.j
ava:241)
at CxCommon.ThreadingServices.ThreadPoolThread.run(ThreadPoolThread.java
:175)
]
[Time: 2008/04/29 02:19:59.188] [System: Server] [Thread: REQJmsThreadPool.threa
d1 (#1287422410)] [Mesg: Could not find worker for CxCommon.Messaging.jms.Receiv
er$ThreadCallBackImp@5e1c01e6.]
|
|
| Back to top |
|
|
| Gaya3 |
| Posted: Mon Apr 28, 2008 10:31 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
[Mesg: Could not find worker for CxCommo
hey, but still you are placing the wrong message is not understandable by the BO/message set that you have created.
To solve this.
test it using Visual Connector first.
Let me know how you created the BO and imported to MB too.
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| sirisha.n |
| Posted: Mon Apr 28, 2008 11:12 pm Post subject: |
|
|
Apprentice
Joined: 25 Feb 2008
Posts: 27
|
Hi Gaya3,
even i tried with Visual test connector,i facing same problem.
My MB flow is like this:
Input node------->compute node--------> output node
instead of mapping node i used compute node for the mapping. just created 2 message sets for input and output.
in the connector i just mentioned a Request queue name and simple select query as value for the PING Query property.
and verb is 'Create',i hard coded it in esql.
is my approach is correct?
please suggest me,if any other configurations required to achieve this. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Mon Apr 28, 2008 11:37 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
i will start from the ODA configuration
1. Select ODA
2. Select Database objects
3. Select Objects by expanding All Schema
4. Slect the table
5. provide the verb, and Select "YES" for Add stored procedure attribute
6. Select the Stored Procedure
*******************************************
The stored procedure will help you to insert the values to the table.
*******************************************
Once you ready with the BO, Export and import it to MB, it will inturn become a message set.
Use this and manipulate at ESQL level.
are you sure, you have done the above mentioned things properly.
If yes/not, cross check it once again
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| sirisha.n |
| Posted: Tue Apr 29, 2008 9:16 pm Post subject: |
|
|
Apprentice
Joined: 25 Feb 2008
Posts: 27
|
Hi Gaya3,
I also did same thing what you said.
I used this Bo as output message set in my flow.
can please explain me how connector works in this scenario.
how connector will convert XML data which is coming from the MB into the database format. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue Apr 29, 2008 10:09 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Each connector is unique, because it communicates with its application according to the application's interfaces.
For more information:
http://publib.boulder.ibm.com/infocenter/wbihelp/v6rxmx/index.jsp
Is it working perfectly for you...
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| siva.kasetty |
| Posted: Mon May 26, 2008 12:22 am Post subject: |
|
|
Apprentice
Joined: 17 Mar 2008
Posts: 45
|
Hi Gaya3
IT is not working..... |
|
| Back to top |
|
|
| RocknRambo |
| Posted: Thu May 29, 2008 9:15 am Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
Has your connector started successful ? before you put message, start the connector and check the logs whether its polling (if configured)
-RR |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu May 29, 2008 12:50 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20696
Location: LI,NY
|
| sirisha.n wrote: |
Hi,
I am getting following exception if i run connector and placing data in the queue.
[Time: 2008/04/28 07:13:05.844] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: REQJmsThreadPool.thread11 (#1301089172)] [Type: Error] [MsgID: 9064] [Mesg
: Message received is not of the type (Text, Object) expected for the current en
cryption settings. Message ID: ID:414d512041737369676e5f514d2020200d6b154820044b
06]
[Time: 2008/04/28 07:13:05.844] [System: Server] [Thread: REQJmsThreadPool.threa
d11 (#1301089172)] [Type: Error] [MsgID: 84017] [Mesg: Unable to deliver the mes
sage to the Queue. Reason: java.lang.ClassCastException: com.ibm.jms.JMSBytesMes
sage]
[Time: 2008/04/28 07:13:05.844] [System: ConnectorAgent] [SS: JDBCConnector] [Th
read: REQJmsThreadPool.thread11 (#1301089172)] [Type: Error] [MsgID: 9061] [Mesg
: Caught JMS error. Reason: javax.jms.JMSException: java.lang.ClassCastException
: com.ibm.jms.JMSBytesMessage.]
[Time: 2008/04/28 07:13:05.844] [System: Server] [Thread: REQJmsThreadPool.threa
d11 (#1301089172)] [Mesg: [Type: Fatal Error] [MsgID: 17056] [Mesg: Failed to es
tablish connection to messaging system.] ]
thanks.... |
Well if you are using standard SOAP over JMS you get a BytesMessage and not a TextMessage. This is to allow any binary attachements (multi-mime formatted msg)
You need to take care of this case.
Working as designed.
Enjoy  
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
