Hi all,
iam new to webMethods ,i need help on the following scenario.

Scenario:

i have a scenario like , iam inserting data from flatfile to database .After the completion of inserting data , i need to clarify that whether my data is inserted into the database or not, for that iam using insert notification to know whether data is inserted or not.The problem with this is i dont know how to write process for the above scenario, that means how to use the nofitication and when to fire the notification.
so please send any sample code ,so that i can implement the above

with regards,
sitaram

Hi all i am also facing the same problem as sitaram.
Could anyone help us in this matter

Is the purpose to confirm that the data is written to the DB? Or is it to trigger other integration activity?

If it is the former, I would suggest that doing so is unnecessary. If the JDBC adapter service returns without error, you can rest assured that the data is stored in the database. If you absolutely MUST read the data, then I would suggest creating a SELECT adapter service that can read the record using the key data you just used to do the insert. Using notification for “data confirmation” purposes is not advisable.

If it is that latter, please review the JDBC adapter documentation on notifications. There are a number of steps needed, possibly including some work by a DB programmer. If you have any specific questions please feel free to post them here.

Hi reamon ,All

The problem that i am facing is i want to trigger a different service when the adapter notification publishes it’s corresponding document type to the local broker.
After inserting the records in table and commiting
I am not sure whether the notification is picking them or not.
Can anyone tell me how the IS log looks like when a notification finds a record or entry in the table that it is polling for.
The eror i am getting is:-

2005-05-30 20:56:55 GMT+05:30 [ART.0116.3502V1] Adapter Runtime (Notification): Execution begin for Notification:BasicNo
tificationPackage:mybasic UUID:94f7454a36bc6d231127a399304.
2005-05-30 20:56:55 GMT+05:30 [ADA.0001.0103V1] Begin local transaction.
2005-05-30 20:56:55 GMT+05:30 [ART.0116.3507V1] Adapter Runtime (Notification): useConnection Connection:com.wm.adapter.
[COLOR=red]wmjdbc.connection.JDBCConnection@ef9fdc4[/color] for Notification:BasicNotificationPackage:mybasic UUID:94f7454a36bc6d231127a399
304.
2005-05-30 20:56:55 GMT+05:30 [ADA.0001.0109V1] In notification callback “runCallBack”().
2005-05-30 20:56:55 GMT+05:30 [ART.0116.3508V1] Adapter Runtime (Notification): getConnection Connection:com.wm.adapter.
[COLOR=red]wmjdbc.connection.JDBCConnection@ef9fdc4[/color] for Notification:BasicNotificationPackage:mybasic UUID:94f7454a36bc6d231127a399
304.
2005-05-30 20:56:55 GMT+05:30 [ART.0116.3504V1] Adapter Runtime (Notification): Execution finish for Notification:BasicN
otificationPackage:mybasic UUID:94f7454a36bc6d231127a399304.
2005-05-30 20:56:55 GMT+05:30 [ART.0116.3507V1] Adapter Runtime (Notification): useConnection Connection:null for Notifi
cation:BasicNotificationPackage:mybasic UUID:94f7454a36bc6d231127a399304.
2005-05-30 20:56:55 GMT+05:30 [ADA.0001.0104V1] Commit local transaction.

Here the underlined fonts in blue indicates the connection is null which is also surprising.

Can you post the config of your JDBC connection and your IS trigger?

Hi All/Reamon

i am able to publish the document in to the broker and trigeer is also firing.
The trigger calls a flow service where i transfer this publishable document type to XML string consequently write in to a local file.But i am getting the folowing err.

:30 [ART.0116.3502V1] Adapter Runtime (Notification): Execution begin for Notification:BasicNo
UUID:94f7454a36bc6d231127a399304.
:30 [ADA.0001.0103V1] Begin local transaction.
:30 [ART.0116.3507V1] Adapter Runtime (Notification): useConnection Connection:com.wm.adapter.
[COLOR=red]ection@13b0b71b[/color] for Notification:BasicNotificationPackage:mybasic UUID:94f7454a36bc6d231127a39
:30 [ADA.0001.0109V1] In notification callback “runCallBack”().
:30 [ART.0116.3508V1] Adapter Runtime (Notification): getConnection Connection:com.wm.adapter.
[COLOR=red]ection@13b0b71b[/color] for Notification:BasicNotificationPackage:mybasic UUID:94f7454a36bc6d231127a39
:30 [ART.0116.3504V1] Adapter Runtime (Notification): Execution finish for Notification:BasicN
UUID:94f7454a36bc6d231127a399304.
:30 [ART.0116.3507V1] Adapter Runtime (Notification): useConnection Connection:null for Notifi
ckage:mybasic UUID:94f7454a36bc6d231127a399304.
:30 [ADA.0001.0104V1] Commit local transaction.

i am unable to write the file.
thanx and regards

Hi,

In my case too, we have basic notification.
Everything works fine but still i get entry on log for useConnection Connection:null
What could be the reason?

Thanks for help

Regards,
Sumit