Connecting to Derby database

[corecat77]

I'm completely new to iReport, so my question may have already been asked and answered.  I'm attempting to connect to a Derby database for my report, and I'm experiencing problems.

When I try to connect to the datasource, using the Database JDBC connection type, I can't find the derby driver.  I've added the driver to the CLASSPATH in Tools > Options, but it doesn't seem to get added to the type list.

Am I doing something wrong, or is it that iReport just doesn't handle the Derby database?

Thanks in advanced

[pwd]

Be sure you have the correct connection string.

Does this help:

http://forums.sun.com/thread.jspa?threadID=5198771

?

[corecat77]

The problem is that I can't get that far. I don't have the option to even select the derby.jar from the JDBC Connection screen. The drop down for the JDBC driver doesn't show the Derby driver that I've added.

[pwd]

Try manually typing in the Driver name and the JDBC URL. I recall having to do this for a customer driver.

[abyss888]

i also have this problem, so a temporary solution for me is by adding both drivers (client & embedded) in the 'service' section, and creating a new "Netbeans database JDBC connection" instead as my report's datasource

[corecat77]

pwd,

Thanks for this tip. Manually entering the driver worked perfectly. I got so caught up on the fact that the driver wasn't listed in the drop down that I never thought to manually enter it.

[corecat77]

abyss888,

I wasn't able to find the 'service' section you spoke of, but the post from pwd worked perfectly for me. I'd suggest trying it if you are still experiencing the problem.

[abyss888]

'services' can be accessed from the menubar 'window' -> 'services' or ctrl+5

btw i typed the url manually as pwd suggested and it works, thanks a lot :)

[atharindhi]

Hi

Im facing to same kind of problem.
but itz not with i-report but eclipse
If u'll interested plz help me.

 

Using eclipse im designing a web base application. for this im using derby server  to do the DB part.

But i cant add Derby Nature to my project. when i click Add Apache Derby Nature (http://db.apache.org/derby/integrate/plugin_help/nature.html#Adding+the+Derby+nature+to+a+Java+project)

it says "the choose operation is not currently available"

Whats the issue here..?

I add eclipse derby plug ins (derby_core_plugin_10.6.1.zip and derby_ui_doc_plugin_1.1.2.zip) to my eclipse plug ins.

i Set the class paths in environment variable derby.jar , derbytools.jar and all the required .jar mention in Apache site.Im using eclipse Version: 3.3.2

What is this problem

Plz help

Post Edited by atharindhi at 08/06/2010 10:54

[corrado49]

I am having this same issue: I am copying and pasting the Driver and URL from Openbravo Pos Config and it shows me an error. Please help.