|
Hello,
Although this is possible, adding jdbc drivers can cause support problems as we can not reproduct the exact same configuration in our labs.
Adding a driver can be done by editing the :
"jdbc_drivers.properties"
in the
"plugins\com.twinsoft.convertigo.studio_XXXX\tomcat\webapps\convertigo\WEB-INF\classes"
Directory.
Convertigo uses a pooling mechanism. In order to test if jdbc connexctions remain valid, convertigo will regulary pool the connections. Each jdbc driver has a specific polling command. The default convertigo code will automatically poll any supported jdbc driver. If you add your custom one, you will have to configure in the :
"System table query"
property of the SQL connector
The SQL command to query system tables : for example "Show tables" for MySQL
Be sure to have the JDBC driver JAR filr to be in the classpath of the studio. You can do this by editing the Convertigo plugin.xml file and add the jar.
Be sure to restart convertigo studio with the "-clean" option in order to have the plugin cache refreshed.
As a reminder we repeat that adding JDBC drivers is not officially supported by maintenance contracts. If you have a specific driver to add, we may add it for a next release for offical support.
Best Rds
Support team.
|
