javadb and ireport

Hi

I am trying to set up a connection to the javadb database. I have created the database via the netbeans IDE and have a simple table. The table is located in C:\javadb\database.

My iReport connection settings are:

JDBC Driver - org.apache.derby.jdbc.EmbeddedDriver

JDBC URL - jdbc:derby://localhost:1527/contact_database

I have added derby.jar to the iReport classpath.

I have also copied derby.jar to my ireport library.

However when I test the connection I receive the following message:

General problem: null

Please check username and password.

The DBMS is running?!

My username and password are correct and I have started the database server from netbeans

Does anyone have any ideas?

Thanks GB

Message was edited by:

greenockboy

[846 byte] By [greenockboya] at [2007-11-27 11:39:31]
# 1

Hi

I discovered the cause of the problem.

It is down to the my JDBC URL setting.

The format for this should be:

jdbc:derby:C:/javadb/database/contact_database

Hope this helps someone in the future.

Regards

George

greenockboya at 2007-7-29 17:26:41 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...