java.sql.SQLException: 'IMPLICIT_TRANSACTIONS' is not a recognized option.

[Vasco Mesquita]

I'm having an error:
"java.sql.SQLException: 'IMPLICIT_TRANSACTIONS' is not a recognized option."
when trying to execute a a JDBC Sybase DB connection.
These are my driver set properties beside ServerName, Username, Password, PortNumber, DatabaseName and loginTimeout:

      ds.setTds("5.0");
      ds.setBatchSize(1000);
      ds.setAutoCommit(true);
      ds.setPrepareSql(1);
      ds.setAppName("jTDS");
      ds.setBatchSize(1000);
      ds.setBufferMaxMemory(1024);
      ds.setCacheMetaData(false);
      ds.setLastUpdateCount(true);
      ds.setMaxStatements(500);
      ds.setNamedPipe(false);
      ds.setPacketSize(512);
      ds.setProgName("jTDS");
      ds.setSsl("off");
      ds.setUseCursors(false);
      ds.setXaEmulation(true);

I've searched around for this error but very few details were given. Any ideas on how to avoid it?

Thanks in advance,

Vasco Mesquita

[Vasco Mesquita]

Missed ds.setServerType(2);
Problem solved.