| Author |
Message
|
| biibana |
 Posted: Mon Apr 03, 2006 2:26 am Post subject: Triggering |
 |
|
Newbie
Joined: 22 Mar 2006
Posts: 5
|
I am entering values into the database , and have created a trigger for the same table. But I get an error when i start the jdbcconnector saying
"The call to method poll() in the application connector failed."
It does not process the record in the events table and the EVENT_STATUS also shows 0.It does not change
How can i rectify this????? |
|
| Back to top |
|
 |
| vk |
| Posted: Wed Apr 05, 2006 5:10 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Did the connector recognise the Event Table during startup? If yes, then make sure that the structure of the Event Table is correct.
If both the above are fine, then the issue is with the entry made in the Event Table. With the key fields entered in the Event Table, the connector might not have been able to fetch any rows.
Can you post the contents of the log file.
Regards,
VK. |
|
| Back to top |
|
|
| lehare |
| Posted: Wed Apr 05, 2006 5:18 am Post subject: |
|
|
Apprentice
Joined: 25 Jul 2005
Posts: 48
|
| without the triggering part can the jdbc adapter atlease poll the the event_table? |
|
| Back to top |
|
|
| RocknRambo |
| Posted: Wed Apr 05, 2006 9:49 am Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
Triggering and Adapter polling the Event Tbl are two different entities.
Trigger - custom build to populate event tbl with key values.
Adapter Polling Event Tbl - Out of box functionality provided
-RR |
|
| Back to top |
|
|
| biibana |
| Posted: Wed Apr 05, 2006 9:41 pm Post subject: solved |
|
|
Newbie
Joined: 22 Mar 2006
Posts: 5
|
hi
this error was solved
i re created the tables
that is the xworls_events table as well as both the parent and child table
then made a new trigger
and it started polling
thanks |
|
| Back to top |
|
|
|
|
