Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: DB connection error

  1. #1
    Join Date
    Sep 2007
    Posts
    2

    Default DB connection error

    Total newbie to Kettle / Pentaho -

    Downloaded Kettle onto my linux box. Brought up spoon - spoon.sh

    and trying to create a new DB connection - any idea what I am missing here? I did create a DB in my mysql database. is there something else that I need to do beforehand - doesn't look like it is complaining about configuration

    Error connecting to database [testdb] : be.ibridge.kettle.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class org.gjt.mm.mysql.Driver)
    Error during query: Unexpected Exception: java.io.CharConversionException message given: null

    Nested Stack Trace:


    ** BEGIN NESTED EXCEPTION **

    java.io.CharConversionException

    STACKTRACE:

    java.io.CharConversionException
    at gnu.gcj.convert.Input_iconv.read(char[], int, int) (/usr/lib/libgcj.so.6.0.0)
    at java.lang.String.init(byte[], int, int, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
    at java.lang.String.String(byte[], int, int, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
    at com.mysql.jdbc.SingleByteCharsetConverter.SingleByteCharsetConverter(java.lang.String) (Unknown Source)
    at com.mysql.jdbc.SingleByteCharsetConverter.initCharset(java.lang.String) (Unknown Source)
    at com.mysql.jdbc.SingleByteCharsetConverter.getInstance(java.lang.String, com.mysql.jdbc.Connection) (Unknown Source)
    at com.mysql.jdbc.StringUtils.getBytes(java.lang.String, java.lang.String, java.lang.String, boolean) (Unknown Source)
    at com.mysql.jdbc.ByteArrayBuffer.writeStringNoNull(java.lang.String, java.lang.String, java.lang.String, boolean) (Unknown Source)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(com.mysql.jdbc.Statement, java.lang.String, java.lang.String, com.mysql.jdbc.Buffer, int, com.mysql.jdbc.Connection, int, int, boolean, java.lang.String, boolean) (Unknown Source)
    at com.mysql.jdbc.Connection.execSQL(com.mysql.jdbc.Statement, java.lang.String, int, com.mysql.jdbc.Buffer, int, int, boolean, boolean, java.lang.String, boolean, byte, boolean) (Unknown Source)
    at com.mysql.jdbc.Connection.configureClientCharacterSet() (Unknown Source)
    at com.mysql.jdbc.Connection.initializePropsFromServer(java.util.Properties) (Unknown Source)
    at com.mysql.jdbc.Connection.createNewIO(boolean) (Unknown Source)
    at com.mysql.jdbc.Connection.Connection(java.lang.String, int, java.util.Properties, java.lang.String, java.lang.String, com.mysql.jdbc.NonRegisteringDriver) (Unknown Source)
    at com.mysql.jdbc.NonRegisteringDriver.connect(java.lang.String, java.util.Properties) (Unknown Source)
    at java.sql.DriverManager.getConnection(java.lang.String, java.util.Properties) (/usr/lib/libgcj.so.6.0.0)
    at java.sql.DriverManager.getConnection(java.lang.String, java.lang.String, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
    at be.ibridge.kettle.core.database.Database.connectUsingClass(java.lang.String, java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.normalConnect(java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect(java.lang.String, java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect(java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect() (Unknown Source)
    at be.ibridge.kettle.core.dialog.DatabaseDialog.test(org.eclipse.swt.widgets.Shell, be.ibridge.kettle.core.database.DatabaseMeta) (Unknown Source)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizardPage2.test() (Unknown Source)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizardPage2$3.widgetSelected(org.eclipse.swt.events.SelectionEvent) (Unknown Source)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)


    ** END NESTED EXCEPTION **




    be.ibridge.kettle.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database

    Error connecting to database: (using class org.gjt.mm.mysql.Driver)
    Error during query: Unexpected Exception: java.io.CharConversionException message given: null

    Nested Stack Trace:


    ** BEGIN NESTED EXCEPTION **

    java.io.CharConversionException

    STACKTRACE:

    java.io.CharConversionException
    at gnu.gcj.convert.Input_iconv.read(char[], int, int) (/usr/lib/libgcj.so.6.0.0)
    at java.lang.String.init(byte[], int, int, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
    at java.lang.String.String(byte[], int, int, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
    at com.mysql.jdbc.SingleByteCharsetConverter.SingleByteCharsetConverter(java.lang.String) (Unknown Source)
    at com.mysql.jdbc.SingleByteCharsetConverter.initCharset(java.lang.String) (Unknown Source)
    at com.mysql.jdbc.SingleByteCharsetConverter.getInstance(java.lang.String, com.mysql.jdbc.Connection) (Unknown Source)
    at com.mysql.jdbc.StringUtils.getBytes(java.lang.String, java.lang.String, java.lang.String, boolean) (Unknown Source)
    at com.mysql.jdbc.ByteArrayBuffer.writeStringNoNull(java.lang.String, java.lang.String, java.lang.String, boolean) (Unknown Source)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(com.mysql.jdbc.Statement, java.lang.String, java.lang.String, com.mysql.jdbc.Buffer, int, com.mysql.jdbc.Connection, int, int, boolean, java.lang.String, boolean) (Unknown Source)
    at com.mysql.jdbc.Connection.execSQL(com.mysql.jdbc.Statement, java.lang.String, int, com.mysql.jdbc.Buffer, int, int, boolean, boolean, java.lang.String, boolean, byte, boolean) (Unknown Source)
    at com.mysql.jdbc.Connection.configureClientCharacterSet() (Unknown Source)
    at com.mysql.jdbc.Connection.initializePropsFromServer(java.util.Properties) (Unknown Source)
    at com.mysql.jdbc.Connection.createNewIO(boolean) (Unknown Source)
    at com.mysql.jdbc.Connection.Connection(java.lang.String, int, java.util.Properties, java.lang.String, java.lang.String, com.mysql.jdbc.NonRegisteringDriver) (Unknown Source)
    at com.mysql.jdbc.NonRegisteringDriver.connect(java.lang.String, java.util.Properties) (Unknown Source)
    at java.sql.DriverManager.getConnection(java.lang.String, java.util.Properties) (/usr/lib/libgcj.so.6.0.0)
    at java.sql.DriverManager.getConnection(java.lang.String, java.lang.String, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
    at be.ibridge.kettle.core.database.Database.connectUsingClass(java.lang.String, java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.normalConnect(java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect(java.lang.String, java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect(java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect() (Unknown Source)
    at be.ibridge.kettle.core.dialog.DatabaseDialog.test(org.eclipse.swt.widgets.Shell, be.ibridge.kettle.core.database.DatabaseMeta) (Unknown Source)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizardPage2.test() (Unknown Source)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizardPage2$3.widgetSelected(org.eclipse.swt.events.SelectionEvent) (Unknown Source)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)


    ** END NESTED EXCEPTION **




    at be.ibridge.kettle.core.database.Database.normalConnect(java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect(java.lang.String, java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect(java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect() (Unknown Source)
    at be.ibridge.kettle.core.dialog.DatabaseDialog.test(org.eclipse.swt.widgets.Shell, be.ibridge.kettle.core.database.DatabaseMeta) (Unknown Source)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizardPage2.test() (Unknown Source)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizardPage2$3.widgetSelected(org.eclipse.swt.events.SelectionEvent) (Unknown Source)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents() (Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch() (Unknown Source)
    at org.eclipse.jface.window.Window.runEventLoop(org.eclipse.swt.widgets.Shell) (Unknown Source)
    at org.eclipse.jface.window.Window.open() (Unknown Source)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizard.createAndRunDatabaseWizard(org.eclipse.swt.widgets.Shell, be.ibridge.kettle.core.Props, java.util.ArrayList) (Unknown Source)
    at be.ibridge.kettle.spoon.Spoon.createDatabaseWizard() (Unknown Source)
    at be.ibridge.kettle.spoon.Spoon.access$100(be.ibridge.kettle.spoon.Spoon) (Unknown Source)
    at be.ibridge.kettle.spoon.Spoon$81.widgetSelected(org.eclipse.swt.events.SelectionEvent) (Unknown Source)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents() (Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch() (Unknown Source)
    Caused by: be.ibridge.kettle.core.exception.KettleDatabaseException:
    Error connecting to database: (using class org.gjt.mm.mysql.Driver)
    Error during query: Unexpected Exception: java.io.CharConversionException message given: null

    Nested Stack Trace:


    ** BEGIN NESTED EXCEPTION **

    java.io.CharConversionException

    STACKTRACE:

    java.io.CharConversionException
    at gnu.gcj.convert.Input_iconv.read(char[], int, int) (/usr/lib/libgcj.so.6.0.0)
    at java.lang.String.init(byte[], int, int, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
    at java.lang.String.String(byte[], int, int, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
    at com.mysql.jdbc.SingleByteCharsetConverter.SingleByteCharsetConverter(java.lang.String) (Unknown Source)
    at com.mysql.jdbc.SingleByteCharsetConverter.initCharset(java.lang.String) (Unknown Source)
    at com.mysql.jdbc.SingleByteCharsetConverter.getInstance(java.lang.String, com.mysql.jdbc.Connection) (Unknown Source)
    at com.mysql.jdbc.StringUtils.getBytes(java.lang.String, java.lang.String, java.lang.String, boolean) (Unknown Source)
    at com.mysql.jdbc.ByteArrayBuffer.writeStringNoNull(java.lang.String, java.lang.String, java.lang.String, boolean) (Unknown Source)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(com.mysql.jdbc.Statement, java.lang.String, java.lang.String, com.mysql.jdbc.Buffer, int, com.mysql.jdbc.Connection, int, int, boolean, java.lang.String, boolean) (Unknown Source)
    at com.mysql.jdbc.Connection.execSQL(com.mysql.jdbc.Statement, java.lang.String, int, com.mysql.jdbc.Buffer, int, int, boolean, boolean, java.lang.String, boolean, byte, boolean) (Unknown Source)
    at com.mysql.jdbc.Connection.configureClientCharacterSet() (Unknown Source)
    at com.mysql.jdbc.Connection.initializePropsFromServer(java.util.Properties) (Unknown Source)
    at com.mysql.jdbc.Connection.createNewIO(boolean) (Unknown Source)
    at com.mysql.jdbc.Connection.Connection(java.lang.String, int, java.util.Properties, java.lang.String, java.lang.String, com.mysql.jdbc.NonRegisteringDriver) (Unknown Source)
    at com.mysql.jdbc.NonRegisteringDriver.connect(java.lang.String, java.util.Properties) (Unknown Source)
    at java.sql.DriverManager.getConnection(java.lang.String, java.util.Properties) (/usr/lib/libgcj.so.6.0.0)
    at java.sql.DriverManager.getConnection(java.lang.String, java.lang.String, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
    at be.ibridge.kettle.core.database.Database.connectUsingClass(java.lang.String, java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.normalConnect(java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect(java.lang.String, java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect(java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect() (Unknown Source)
    at be.ibridge.kettle.core.dialog.DatabaseDialog.test(org.eclipse.swt.widgets.Shell, be.ibridge.kettle.core.database.DatabaseMeta) (Unknown Source)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizardPage2.test() (Unknown Source)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizardPage2$3.widgetSelected(org.eclipse.swt.events.SelectionEvent) (Unknown Source)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)


    ** END NESTED EXCEPTION **



    at be.ibridge.kettle.core.database.Database.connectUsingClass(java.lang.String, java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.normalConnect(java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect(java.lang.String, java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect(java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect() (Unknown Source)
    at be.ibridge.kettle.core.dialog.DatabaseDialog.test(org.eclipse.swt.widgets.Shell, be.ibridge.kettle.core.database.DatabaseMeta) (Unknown Source)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizardPage2.test() (Unknown Source)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizardPage2$3.widgetSelected(org.eclipse.swt.events.SelectionEvent) (Unknown Source)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents() (Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch() (Unknown Source)
    at org.eclipse.jface.window.Window.runEventLoop(org.eclipse.swt.widgets.Shell) (Unknown Source)
    at org.eclipse.jface.window.Window.open() (Unknown Source)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizard.createAndRunDatabaseWizard(org.eclipse.swt.widgets.Shell, be.ibridge.kettle.core.Props, java.util.ArrayList) (Unknown Source)
    at be.ibridge.kettle.spoon.Spoon.createDatabaseWizard() (Unknown Source)
    at be.ibridge.kettle.spoon.Spoon.access$100(be.ibridge.kettle.spoon.Spoon) (Unknown Source)
    at be.ibridge.kettle.spoon.Spoon$81.widgetSelected(org.eclipse.swt.events.SelectionEvent) (Unknown Source)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents() (Unknown Source)
    Caused by: java.sql.SQLException: Error during query: Unexpected Exception: java.io.CharConversionException message given: null

    Nested Stack Trace:


    ** BEGIN NESTED EXCEPTION **

    java.io.CharConversionException

    STACKTRACE:

    java.io.CharConversionException
    at gnu.gcj.convert.Input_iconv.read(char[], int, int) (/usr/lib/libgcj.so.6.0.0)
    at java.lang.String.init(byte[], int, int, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
    at java.lang.String.String(byte[], int, int, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
    at com.mysql.jdbc.SingleByteCharsetConverter.SingleByteCharsetConverter(java.lang.String) (Unknown Source)
    at com.mysql.jdbc.SingleByteCharsetConverter.initCharset(java.lang.String) (Unknown Source)
    at com.mysql.jdbc.SingleByteCharsetConverter.getInstance(java.lang.String, com.mysql.jdbc.Connection) (Unknown Source)
    at com.mysql.jdbc.StringUtils.getBytes(java.lang.String, java.lang.String, java.lang.String, boolean) (Unknown Source)
    at com.mysql.jdbc.ByteArrayBuffer.writeStringNoNull(java.lang.String, java.lang.String, java.lang.String, boolean) (Unknown Source)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(com.mysql.jdbc.Statement, java.lang.String, java.lang.String, com.mysql.jdbc.Buffer, int, com.mysql.jdbc.Connection, int, int, boolean, java.lang.String, boolean) (Unknown Source)
    at com.mysql.jdbc.Connection.execSQL(com.mysql.jdbc.Statement, java.lang.String, int, com.mysql.jdbc.Buffer, int, int, boolean, boolean, java.lang.String, boolean, byte, boolean) (Unknown Source)
    at com.mysql.jdbc.Connection.configureClientCharacterSet() (Unknown Source)
    at com.mysql.jdbc.Connection.initializePropsFromServer(java.util.Properties) (Unknown Source)
    at com.mysql.jdbc.Connection.createNewIO(boolean) (Unknown Source)
    at com.mysql.jdbc.Connection.Connection(java.lang.String, int, java.util.Properties, java.lang.String, java.lang.String, com.mysql.jdbc.NonRegisteringDriver) (Unknown Source)
    at com.mysql.jdbc.NonRegisteringDriver.connect(java.lang.String, java.util.Properties) (Unknown Source)
    at java.sql.DriverManager.getConnection(java.lang.String, java.util.Properties) (/usr/lib/libgcj.so.6.0.0)
    at java.sql.DriverManager.getConnection(java.lang.String, java.lang.String, java.lang.String) (/usr/lib/libgcj.so.6.0.0)
    at be.ibridge.kettle.core.database.Database.connectUsingClass(java.lang.String, java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.normalConnect(java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect(java.lang.String, java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect(java.lang.String) (Unknown Source)
    at be.ibridge.kettle.core.database.Database.connect() (Unknown Source)
    at be.ibridge.kettle.core.dialog.DatabaseDialog.test(org.eclipse.swt.widgets.Shell, be.ibridge.kettle.core.database.DatabaseMeta) (Unknown Source)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizardPage2.test() (Unknown Source)
    at be.ibridge.kettle.core.wizards.createdatabase.CreateDatabaseWizardPage2$3.widgetSelected(org.eclipse.swt.events.SelectionEvent) (Unknown Source)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(org.eclipse.swt.widgets.Event) (Unknown Source)


    ** END NESTED EXCEPTION **



    Hostname : localhost
    Port : 3306
    Database name : webanalytics

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    First start by installing a correct JDK... JDK 1.4 at least for Kettle 2.5 (JDK 5 for Kettle 3.0), the Sun one ;-)... the gnu one is not good enough.

    Regards,
    Sven

  3. #3
    Join Date
    Sep 2007
    Posts
    2

    Default

    Thanks - I do have a version on the box for tomcat application server.
    Does spoon use an env variable - like JAVA_HOME - or is there another config.

    ed

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    To find java not, it searches the PATH (looking at spoon.sh).

    Regards,
    Sven

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.