Thanks Gary,
A truly helpful explanation.
Based on what John had said earlier, and your explanation I was able to get
a correct response from the 'java jdbcinfo' (yes, I now realise its also
case-sensitive)
That done, I set the CLASSPATH as suggested as a system environment
variable. (I was manually setting it in a dos window whilst testing)
Once that was done, I re-started iReports and the ingres jdbc was now
available
Successfully created and tested a connection to my db, so its now only a
matter of experimenting / learning iReports
To all who replied,
Thanks a-lot you guys are life-savers.
Dic.
-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
ghingres (AT) yahoo (DOT) co.uk
Sent: Wednesday, 10 June 2009 8:08 p.m.
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] Installing and using an Ingres JDBC connection
Richard,
=================================================
To test that you have a good JDBC driver, try the following: -
=================================================
1/ Ensure you have the files "JdbcInfo.class" and "iijdbc.jar" inside
your %II_SYSTEM%\ingres\lib directory
2/ At the DOS command prompt use the following command (you can be in
any directory) : -
java -cp %II_SYSTEM%\ingres\lib;%II_SYSTEM%\ingres\lib\iijd bc.jar
JdbcInfo
If all is OK, you should see information about the JDBC driver
release
=================================================
Your Java reporting problem
=================================================
1/ All operating systems have a set of directories they will search to
resolve a command. Java is the same but for programs and classes that
make up programs. For Java this is the CLASSPATH variable which is set
at the operating system level before you start any Java program.
2/ In the case of your reporting program, normally there will be a
configuration file (or screen) that will describe where the program
looks for JDBC drivers (you enter the full path name and .JAR file
name). Think of the .JAR file as a ZIP file because that is what it
is.. you can use 7-zip to explore it :-) Just saves copying lots of
directory structures and keeps things tidy. The classname (driver) you
want from this file is called "com.ingres.jdbc.IngresDriver", which if
you explorer the .JAR file you'll see there's a file called
IngresDriver.class in the sub-directory of com\ingres\jdbc. The report
program will want to know this classname.
3) So now the report program should be configured to load the
iijdbc.jar file in the %II_SYSTEM%\ingres\lib area and use the class
called "com.ingres.jdbc.IngresDriver".
=================================================
Finally - using the JDBC driver
=================================================
1/ Now you've got the JDBC driver loaded into the reporting program,
you'll have to supply the URL for where it must go to find the Ingres
database (it's name/node/port/password etc)...
For Ingres you use the following structure: -
jdbc:ingres://host
ort/db
so something like
jdbc:ingres://host:II7/testdb
the II7 is usually the default for the JDBC server component on an
ingres system configured with the installation code of II (but use CBF
on the system to see what the real port is).
=================================================
Hope this helps to clarify
Cheers
Gary
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres
[Info-Ingres] Installing and using an Ingres JDBC connection -
06-10-2009
, 12:12 AM
Linear Mode
