On Thu, 2010-05-06 at 08:59 -0700, Rick Nuckolls wrote: >Looks like your classpath is fine. ...
Rick, In the logs posted, there is a NoClassDefError: > Caused by: java.lang.NoClassDefFoundError: asjava/unirpc/UniRPCException Which means that the application can't find the asjava.jar file. This is why I asked what type of app Kettle is. Application servers use custom class loaders to find classes instead of relying on the CLASSPATH environment variable. This is how they run multiple web apps and keep them isolated from one another. It may just be that asjava.jar needs to be in a specific directory within the app or app server. -Ben On Thu, 2010-05-06 at 08:59 -0700, Rick Nuckolls wrote: > 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 > -- 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
