No suitable driver error on TN startup

, ,
1

HI all while starting the TN Console i m getting the following error plz suggest

class: com.wm.app.tn.db.DatastoreException

Stack trace:
java.sql.SQLException: No suitable driver

java.sql.SQLException: No suitable driver

java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getConnection(DriverManager.java:532)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at com.wm.app.jdbc.JDBCConnection.<init>(JDBCConnection.java:41)

at com.wm.app.jdbc.JDBCConnectionPool.getAvailConnection(JDBCConnectionPool.java:241)

at com.wm.app.jdbc.JDBCConnectionPool.getConnection(JDBCConnectionPool.java:125)

at com.wm.app.jdbc.JDBCConnectionPool.getConnection(JDBCConnectionPool.java:113)

at com.wm.app.tn.db.Datastore.getConnection(Datastore.java:275)

at com.wm.app.tn.db.Datastore.getDBMetaData(Datastore.java:505)

at com.wm.app.tn.db.Datastore.init(Datastore.java:175)

at wm.tn.admin.startup(admin.java:674)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.wm.app.b2b.server.JavaService.baseInvoke(JavaService.java:287)

at com.wm.app.b2b.server.invoke.InvokeManager.process(InvokeManager.java:554)

at com.wm.app.b2b.server.invoke.StatisticsProcessor.process(StatisticsProcessor.java:44)

at com.wm.app.b2b.server.invoke.ServiceCompletionImpl.process(ServiceCompletionImpl.java:221)

at com.wm.app.b2b.server.invoke.ValidateProcessor.process(ValidateProcessor.java:49)

at com.wm.app.b2b.server.ACLManager.process(ACLManager.java:194)

at com.wm.app.b2b.server.invoke.DispatchProcessor.process(DispatchProcessor.java:39)

at com.wm.app.b2b.server.AuditLogManager.process(AuditLogManager.java:384)

at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:486)

at com.wm.app.b2b.server.invoke.InvokeManager.invoke(InvokeManager.java:359)

at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:246)

at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:128)

at com.wm.app.b2b.server.ServiceManager.invoke(ServiceManager.java:100)

at com.wm.app.b2b.server.SessionInvoke.run(Session.java:705)

at com.wm.util.pool.PooledThread.run(PooledThread.java:105)

at java.lang.Thread.run(Thread.java:534)
2

Check to make sure you have configured the connection pool for TN in the Admin page. Refer to ‘webMethods Installation Guide 65.pdf’ page 74 for information on setting up connection pool for TN.

3

If still you have the same failure, i guess you need to get classes111.jar,classes12.jar,classes12_g.jar to your webMethods/integrationserver/lib/jars folder. It worked for me…

4

Arpit,

Can you share settings info of the TN JDBC Connection Pool (From IS Admin: Settings > JDBC Pools > Connection Aliases)? I remember seeing this error (or at least a similar one) once when I was configuring the TN Pool and later found that I was using an incorrect Database URL.

~ Rohit