Java Programming

Hi All,

I know this is not the right forum to ask the question.
But still posting the question after looking for it over the net for long
and not getting answers.

I am trying Spring as well as trying my hands to DB connection things after a long time.

I have created a sample app.
From my Java code i could connect to the database but i get this error

<code>

Caused by: java.sql.SQLException: Table not found in statement
</code>

But through the thick client the same sql query returns me the correct results.

I have tried setting the schema as PUBLIC and then executing the command.
PUBLIC is the default schema in HSQLDB, but still i am getting the same result.
I think the problem is with the loading.
This are my JDBC properties in the properties file

jdbc.driverClassName=org.hsqldb.jdbcDriver
jdbc.url=jdbc:hsqldb:hsql//localhost/dbname
jdbc.username=sa
jdbc.password=

I created the tables inside the dbname and able to execute the commands in the thick client.Do i need to load the data from the code but wondering why?.

Any help would be hugely appreciated.

Cheers,
Saurav