KB Article #178279

java.sql.SQLException: No suitable driver found for...

Problem

-- getting those errors in Message Log at runtime

Exception occured in custom function com.axway.xib.runtime.dml.sqlcustomfunction.SqlCustomFunction.execute.

Detail Message :
java.sql.SQLException: No suitable driver found for
Stack Trace :
java.sql.DriverManager.getConnection(DriverManager.java:689)
java.sql.DriverManager.getConnection(DriverManager.java:208)
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:68)org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
com.axway.xib.runtime.dml.sqlcustomfunction.SqlCustomFunction.execute(SqlCustomFunction.java:63)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:497)
com.axway.xib.runtime.dml.FunctionContext.execute(FunctionContext.java:57)
com.axway.xib.runtime.dml.FunctionController.pass(FunctionController.java:248)



Resolution

* the flow you are executing is using a JDBC custom function
* check in the UI : Processing configuration -> Manage connections
* retrieve the related connection and check the validity of the "Driver class" and the "URL"