Re: HSQLDB not properly recognizing Primary Key from JPA Annotations
Fred Toussi <[email protected]>
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Message-ID | <1407528115.2260678.150703817.395F46F2@webmail.messagingengine.com> |
Certainly. You just execute all the CREATE TABLE and related statements via JDBC. This can be done even when Hibernate is used. Fred On Fri, Aug 8, 2014, at 19:16, Chris Pratt wrote: Fred, Is there a way to user define the schema with in-memory HSQLDB? (*Chris*) On Fri, Aug 8, 2014 at 1:03 AM, Fred Toussi <[1][email protected]> wrote: This has nothing to do with HSQLDB. The primary key for a table is always user-defined. In this case it is the JPA (Hibernate) that sends a statement such as CREATE TABLE X(Y INTEGER PRIMARY KEY, ..) to the database engine. Hibernate would create primary keys the same way with Oracle and HSQLDB. As someone commented on your question, the most likely cause is your Oracle schema is user-defined but you are relying on Hibernate to generate the primary key in your tests. Fred On Fri, Aug 8, 2014, at 00:04, Chris Pratt wrote: I just asked this question over on Stack Overflow. Does anyone here know the answer? [2]http://stackoverflow.com/questions/25193560/hsqldb-not-prope rly-recognizing-primary-key-from-jpa-annotations Thanks. (*Chris*) --------------------------------------------------------------- --------------- Infragistics Professional Build stunning WinForms apps today! Reboot your WinForms applications with our WinForms controls. Build a bridge from your legacy apps to the future. [3]http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/ 4140/ostg.clktrk _______________________________________________ Hsqldb-user mailing list [4][email protected] [5]https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------ ------------------ Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. [6]http://p.sf.net/sfu/bds _______________________________________________ Hsqldb-user mailing list [7][email protected] [8]https://lists.sourceforge.net/lists/listinfo/hsqldb-user --------------------------------------------------------------- --------------- Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. [9]http://p.sf.net/sfu/bds _______________________________________________ Hsqldb-user mailing list [10][email protected] [11]https://lists.sourceforge.net/lists/listinfo/hsqldb-user References 1. mailto:[email protected] 2. http://stackoverflow.com/questions/25193560/hsqldb-not-properly-recognizing-primary-key-from-jpa-annotations 3. http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk 4. mailto:[email protected] 5. https://lists.sourceforge.net/lists/listinfo/hsqldb-user 6. http://p.sf.net/sfu/bds 7. mailto:[email protected] 8. https://lists.sourceforge.net/lists/listinfo/hsqldb-user 9. http://p.sf.net/sfu/bds 10. mailto:[email protected] 11. https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------------ Want fast and easy access to all the code in your enterprise? Index and search up to 200,000 lines of code with a free copy of Black Duck Code Sight - the same software that powers the world's largest code search on Ohloh, the Black Duck Open Hub! Try it now. http://p.sf.net/sfu/bds _______________________________________________ Hsqldb-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hsqldb-user