jdbc errors

Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Math:test.[ART.118.5063] Adapter Runtime (Connection): Unable to start connection Math:test: after 1 attempt(s).[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.OracleConnectionPoolDataSource”.Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))in Adapters > JDBC Adapter > Connections[TABLE=“width: 100%”]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]Transaction Type[/TD]
[TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined”] LOCAL_TRANSACTION XA_TRANSACTION NO_TRANSACTION [/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]DataSource Class[/TD]
[TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined”][/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]serverName[/TD]
[TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined”][/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]user[/TD]
[TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined”][/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]password[/TD]
[TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined”][/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, align: right”]Retype password[/TD]
[TD=“class: oddrowdata-l, bgcolor: #E0E0C0”][/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]databaseName[/TD]
[TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined”][/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]portNumber[/TD]
[TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined”][/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]networkProtocol[/TD]
[TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined”][/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]Other Properties[/TD]
[TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined”][/TD]
[/TR]
[TR]
[TD=“class: heading, bgcolor: #000000, colspan: 2”]Connection Management Properties[/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]Enable Connection Pooling[/TD]
[TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined”] true false [/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]Minimum Pool Size[/TD]
[TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined”][/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]Maximum Pool Size[/TD]
[TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined”][/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]Pool Increment Size[/TD]
[TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined”][/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]Block Timeout (msec)[/TD]
[TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined”][/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]Expire Timeout (msec)[/TD]
[TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined”][/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, colspan: undefined, align: right”]Startup Retry Count[/TD]
[TD=“class: evenrowdata-l, bgcolor: #F0F0E0, colspan: undefined”][/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, colspan: undefined, align: right”]Startup Backoff Timeout (sec)[/TD]
[TD=“class: oddrowdata-l, bgcolor: #E0E0C0, colspan: undefined”][/TD]
[/TR]
[/TABLE]
and errors in my log file is

2012-08-19 10:31:10 IST [ISS.0096.0001C] JDBCConnectionManager: initialization failed for ISCoreAudit functional alias, check configuration.
2012-08-19 10:31:10 IST [ISS.0096.0001C] JDBCConnectionManager: initialization failed for ISInternal functional alias, check configuration.
2012-08-19 10:31:10 IST [ISS.0096.0001C] JDBCConnectionManager: initialization failed for ProcessAudit functional alias, check configuration.
2012-08-19 10:31:10 IST [ISS.0096.0001C] JDBCConnectionManager: initialization failed for ProcessEngine functional alias, check configuration.
2012-08-19 10:31:10 IST [ISS.0096.0001C] JDBCConnectionManager: initialization failed for TN functional alias, check configuration.
2012-08-19 10:31:10 IST [ISS.0096.0001C] JDBCConnectionManager: initialization failed for Xref functional alias, check configuration.

[TABLE=“width: 100%”]
[TR]
[TD=“class: menusection-Settings, bgcolor: #08419C, colspan: 7”]Settings > JDBC Pools[/TD]
[/TR]
[TR]
[TD=“colspan: 7”] [/TD]
[/TR]
[TR]
[TD=“class: message, bgcolor: #FFE5E9, colspan: 7”]Test of ISCoreAudit Failed
Invalid Oracle URL specified[/TD]
[/TR]
[/TABLE]

[TABLE=“width: 100%”]
[TR]
[TD][TABLE=“class: tableForm”]
[TR]
[TD=“class: heading, bgcolor: #000000, colspan: 2”]JDBC Connection Pool Alias[/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, align: right”]Alias Name[/TD]
[TD=“class: evenrow-l, bgcolor: #F0F0E0”]tnpool[/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, align: right”]Alias Description[/TD]
[TD=“class: oddrow-l, bgcolor: #E0E0C0”][/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, align: right”]Associated Driver Alias[/TD]
[TD=“class: evenrow-l, bgcolor: #F0F0E0”] None DataDirect Connect JDBC DB2 Driver DataDirect Connect JDBC Oracle Driver DataDirect Connect JDBC SQL Server Driver Embedded Database Driver [/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, align: right”]Database URL[/TD]
[TD=“class: oddrow-l, bgcolor: #E0E0C0”][/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, align: right”]User Id[/TD]
[TD=“class: evenrow-l, bgcolor: #F0F0E0”][/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, align: right”]Password[/TD]
[TD=“class: oddrow-l, bgcolor: #E0E0C0”][/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, align: right”]Minimum Connections[/TD]
[TD=“class: evenrow-l, bgcolor: #F0F0E0”][/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, align: right”]Maximum Connections[/TD]
[TD=“class: oddrow-l, bgcolor: #E0E0C0”][/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, align: right”]Idle Timeout[/TD]
[TD=“class: evenrow-l, bgcolor: #F0F0E0”] milliseconds[/TD]
[/TR]
[TR]
[TD=“class: action, bgcolor: #758EBD, colspan: 2”]

[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[/TABLE]

any help is appreciated i advance

Thanks & Regards
sudheer

reply quickly guys
pls

After installation, you have to run Database Component Configurator tool and execute scripts related to Product Integration Server. This will create all set of tables related to IS. Go to your IS Admin page, and create a pool alias by pointing to the db where you created all tables by executing scripts… Then assign this pool to each functional pool alias from your IS admin page. You got to refer the installation and configuration guide to know more in detail.

-Senthil

can u give example with some settings
mainly url

Go to Database Component Configurator

Under Action

Type : Create

Database Component : ALL

Version : Latest

Under Connection

Select RDBMS Ex if you are using Oracle DB

URL if your are using oracle DB: jdbc:wm:oracle://localhost:1521;serviceName=XE;

Provide User Id and password.

Create table spaces and Database User

Provide Admin user id and password for the DB.

Select the location for tablespace dir Ex: C:\webMethods7\common\db\scripts\oracle\storage\20\create

Finally check save settings as default and Execute.

Thanks.

thanks satish i configured as u said similarly can u give examples how to configure jdbc pool settings

iam still getting these errors in log file JDBCConnectionManager: initialization failed for ISCoreAudit functional alias, check configuration.2012-08-21 10:29:43 IST [ISS.0096.0001C] JDBCConnectionManager: initialization failed for ISInternal functional alias, check configuration.
2012-08-21 10:29:43 IST [ISS.0096.0001C] JDBCConnectionManager: initialization failed for ProcessAudit functional alias, check configuration.
2012-08-21 10:29:43 IST [ISS.0096.0001C] JDBCConnectionManager: initialization failed for ProcessEngine functional alias, check configuration.
2012-08-21 10:29:43 IST [ISS.0096.0001C] JDBCConnectionManager: initialization failed for TN functional alias, check configuration.
2012-08-21 10:29:43 IST [ISS.0096.0001C] JDBCConnectionManager: initialization failed for Xref functional alias, check configuration.

this error in Jdbc POols

Test of ISCoreAudit Failed
[wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-12519 The listener could not find any available service handlers that are appropriate for the client connection. One possible cause for this error is that the server was not configured for the specified server type (shared/dedicated).

Are you using/following the installation documentation? It will guide you through all the steps to follow.

[TABLE=“class: tableForm”]
[TR]
[TD=“class: heading, bgcolor: #000000, colspan: 2”]JDBC Connection Pool Alias[/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, align: right”]Alias Name[/TD]
[TD=“class: evenrow-l, bgcolor: #F0F0E0”]tnpool[/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, align: right”]Alias Description[/TD]
[TD=“class: oddrow-l, bgcolor: #E0E0C0”][/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, align: right”]Associated Driver Alias[/TD]
[TD=“class: evenrow-l, bgcolor: #F0F0E0”]DataDirect Connect JDBC Oracle Driver[/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, align: right”]Database URL[/TD]
[TD=“class: oddrow-l, bgcolor: #E0E0C0”]jdbc:wm:oracle://localhost:1521;SID=XE[/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, align: right”]User Id[/TD]
[TD=“class: evenrow-l, bgcolor: #F0F0E0”]sudheer[/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, align: right”]Password[/TD]
[TD=“class: oddrow-l, bgcolor: #E0E0C0”]******[/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, align: right”]Minimum Connections[/TD]
[TD=“class: evenrow-l, bgcolor: #F0F0E0”]10[/TD]
[/TR]
[TR]
[TD=“class: oddrow, bgcolor: #E0E0C0, align: right”]Maximum Connections[/TD]
[TD=“class: oddrow-l, bgcolor: #E0E0C0”]40[/TD]
[/TR]
[TR]
[TD=“class: evenrow, bgcolor: #F0F0E0, align: right”]Idle Timeout[/TD]
[TD=“class: evenrow-l, bgcolor: #F0F0E0”] 30000[/TD]
[/TR]
[TR]
[TD=“class: action, bgcolor: #758EBD, colspan: 2”][/TD]
[/TR]
[/TABLE]

Test of ISCoreAudit Failed
[wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-12519 The listener could not find any available service handlers that are appropriate for the client connection. One possible cause for this error is that the server was not configured for the specified server type (shared/dedicated).

iam followed guide is there any mistakes in my configuration

contact me this number 09125225712, i will slove your problem.(night 8-9)

Hello Naga,

Let the forum know what the solution you are giving to fix the above issue.

Regards,
Sasanka

hello naga ,
u mobile switch off i think can u give missed call to my number 9916660579 ,iam waiting for ur reply

guys please let me know how to this problems its urgent to me ,if any of u free contact my mail ID sudheer.villuri@gmail.com

Hi Sudheer,

I have also face the same issue but after reinsatallation of database my problem get solved but dont know what was the exact issue, I have googled this issue but problem was there but solution is not there anywhere

I believe issue might be with DB but not with webMethods.
I’m guessing that, DB is reached the maximum limit of connections so it’s not allowing any new connections.

So wait for some time to DB release the connections or ask DBA to increase the allowed max limit of connections.

I faced the same issue while i was working with oracle 10g, and solved it with below link.
https://community.oracle.com/message/1995111#1995111 :smiley:

1 Like