On tomcat, that should be: $CATALINA_HOME / shared/ lib
where $CATALINA_HOME is probably C:\tomcat.... -Rick On May 6, 2010, at 10:17 AM, Shawn Hayes wrote: > I placed asjava.jar and unijdbc.jar in > > C:\Program Files\pentaho\server\enterprise-console\lib > > and then I tried > > C:\Program Files\pentaho\server\enterprise-console\jdbc > > No luck (so far:) > '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: Bob Little <b...@marketamerica.com> > To: U2 Users List <u2-users@listserver.u2ug.org> > Sent: Thu, May 6, 2010 11:51:52 AM > Subject: Re: [U2] as.java.unirpc.UniRPCException > > I believe you'd put the jar files either in $CATALINA_HOME/lib or in > your web app's WEB-INF/lib/ directory. > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben > Sent: Thursday, May 06, 2010 12:42 PM > To: U2 Users List > Subject: Re: [U2] as.java.unirpc.UniRPCException > > I don't remember the details off the top of my head, but there is a > place to "tell" Tomcat of jars you want it to include. > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shawn Hayes > Sent: Thursday, May 06, 2010 9:40 AM > To: U2 Users List > Subject: Re: [U2] as.java.unirpc.UniRPCException > > 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(Dat > abaseFactory.java:55) > at > org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.ja > va:2409) > at > org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHan > dler.java:487) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomCon > tainer.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(XulDatabas > eDialog.java:161) > at > org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDB > Delegate.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:43 > 9) > 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:41 > 6) > ... 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 <r...@lynden.com> > To: U2 Users List <u2-users@listserver.u2ug.org> > 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(Dat > abaseFactory.java:55) >> at > org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.ja > va:2409) >> at > org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHan > dler.java:487) >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav > a:39) >> at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor > Impl.java:25) >> at java.lang.reflect.Method.invoke(Method.java:585) >> at > org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomCon > tainer.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(XulDatabas > eDialog.java:161) >> at > org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDB > Delegate.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:43 > 9) >> 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:41 > 6) >> ... 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 <bsout...@fwdco.com> >> To: U2 Users List <u2-users@listserver.u2ug.org> >> 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 <r...@lynden.com> >>> To: U2 Users List <u2-users@listserver.u2ug.org> >>> 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;%CL > ASSPATH% >>>> >>>> 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 >>>> U2-Users@listserver.u2ug.org >>>> http://listserver.u2ug.org/mailman/listinfo/u2-users >>> >>> _______________________________________________ >>> U2-Users mailing list >>> U2-Users@listserver.u2ug.org >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >>> >>> _______________________________________________ >>> U2-Users mailing list >>> U2-Users@listserver.u2ug.org >>> http://listserver.u2ug.org/mailman/listinfo/u2-users >>> >> -- >> Ben Souther >> Manager, Web and Web Service Development >> bsout...@fwdco.com | 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 >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> >> _______________________________________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users