cannot using xa transaction

Hi…

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”.

[wm-cjdbc32-0014][Oracle JDBC Driver]Error establishing socket. Connection refused
2006-05-16 10:14:13 GMT-07:00 [ART.0114.1007E] Adapter Runtime: Error Logged.

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…

why?

regards,

fatkur

addition, there are error in WM developer

==========

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)

==================

why?..please help me?..

thank’s for cooperation

regards,

fatkur

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?

Mark

Thanks for your suggestion.

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 ?

Regards,
Jhe