Kettle is an ETL Application and is now a part of the Pentaho BI Suite (Very cool application:)
I deployed this "out-of-the-box" in a standalone mode. It uses Tomcat as the application server. I have already confirmed that Unirpcd service is started. I have the correct IP Address for the Host Name. I have used port # 31438 (I took the default when generating the error to show you all). I will look into seeing if asjava.jar needs to be in a specific directory within the app or app server. Or if I can just place it in the CLASSPATH. I SO appriciate you helping out!!!! Here is the error again with the port # and host name.... Error connecting to database [Test] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class com.ibm.u2.jdbc.UniJDBCDriver) asjava/unirpc/UniRPCException org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class com.ibm.u2.jdbc.UniJDBCDriver) asjava/unirpc/UniRPCException at org.pentaho.di.core.database.Database.normalConnect(Database.java:312) at org.pentaho.di.core.database.Database.connect(Database.java:261) at org.pentaho.di.core.database.Database.connect(Database.java:223) at org.pentaho.di.core.database.Database.connect(Database.java:213) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:55) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2409) at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:487) 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:294) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:124) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:112) at org.pentaho.ui.xul.swt.tags.SwtButton.access$000(SwtButton.java:17) at org.pentaho.ui.xul.swt.tags.SwtButton$1.widgetSelected(SwtButton.java:77) 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:238) at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:161) at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:79) at org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree(Spoon.java:2317) at org.pentaho.di.ui.spoon.Spoon.access$1600(Spoon.java:242) at org.pentaho.di.ui.spoon.Spoon$25.widgetDefaultSelected(Spoon.java:4061) 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:945) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5574) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:412) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class com.ibm.u2.jdbc.UniJDBCDriver) asjava/unirpc/UniRPCException at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:439) at org.pentaho.di.core.database.Database.normalConnect(Database.java:296) ... 36 more Caused by: java.lang.NoClassDefFoundError: asjava/unirpc/UniRPCException at com.ibm.u2.jdbc.UniJDBCConnectionImpl.<init>(UniJDBCConnectionImpl.java:137) at com.ibm.u2.jdbc.UniJDBCDriver.connect(UniJDBCDriver.java:111) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:171) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:416) ... 37 more Hostname : 192.168.1.21 Port : 31438 Database name : SHAWN 'We act as though comfort and luxury were the chief requirements of life, when all that we need to make us happy is something to be enthusiastic about.' ----- Original Message ---- From: Rick Nuckolls <[email protected]> To: U2 Users List <[email protected]> Sent: Thu, May 6, 2010 10:59:55 AM Subject: Re: [U2] as.java.unirpc.UniRPCException Looks like your classpath is fine. It found all the classes that it needs. The problem appears to be that you are failing to connect to the database. There could be a number of reasons for that, including: The unirpcd service is not started on the machine hosting your data base & The connection string being used to contact it is wrong. I have not done this with uv (ud?) running on windows, so I do not know how to ensure that the unirpc is running on that; but on Unix, you can look for it with "ps -ef |grep unirpcd". the unijdbc stuff uses the asjava classes to access u2 via the unirpcd daemon. But -- if the port that you are connecting on is really "-1" or the hostname is "xxxxxx" (as opposed to something edited on your part), then you also have not successfully specified the uri of the database to the jdbc driver. On Unix, the default port is 31438. -Rick The jdbc stuff needs a configuration file for On May 6, 2010, at 8:36 AM, Shawn Hayes wrote: > How do you know you're missing that class? In the first paragraph of the > error, it says > "Error connecting to database: (using class com.ibm.u2.jdbc.UniJDBCDriver) > asjava/unirpc/UniRPCException" > > Are you seeing an error in a log file somewhere? Here is the whole error.... > "Error connecting to database [Test] : > org.pentaho.di.core.exception.KettleDatabaseException: > Error occured while trying to connect to the database > Error connecting to database: (using class com.ibm.u2.jdbc.UniJDBCDriver) > asjava/unirpc/UniRPCException > > org.pentaho.di.core.exception.KettleDatabaseException: > Error occured while trying to connect to the database > Error connecting to database: (using class com.ibm.u2.jdbc.UniJDBCDriver) > asjava/unirpc/UniRPCException > > at org.pentaho.di.core.database.Database.normalConnect(Database.java:312) > at org.pentaho.di.core.database.Database.connect(Database.java:261) > at org.pentaho.di.core.database.Database.connect(Database.java:223) > at org.pentaho.di.core.database.Database.connect(Database.java:213) > at > org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:55) > at > org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2409) > at > org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:487) > 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:294) > at > org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:124) > at > org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:112) > at org.pentaho.ui.xul.swt.tags.SwtButton.access$000(SwtButton.java:17) > at org.pentaho.ui.xul.swt.tags.SwtButton$1.widgetSelected(SwtButton.java:77) > 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:238) > at > org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:161) > at > org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:79) > at org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree(Spoon.java:2317) > at org.pentaho.di.ui.spoon.Spoon.access$1600(Spoon.java:242) > at org.pentaho.di.ui.spoon.Spoon$25.widgetDefaultSelected(Spoon.java:4061) > 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:945) > at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5574) > at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:412) > Caused by: org.pentaho.di.core.exception.KettleDatabaseException: > Error connecting to database: (using class com.ibm.u2.jdbc.UniJDBCDriver) > asjava/unirpc/UniRPCException > at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:439) > at org.pentaho.di.core.database.Database.normalConnect(Database.java:296) > ... 36 more > Caused by: java.lang.NoClassDefFoundError: asjava/unirpc/UniRPCException > at > com.ibm.u2.jdbc.UniJDBCConnectionImpl.<init>(UniJDBCConnectionImpl.java:137) > at com.ibm.u2.jdbc.UniJDBCDriver.connect(UniJDBCDriver.java:111) > at java.sql.DriverManager.getConnection(DriverManager.java:525) > at java.sql.DriverManager.getConnection(DriverManager.java:171) > at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:416) > ... 37 more > Hostname : xxxxxx > Port : -1 > Database name : SHAWN" > 'We act as though comfort and luxury were the chief requirements of life, > when all that we need to make us happy is something to be enthusiastic about.' > > > > ----- Original Message ---- > From: Ben Souther <[email protected]> > To: U2 Users List <[email protected]> > Sent: Thu, May 6, 2010 10:15:08 AM > Subject: Re: [U2] as.java.unirpc.UniRPCException > > Maybe we should back up. > > How do you know you're missing that class? > Are you seeing an error in a log file somewhere? > > > > > On Thu, 2010-05-06 at 08:11 -0700, Shawn Hayes wrote: >> I was just about to ask that (I am new to Java). So, I looked in the >> asjava.jar file and found >> "UniRPCException.class" and "UniRPC.class". He told me that I needed the >> driver... >> >> "as.java.unirpc.UniRPCException" >> >> Should this be "asjava.UniRPCException.class" instead or does the >> UniRPC.class inherit UniRPCException (I hope I asked that right:). >> >> Thanks!! >> 'We act as though comfort and luxury were the chief requirements of life, >> when all that we need to make us happy is something to be enthusiastic >> about.' >> >> >> >> ----- Original Message ---- >> From: Rick Nuckolls <[email protected]> >> To: U2 Users List <[email protected]> >> Sent: Thu, May 6, 2010 10:01:27 AM >> Subject: Re: [U2] as.java.unirpc.UniRPCException >> >> That class name should really not have a period between "as" and "java". >> >> -Rick >> >> >> On May 6, 2010, at 7:44 AM, Shawn Hayes wrote: >> >>> I am trying to connect to a Universe Database to an application called >>> "Kettle". First of all, has anyone done this? Second, I have had problems >>> connecting. I have been searching their boards looking for solutions and >>> reaching out to the community. I got a response that said... >>> >>> "Looks like you're simply missing a driver library. One that would contain >>> the as.java.unirpc.UniRPCException class" >>> >>> I have set the 2 files (unijdbc.jar and asjava.jar) that are needed for >>> JDBC connection to a Universe Database. I have placed them in my Classpath >>> as >>> >>> C:\IBM\UniDK\jdbc\lib\unijdbc.jar;C:\IBM\UniDK\uojsdk\lib\asjava.zip;%CLASSPATH% >>> >>> I looked through these and can't find "as.java.unirpc.UniRPCException" Can >>> someone help with this? Thank - Shawn >>> 'We act as though comfort and luxury were the chief requirements of life, >>> when all that we need to make us happy is something to be enthusiastic >>> about.' >>> _______________________________________________ >>> U2-Users mailing list >>> [email protected] >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >> >> _______________________________________________ >> U2-Users mailing list >> [email protected] >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> >> _______________________________________________ >> U2-Users mailing list >> [email protected] >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> > -- > Ben Souther > Manager, Web and Web Service Development > [email protected] | 508.927.8147 > FWDavison & Company, Inc. > 10 Cordage Park Circle, Suite 200 > Plymouth, MA 02360-7318 > > CONFIDENTIALITY NOTICE: This e-mail message, and any accompanying > documents, is for the sole use of the intended recipient(s) and may > contain confidential and privileged information. Any unauthorized > review, use, disclosure, distribution or copying is prohibited. If you > are not the intended recipient, please contact our office by e-mail or > by telephone at (508) 747-7261 and immediately destroy all copies of the > original message. > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
