Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Error trying to connect Spoon to a DataBase

  1. #1
    Join Date
    Aug 2013
    Posts
    2

    Default Error trying to connect Spoon to a DataBase

    Hi everyone, I'm new in this.. sorry about my english I'm from Argentina.
    Well, I'm trying to connect Spoon to a DataBase (the database is from the company I'm working), I already create a DSN System (Make the conection from windows to the data base) but when I try to connect from Spoon, the program show me this error:

    Error al conectar a la base de datos [Edisur BD] rg.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database


    Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
    [Microsoft][Administrador de controladores ODBC] Longitud de cadena o de búfer no válida




    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database


    Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
    [Microsoft][Administrador de controladores ODBC] Longitud de cadena o de búfer no válida




    at org.pentaho.di.core.database.Database.normalConnect(Database.java:366)
    at org.pentaho.di.core.database.Database.connect(Database.java:315)
    at org.pentaho.di.core.database.Database.connect(Database.java:277)
    at org.pentaho.di.core.database.Database.connect(Database.java:267)
    at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:86)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2469)
    at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:535)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
    at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(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(Window.java:820)
    at org.eclipse.jface.window.Window.open(Window.java:796)
    at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378)
    at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
    at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:115)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:62)
    at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.newConnection(SpoonDBDelegate.java:493)
    at org.pentaho.di.ui.core.dialog.EnterSelectionDialog.addDataSource(EnterSelectionDialog.java:466)
    at org.pentaho.di.ui.core.dialog.EnterSelectionDialog$2.widgetSelected(EnterSelectionDialog.java:232)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.core.dialog.EnterSelectionDialog.open(EnterSelectionDialog.java:342)
    at org.pentaho.agilebi.spoon.modeler.SpoonModelerController.editDataSource(SpoonModelerController.java:177)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
    at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1219)
    at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7049)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8309)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:578)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
    [Microsoft][Administrador de controladores ODBC] Longitud de cadena o de búfer no válida


    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:502)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:350)
    ... 59 more
    Caused by: java.sql.SQLException: [Microsoft][Administrador de controladores ODBC] Longitud de cadena o de búfer no válida
    at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcConnection.buildTypeInfo(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:482)
    ... 60 more


    Nombre del host:
    Puerto :1521
    Nombre de la base de datos:sql

  2. #2
    Join Date
    Aug 2013
    Posts
    2

    Default

    I try to connect from different tools of pentaho, but everyone show me that message

  3. #3
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Don't use ODBC, download and install the JDBC driver from Microsoft.
    So long, and thanks for all the fish.

  4. #4
    Join Date
    Jul 2009
    Posts
    476

    Default

    No habla Espanol, but the "Puerto: 1521" makes it look like PDI is trying to connect to Oracle. Are you trying to connect to an Oracle database with ODBC?

  5. #5
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    The error states that the DSN is not valid.
    Make sure that the DSN 100% matches the DSN as given in the ODBC Manager.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

Tags for this Thread

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.