Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Imposible conectar a la base de datos

  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Exclamation Imposible conectar a la base de datos

    Hola a todos,

    He estado tratando de conectar mi spoon a la BDD para poder hacer la integracion entre dos productos de la familia de BMC. Pero me sale el siguiente error:


    Error connecting to database [rf_fpac] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database Exception while
    loading class org.gjt.mm.mysql.Driver
    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database Exception while
    loading class org.gjt.mm.mysql.Driver
    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:2464)
    at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:533)
    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.repository.kdr.KettleDatabaseRepositoryDialog$1.widgetSelected(KettleDatabaseRepositoryDialog.java:198)
    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.repository.kdr.KettleDatabaseRepositoryDialog.open(KettleDatabaseRepositoryDialog.java:320)
    at org.pentaho.di.ui.repository.kdr.KettleDatabaseRepositoryDialog.open(KettleDatabaseRepositoryDialog.java:75)
    at org.pentaho.di.ui.repository.RepositoriesHelper.newRepository(RepositoriesHelper.java:119)
    at org.pentaho.di.ui.repository.controllers.RepositoriesController.newRepository(RepositoriesController.java:272)
    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$300(SwtButton.java:26)
    at org.pentaho.ui.xul.swt.tags.SwtButton$2.mouseUp(SwtButton.java:87)
    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.repository.controllers.RepositoriesController.show(RepositoriesController.java:194)
    at org.pentaho.di.ui.repository.RepositoriesDialog.show(RepositoriesDialog.java:102)
    at org.pentaho.di.ui.spoon.Spoon.selectRep(Spoon.java:6829)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6995)
    at org.pentaho.di.ui.spoon.Spoon.createContents(Spoon.java:8288)
    at org.eclipse.jface.window.Window.create(Window.java:426)
    at org.eclipse.jface.window.Window.open(Window.java:785)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8303)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:580)
    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:
    Exception while loading class
    org.gjt.mm.mysql.Driver
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:421)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:350)
    ... 68 more
    Caused by: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:412)
    ... 69 more
    Hostname : FOOTPRINTS
    Port : 3306
    Database name : facdb


    He leido en otros post que esto se debe a que no se tiene la libreria de conectores de java en la carpeta de destino, sin embargo, este paso ya lo hice y sigo teniendo el mismo error. Adjunto pantalla de muestra:

    Name:  pentaho.jpg
Views: 2672
Size:  35.1 KB

    alguna idea o comentario?

  2. #2
    Join Date
    Aug 2013
    Posts
    8

    Default

    Buen dia por favor indicame en que carpeta colocaste los .jar (drivers)?? que version de base de datos estas trabajando? y que version de .jar estas usando?
    Gracias.
    Saludos

  3. #3
    Join Date
    Jan 2007
    Posts
    485

    Default

    Hola... Ojalá sea oportuno...

    En Pentaho PDI, los drivers de conexión a las diversas BDD se ubican en (en mi caso...): C:\Pentaho\data-integration\libext\JDBC.

    Si aquello no funciona, tal vez debas conectarte a tu bdd particular (...BMC...??) usando un ODBC genérico (en PDI ver Generic Database)...

    Ojala esto te sirva; si resolviste el problema, es buena práctica indicar cómo en un post.

    Saludos.

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.