iReport fails to recognize JDBC classpath

[maroshi]

I am using iReprot 1.3.2

 

first I try to make a JDBC connection.

I am using Db2 on AS400.

 

My JDBC driver is included in jt400.jar

 

I coppied jt400.jar to <iReport install>lib

I started iReport from <iReport installbinstartup.bat

 

iReport started with the following command:

C:Documents and SettingsAdministratorDesktopiReport-1.3.2>java -cp "C:Program FilesRationalClearQuestcqjni.jar;.

classes;.fonts;;.libantlr-2.7.5.jar;.libasm-attrs.jar;.libasm.jar;.libbarbecue-1.1.jar;.libbsh-1.3.0.jar;.

libcglib-2.1.jar;.libcincom-jr-xmla.jar;.libcommons-beanutils-1.7.jar;.libcommons-collections-2.1.jar;.libcomm

ons-dbcp-1.2.1.jar;.libcommons-digester-1.7.jar;.libcommons-javaflow-20060411.jar;.libcommons-logging-1.0.2.jar;.

libcommons-logging-api-1.0.2.jar;.libcommons-pool-1.3.jar;.libdom4j-1.6.jar;.libehcache-1.1.jar;.libeigenbase-p

roperties.jar;.libeigenbase-resgen.jar;.libeigenbase-xom.jar;.libflexdock-0.4.1.jar;.libgroovy-all-1.0-beta-10.j

ar;.libhibernate3.jar;.libhsqldb-1.7.1.jar;.libiReport.jar;.libitext-1.3.1.jar;.libjakarta-bcel-20050813.jar;.

libJasperBabylon-1.0.0.jar;.libjasperreports-1.3.2.jar;.libjasperreports-extensions-1.3.1.jar;.libjavacup.jar;.

libjcmdline-1.0.2.jar;.libjcommon-1.0.0.jar;.libjdt-compiler-3.1.1.jar;.libjfreechart-1.0.0.jar;.libjpa.jar;.l

ibjr-bsh-compiler.jar;.libjsmoothgen-ant-0.9.7.jar;.libjt400.jar;.libjta.jar;.libjxl-2.6.jar;.liblog4j-1.2.8.

jar;.liblooks-2.0-rc.jar;.libmicroba-0.4.1-bin.jar;.libmondrian-2.0.1.jar;.libmysql-connector-java-3.1.11-bin.ja

r;.libnsisant-1.1.jar;.libpng-encoder-1.5.jar;.libpoi-2.0-final-20040126.jar;.librex-20070125.jar;.libsaaj-api

-1.3.jar;.libservlet.jar;.libspring-2.0-m2.jar;.libspring-context-2.0-m2.jar;.libspring-hibernate3-2.0-m2.jar;.

libsqleonardo-2007.03.jar;.libtinylaf.jar;.libtoniclf.jar;.libxalan.jar;.libxercesImpl.jar;.libxml-apis.jar;.

libdb2_jdbc_t4_fp13.zip" -Direport.home="C:Documents and SettingsAdministratorDesktopiReport-1.3.2" -Djava.securit

y.policy="C:Documents and SettingsAdministratorDesktopiReport-1.3.2/policy.all" -Xms128m -Xmx512m it.businesslogic.i

report.gui.MainFrame

 

Apparently jt400.jar is in the classpath.

 

My JDBC class is "com.ibm.as400.access.AS400JDBCConnectionPoolDataSource"

 

Testing the connection I get class not found error message.

 

and the error stack in the cmd window:

java.lang.Exception:

at it.businesslogic.ireport.connection.JDBCConnection.test(JDBCConnection.java:384)

at it.businesslogic.ireport.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:322

)

at it.businesslogic.ireport.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:24)

 

 

I do not know how to continue.

iReport is not usable without DB connection.

 

Please advise

thanks

David

[3rwin]

Try using the following properties for your connection:

 

JDBC Driver: com.ibm.as400.access.AS400JDBCDriver

JDBC URL: jdbc:as400://system

 

3rwin

[maroshi]

thanks

 

It works fine and I am very happy.

Joy and happiness

David