Can't register new jdbc drivers

[2004 IR Help]

By: Luciano Zanin - cianoz

Can't register new jdbc drivers

2004-03-15 02:53

I have iReport 0.2.3 installed on WinXP, and j2sdk1.4.2_04.

iReport works with the supplied JDBC drivers but i am not able to register any new one. Copying the new drivers in the db_drivers folders as suggested in the readme file does not provide any new entry in the driver list of the DataSource window.

Notes:

? I'm trying to register these drivers: DBF_JDBC20.jar and csvjdbc.jar

? I have not set any CLASSPATH system env variable (it should not be need)

Anyone have a suggestion about registering new drivers ?

 

 

 

 

By: Luciano Zanin - cianoz

RE: Can't register new jdbc drivers

2004-04-08 00:07

I'm trying to make iReport the main report app in my company, but it's difficult to do it if i can't work with our dbs !

 

I'd like to support and promote iReport, but if without any tip or suggestion for resolving an important need like making iReport / JasperReports working with new jdbc drivers causes other reports applicantions are preferred by the managers of the company.

 

Please, anybody is enough experienced for explain how to use a new jdbc driver with iReport (+ OpenReports) ?

 

I put my .jar drivers in a lot of folders (at least in the "db_drivers" and the "lib" folders) but i can't see any new entry in the datasoure dialog, this is where i see my problem.

 

 

 

 

By: Dan Watling - dwatling

RE: Can't register new jdbc drivers

2004-04-13 11:29

I haven't tried adding the JDBC drivers to the db_drivers folder, but I did modify the build.xml to include my JDBC drivers in another directory. It worked perfectly. If you haven't figured it out already, try modifying the 'iReport' and 'start_jar' targets to include your jar files.

 

Example:

 

<target name="iReport" depends="compile">

<java classname="it.businesslogic.ireport.gui.MainFrame" fork="true">

<sysproperty key="ireport.home" value="."/>

<classpath>

...

<fileset dir="YOUR_DIR_HERE">

<include name="*.jar"/>

</fileset>

</classpath>

</java>

</target>

 

...

 

<target name="start_jar">

<java classname="it.businesslogic.ireport.gui.MainFrame" fork="true">

<classpath>

<fileset dir="YOUR_DIR_HERE">

<include name="*.jar"/>

</fileset>

</classpath>

</java>

</target>

 

-Dan Watling

 

 

 

 

By: Luciano Zanin - cianoz

RE: Can't register new jdbc drivers

2004-04-14 02:09

I checked my build.xml file but honestly it looks to be OK (in my opinion, of course), because the variables are set correctly related to the paths and the file types to include, so i should not to have any need to add a user-defined path.

 

Maybe i'm the only ireport user that is not able to add a new driver :-(

I'll wait until a new inexperienced user like me will have my same problems...

 

Thank you for your interesting, Dan.

 

 

 

 

By: Dan Watling - dwatling

RE: Can't register new jdbc drivers

2004-04-14 10:58

After looking more closely at the build.xml, I believe I have discovered why it isn't working the way it should be. At the start of the file there are two lines:

 

<property name="lib" value="${basedir}/lib"/>

<property name="lib" value="${basedir}/db_drivers"/>

 

The second line would be ignored since 'lib' has already been set by ant. This causes iReport to not even check the db_drivers directory. A simple solution would be to rename the second 'lib' to 'db_drivers' and then include 'db_drivers' in addition to 'lib' in the 'start_jar' and the 'iReport' targets.

 

There may be an even simpler solution if ant has the ability to allow 'lib' to point to both directories at once.

 

-Dan

 

 

 

 

By: Marcelo - marcelocda

RE: Can't register new jdbc drivers

2004-04-27 07:05

Guys, I have the same problem.

When I copy the firebird driver, called "firebirdsql-full.jar" into the db_drivers directory, the IReport doesn't detect the driver. Even when I modify the XML file it doesn't works :(

Here's my XML file after the modification:

<property name="db_drivers" value="${basedir}/db_drivers"/>

<property name="lib" value="${basedir}/lib"/>

...

<target name="iReport" depends="compile">

...

<fileset dir="${db_drivers}">

<include name="**/*.jar"/>

</fileset>

<fileset dir="${lib}">

<include name="**/*.jar"/>

<include name="**/*.zip"/>

</fileset>

...

<target name="start_jar">

...

<fileset dir="${db_drivers}">

<include name="**/*.jar"/>

</fileset>

<fileset dir="${lib}">

<include name="**/*.jar"/>

</fileset>

 

These are only fragments of the file, of course.

 

Thanks in advance!

Marcelo.