CloverETL engine error with sybase datbase using jconn3

CloverDX Platform
1

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

2

Hello,
it seems, that SybaseConnection really has a bug (http://bug.cloveretl.org/view.php?id=3944). Usage of jdbcSpecific=MSSQL should help.

3

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)

4

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.

5

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.

6

Hello Kris,
this is configuration for built-in Sybase connection

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.

7

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.

8

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 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 ?