CloverETL engine error with sybase datbase using jconn3

kxm20

• March 22, 2010 00:00

• Answered

Follow

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.<init>(Defa
ultConnection.java:85)
at org.jetel.connection.jdbc.specific.conn.DefaultConnection.<init>(Defa
ultConnection.java:76)
at org.jetel.connection.jdbc.specific.conn.SybaseConnection.<init>(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

• 

  avackova

  • March 23, 2010 09:05

  0

  Comment actions Permalink

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

  kxm20

  • March 23, 2010 13:23

  0

  Comment actions Permalink

  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)
• 

  avackova

  • March 24, 2010 08:47

  0

  Comment actions Permalink

  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.
• 

  kxm20

  • March 24, 2010 13:21

  0

  Comment actions Permalink

  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.
• 

  avackova

  • March 25, 2010 10:04

  0

  Comment actions Permalink

  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.
• 

  kxm20

  • March 25, 2010 18:02

  0

  Comment actions Permalink

  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.
• 

  dpavlis

  • March 25, 2010 21:08

  0

  Comment actions Permalink

  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 ?

Please sign in to leave a comment.