Pentaho

 View Only

 Database connection error from PDI CE 8.1.

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
Manojkumar Ramalingam's profile image
Manojkumar Ramalingam posted 07-24-2020 15:54

I am getting below error while connecting to the database from 'Pentaho CE 8.1'.

Any suggestions on overcoming this issue?

 

Error connecting to database :

org.pentaho.di.core.exception.KettleDatabaseException: 

Error occurred while trying to connect to the database

 

Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)

The syntax of the connection URL 'jdbc:jtds:sqlserver:///;useServerPrepStmts=false;useCompressions=true;rewriteBatchedStatements=true' is invalid.

 

 

org.pentaho.di.core.exception.KettleDatabaseException: 

Error occurred while trying to connect to the database

 

Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)

The syntax of the connection URL 'jdbc:jtds:sqlserver:///;useServerPrepStmts=false;useCompressions=true;rewriteBatchedStatements=true' is invalid.

 


#PentahoDataIntegrationPDI
#Pentaho
#Kettle
Gert Wieland's profile image
Gert Wieland posted 08-05-2020 18:02

Am I understanding it correctly and you get this error when trying to set up the connection to the database?

My first hunch would be that you might be using the wrong jdbc driver (because it states "syntax of connection URL is invalid, but as users, we don't have control over that syntax).

 

Are you sure you selected the correct database type in your connection settings?

 

Another thought: Maybe try with the current version PDI CE 9?

Related Content