Hi,
I have successfully generated scaffold for my MYSQL db, while running its
connecting it to HSQLDB, here is the log details.
how do i just point to mySQL
Caused by: java.sql.SQLException: invalid schema name: TEST in statement
[select xxxxxx from test.abc_admins xxxxxx _]
at org.*hsqldb*.jdbc.Util.throwError(Unknown Source) [:6.0.0.Final]
at org.*hsqldb*.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
[:6.0.0.Final]
at org.*hsqldb*.jdbc.jdbcConnection.prepareStatement(Unknown Source)
[:6.0.0.Final]
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:467)
[:6.0.0.Final]
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:455)
[:6.0.0.Final]
at
org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:253)
[:6.0.0.Final]
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
[:3.6.0.Final]
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
[:3.6.0.Final]
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
[:3.6.0.Final]
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
[:3.6.0.Final]
at org.hibernate.loader.Loader.doQuery(Loader.java:801) [:3.6.0.Final]
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
[:3.6.0.Final]
at org.hibernate.loader.Loader.doList(Loader.java:2533) [:3.6.0.Final]
... 188 more
thanks in advance