Mar 13th, 2012, 10:38 AM
Schema PUBLIC, and tables, not found during Roo reverse engineering
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.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
Mar 15th, 2012, 03:13 PM
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.
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.
Last edited by jbustamovej; Mar 15th, 2012 at 03:35 PM.