HSQLDB usage: Table not found in statement

[2005 IR Help]

By: Karsten Voigt - karschten

HSQLDB usage: Table not found in statement

2005-08-02 09:37

Hello,

 

I try to use iReport 0.5.0 together with HSQLDB 1.8.0. I have a database with several tables and I can connect and use this table from my application and from the DBVisualizer.

Now I've created a new database connection in iReport (and tested that connection). Everything seems to be ok. Now I've called the iReport Wizard and entered a query string: SELECT * FROM SPEN (where SPEN is the table name). Saying next, password dialog appears and now clicking ok (without pw) I get an exception:

 

Table not found in statement [sELECT * FROM SPEN]

 

Again for my application and the DBVisualizer its possible to use that statement and all tools are using the same hsqldb.jar.

 

Has anyone any suggestions how to solve the problem?

 

Thanks

Karsten

 

 

 

 

By: John Zoetebier - johnzoet

RE: HSQLDB usage: Table not found in statement

2005-08-02 14:45

I had a similar experience and discovered that the JDBC connection test of iReports is unreliable.

It shows success while running the report with a JDBC conneciton fails.

The solution I found was to put all JDBC information in the database URL, do not use any other field. Thereafter it worked.