Schema PUBLIC, and tables, not found during Roo reverse engineering

[nikki_sixx]

Hello. I am new to Spring Roo, and I have STS 2.9.0 installed. I am trying to reverse engineer a Hypersonic database, but I am having an issue where it says that schema PUBLIC is not found. I did the following steps through the shell in the STS:

addon install bundle --bundleSymbolicName org.springframework.roo.wrapping.hsqldb
database reverse engineer --schema PUBLIC --package ~.domain

and I get:

Schema(s) 'PUBLIC' do not exist or does not have any tables. Note that the schema names of some databases are case-sensitive

I tried with lowercase 'public', and got the same message.. When I run "database properties list" through the shell, I get:

database.driverClassName = org.hsqldb.jdbcDriver
database.password =
database.url = jdbc:hsqldb:mem:crm
database.username = sa

Now, I had also downloaded and installed HSQLDB externally on my machine, created my tables through runManager, but I am not sure why the tables are not found, as I see them in runManager after creation. Is there some internal hsqldb database that STS is referencing? How would I be able to determine which one Roo is using?

Thanks so much for your time.

ps - I am following the steps in the O'Reilly book "Getting Started With Roo" on Pg 15. - Thanks again

[jbustamovej]

Have you tried using crm as your schema name instead of PUBLIC or public?

I have a similar issue. I'm trying database introspect --schema schemaname, where schemaname is the last part of the database.url, i.e. database.url = jdbc:hsqldb:mem:schemaname. The error I get is

Schema(s) 'schemaname' do not exist or does not have any tables. Note that the schema names of some databases are case-sensitive

Does database introspect --schema schemaname not work in hsqldb in in-memory mode? I know that the schema is being created and objects are being persisted there because I can see them through the roo scaffolded GUI.

I also tried changing the url to file mode, i.e.

database.url=jdbc\:hsqldb\:file\:/Users/first.last/dev/workspace/schemaname/target/hsqldb/schemaname

Now I get a different error:

Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@19fd947c[file =C:\Users\first.last\dev\workspace\schemaname\targ et\hsqldb\schemaname.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2012-03-15 20:32:02 heartbeat - read: -5540 ms.