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