Jump to content
Changes to the Jaspersoft community edition download ×

HSQLDB usage: Table not found in statement


2005 IR Help

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...