# CloverETL engine error with sybase datbase using jconn3 **URL:** \ **Category:** CloverDX Platform\ **Created:** [March 22, 2010, 12:00am UTC](https://forum.cloverdx.com/t/cloveretl-engine-error-with-sybase-datbase-using-jconn3/679 "2010-03-22T00:00:00Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![kxm20](https://avatars.discourse-cdn.com/v4/letter/k/ec9cab/32.png) [@kxm20](https://forum.cloverdx.com/u/kxm20)\ **Post date:** [March 22, 2010, 12:00am UTC](https://forum.cloverdx.com/t/cloveretl-engine-error-with-sybase-datbase-using-jconn3/679/1 "2010-03-22T00:00:00Z")
Hello, I keep getting the following error when I try to run a graph using clover engine. I’m using Sybase Adaptive Server Enterprise(ASE) 12.5.4 with Jconn3 driver. Wondering if you can help? ERROR [main] - Error during graph initialization ! com.sybase.jdbc3.utils.UnimplementedOperationException: The method com.sybase.jd bc3.jdbc.SybConnection.setHoldability(int) has not been completed and should not be called. at com.sybase.jdbc3.jdbc.ErrorMessage.raiseRuntimeException(Unknown Sour ce) at com.sybase.jdbc3.utils.Debug.notImplemented(Unknown Source) at com.sybase.jdbc3.jdbc.SybConnection.setHoldability(Unknown Source) at org.jetel.connection.jdbc.specific.conn.SybaseConnection.optimizeConn ection(SybaseConnection.java:90) at org.jetel.connection.jdbc.specific.conn.DefaultConnection.(Defa ultConnection.java:85) at org.jetel.connection.jdbc.specific.conn.DefaultConnection.(Defa ultConnection.java:76) at org.jetel.connection.jdbc.specific.conn.SybaseConnection.(Sybas eConnection.java:51) at org.jetel.connection.jdbc.specific.impl.SybaseSpecific.createSQLConne ction(SybaseSpecific.java:57) at org.jetel.connection.jdbc.DBConnection.connect(DBConnection.java:493) at org.jetel.connection.jdbc.DBConnection.getConnection(DBConnection.jav a:469) at org.jetel.component.DBOutputTable.checkConfig(DBOutputTable.java:1241 ) at org.jetel.graph.Phase.checkConfig(Phase.java:208) at org.jetel.graph.TransformationGraph.checkConfig(TransformationGraph.j ava:905) at org.jetel.graph.runtime.EngineInitializer.initGraph(EngineInitializer .java:147) at org.jetel.main.runGraph.runGraph(runGraph.java:370) at org.jetel.main.runGraph.main(runGraph.java:336) Thanks, Kris ---
**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\ **Post date:** [March 23, 2010, 9:05am UTC](https://forum.cloverdx.com/t/cloveretl-engine-error-with-sybase-datbase-using-jconn3/679/2 "2010-03-23T09:05:47Z")
Hello, it seems, that SybaseConnection really has a bug ([http://bug.cloveretl.org/view.php?id=3944](http://bug.cloveretl.org/view.php?id=3944)). Usage of _jdbcSpecific=MSSQL_ should help. ---
**Author:** ![kxm20](https://avatars.discourse-cdn.com/v4/letter/k/ec9cab/32.png) [@kxm20](https://forum.cloverdx.com/u/kxm20)\ **Post date:** [March 23, 2010, 1:23pm UTC](https://forum.cloverdx.com/t/cloveretl-engine-error-with-sybase-datbase-using-jconn3/679/3 "2010-03-23T13:23:32Z")
**Wondering if anyone is able to work with Sybase database on cloverETL engine. It doesn’t seem to like either jconn2 or jconn3.** **I tried jdbcSpecific=MSSQL (instead of jdbcSpecific=SYBASE) to connect to sybase and see the following error. I have no problem connecting to Oracle using oracle configuration settings. I need to be able to connect to Sybase database using jdbc - if this doesn’t work, then I have to abandon the use of cloverETL. Any advice?** ERROR [main] - Error during graph initialization ! com.sybase.jdbc3.utils.UnimplementedOperationException: The method com.sybase.jd bc3.jdbc.SybDatabaseMetaData.supportsGetGeneratedKeys() has not been completed a nd should not be called. at com.sybase.jdbc3.jdbc.ErrorMessage.raiseRuntimeException(Unknown Sour ce) at com.sybase.jdbc3.utils.Debug.notImplemented(Unknown Source) at com.sybase.jdbc3.jdbc.SybDatabaseMetaData.supportsGetGeneratedKeys(Un known Source) at org.jetel.component.DBOutputTable.checkConfig(DBOutputTable.java:1257 ) at org.jetel.graph.Phase.checkConfig(Phase.java:208) at org.jetel.graph.TransformationGraph.checkConfig(TransformationGraph.j ava:905) at org.jetel.graph.runtime.EngineInitializer.initGraph(EngineInitializer .java:147) at org.jetel.main.runGraph.runGraph(runGraph.java:370) at org.jetel.main.runGraph.main(runGraph.java:336) ---
**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\ **Post date:** [March 24, 2010, 8:47am UTC](https://forum.cloverdx.com/t/cloveretl-engine-error-with-sybase-datbase-using-jconn3/679/4 "2010-03-24T08:47:06Z")
Hello Kris, I get the errors only when using jconn2 driver. With jconn3, as well as with jtds driver (CloverETL built-in sybase connection), the graph with DBExecute, DBInput/OutputTable components work properly. Please check if you really use jconn3 driver in all your connections. ---
**Author:** ![kxm20](https://avatars.discourse-cdn.com/v4/letter/k/ec9cab/32.png) [@kxm20](https://forum.cloverdx.com/u/kxm20)\ **Post date:** [March 24, 2010, 1:21pm UTC](https://forum.cloverdx.com/t/cloveretl-engine-error-with-sybase-datbase-using-jconn3/679/5 "2010-03-24T13:21:10Z")
Yes, Jconn3 has been used in all the places. Is jtds built into cloverETL engine? If so can you send a sample usage. We want to test this using cloverETL engine first. Thanks. ---
**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\ **Post date:** [March 25, 2010, 10:04am UTC](https://forum.cloverdx.com/t/cloveretl-engine-error-with-sybase-datbase-using-jconn3/679/6 "2010-03-25T10:04:01Z")
Hello Kris, this is configuration for built-in Sybase connection ```auto passwordEncrypted=false name=Sybase threadSafeConnection=true dbURL=jdbc\:jtds\:sybase\://server:port user=sa jndiName= database=SYBASE password=password jdbcSpecific=SYBASE ``` Invalid connection (with jconn2 driver) can’t exist in graph, to run it successfully. In other case (nevertheless you use the connection or not), you get an exception. ---
**Author:** ![kxm20](https://avatars.discourse-cdn.com/v4/letter/k/ec9cab/32.png) [@kxm20](https://forum.cloverdx.com/u/kxm20)\ **Post date:** [March 25, 2010, 6:02pm UTC](https://forum.cloverdx.com/t/cloveretl-engine-error-with-sybase-datbase-using-jconn3/679/7 "2010-03-25T18:02:32Z")
I tried but connection to sybase is not working. We were able to connect to sybase using other open source tools e.g. Pentaho. Is there any other way round on this. Hope clover puts more serious thought into fixing connection problem with Sybase. Thanks. ---
**Author:** ![dpavlis](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dpavlis](https://forum.cloverdx.com/u/dpavlis)\ **Post date:** [March 25, 2010, 9:08pm UTC](https://forum.cloverdx.com/t/cloveretl-engine-error-with-sybase-datbase-using-jconn3/679/8 "2010-03-25T21:08:17Z")
Hi, In order to help you with your problem, we need your transformation graph (with all the config, especially DB connection) and possibly some sample data to be sent to [support@cloveretl.com](mailto:support@cloveretl.com) Include also your phone number so we can call you if additional info is needed. Let us also know the exact version of the driver you are using. Did you try the jTDS driver ? Does it sport the same problem ?