JDBC Adapter connection problem

, ,
1

Hi all,

I am getting the below mentioned adapter connection error msg. while creating a connection.

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Testin:First_Conn.[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.Invalid Oracle URL specified: OracleDataSource.makeURL
Other details:-
database- Oracle 9i.Remote server.Logging as a client.
Adapter Connection :- to be created Locally(in IS localhost:5555)

please let me know the root cause .Screenshot of the configured connection is attched herewith.

Thnx in advance.
Sthita

2

Can you post all the connection properties that are specified on the JDBC Adapter Connection screen?

3

i got the problem i had.
I didn’t type “driver Type = thin” in proper manner.
I had typed “driver type” instead.
Anyway thanks Reamon.

4

Hi all

 I have created a JDBC Adapter connection and worked on it. Next day when i am trying to open the connection , it is not connecting an d showing an error

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Test:mycon.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “com.microsoft.jdbcx.sqlserver.SQLServerDataSource”.
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

Can any one give me the correct guidence…

5

Can you post all the connection properties that are specified on the JDBC Adapter Connection screen?

6

Hi good morning,

  1. First i copyed three jar files in webMethod/integrationerver/lib/jars
  2. Again i copyed the same files in webMethods/integrationserver/packages/wMJDBCAdapter/code/jars
  3. i copyed a javaxsql file from there and i paste it in lib jars
  4. next i configured the adapter like
    connection------------------> mycon
    Connection Type ---------> JDBC Adapter Connection
    Package Name ----------> TestAdapter
    Transaction Type---------> LOCAL_TRANSACTION
    DataSource Class -------->com.microsoft.jdbcx.sqlserver.SQLServerDataSource
    serverName ------------------>webs
    user ------------------------------>sa
    password ---------------------> sa
    Retype password -----------> sa
    databaseName --------------->Example
    portNumber -------------------> 1433
    networkProtocol -------------->TCP/IP
    Other Properties --------------->selectMethod=cursor

These are the steps i did.

7

The “Error establishing socket.” would seem to suggest that your server’s hostname, port or both is incorrect or that your SQLServer is not running.

Mark

8

Hi,

My serevr name is correct and my SQL is also running fine. I deleted that connection and created new one now its working. All our team members got the same error at one.