1. Hibernate Many-to-one relationship not returning value??? forum.hibernate.orgHi, Hibernate version:3.0 mapping document : CertCartons.hbm.xml I am not able to retrieve the values for the many-to-one relationships where i am able to retrieve values for one-to-one relationships.. Please do check my code & .hbm.xml file:- List alReasons = hibSession.createCriteria(CertCartonsDTO.class,"carton") .createAlias("certPallets","cp") //association path with alias .setProjection(Projections.projectionList() .add(Projections.property("carton.ccCartonNo"),"ccCartonNo")// working well .add(Projections.property("cp.cpPalletNo"),"certPallets.cpPalletNo")) // Not working for many-to-one .add(Property.forName("carton.ccCartonNo").eq(new String("CA89374238"))) .setResultTransformer(new AliasToBeanResultTransformer(CertCartonsDTO.class)).list(); System.out.println("The ... |
2. Many to Many Relationship returning an empty set With Sybase forum.hibernate.orgWe are trying to implement Many to Many relationship using Hibernate and Sybase. We have a product database with Category, Item and Category_Item tables. There is a many to many relationship between Category and Item and it is stored in Category_Item table. We are trying to get items for a given category and it returns an empty set. This only happens ... |
3. One to One relationship - isNull semantics forum.hibernate.orgSession session = HibernateUtil.currentSession(); Transaction tx = session.beginTransaction(); Criteria criteria = session.createCriteria(StudentEnquiry.class); criteria.createCriteria("enrollment").add(Expression.isNull("enrollment")); List list = criteria.list(); ... |
4. Trying to create a simple many-to-one relationship forum.hibernate.orgNewbie Joined: Mon Mar 06, 2006 1:17 pm Posts: 4 I'm trying to create a simple many-to-one relationship and am getting the stack trace shown below after my comments. Environment: MyEclipse 4.1.0GA. Hibernate 3.0.5 (ships with MyEclipse) JRE 1.5.0_02 JBoss 4.0.2RC1 MySQL 5.0.18 All is on a development machine running Windows XP SP2. I've conclude the mapping file, the code snippet ... |
5. Trouble with many-to-many relationship forum.hibernate.orgHello, i have trouble with a many to many relationship. I have a table, and a second table with dependencies: First table: +-------+ Users +-------+ userId (PK) userName Second table: +---------------+ UserDependencies +---------------+ callingUserId (FK to userId) calledUserId (FK to userId) I want to indicate realtions between users. Something like that: - user A (calling) has called user B (called) - ... |
6. many-to-many relationship forum.hibernate.orgHibernate version 3.1.3 and backend postgres8.0 I have a many-to-many relation between company and location linked by company_location table I have defined a set on my company.hbm.xml file |
7. many-to-many relationship forum.hibernate.orgHibernate version 3.1.3 and backend postgres8.0 I have a many-to-many relation between company and location linked by company_location table I have defined a set on my company.hbm.xml file |
8. many-to-many not storing the relationship forum.hibernate.orgHi, I'm trying store a Vehicle with a newly created LicensePlate using a many-to-many relationship. Here is the mapping (simplified): Code: |
9. one-to-many relationship throws NullPointer forum.hibernate.orgBeginner Joined: Fri Jun 23, 2006 6:28 am Posts: 22 Hi I have a table "ReportTables" which containst several "ReportFields". "ReportFields" is also a table, which contains two primary keys: a pk called "FIELD_NAME" and one called "REPORT_TABLES_ID". Both together gives a unique tuple. The hibernate mapping looks like this: Table ReportField: Code: |
10. Relationship - M:M ??? forum.hibernate.orgI am deciding upon M:M relationship. I have two tables Investors and MutualFunds. And Below is the relationship. Mandatory Many (Investors Table) : optional Many (MutualFunds Table) When I create the mapping file for these two tables. Shall I go for relationship ? because MutualFunds table has optional record. Any thought? Thanks |
11. Unable to do a get Operation through relationship forum.hibernate.orgNewbie Joined: Thu Aug 03, 2006 1:31 am Posts: 5 Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version:3.1.3 Mapping documents: |
12. Unable to do a get Operation through relationship forum.hibernate.orgNewbie Joined: Thu Aug 03, 2006 1:31 am Posts: 5 Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version:3.1.3 Mapping documents: |
13. one-to-many relationship - need help forum.hibernate.orgNewbie Joined: Tue Aug 22, 2006 5:26 am Posts: 10 Location: Pakistan Need help with Hibernate one-to-many relationship? I have two tables, UserAccount (PK userID, FK businessID) business (PK businessID) businessID is forign key in UserAccount (one business has many users) I m using Eclipse 3.1 and genrate code by reveng file it generated two hbm files (UserAccount.hbm.xml and business.hbm.xml) My ... |
14. one to one relationship forum.hibernate.orgNeed help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp [b]Hibernate version:[/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:[/b] [b]The generated SQL (show_sql=true):[/b] [b]Debug level Hibernate log excerpt:[/b] Problems with Session and transaction handling? Read this: http://hibernate.org/42.html I have been really strugging with some ... |
15. Many-to-many relationship with properties forum.hibernate.orgHibernate version: 3.0 In my current version of my software I have two classes Resource and Activity. The Resource class has a set of Activities and the Activity class has a set of Resources. In hibernate these are set up as many-to-many relationships. In the next version of the software, I want to extend this Resource-Activity relationship to have a strength ... |
16. Restriction on depth of relationships? forum.hibernate.org |
17. Hibernate merge() creating new records for relationships forum.hibernate.orgFor all of my one-to-manys, I annotated them with CascadeType=ALL. I read the document you mentioned and it seems like I'm missing a delete-orphan value, but the CascadeType enumeration does not give me this option (unless it is inherently built into ALL). Is this what's causing an insertion rather than an update? -Larry |
18. Many to many relationships and deletions forum.hibernate.orgI have a many to many relationship that seems to work ok, except when I try and remove a User object. When I remove a User object by calling delete (using the Spring HibernateTemplate object) it removes not only the User but all the groups assigned to that user and all the users assigned to those groups. What I want is ... |
19. about many-to-one relationship doubt forum.hibernate.orgi have another question. if for example, i have 2 class file: reply and message. reply will inherit from message. so how do i do the mapping? Message could have the following attribute: id, messageId, creationDate. Reply could have the following attribute: modifiedDate, and it will take the message's id and messageId attribute. How do i do the mapping for the ... |
20. StaleStateException when adding (0,1) to many relationship forum.hibernate.org |
21. 'one to one' relationship forum.hibernate.org |
22. One to many relationship forum.hibernate.orgI hav three table, a role table, an action table and a composition permission table which contain roleId and actionId. The code for RolePos.hbm.xml is |
23. Best approach to handle this many to many relationship forum.hibernate.orgHi, Want to implement a feature to allow a user to block a list of other users. The use case is for any given user id, find the list of users he blocks. I use a many-to-many relationship table to map the relationship: user1_id, user2_id Since there might be a huge long list of users a user want to block, I ... |
24. creating many-to-many relationship ... forum.hibernate.orgat org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.collection.AbstractCollectionPersister.insertRows(AbstractCollectionPersister.java:1394) at org.hibernate.action.CollectionUpdateAction.execute(CollectionUpdateAction.java:56) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at com.jjcs.fas.dbms.organisation.OrganisationDAO.save(OrganisationDAO.java:172) ... |
25. how to specify one-to-one relationship forum.hibernate.orgAny one will u pls tell me how to specify a one-to-one relationship in the mapping and java files i have a generalid field which is used in two tables as a one to one relationship General Table generalid placedesc 1 5/156 alangkr anmdnf, chennai 2 232 fajksdj,alsls ,delhi User Table userid username generalid 1 barani 1 2 prveen 3 pls ... |
26. View with relationships forum.hibernate.org |
27. Need help with Many to Many relationship forum.hibernate.orgAuthor Message suneetshah Post subject: Need help with Many to Many relationship Posted: Sat Jul 07, 2007 12:23 am Beginner Joined: Mon May 07, 2007 11:12 pm Posts: 20 Hello, I am trying to define a many to many relationship and am running into some problems. First I get the exception below. But I am also interested in finding ... |
28. What Am I Doing Wrong with this One-to-one Relationship? forum.hibernate.org@Entity @Table(name = "user", catalog = "test", uniqueConstraints = @UniqueConstraint(columnNames = "internet_id")) public class User extends BaseObject implements java.io.Serializable { private static final long serialVersionUID = -1831772440461169308L; private String userId; private String internetId; private UserInfo userInfo; ... |
29. Need help with Many to Many relationship forum.hibernate.orgAuthor Message suneetshah Post subject: Need help with Many to Many relationship Posted: Fri Jul 27, 2007 1:34 am Beginner Joined: Mon May 07, 2007 11:12 pm Posts: 20 Hello, I am trying to implement a many to many relationship and getting the exception below. I was hoping to get some suggestions on how to get this working. - ... |
30. How to bulk populate many-to-many relationships? forum.hibernate.orgNewbie Joined: Wed Aug 01, 2007 9:10 am Posts: 1 I've been struggling to find an way to populate many-to-many relationships using Hibernate stateless sessions or using HSQL. I'm using Hibernate 3.2.4ga and Hibernate Annotations 3.3.0. Up to now, we have performed bulk data loads using standard Hibernate persistance, but this is starting to perform very badly under big imports. This ... |
31. Confused about many-to-many relationships forum.hibernate.orgNewbie Joined: Fri Aug 17, 2007 6:10 pm Posts: 1 Hibernate version: 3 (not aware of the minor version if there is one) Mapping documents: snippets below Name and version of the database you are using: Oracle 10i Okay, I'm throwing up my hands a bit earlier than I normally do on problems. I've been through mounds of docs and it's ... |
32. one-to-many for inversed any relationship forum.hibernate.org |
33. one-to-many relationship forum.hibernate.org |
34. how can I create this kind of relationship? forum.hibernate.orgI want to create the following relationship. Code: User(1)--------(n)UserBoard(n)-----(1)Board |(1) | ... |
35. Over use of one-to-many relationship? forum.hibernate.org |
36. Many-to-Many Relationships forum.hibernate.orgHi, I am trying to create a many-to-many relationship. I have a class User and Exam. User can have many exams and Exam can have many users hence many-to-many relationship. I have a UserExams table in the database that refer to the Users and Exams table. UserExams contain the UserID and ExamID from the Users, Exams table respectively. Now, when I ... |
37. Why can't I handle one-to-one relationships efficiently? forum.hibernate.orgHibernate version: 3.2.5.ga I've managed to find some odd behaviour with one-to-one relationships. I'm hoping this is because I'm not handling the mappings properly, but I basically copied them directly from the documentation. Here's my tables / objects / hbm files: Code: a(id INT AUTO_INCREMENT, bId INT NOT NULL, PRIMARY KEY(id)) b(id INT AUTO_INCREMENT, PRIMARY KEY(id)) class A { ... |
38. One to Many Relationship forum.hibernate.org |
39. Can I create user type to cover a one to many relationship? forum.hibernate.orgHibernate version: 3.2.3 I would like to create a user type to replace the following block of mapping scripts scattered in my mapping files: |
40. One to many relationship forum.hibernate.orgNewbie Joined: Sun Dec 23, 2007 7:03 am Posts: 1 Hi Guys I am getting a class cast exception when trying to create a simple one to many relationship. I have included the stack trace, the code that is causing it, the configuration file and the persistent object. What am I doing wrong? hibernate 3.1 /* * Created on 2 Sep ... |
41. One to Many relationship forum.hibernate.orgIn a traditional 1 to Many relationship it might be modelled like this: An Organization has many contacts. Organization ------------- Org_Id (PK) Other fields Org_Contact -------------- Contact_ID (PK) Org_Id (FK) Other fields I am being told by a colleague that mapping this in Hibernate will create a problem where the Organization object will be created as a child of the contact ... |
42. Many-to-many relationship with a historical mechanism forum.hibernate.orgHi guys, I'm having trouble with some many-to-many relationships that are implemented in the project that I work for. This has a historical mechanism that every update on certain tables are registered on a specific table in my database. But some tables which implements a many-to-many relationship and are choosen to registered on historical tables are identified on the historical table ... |
43. one-to-many relationship forum.hibernate.orgHi all, I've a problem with a one-to-many relationship. Givin the following tables: IDM_CODE_TABLE ------------------------- INT ID (PK) VARCHAR(64) NAME IDM_RANGE -------------------------------------------- INT ID (PK) INT CODE_TABLE_ID (PK) INT START_ID INT END_ID Here below are the mapping files: |
44. many to many relationship forum.hibernate.org |
45. Many-to-One relationship to a one-to-one solution forum.hibernate.orgHi, I'm wondering if there is a more elegant solution to my current problem: I have two classes: User and Address. A user has more than one address associated with it but only one current address. Ideally I would like the user bean to contain only the latest address such that user.getAddress() returns the current address object for this user. One ... |
46. unable to identify relationships forum.hibernate.orghi, i am just started learning hibernate. i am developing a project which is simple forum. So, i created my tables as create table Topic(topic_id number(8) primary key, Topic_Name varchar2(41)); create table Questions(topic_id number(8),Question_id number(8), Questions varchar2(500), username varchar2(50), Q_Date Date) alter table Questions add constraint fk TopicId references Topic(topic_id); i got stuck up at one place i,e. which relationship mapping ... |
47. one-to-one relationship forum.hibernate.orgHello everyone, I am trying to get a one-to-one relationship working, but i am stuck at this. I have two tables, user and profile. One user can only have one profile, and one profile belongs only to one user. These are part of my mapping files: User |
48. How can implement this relationship forum.hibernate.orgFirst of all apologies for my poor English, I'm from Galicia. I have a table called 'phones' like this Code: CREATE TABLE `phones` ( `id` integer (10) NOT NULL AUTO_INCREMENT , `entidad` varchar (50), `idEntidad` integer (10), `tipo` varchar (50), `numero` varchar (200), ... |
49. m:m relationship with views. forum.hibernate.orgI have two views Customer and City with m:m relationship and there are no ids because they are views. Both views can be joined on Customer.customerNummber = City.customerNummber Customer customerNummber customerName City cityName customerNummber One city can have several customers and one customer can have several cities. This can be found in City view. Can anybody suggest how the hbm files ... |
50. Relationship advice forum.hibernate.org |
51. many-to-one relationship forum.hibernate.orgIam an absolute beginner when it comes to Hibernate. Iam attempting to create my first one-to-many relationship and am receiving the following output when I attempt to reference the value [java] Welcome nikki massamanute [java] This staff member manages a department! [java] This staff member manages id: 3 [java] Hibernate: select dept0_.dept_id as dept1_2_0_, dept0_.dept_name as dept2_2_0_ from dept dept0_ where ... |
52. Hibernate 3 one-to-many relationship forum.hibernate.orgAuthor Message abdujaparov Post subject: Hibernate 3 one-to-many relationship Posted: Tue Jun 16, 2009 3:45 am Newbie Joined: Sun Apr 05, 2009 6:56 am Posts: 5 Hi, I have these 2 tables: Code: TABLE TPS16_CONFIGURATION ( [u]TPS16_NAME[/u], TPS16_VALID_FROM_DATE, TPS16_OPERATING_RANGE_HI, TPS16_OPERATING_RANGE_LO, TPS16_MAX_OPERATING_DELTA, TPS16_TIME_GRID_PROTOTYPE) Code: TPS25_CURRENCIES_DIFFMIN ( [u]TPS16_ID, TPS25_ISO_CURRENCY,[/u] TPS25_DIFF_MIN ) I underlined the keys of the tables. There is a ... |
53. Mistakes in Relationships - forum.hibernate.orgNewbie Joined: Mon Mar 30, 2009 6:18 pm Posts: 2 Hello everyone!, I have a newbie question about hibernate, later of try and try to understand I cannot and then I m here, my question is the following: I have 3 Classes: Form.java / Question.java / Option.java in which I formulate the relationship like a survey: Form has many Questions / ... |
54. How to audit trail in one-to-many relationship forum.hibernate.org |
55. How do I know which relationship shall be eager fetched? forum.hibernate.orgRegular Joined: Tue Feb 17, 2009 3:36 pm Posts: 71 I get an exception as the following: Quote: org.hibernate.LazyInitializationException: could not initialize proxy - no Session at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:86) at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:140) at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:190) at com.xyz.smyapp.domain.group.GroupCategory_$$_javassist_14.equals(GroupCategory_$$_javassist_14.java) And the GroupCategory class is defined as the following: Code: @Entity @Table(name = "category") public class GroupCategory implements Serializable { /** ... |
56. One To Many Relationship forum.hibernate.orgHi, I have a requirement where i have to establish a one-to-one relationship between tables CUSTOMER<-1--1->CORPORATE_EMPLOYEE<1--1>LOGIN_CREDENTIALS table I tried with |
57. working with one-to-many relationship.i'm stacked somewhere forum.hibernate.orgHello good people. I know the kind of help and understanding i'm about to request for might look trivail for you gurus but i'm just getting my hands on hibernate and i'm a complete newbie.Well that said i'm trying to understand hibernate by doing a small project for myself.I have 2 tables : message (messageId, text, commaseprecipnums, date) and log table ... |
58. can not make a many-to-one relationship optional forum.hibernate.orgHello, I have a Many-to-one relationship between Token and TokenTrack classes. The Token primary key consistes of three columns (composite key). I need to make this relationship optional=false but couldn't do that. Code: @ManyToOne(optional = false) @ForeignKey(name = "token_track_fk_site_date_number") @JoinColumns({ @JoinColumn(name ... |