Where is the schema of the database ?

[GoogleCodeExporter]

What steps will reproduce the problem?
1. I deploy the war after settings

What is the expected output? What do you see instead?
[[6~2009-12-14 15:50:08,548 ERROR
[org.hibernate.tool.hbm2ddl.SchemaUpdate:134] - could not get database metadata
org.h2.jdbc.JdbcSQLException: Column NAME not found; SQL statement:

What version of the product are you using? On what operating system?
1.2.0

Please provide any additional information below.
Where is the schema of the database ?
I use H2 database

Original issue reported on code.google.com by sebastie...@gmail.com on 14 Dec 2009 at 3:03

[GoogleCodeExporter]

OK it works with derby but not with H2 database !

Original comment by sebastie...@gmail.com on 14 Dec 2009 at 3:34

[GoogleCodeExporter]

Sebasian, 

I am trying to get this working with mysql. I can talk to mysql, but I get the 
same
error! Does jos setup its own tables? Any chance you could post the table
descriptions? I am trying to reverse engineer them from the hibernate XML 
files, but,
there isn't quite enough info.

Original comment by thec...@gmail.com on 15 Dec 2009 at 4:15

[GoogleCodeExporter]

Effectively jos setup its own tables.
If you want the tables descriptions, I advise you to use derby first:
jdbc.driverClassName=org.apache.derby.jdbc.EmbeddedDriver
jdbc.url=jdbc:derby:jos;create=true
jdbc.username=user
jdbc.password=password
jdbc.validationQuery=select from 1
hibernate.dialect=org.hibernate.dialect.DerbyDialect
hibernate.show_sql=false
hibernate.hbm2ddl.auto=update

When the war is deployed, the tables are created.
Then you can take the table descriptions if you want.

Original comment by sebastie...@gmail.com on 16 Dec 2009 at 9:13

[GoogleCodeExporter]

Interesting, I will check it out.

Original comment by thec...@gmail.com on 17 Dec 2009 at 4:17

[GoogleCodeExporter]

This question has been documented in the FAQ.

Original comment by zhoushu...@gmail.com on 21 Apr 2010 at 2:55

• Changed state: WontFix