table 1 « Table « JPA Q&A





1. How to convert slightly different tables?    stackoverflow.com

Is there a way to convert table entries from an old table to a new one using the same entity class? To be specfic, here are my entity class' annotations for the ...

2. JPA (Hibernate) and custom table prefixes    stackoverflow.com

Is it possible to override table names in JPA/Hibernate in order to add a common prefix for all project entities? For instance to be able to prefix all JBPM 5 tables ...

3. JPA I:N and 1:1 using Junction table    stackoverflow.com

JPA Question: I am trying to model 1:N (Person & Address) relationship using a junction table (Person_Address).

  1. Person (personId PK)
  2. Address (addressId PK)
  3. PersonAddress ( personId, addressId composite PK, personId FK references Person, addressid FK references ...

4. How to implement history table with pure JPA?    stackoverflow.com

I need to keep change of one "entity_name" into another log table called "entity_name_history" without using any JPA provider (I have to change existing project which doesn't use one). What I ...

5. trying to connect two tables in hibernate with no luck!    stackoverflow.com

I am trying to fetch data from two different tables with oneToMany relation but the call from server is getting failed

    @Table (name = candidatresumeinfo)
    public ...

6. Creating a new Hibernate table    stackoverflow.com

So I'm still pretty new to Hibernate, and I'm working on a large-ish application that already has a database with several Hibernate tables. I'm working on a new feature, which ...

7. Why my Tables get cleared when i use hibernate?    stackoverflow.com

I have used hibernate along with oracle to create some project... I had many mappings in it.. After mapping when i execute the program then it works Nicely but whn i ...

8. Joint tables in jpa    stackoverflow.com

I have this query to execute with JPA but it doesn't want to work... However if I try to do it directly on the database query exectuor it works fine. Where's ...

9. JPA & Relational Tables    forums.netbeans.org

Hi All, could someone point me in the rught direction please. I am fairly new to Netbeans and getting to grips with the correct process of carrying out tasks. I have created a small app with various tabbed panes where I have dragged tables from my database. All this works fine and I have now moved on to related tables. I ...





10. How to not reinialize tables created with JPA?    coderanch.com

This example seems to work: http://javahowto.blogspot.com/2006/07/helloworld-with-jpa-toplink-and-mysql.html However, when I comment out the statements that create and delete the objects (as I have done below), I expect to see it display the same greetings and messages. Instead, no messages are being retrieved. Apparently something is recreating the database tables every time I run the program. What do change so I can run ...

12. Hibernate and JPA - Creating Table    coderanch.com

Programatically, you can use the SchemaExport class to recreate a database. It drops everything though, and recreates a blank database. public static void main(String args[]) { AnnotationConfiguration config = new AnnotationConfiguration(); config.addAnnotatedClass(User.class); config.configure(); new SchemaExport(config).create(true, true); } Here's a little tutorial on using a simple SchemaExport. I'm not sure if this is going to give you the 'create a database table ...

13. Hibernate calling "analyze table"    forum.hibernate.org

Hi all, I'm not sure which change in my project (or database) caused this, but for a while now, Hibernate calls an "analyze table xxx estimate statistics" everytime I run my tests for some tables. I have 2 database users available and this happens only for one of them, so I figure there is a difference in the database. But still, ...

14. Unsuccessful: create table    forum.hibernate.org

Newbie Joined: Sat Oct 03, 2009 10:59 pm Posts: 7 dear friends, i've built a project based on MyEclipse, which have been integrated with struts and hibernate. Some error as follow occured when i run the project. Quote: (0 ms) [http-8080-1] ERROR: org.hibernate.tool.hbm2ddl.SchemaUpdate#execute : Unsuccessful: create table tour.base_hotel (id integer not null, typeId_1 integer, totalTime float, totalMoney float, line varchar(255), typeId_2 ...

15. IDENTITY works on one table, not on an identical one    forum.hibernate.org

Newbie Joined: Thu Apr 02, 2009 9:46 pm Posts: 8 I have two identical tables (h2 database). Same schema, same DDL, same all, except for different table names. When I try to map the same entity bean to one of them, it works; to the other - it fails, saying "NULL not allowed for column ID". Here are the two (identical, ...

16. Automatic table creation    forum.hibernate.org

Hi all, I would like to write a bulletin-board application with hibernate. I thought one topic will be one table, and a message in a topic a row (with an id). I've written this entity class: @Entity @Table(name = "TOPIC") public class Topic { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "ID") private Long id; @Column(name = "MESSAGE") private String message; /*constructors, ...





17. volatile table using hibernate    forum.hibernate.org

19. Many to many table    forum.hibernate.org

Hi all, I have a problem and I hope you can help me. I have a table called FAppDescriptor and another which name is FTheme. FTheme contains a list of themes, and FAppDescriptor must have which theme it has, and for it, I have created another table called FDesTheme. The two first tables has been described as always, with it's own ...

20. 3 tables related as composites    forum.hibernate.org

21. @Embeded with different table    forum.hibernate.org

Hi , I have an Embeddable (class Name) class and and an Entity which embed the same(class Person). Assume there is a one to one mapping between them. I have two tables PERSON and NAME. Name table have a person id , which is the foreign key I want to map Person and Name into two separate tables using the annotation. ...

22. creating tables with hibernate    forum.hibernate.org

Hi. My question is - Is it possible to configure hibernate so that it creates a table when I try to save a class which is mapped to non existing table? If it's possible then how? My configuration file looks like this so far: Code:

23. Implementing control table using hibernate    forum.hibernate.org

Hi, I have a control table which has the currently active view and I should be using this view to fetch the data. Could some one please tell, how can I do this in hibernate? I mean, how to configure the view name in my hbm.xml to get the currently active view and load the data from it. TIA..

24. Several one to many tables    forum.hibernate.org

Hi! I have four tables with one to many relations between them. I can save and update data to the first two tables but i can't do it to the rest of the tables. I don't get an errormessage but nothing is added to the tables. I have tried to google about my problem but i can't seem to find an ...

25. Maintaining identical tables    forum.hibernate.org

I need to implement something rather strange. My application creates internal application sessions for interacting with the client. Session is basically a db record with a unique ID. The session needs to be stored forever, even after the client had disconnected. The problem is that ACTIVE sessions need to be checked very often, while FINISHED sessions are used only by reporting. ...

26. Compare table A to table B using hibernate ?    forum.hibernate.org

27. Create a table in Junit    forum.hibernate.org

Hi Guys, i'm new to Hibernate (both forum and technology). I search for these terms and in doc but was unable to find how to do this : I have set my Hibernate configuration, *.hbm.xml file and Junit test on these files. My tests run ok. I use setUp and tearDown to insert and remove data from my database Test. But ...

28. Tables get created, but do not get populated    forum.hibernate.org

Author Message Shitij Post subject: Tables get created, but do not get populated Posted: Tue Jun 22, 2010 7:13 am Newbie Joined: Tue Jun 22, 2010 5:16 am Posts: 2 First off, I am quite new to Hibernate and have not read hibernate much. I am following a tutorial from the internet and am trying to see if the ...

29. How can i create table in hibernate?    forum.hibernate.org

30. Matrix to table    forum.hibernate.org

31. Skip table creation for some VO    forum.hibernate.org

I got BIG problem with my system. My system got many VOes (Value Object - Hibernate annotated classes) as complex solution for some customers but one of them want basic funcionality. Is there any chance to use some maven profile and other special annotation to show which table should be created/updated and which should NOT when schema creation/update flag in hibernate ...

32. Hibernate clears my tables when the application is started    forum.hibernate.org

My objects are stored in the database correctly, however, when I restart the application, all tables in my database (mysql) are always cleared. During runtime I can see that the database if filled correctly. When I quit the application, the database still contains all objects. After I restart however, I see that all tables are cleared from the database. At that ...

33. Hibernate clears my tables when the application is started    forum.hibernate.org

My objects are stored in the database correctly, however, when I restart the application, all tables in my database (mysql) are always cleared. During runtime I can see that the database if filled correctly. When I quit the application, the database still contains all objects. After I restart however, I see that all tables are cleared from the database. At that ...

34. Is there an elegant way to handle linking tables    forum.hibernate.org

There may already be an answer for this on the forum somewhere because it is a common problem, but apparently I don't know what the right search terms for it would be to find it, so here it goes: I have a product table, category table, and a product_category table that links the two. What is the best way to pass ...

35. SEVERE: an assertion failure occured Table not found    forum.hibernate.org

My mapping seems to be causing the following error: Code: SEVERE: an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session) org.hibernate.AssertionFailure: Table SUBCATEGORY not found at org.hibernate.persister.entity.JoinedSubclassEntityPersister.getTableId(JoinedSubclassEntityPersister.java:458) at org.hibernate.persister.entity.JoinedSubclassEntityPersister.(JoinedSubclassEntityPersister.java:237) ...

36. Three Tables and Restrictions    forum.hibernate.org

Hello guys, I am trying to create a simple request over three tables, using criteria an restrictions. Or, otherwise, accessing an object which is in a list of objects which is part of an object :) Description: There is an object "Message" containing a list of "Recipients". Now I want to check if a certain message, belonging to a single recipient ...

37. Table valued parameters swl server 2008    forum.hibernate.org

Hello, i have no idea how to use TVPs in hibernate. My basic goal is to use an array of data as an input for a procedure. Sqlserver 2008 supports table valued parameters (TVPs) to implement these requirements. Does anyone have experiences or an idea how to do this with hibernate ? thanks for reply

38. How to print Create table script using hibernate?    forum.hibernate.org

com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc:sqlserver://192.168.1.214:1533 DEV_RFG_ANALYTIX4 DEV_RFG_ANALYTIX4 10 true org.hibernate.dialect.SQLServerDialect ...

39. Strange behaviour in table creation    forum.hibernate.org

public String getSqlType(Dialect dialect, Mapping mapping) throws HibernateException { if(sqlType == null || sqlType.equals("varchar")) { return dialect.getTypeName( getSqlTypeCode(mapping), getLength(), getPrecision(), getScale() ) ; } else { ...

40. Driscriminator on same table    forum.hibernate.org

I have a mapping of where I have a base table (Tasks) and then an extending table (CRS) but the CRS table actually have date for three different objects. Some of the fields are in common and some are unique. Ignoring the inheritance of the common fields to keep this simple, I have join statements in my three extending classes such ...

41. Adding Two Tables With Single Table    forum.hibernate.org

Hi Friends, I am in need where I have to add two tables with a single table. Suppose there are two entities Customer and Order. I have two separate tables for them. I have another table that has customerId and OrderId. Please help me in doing the mapping. Please help me regarding the same.I need mapping files and not the annotations ...

42. Add an extra colum on a intermediate table    forum.hibernate.org

Hello, I have seen a lot of threads very similar to this one, bur neither of them could help me :s I have two entities: triple and concept. A triple will contain 3 concepts, one of them object, subject or predicate. Modeling in java: Triple.java Code: @Entity @Table(name = "triple") ...

43. Hibernate is not creating my table    forum.hibernate.org

44. Hibernate Inaccurate Table.foreignKeys    forum.hibernate.org

45. Hibernate doesn't create table to InnoDB    forum.hibernate.org

Hi, first sorry for my english. I'm having a trouble using hbm2ddl.auto, it doesn't create tables using InnoDB. I'm using MySQL5InnoDBDialect. I'm Using Mysql 5.0.77 and Hibernate 3.6.5.FINAL here is my applicationContext.xml Code: ...

46. ColumnTransformer causes table scans    forum.hibernate.org

47. Hibernate console dont return any table    forum.hibernate.org

Hello, recently y introduced with the Jboss tools for hibernate, in this moment i require a reverse engineer for a Oracle 10g express database, but when i configure the console for this database does not trhow me a any table from the db schema... i dont now , what happend with this DB becasue when i tested with a MySQL db ...

48. Hibernate Stored Prodedure (Temp Table)    forum.hibernate.org

Hello every one!! I am new to Hibernate and i need the following: i have created a stored procedure that through multi innerjoins creates a temp table which returns 23 values (Field 1 -.. Field23). i have followed the previous example shown here: https://forum.hibernate.org/viewtopic.php?p=2248512 but i still have trouble with the mapping. Since there is no real table (reportE6) in the ...

49. Dynamtic Table creation Using Hibernate    forum.hibernate.org

Thank's for reading my Post. I am new to hibernate.all i need some clarification and explaination. Problem 1: How to create seperate table for all users they sign up for my web app. i need to create 2 table's 1.User Details - Store user mail address,username,password,etc. 2.Media - Allow user to store Mp3 Files.[I have File Id[int],Mp3[LONG BLOB],Tag [Varchar]] According to ...

51. Tables recreated on each new openSession()    forum.hibernate.org

I was just getting in to things when I noticed that every time I added data to my DB it would drop and recreate all the tables first. I'm starting out simple, all persisted classes are created by hbm2java and SchemaExport creates the schema. I have then written a couple of simple utils that load the DB with some data from ...

52. create table by hibernate?    forum.hibernate.org

53. Table Querys    forum.hibernate.org

Hi, I'm trying to make a query on a simple MySQL database but i'm having some problems. I try this two commands: 1) List result = session.find ("from TestObject where name='joao'"); 2) List result = session.find ("from TestObject as obj where obj.name='A'"); The first command works fine, but in the second command, which should be equal, i got the following error: ...

54. Libraries and Tables in AS400    forum.hibernate.org

Hi, I have some questions about hibernate. First of all, my company has a as400 with database db2. The database isn't relational database. Then, it's good idea work with hibernate? This database has libraries and inside this libraries has tables. LIBRARY | |---Table1 |---Table2 When I do a query with sql with ODBC or JDBC the syntax is "SELECT * FROM ...

55. one-to-one on one big table    forum.hibernate.org

I have a big table "account" that several other tables also link to, so I want to split the mapping into 2 objects, one for the fields in the table (AccountDetail), and another one (Account) for managing the relationships with other objects/tables. I want to implement this as one-to-one, but had problems with the following approaches: 1. use Mapping, account.getAccountDetail(): got ...

56. Bidirecional N-N shared table    forum.hibernate.org

Hi, I have a bidirecional many-to-many relation between classes A and B. A uses an association table AtoB and B uses an association table BtoA. I am using lists in both sides. My ideia was to use AtoB and BtoA on the same table, creating a single four filed association table with the following fields: 1 - keyA 2 - keyB ...

57. How to use "many-to-one" to a table with discrimin    forum.hibernate.org

Hi all, in our project we use Hibernate 2.1 to map our fine grained, strong typed object model to a relational database (Oracle). We have a variety of code/description classes mapped onto a single database table, each of them being a subclass of a CodeModel class distinguished by a discriminator. This works fine for reading the individual code/description classes, but to ...

58. SEVERE: Table not found    forum.hibernate.org

I have followed the instruction of the demo application in http://www.onjava.com/pub/a/onjava/2004/01/14/hibernate.html?page=1 using HSQL My properties file is: Code: hibernate.connection.username=sa hibernate.connection.password= hibernate.connection.url=[b]jdbc:hsqldb:D:\db\order[/b] hibernate.connection.driver_class=org.hsqldb.jdbcDriver hibernate.dialect=net.sf.hibernate.dialect.HSQLDialect I can access my database and tables using both HSQL Database Manager and Data Studio, my hbm XML for this matter is Code:

59. Application with four hundred tables    forum.hibernate.org

60. how to handle large table in Hibernate?    forum.hibernate.org

61. Using a backup table for historization    forum.hibernate.org

Hi, have two tables one is called Mitgliedr and one is MitgliedHistory that has an additional version counter. When I try to save a member instance I'ld like to have a copy with a version counter in the mitglied_history table. I always receive an exception saying: HibernateException: identifier of an instance of de.guug.mv.data.MitgliedHistory altered from de.guug.mv.data.MitgliedHistory@1d686c1 to de.guug.mv.data.MitgliedHistory@1d686c1 My code is: ...

62. Flattening a table    forum.hibernate.org

I want to have a 'Customer' class that has a 'getCountryName()' property. Basically, I have a 'Customer' table, a 'Country' table, and I can get the country name doing customer.getCountry().getName(), but I want to be able to write the following query: "from Customer c where c.countryname = 'USA'" so I need to map the country.Name field to customer.countryName in the mapping ...

63. Efficient way to process a large table    forum.hibernate.org

Hi guys, I need to iterate over the records of a large table (a couple mil records) and I'm trying to figure out an efficient way to do it in hibernate. 1. using query.list() brings everything in memory (not scalable) 2. using query.iterate() or query.scroll() performs N + 1 queries (inefficient) I was looking for some functionality similar to navigating a ...

64. Three tables in a one-to-one chain valid?    forum.hibernate.org

I have three tables: parent, child, grandchild. The Parent has a 1to1 to Child. The Child has a 1to1 to Grandchild. So all three tables share the same primary key using Identity generation on the Parent and foreign generation on Child and Grandchild. Is this configuration possible within hibernate. I know it seems silly, but this structure makes sense for the ...

65. Hibernate not creating table    forum.hibernate.org

Newbie Joined: Wed Aug 11, 2004 11:41 am Posts: 14 I am a first-time user of Hibernate. Hibernate appears not to be creating the database table for my class. The class is firsthib.SalesPerson. I'm sure I'm doing something wrong but I can't figure it out. I assume that Hibernate should create the database tables the first time I use them. It ...

66. Persistance to Dyanamic Tables    forum.hibernate.org

I have a database schema that looks something like this: Documents doc_id filecabinet_id FileCabinet filecabinet_id table_name num_fields Example of file cabinet implementations SchoolWork fc_id doc_id attribute fields... ... attribute fields So. I can build the classes for the Documents and FileCabinet tables, but the other tables -- such as SchoolWork do not have a defined schema. The only thing they have ...

67. AutoCreate table MBean    forum.hibernate.org

68. 2 many-to-one to the same table    forum.hibernate.org

Hibernate version:2.1.6 Hi; This is my first question to this forum, since I had to do allot of reading before bothering people with questions :) I have a strange reaction from hibernate, and I can't get it... I have a class called "Shipment" it contains allot of info., another class called "ServiceAreaCode" that contain cities and so... each Shipment contain 2 ...

