Hi,
I have Created an Adapter Notification For Oracle. i followed the steps given in JDBC Documentation.

1. Created Connection
2. Created Adapter Notification for Insert
3. made the document publishable
4. sync the doc to broker
5. when i commited a record.
6. All i got is 2 types of Errors
   Error 1 :

   ---

   wm.adapter.wmjdbc.admin:registerAdapter
   com.wm.pkg.art.error.DetailedServiceException: [ART.114.13] Adapter Runtime: Error occured while Adapter Runtime was loading adapter type “JDBCAdapter”. [ART.114.9] Adapter Runtime: Error(s) while registering adapter type JDBCAdapter

Trace :

com.wm.pkg.art.error.DetailedServiceException: [ART.114.13] Adapter Runtime: Error occured while Adapter Runtime was loading adapter type “JDBCAdapter”.
[ART.114.9] Adapter Runtime: Error(s) while registering adapter type JDBCAdapter.
at com.wm.pkg.art.deployment.Service.registerAdapterType(Service.java:126)
at java.lang.reflect.Method.invoke(Native Method)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:339)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:104)
at com.wm.app.b2b.server.Service.doInvoke(Service.java:605)
at com.wm.app.b2b.server.Service.doInvoke(Service.java:502)
at com.wm.adapter.wmjdbc.admin.Service.registerAdapter(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:339)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:119)
at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:91)
at com.wm.app.b2b.server.SessionInvoke.run(Session.java:652)
at com.wm.util.pool.PooledThread.run(PooledThread.java:105)
at java.lang.Thread.run(Thread.java:479)

After that i went and changed the Transaction Type from “LOCAL_TRANSACTION” to “NO_TRANSACTION”. when i did the mentioned steps again i got the following Error

Error 2:

wm.art.ns:createAdapterNotification
[ADA.1.308] There must be at least one expression for the SELECT statement.

Trace :
>>>BasicData:message=There must be at least one expression for the SELECT statement.,service=wm.art.ns:createAdapterNotification,date=Mon Aug 25 20:47:23 CST 2003,sessionId=Venki,sessionName=10.1.28.36,sessionId=25Gww6zQCqkk0J6|oLvC1+rptHPOA=55558,serviceCallStack=[0]wm.art.ns:createAdapterNotification,stack=

com.wm.adk.error.AdapterServiceException: [ADA.1.308] There must be at least one expression for the SELECT statement.
at com.wm.adk.error.AdapterException.(AdapterException.java:270)
at com.wm.adk.WmAdapter.createAdapterException(WmAdapter.java:100)
at com.wm.adapter.wmjdbc.services.SelectColumns.generateSql(Unknown Source)
at com.wm.

Hi Anush,

I think you have not passed when condition to get InsertNotification
(template).sometimes there may be multiple records inserted one at a time.If you pass input parameter to above second condition then it will
work.

Thanks,
Srinik

Hi SriniK,
Thanks for the reply. i myself solved this problem. actually when i started tracking down …i found that the triggers were not created in the oracle table. when i explored … i found this error is coz one silly mistake. i didnt enable the polling interval in JDBC Notification. thats y the trigger is not created.
i guess this will be helpful rest of the folks

thanks
Anush

Hi,

I am new to Oracle and webMethods interface. I would like to know how Oracle trigger and webMethods works in detail.

Please help…

Thanks,
sm

Adapter Notifications work with LOCAL_TRANSACTION only