Hi Everybody,
I am trying to do a AdatperService with Oracle9i database in Developer Console.
I sucessfully configured JDBC Adapter configured with the following parameters.
Trasaction Type : No_TRANSACTION (or) LOCAL_TRANSACTION
DataSourceClass : oracle.jdbc.pool.OracleConnectionPoolDataSource
(or)oracle.jdbc.pool.OracleDataSource
serverName : localhost
user : scott
pw : tiger
dB Name : PRAVEEN
portNumber : 1521
networkprotocol : TCP
other Properties : driverType=thin
I copied classes12.zip file in /lib/jars as well as in my working package and
WmJDBCAdapter package(code/jars directory)
Operating System : WINDOWS XP PROFESSIONAL
Microsoft Windows XP [Version 5.1.2600]
Problem :
I created a JDBC Adaper Service in the Developer using SelectSQL Template. I used the
Adapter connection
which I earlier configured in the Administrator browser–>JDBCAdapter Menu–>
Adapters > JDBC Adapter > Edit Connection
Connection Name Package Name Connection Type
Enabled Edit View Copy Delete
MyOracleConnection:JDBCoracleconnection MyJDBCTest JDBC Adapter Connection
YES
In the Developer Console for MyOracleConnection:MYSelectSQL AdapterService
It is Unable list the tables which are in the database for Tables TAB, i.e.,
----------------|--------------------------|------------
| Table Alias | Table Name | Type |
|---|---|---|
| t1 | ||
| when I click the tab in search of tables which are in the database. | ||
| Actually There are | ||
| tables in the database PRAVEEN. |
When I press the button Reload values from the adapter, I got the follwing error messages.
The details:
com.wm.app.b2b.server.ServiceException: [ART.114.205] Adapter Runtime (Metadata): Unable to
lookup the resource domain values.
[ADA.1.321] Cannot get the list of schemas. "
(60000/600) ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], , , , ,
,
"
ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], , , , , ,
on tables.schemaName [Ljava.lang.String;@1a6cb2djava.lang.Exception: Adapter values are not
available.
java.lang.Exception: Adapter values are not available. at
com.webMethods.developer.adapter.metadata.AdapterMetadataException.(AdapterMetadataExc
eption.java:57) at
com.webMethods.developer.adapter.metadata.AdapterMetadataParameterValue.assertNoErrorString(
AdapterMetadataParameterValue.java:3759) at
com.webMethods.developer.adapter.metadata.AdapterMetadataParameterValue.getValidValuesIntern
al(AdapterMetadataParameterValue.java:3644) at
com.webMethods.developer.adapter.metadata.AdapterMetadataParameterValue.confirmIndexMapArray
ValueInternal(AdapterMetadataParameterValue.java:3078) at
com.webMethods.developer.adapter.metadata.AdapterMetadataParameterValue.confirmValueInternal
(AdapterMetadataParameterValue.java:3259) at
com.webMethods.developer.adapter.metadata.AdapterMetadataParameterValue.confirmValue(Adapter
MetadataParameterValue.java:2854) at
com.webMethods.developer.adapter.metadata.AdapterMetadata.confirmAll(AdapterMetadata.java:20
83) at
com.webMethods.developer.adapter.metadata.AdapterMetadata.validateInternal(AdapterMetadata.j
ava:506) at
com.webMethods.developer.adapter.metadata.AdapterMetadata.validate(AdapterMetadata.java:472)
at
com.webMethods.developer.adapter.metadata.AdapterMetadata.reload(AdapterMetadata.java:2707)
at
com.webMethods.developer.adapter.editor.AdapterServiceEditor$2.actionPerformed(AdapterServic
eEditor.java:324) at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) at
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245) at
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231) at
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231) at
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231) at
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231) at
java.awt.Component.processMouseEvent(Component.java:5100) at
java.awt.Component.processEvent(Component.java:4897) at
java.awt.Container.processEvent(Container.java:1569) at
java.awt.Component.dispatchEventImpl(Component.java:3615) at
java.awt.Container.dispatchEventImpl(Container.java:1627) at
java.awt.Component.dispatchEvent(Component.java:3477) at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483) at
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at
java.awt.Container.dispatchEventImpl(Container.java:1613) at
java.awt.Window.dispatchEventImpl(Window.java:1606) at
java.awt.Component.dispatchEvent(Component.java:3477) at
java.awt.EventQueue.dispatchEvent(EventQueue.java:456) at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) at
java.awt.EventDispatchThread.run(EventDispatchThread.java:100) at
java.awt.EventQueue.dispatchEvent(EventQueue.java:456) at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) at
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) at
java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
I Hope this information sufficient.
Earlier I sucessfully worked with MS SQL SERVER 2000.
Help me out,
PRAVEEN