69. Best Practice for Non-Keyed tables    forum.hibernate.org

Hello, I am working with a legacy system where a lot of the database tables do not have a single key field. Some have multiple (compisite) keys some do have one at all (we just use SQL to grab what we need). What is the recommendation on these types of tables? I have seen postings here of how it has been ...

70. Only one table is commited, what about the others?    forum.hibernate.org

Author Message marceltoma Post subject: Only one table is commited, what about the others? Posted: Tue Feb 08, 2005 1:28 pm Beginner Joined: Fri Apr 16, 2004 10:25 am Posts: 44 Location: Brazil Hibernate version: 2.1.8 Code ParceirosBO: Code: public boolean inserir(parceiroVO parceiro, empresaVO empresa, Collection colProfiles) { try { ...

71. table-per-hiearchy with interface at root?    forum.hibernate.org

(FYI, I've read all the FAQs, searched the forum, and read the hmtl docs, read the HIA book. I've seen several posts on interface mappings, but all seemed to dead-end with no definitive answer.) - I would like to persist a hiearchy of classes implementing an interface with no shared base class. - I don't want to declare 'getId, getVersion, etc' ...

72. New tables can't be written to    forum.hibernate.org

Hibernate version: 2.0 Name and version of the database you are using: MySQL 4.1 I have an interesting problem that I can't quite figure out. Here is the scenario: 1. I have many existing tables on a MySQL install and they all work great. I can write to them query them, etc, with Hibernate. 2. I go to create a new ...

73. "author" table is created, but not the "post&    forum.hibernate.org

the "author" table is created, but not the "post" table...why is this??? NOTE: One weird thing I noticed is that "datex" (despite being specified in the "post.hbm.xml" mapping file) does not seem to appear in the generated Oracle sql (instead "date date," appears and seems to be the caue of the invalid identifier message)...i.e., Quote: create table post (ID varchar2(255) not ...

75. How to always prefetch a table entirely    forum.hibernate.org

The first time a table (or class) is accessed I want it to be loaded entirely. I do not want that only the requeste rows are loaded. For example suppose a model where I have a single persistent class and a single table. At the first query, I want the table to be loaded, and whatever is queried later, everything is ...

76. please help, cannot create table...    forum.hibernate.org

Read the rules before posting! http://www.hibernate.org/ForumMailingli ... AskForHelp [b]Hibernate version: 3.0[/b] [b]Mapping documents:[/b] [b]Code between sessionFactory.openSession() and session.close():[/b] [b]Full stack trace of any exception that occurs:[/b] [b]Name and version of the database you are using: postgresql 8.0 [/b] [b]The generated SQL (show_sql=true):[/b] [b]Debug level Hibernate log excerpt:[/b] Hi, Am actually trying to create tables in my db from xdoclet tag placed ...

77. OutOfMemoryError on delpoy with 1975 tables    forum.hibernate.org

Hibernate version: 2.1.8 Mapping documents: 1975 tables mapped Full stack trace of any exception that occurs: Code: 09:21:39,182 INFO [Configuration] Mapping resource: mappings/Sqa.hbm.xml 09:21:39,195 INFO [Binder] Mapping class: com.relevant.util.dao.Sqa -> sqa 09:21:41,923 WARN [ServiceController] Problem starting service jboss.jca:service=SessionFactory, ...

78. Many to Many on same table    forum.hibernate.org

Hi, I am having problems doing a many2many mapping on the same table. There is a PRODUCT table and a DEPENDENCY table. The relationship, each product can have other products as its dependents and vice versa. DB looks like: PRODUCT ________ product_id DEPENDENCY ___________ id parent_product_id dependent_product_id ========================= parent_product_id and dependent_product_id are FK to PRODUCT.product_id Gettin errors...details as follows: Please help ...

79. Please help regarding this master-detail tables    forum.hibernate.org

80. many to many table    forum.hibernate.org

Hi All, I have class PROFILE and class FEATURE. I am trying to create a many to many table using xdoclet, however I need another colum in the many to many table type varchar. How can I do so? This is what I wrote in order to have the many to many table. What is missing? @hibernate.bag * table="FEATURE_PROFILE" * cascade="all" ...

81. Read-Only table    forum.hibernate.org

82. When complie ,Hibernate wants to create a new table for me    forum.hibernate.org

[java] Sun Aug 07 13:58:50 CST 2005 TRACE: --> ResultSet.java:4464 com.mysql.jdbc.ResultSet.realClose(false) [java] Sun Aug 07 13:58:50 CST 2005 TRACE: <-- ResultSet.java:4464 com.mysql.jdbc.ResultSet.realClose(..) returning null [java] Sun Aug 07 13:58:50 CST 2005 TRACE: <-- ResultSet.java:7079 com.mysql.jdbc.ResultSet.finalize(..) returning null [java] ERROR - Unsuccessful: create table EVENTS (EVENT_ID bigint not null, EVENT_DATE timestamp, TITLE varchar(255), primary key (EVENT_ID)) Here--> [java] ERROR - Table 'events' ...

84. How operate Temporay table in Hibernate3?    forum.hibernate.org

Good question soldier. Maybe you can dynamitcally create a map on the fly and shove it into Hibernate some how (!) But I too can see me wanting to face this issue in the future, in my situation I can describe the object relation ahead of time with a group of dummy tables but need to just change the name of ...

85. Don't reinitialized table    forum.hibernate.org

Hi everybody, I beginning to use hibernate and i have some question if somebody can help me i am very happy ! :) I have start to create my mapping xml file .hbm described my tables on my database oracle described in hibernate.properties. I starting all described in hibernate.cfg.xml by an classe java who contained : public static void main(String[] args) ...

86. table per heirarchy    forum.hibernate.org

In table-per-hierarchy approach we can have single table in DB as well as single hibernate mapping file containing mapping for each sub-class. Here we need discriminator to differentiate between different sub-classes and while loading or in HQL query we can use Base class.(In this case discriminator is must) The same can be achieved by having separate mapping file per sub class, ...

87. Access to table with a qualifier    forum.hibernate.org

Hi! Platform: DB2/400, Websphere Application Server Scenario: Library for application schema, library for master schema, multiple libraries for detail schema Libraries for detail have the same schema but data is different. Configuration option: Single datasource connecting to all libraries; Objects retrieved with qualifier One datasource connecting to one detail library. Objects retrieved without qualifier, but scalability issues based on how many ...

88. Table named messed when specifying 'catalog=mycat'    forum.hibernate.org

So, this is about a problem I solved by trial and error, but I need to understand what happened. The symptom: in the Hibernate generted SQL, there was an error, which resulted in MySQL reporting the table not being found. The background: - used Hibernate Tools to reverse engineer a few sample tables from MySQL test db. - had class mappings ...

89. Customizing table creation    forum.hibernate.org

90. hibernate 3, firebird 1.5 and not supported derived tables    forum.hibernate.org

Newbie Joined: Thu May 05, 2005 5:54 am Posts: 17 Hi have a problem with a "table pre concrete class" inheritance mapping using firebird 1.5 and hibernate 3.0.5. When i select data from tables Hibernate generates a query that does not work with firebird. The query uses the syntax "select * from (select ...) that is not supported on firebird 1.5. ...

91. one-to-many with xref tables    forum.hibernate.org

I am having a terrible time understaning how to make this work. I have a table structure that represents and exam with many questions. Becsuse the qusetions can be created without an exam I have a lookup table between them with examid and questionid to connect questions to an exam. I used the generator from myeclipseide's hibernate support and it created ...

92. one-to-one and tables    forum.hibernate.org

Hi, I need two javabeans with the relationship that one contains another, which is one-to-one relationship. For example, I have two tables: CREATE TABLE PERSONS( PERSON_ID NUMBER(8) NOT NULL, FIRST_NAME VARCHAR2(32) NOT NULL, LAST_NAME VARCHAR2(32) NOT NULL ); CREATE TABLE RESERVATIONS( RESERVATION_ID NUMBER(8) NOT NULL, PERSON_ID NUMBER(8) NOT NULL, REGISTRATION_UTC DATE NOT NULL, COMMENTARY VARCHAR2(200) NULL ); In which: one instance ...

93. using one FORM for two different tables    forum.hibernate.org

I have two tables: TABLE 1: Person (personid, personname) TABLE 2: Person_Address(addressid, personid, address, city, zipcode, country) I have ONE FORM with field personname, address, city, zipcode, country. What I want is, when I submit this form the values from the form should go to their respective tables. Can someone please help me how to do it. And how to write ...

94. How is HILOSEQUENCES table created    forum.hibernate.org

Hello, I just want to ask a very general question: How is HILOSEQUENCES table created? In our current project, we use this table a lot to create primary key for multiple tables in our database, and it seems to exist in the database from the beginning of the project. So my question is: Whether the table is created during Hibernate installation ...

95. When Table is created By Hiberante.    forum.hibernate.org

Hi, When is Table created automatically by Hibernate? What happens when the following property is set? update What is the default value of the above property? This is an urgent requirement. Hiberante is automatically creating Tables. Here is the scenario: I have 2 schemas in the Database schema1 and schema2 , All the tables are created in schema1 and corresponding ...

96. tables not being created    forum.hibernate.org

Newbie Joined: Tue Dec 13, 2005 12:16 pm Posts: 6 Hi, It seems that hibernate is not creating tables. Error is: 11:59:00,168 ERROR JDBCExceptionReporter:72 - Table not found in statement [insert into SCORES (attribute, value, SCORE_ID) values (?, ?, null)] Things were fine before I started using the tag. Thanks for any tips. -- Nick Hibernate version: 3.1 Mapping documents: ...

97. unmapped table    forum.hibernate.org

98. table is always lost    forum.hibernate.org

Hello, Im new to Hibernate and tried the first example from the Hibernate Reference Documentation (EVENT) ...... But always when I start my App I get the information that the table EVENT can not be found. I changed a property in the original hibernate.cfg.xml from hbm2ddl.auto=create to hbm2ddl.auto=update, but still the App makes a new Table always when I start. ...

99. Work arounds for "Too many tables" with deep inher    forum.hibernate.org

Newbie Joined: Thu Mar 30, 2006 6:51 pm Posts: 3 With an application requiring many different (eventually into hundreds of) subclasses, I'm getting the "MySQL can only use 31 table in a join" problem when I try to use the table per subclass strategy. I've tried setting fetch="select" and max_fetch_depth to 0 recommended in various postings with no luck for a ...

100. [Beginner][Table creation] Table configuration    forum.hibernate.org

Hello there, I'm new on Hibernate and am currently investigating the feasibility of moving the persistence layer of our platform from a in-house solution and a Hibernate one. This library is used by many Java multi-threaded modules on our platform and it's bootstrapped upon each module start-up. We used to have EJBs but for performance reasons we've decided to move back ...