Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: trabajando con pentaho aggregation design

  1. #1

    Default trabajando con pentaho aggregation design

    hola algien esta trabajando con pentaho aggregation design cuando se trata de hacer una coneccion a una base detados en mi caso oracle marca el siguiente error que dice que no encuantra la "oracle.jdbc.driver.OracleDriver"


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

    Exception while loading class
    oracle.jdbc.driver.OracleDriver


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

    Exception while loading class
    oracle.jdbc.driver.OracleDriver


    at org.pentaho.di.core.database.Database.normalConnect(Database.java:318)
    at org.pentaho.di.core.database.Database.connect(Database.java:267)
    at org.pentaho.di.core.database.Database.connect(Database.java:229)
    at org.pentaho.di.core.database.Database.connect(Database.java:219)
    at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:54)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2368)
    at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:464)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:293)
    at org.pentaho.ui.xul.swing.tags.SwingButton$1$1.run(SwingButton.java:80)
    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153)
    at java.awt.Dialog$1.run(Dialog.java:517)
    at java.awt.Dialog$2.run(Dialog.java:545)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.awt.Dialog.show(Dialog.java:543)
    at java.awt.Component.show(Component.java:1300)
    at java.awt.Component.setVisible(Component.java:1253)
    at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:214)
    at org.pentaho.aggdes.ui.form.controller.ConnectionController.loadDatabaseDialog(ConnectionController.java:235)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:293)
    at org.pentaho.ui.xul.swing.tags.SwingButton$1$1.run(SwingButton.java:80)
    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153)
    at java.awt.Dialog$1.run(Dialog.java:517)
    at java.awt.Dialog$2.run(Dialog.java:545)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.awt.Dialog.show(Dialog.java:543)
    at java.awt.Component.show(Component.java:1300)
    at java.awt.Component.setVisible(Component.java:1253)
    at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:214)
    at org.pentaho.aggdes.ui.form.controller.ConnectionController.showConnectionDialog(ConnectionController.java:313)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:293)
    at org.pentaho.ui.xul.swing.tags.SwingButton$1$1.run(SwingButton.java:80)
    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
    at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Exception while loading class
    oracle.jdbc.driver.OracleDriver

    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:365)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:302)
    ... 57 more
    Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
    at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:164)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:357)
    ... 58 more

    Hostname : ip de la dase de datos
    Port : 1521
    Database name : base




    de antemano gracias por la ayuda

  2. #2

    Default

    para poder resolver el problema hay que realizar una conexion en el pentaho data integration y listo


    saludos

  3. #3
    Join Date
    Mar 2009
    Posts
    4

    Smile

    Hola
    Tal vez debas agregar el driver jdbc correspondiente a tu versión de Oracle dentro de la carpeta drivers del aggregation designer (.\aggregation-designer\drivers).
    Yo para poder conectarme a una base de datos postgresql agregué el driver postgresql-8.2-504.jdbc3.jar dentro de esta carpeta y no tuve problemas.
    Suerte!!

  4. #4

    Unhappy

    Pls como hiciste la conexion con el Data Integration plss!! tengo el mismo probelma gracias

  5. #5
    Join Date
    Aug 2006
    Posts
    141

    Default

    Para las conecciones de base de datos se requiere un archivo JDBC correspondiente a la base de datos que utilices, copiarlo al directorio correspondiente por lo general a JDBC o Drivers como es el caso de Aggregation Designer y configurar la coneccion de forma adecuada datos de usuario puerto url.


    A propósito estoy intnetando hacer funcionar las tablas agregadas en Pentaho pero por mas que busco, me doy cuenta que el servidor nunca las consulta, siempre va a la tabla de hechos. Mire la configuracion de Mondrian y las opciones estan habilitadas

  6. #6
    Join Date
    Aug 2006
    Posts
    141

    Default

    Efectivamente se necesita un JDBC que debes copiar al directorio JDBC o DRIVERS. Yo estoy intnetando ya implementar tablas agregadas, pero aun cuando las he hecho con el aggregation designer y utilizado el modelo y configurado los parametros de Mondrian no he logrado que este efectivamente las consulte, siempre utiliza la fact_table

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.