i’m using IS 6.0.1 , JDBC adapter 6.0.3, oracle 8.1.7 and OS HP-UX
if i’m execution service that using local transaction is OK…nothing error message…
but if i’m running service that using xa transaction, with error…
2006-05-16 10:14:13 GMT-07:00 [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.xa.client.OracleXADataSource”.
See Error log for details. Error: [ART.117.4012] Adapter Runtime (Adapter Service): Unable to run adapter service. Error occured when connecting to resource GenevaJDBC:genevaConnection.
[ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource GenevaJDBC:genevaConnection.
my dba administrator trying reinstall and reconfigure javaVM and resize JAVA_POOL in oracle but still error like above…
Templates are not loaded properly for the following reason:
com.wm.ui.UiException: com.wm.app.b2b.server.ServiceException: [ART.118.5040] Adapter Runtime (Connection): Unable to get adapter service templates for connection GenevaJDBC:genevaConnection.
[ART.118.5048] Adapter Runtime (Connection): Unable to get adapter service templates for connection resource GenevaJDBC:genevaConnection.
=============
and if button detail i’m click, see error log
======
com.wm.ui.UiException: com.wm.app.b2b.server.ServiceException: [ART.118.5040] Adapter Runtime (Connection): Unable to get adapter service templates for connection GenevaJDBC:genevaConnection.
[ART.118.5048] Adapter Runtime (Connection): Unable to get adapter service templates for connection resource GenevaJDBC:genevaConnection.
at com.wm.ui.UiException.handle(UiException.java:72)
at com.wm.ui.UiException.handle(UiException.java:43)
at com.wm.app.b2b.dev.servfacades.SFServFacade.invoke(SFServFacade.java:618)
at com.wm.app.b2b.dev.service.adapter.metadata.AdapterMetadataLoader.getTemplateList(AdapterMetadataLoader.java:928)
at com.wm.app.b2b.dev.service.adapter.metadata.AdapterMetadataLoader.loadAdapter(AdapterMetadataLoader.java:762)
at com.wm.app.b2b.dev.service.adapter.metadata.AdapterMetadataLoader.getAdapter(AdapterMetadataLoader.java:369)
at com.wm.app.b2b.dev.service.adapter.metadata.AdapterService.setNSNodeData(AdapterService.java:390)
at com.wm.app.b2b.dev.service.adapter.metadata.AdapterMetadata.setNSNode(AdapterMetadata.java:258)
at com.wm.app.b2b.dev.service.adapter.metadata.AdapterMetadata.<init>(AdapterMetadata.java:149)
at com.wm.app.b2b.dev.service.adapter.metadata.AdapterService.<init>(AdapterService.java:114)
at com.wm.app.b2b.dev.service.adapter.editor.AdapterServiceEditor.setISElement(AdapterServiceEditor.java:193)
at com.wm.app.b2b.dev.extAccess.ns.view.B2BElementView.setModel(B2BElementView.java:142)
at com.wm.app.b2b.dev.DevMainFrame.showModel(DevMainFrame.java:1750)
at com.wm.app.b2b.dev.DevMainFrame$2.valueChanged(DevMainFrame.java:1454)
at javax.swing.JTree.fireValueChanged(JTree.java:2269)
at javax.swing.JTree$TreeSelectionRedirector.valueChanged(JTree.java:2575)
at javax.swing.tree.DefaultTreeSelectionModel.fireValueChanged(DefaultTreeSelectionModel.java:612)
at javax.swing.tree.DefaultTreeSelectionModel.notifyPathChange(DefaultTreeSelectionModel.java:1006)
at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPaths(DefaultTreeSelectionModel.java:288)
at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPath(DefaultTreeSelectionModel.java:171)
at javax.swing.JTree.setSelectionPath(JTree.java:1088)
at javax.swing.plaf.basic.BasicTreeUI.selectPathForEvent(BasicTreeUI.java:2117)
at javax.swing.plaf.basic.BasicTreeUI$MouseHandler.mousePressed(BasicTreeUI.java:2683)
at java.awt.AWTEventMulticaster.mousePressed(AWTEventMulticaster.java:220)
at java.awt.Component.processMouseEvent(Component.java:3712)
at java.awt.Component.processEvent(Component.java:3544)
at java.awt.Container.processEvent(Container.java:1164)
at java.awt.Component.dispatchEventImpl(Component.java:2593)
at java.awt.Container.dispatchEventImpl(Container.java:1213)
at java.awt.Component.dispatchEvent(Component.java:2497)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2451)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:2210)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2125)
at java.awt.Container.dispatchEventImpl(Container.java:1200)
at java.awt.Window.dispatchEventImpl(Window.java:914)
at java.awt.Component.dispatchEvent(Component.java:2497)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:339)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:131)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:98)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:85)
Did you place the Oracle classes12.zip in your IS \lib\jars folder or are you attempting to use the SequelLink driver provided by webMethods for internal database pools only? Do you really need an XA connection?
Yes, I have put classess12.zip in our IS\lib\jars. and It 's still not working. We still get the same error.
For your information, before we have used connection for XA Transaction, and It was OK. Yesterday, we found that Our connection with XA Transaction was error. Is there any possibility, If our JDBC Adapter is error ? How to fix it ?