Java.sql.SQLException: Schema 'ROOT' does not exist?

After removing the import. Sql file from classpath and running the application, I found that the error was that the databse is created, but the tables was not created by hbm2ddl due to the issue issues.apache.org/jira/browse/DERBY-789 stated here: constraint problems using apache derby and hbm2ddl.

After removing the import. Sql file from classpath and running the application, I found that the error was that the databse is created, but the tables was not created by hbm2ddl due to the issue issues.apache.org/jira/browse/DERBY-789 stated here: constraint problems using apache derby and hbm2ddl that the primary key cannot be defined as unique, since that is handled by the database itself. So when I removed the unique attribute from the primary key, the error is gone.

Sorry, never used Derby myself, but I think the problem is that bernate cannot create any databases, database users or database schemas for you. This is just a guess, but to me the error message indicates that you also need a database schema for the user. Try to create the database, the database user root and a schema root beforehand, then connect with bernate to create the tables.

Create=true should take care of that – oers Dec 23 '11 at 13:11 @oers: Thanks, didn't see that. But I am quite sure hibernate cannot create a schema, and it looks like the schema for the user is missing. So, I would try with create=false and create the database and schema beforehand.

– tscho Dec 23 '11 at 13:21 @tscho, I updated the post, please advise. – Msaleh Dec 23 '11 at 19:53.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.