Error connecting to database oracle

[Rosa Maria]

Buenas tardes,

Estoy teniendo problemas al crear una conexión a oracle en Report Designer 3.6.0. El error que me sale es el siguiente:

 

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

Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
 at java.awt.EventDispatchThread.run (EventDispatchThread.java:110)
 at java.awt.EventDispatchThread.pumpEvents (EventDispatchThread.java:149)
 at java.awt.EventDispatchThread.pumpEvents (EventDispatchThread.java:157)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy (EventDispatchThread.java:163)
 at java.awt.EventDispatchThread.pumpOneEventForHierarchy (EventDispatchThread.java:242)
 at java.awt.EventQueue.dispatchEvent (EventQueue.java:463)
 at java.awt.Component.dispatchEvent (Component.java:3803)
 at java.awt.Window.dispatchEventImpl (Window.java:1774)
 at java.awt.Container.dispatchEventImpl (Container.java:2010)
 at java.awt.LightweightDispatcher.dispatchEvent (Container.java:3822)
 at java.awt.LightweightDispatcher.processMouseEvent (Container.java:3892)
 at java.awt.LightweightDispatcher.retargetMouseEvent (Container.java:4212)
 at java.awt.Component.dispatchEvent (Component.java:3803)
 at java.awt.Container.dispatchEventImpl (Container.java:2024)
 at java.awt.Component.dispatchEventImpl (Component.java:3955)
 at java.awt.Container.processEvent (Container.java:1966)
 at java.awt.Component.processEvent (Component.java:5253)
 at javax.swing.JComponent.processMouseEvent (JComponent.java:3126)
 at java.awt.Component.processMouseEvent (Component.java:5488)
 at java.awt.AWTEventMulticaster.mouseReleased (AWTEventMulticaster.java:231)
 at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased (BasicMenuItemUI.java:1041)
 at javax.swing.plaf.basic.BasicMenuItemUI.doClick (BasicMenuItemUI.java:1000)
 at javax.swing.AbstractButton.doClick (AbstractButton.java:302)
 at javax.swing.DefaultButtonModel.setPressed (DefaultButtonModel.java:258)
 at javax.swing.DefaultButtonModel.fireActionPerformed (DefaultButtonModel.java:420)
 at javax.swing.AbstractButton$Handler.actionPerformed (AbstractButton.java:2169)
 at javax.swing.AbstractButton.fireActionPerformed (AbstractButton.java:1849)
 at org.pentaho.reporting.designer.core.actions.report.AddDataFactoryAction.actionPerformed (AddDataFactoryAction.java:80)
 at org.pentaho.reporting.ui.datasources.jdbc.JdbcDataSourcePlugin.performEdit (JdbcDataSourcePlugin.java:67)
 at org.pentaho.reporting.ui.datasources.jdbc.ui.JdbcDataSourceDialog.performConfiguration (JdbcDataSourceDialog.java:624)
 at java.awt.Component.setVisible (Component.java:1253)
 at java.awt.Component.show (Component.java:1300)
 at java.awt.Dialog.show (Dialog.java:536)
 at java.awt.Dialog$1.run (Dialog.java:515)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy (EventDispatchThread.java:153)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy (EventDispatchThread.java:163)
 at java.awt.EventDispatchThread.pumpOneEventForHierarchy (EventDispatchThread.java:242)
 at java.awt.EventQueue.dispatchEvent (EventQueue.java:463)
 at java.awt.Component.dispatchEvent (Component.java:3803)
 at java.awt.Window.dispatchEventImpl (Window.java:1774)
 at java.awt.Container.dispatchEventImpl (Container.java:2010)
 at java.awt.LightweightDispatcher.dispatchEvent (Container.java:3822)
 at java.awt.LightweightDispatcher.processMouseEvent (Container.java:3892)
 at java.awt.LightweightDispatcher.retargetMouseEvent (Container.java:4212)
 at java.awt.Component.dispatchEvent (Component.java:3803)
 at java.awt.Container.dispatchEventImpl (Container.java:2024)
 at java.awt.Component.dispatchEventImpl (Component.java:3955)
 at java.awt.Container.processEvent (Container.java:1966)
 at java.awt.Component.processEvent (Component.java:5253)
 at javax.swing.JComponent.processMouseEvent (JComponent.java:3126)
 at java.awt.Component.processMouseEvent (Component.java:5488)
 at java.awt.AWTEventMulticaster.mouseReleased (AWTEventMulticaster.java:231)
 at java.awt.AWTEventMulticaster.mouseReleased (AWTEventMulticaster.java:231)
 at javax.swing.plaf.basic.BasicButtonListener.mouseReleased (BasicButtonListener.java:234)
 at javax.swing.DefaultButtonModel.setPressed (DefaultButtonModel.java:258)
 at javax.swing.DefaultButtonModel.fireActionPerformed (DefaultButtonModel.java:420)
 at javax.swing.AbstractButton$Handler.actionPerformed (AbstractButton.java:2169)
 at javax.swing.AbstractButton.fireActionPerformed (AbstractButton.java:1849)
 at org.pentaho.reporting.ui.datasources.jdbc.ui.ConnectionPanel$AddDataSourceAction.actionPerformed (ConnectionPanel.java:253)
 at org.pentaho.reporting.ui.datasources.jdbc.ui.XulDatabaseDialog.open (XulDatabaseDialog.java:237)
 at org.pentaho.ui.xul.swing.tags.SwingDialog.show (SwingDialog.java:232)
 at java.awt.Component.setVisible (Component.java:1253)
 at java.awt.Component.show (Component.java:1300)
 at java.awt.Dialog.show (Dialog.java:536)
 at java.awt.Dialog$1.run (Dialog.java:515)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy (EventDispatchThread.java:153)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy (EventDispatchThread.java:163)
 at java.awt.EventDispatchThread.pumpOneEventForHierarchy (EventDispatchThread.java:242)
 at java.awt.EventQueue.dispatchEvent (EventQueue.java:461)
 at java.awt.event.InvocationEvent.dispatch (InvocationEvent.java:209)
 at org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run (SwingButton.java:58)
 at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke (AbstractXulDomContainer.java:305)
 at java.lang.reflect.Method.invoke (Method.java:585)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)
 at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)
 at sun.reflect.NativeMethodAccessorImpl.invoke0 (NativeMethodAccessorImpl.java:-2)
 at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection (DataHandler.java:487)
 at org.pentaho.di.core.database.DatabaseMeta.testConnection (DatabaseMeta.java:2409)
 at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport (DatabaseFactory.java:55)
 at org.pentaho.di.core.database.Database.connect (Database.java:213)
 at org.pentaho.di.core.database.Database.connect (Database.java:223)
 at org.pentaho.di.core.database.Database.connect (Database.java:261)
 at org.pentaho.di.core.database.Database.normalConnect (Database.java:296)
 at org.pentaho.di.core.database.Database.connectUsingClass (Database.java:430)
 at java.sql.DriverManager.getConnection (DriverManager.java:140)
 at java.sql.DriverManager.getConnection (DriverManager.java:525)
 at oracle.jdbc.driver.OracleDriver.connect (OracleDriver.java:551)
 at oracle.jdbc.driver.T4CDriverExtension.getConnection (T4CDriverExtension.java:31)
 at oracle.jdbc.driver.T4CConnection.<init> (T4CConnection.java:149)
 at oracle.jdbc.driver.PhysicalConnection.<init> (PhysicalConnection.java:414)
 at oracle.jdbc.driver.T4CConnection.logon (T4CConnection.java:221)
 at oracle.jdbc.driver.T4CConnection.connect (T4CConnection.java:726)
 at oracle.jdbc.driver.DBConversion.<init> (DBConversion.java:125)

 

Lo que me parece raro es que yo tenía configurada la misma conexión en mi pc anterior y ahora desde esta nueva pc me da errores, la diferencia es que esta pc tiene windows 7 y la anterior windows xp.

 

Rosa

[Mariano García Mattío]

Tendrás que especificar un poco más: url/driver/archivo jar/versiones de soft etc.

Saludos