work « Schema « JPA Q&A





1. SchemaUpdate uses like '%' which wont work with hsqldb    forum.hibernate.org

Hello ! In Hsqldb the tables do have schema null, now the SchemaUpdate uses a query like select * from system_tables where table_schem like '%' which do not return a row. Now i am searching where to place the error: 1) should "table_schem like '%'" match to rows with null or 2) should the query changed to something like this select ...

2. hibernate.default_schema set to dbo does not work    forum.hibernate.org

I have a problem with the Hibernate config XML. I specify for the schema to default to dbo with dbo It works fine when reading the tables but if the table does not exist, when Hibernate Creates the table, it always creates the table under the owner I log in with. ie. --Hibernate config -- xxUserName xxPassword

3. SchemaUpdate not working with Hqsldb but it used to..?!?    forum.hibernate.org

Hi, We're using the schemaupdate tool with latest hibernate release and HsqlDB java database. I added a new mapping file a very simple table. The tool claims that it's adding the new mapping but I don't see it in the database. Are there nay tools, flags or methods to further debug this problem. I saw the caveat about using SchemaUpdate from ...

4. HsqlDB 1.8+ and Hibernate3 SchemaExport not working    forum.hibernate.org

Hi, I upgraded my code to use Hibernate3 and hsqlDB-1.8.0.2 and it seems the SchemaExport doesn't work anymore. After running the task I don't see my .script database file. I see a log file with ethe contents: CREATE USER SA PASSWORD "" ADMIN and that's all Has anyone else been able to get these versions working? Thanks, Jason

6. schema not working in sql-query tag    forum.hibernate.org

If it's a truly global schema, that all your tables, stps, etc. are in, then that's specified by your user's login. If you've got two tables, dbo.Test and jdbc.Test, then "select * from Test" will return the contents of dbo.Test for all users except jdbc. jdbc would get the results from jdbc.Test (which is a completely different table). I fell into ...

7. annotations onetomany jointable schemaexport not working    forum.hibernate.org

Newbie Joined: Sat Nov 20, 2004 2:26 pm Posts: 5 Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version: Hibernate core 3.1.2 Hibernate Annotations 3.1b8 Mapping documents: (in annotations) Code between sessionFactory.openSession() and session.close(): HibernateUtil.beginTransaction(); s.createQuery("delete from User").executeUpdate(); log.info("deleted users"); HibernateUtil.commitTransaction(); Full stack trace of any exception that occurs: org.hibernate.exception.ConstraintViolationException: could not execute update query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69) at ...

8. Schema-export doesn't work    forum.hibernate.org

Newbie Joined: Thu Nov 23, 2006 1:46 am Posts: 8 Location: Brussels Hi all i'm new to hibernate, i'm trying to do some example witch i found a book but i have some problem: but first here are some details Hibernate version:3.2.0 Hibernate Location:H:\Java\hibernate-3.2 MySQL Driver location:H:\Java\dr Build4.xml Location:H:\Java\Projects\workspace\calendar\work Name and version of the database you are using:mysql 5.0 The generated ...

9. Working with existing schemas    forum.hibernate.org

Hi, I am new to Hibernate. My existing hibernate code creates a schema with the help of mapping file in the underlying database and performs all database operations, but my requirement is my code should work with existing schemas also. For example, assume that my code creates an Emp table to store all employees details in that table. Suppose, if some ...





10. How to work with tables with same table schema?    forum.hibernate.org

I have two tables, orders and orders_history with same table schema. Therefore, how should I create the value objects and hibernate mapping files for them actually? As far as I understand, I should have to create TWO separate Java VO (with same fields on java class), e.g. order and orderHistory with hibernate mapping files like: ...

11. hsql schema export not working?    forum.hibernate.org

hey, i have some problems with setting up hibernate, maily this one: ive created a hibernate.cfg.xml for my project which looks like this Quote: create-drop thread org.hsqldb.jdbcDriver jdbc:hsqldb:file:ticketLineDatabase ...