table « Data Type « JPA Q&A

1. Using Hibernate to pull records based on the number of records in another table    stackoverflow.com

I have a Users table that holds two different kinds of users (A and B). Type A users can have relationships with type B users (which is recorded in a Relationships ...

2. Puzzled by the max number records of a table in MySQL    stackoverflow.com

I am working with a web site analyser which will be used to analyse our own site according to the log from tomcat. Now,we push the log from tomcat to the database(MySQL) ...

3. Hibernate quick way to lookup unique string in table    stackoverflow.com

I have table containing a series of unique strings which I need to provide quick lookups to (besides for memory-caching).

@Entity
public class UniqueString {
    @Id
    ...

4. Populate database table with enum values in hibernate    stackoverflow.com

is there any possibility to let Hibernate (3.6) populate a database table with values for a given enum ? I have the following class:

@Entity
public enum Role
{
    ROLE_USER_FREE("ROLE_USER_FREE"),
   ...

5. How to auto-populate a table upon creation using Hibernate3-Maven-Plugin    stackoverflow.com

I have an enum class that creates a table called ROLE when using the Hibernate3 Maven plugin:

@Entity
@Table(name = "ROLE")
public enum UserRole {

    ADMIN("ADMIN"),
    DEVELOPER("DEVELOPER"),
  ...

6. One Table for all enum types in Hibernate    stackoverflow.com

I have a Class let say Employee as follows;

public class Employee{
    ... Other attributes ...
    @Column @Enumerated(EnumType.Ordinal)
    private Gender gender;

   ...

7. How to copy several rows between two equal tables with JPA/Hibernate?    stackoverflow.com

Is there a way to do something like

INSERT INTO ... SELECT ...

8. Data from HSQLDB table into two dimensional array using Java    stackoverflow.com

I am trying to get data from LivEx table as list, and then save that data into two dimensional array called array. My method is returning object[][]. I made up this code ...

9. [SOLVED] [JPA-HIBERNATE] How to populate a table at start time    coderanch.com

10. Hibernate Limitation:Temporary Table can't be null??    forum.hibernate.org

Hi, I am using the following SQL query in Restrictions.sqlRestriction argument for Criteria API upon whose execution, I get jdbc exception in Hibernate. TABLE Property (id,details) Feature(property_id,desc) property_id is a foreign key in Feature corresponding to Property The query is: Code: Restrictions.sqlRestriction("{alias}.id in (select DISTINCT temp.tid from (select p.id as tid, COUNT(*) as freqfrom Property p, Feature f where p.id=f.property_id and ...

11. Hibernate doesn't create date table    forum.hibernate.org

Im using Spring + hibernate Mysql. Everything works fine except when Im using Date type for a column. When date is in a domain class hibernate skip creating the table. When I remove the date fields, restart the app, the table and the rest of columns are created. But when I put them back i doesnt work. Every other data type ...

12. Empty strings inserted into secondary table on Oracle    forum.hibernate.org

I was about to file a bug, but cannot believe no one else had this problem before and maybe I just dont know how to search... Oracle 9.2.0.4.0, Hibernate 3.2.4.sp1: If an entity with empty string values for its sencondary table attributes is persisted, a row will be inserted into the secondary table even if the empty strings are converted to ...

13. Create table fails: Null Column in PK not allowed in MSSQL    forum.hibernate.org

Hi! My problem: @ElementCollection @CollectionTable(name = "xxx", joinColumns = @JoinColumn(name = "depends", nullable = false)) @Column(name = "dependent", nullable = false) public Map getDependents() { return this.dependents; } generates the following DDL script: create table xxx (depends numeric(19,0) not null, dependent varchar(255) not null, dependents_KEY varchar(255) null, primary key (depends, dependents_KEY)) As you can see, I managed to get the ...

14. Insert current date and time in table    forum.hibernate.org

I am a beginner in Hibernate tech. I want to insert current date and time( e-g 8/17/2010 5:33:00 PM) in Oracle table. Table structure table name - BATCH_Q job_id number(7); start_date date; My Object will be, public class JobStatusObject{ private long jobId; private Date startDate; getters and setters for that } Mapping file will be,

15. Timestamp is not updated when using HQL to update table    forum.hibernate.org

I have a table with a timestamp provided by Hibernate for versioning.The timestamp should change whenever the row is updated.When I am accessing and updating these tables as Pojo's Hibernate updates the timestamp. However, whenever I am updating the row using an HQL, the timestamp is not changed. Why is it so ? I am using hibernate 3.2.6 ga. Is it ...

16. Type safe enum - values stored in a separate table    forum.hibernate.org

Hibernate version2.1.6: For constraints reasons, we often store type safe enum values in a separate table A_enum for example. In Java, I have create a type safe enum class, along with its associated Hibernate user type. In MyEnum.hbm.xml I've set the following: However, when Hibernate loads the data in, it seems to be trying to ...

17. How do I tell Hibernate to use equals() for table entries?    forum.hibernate.org

Hi, I've got two tables: 1) Image 2) ImageSpecification Image.getSpecification() returns an object of type ImageSpecification The problem I'm experiencing is that I see multiple ImageSpecification instances in the database with the exact same values, except for id. Since "id" is the primary key, the table allows this insertation. My question is, how do I tell Hibernate: if you see another ...

18. Internationalized data with minimal number of tables    forum.hibernate.org

Hibernate version: 2.1.7 Name and version of the database you are using: MsSql 2000 In my application I have many referense tables and I want the description/label to be internationalized. I have read and tested the blog entry http://blog.hibernate.org/cgi-bin/blosxom.cgi/2004/06/#i18n. But that example has one "label" table for each reference table. I have 50 reference tables which means 100 tables to store ...

19. 3 table columns to one java Date    forum.hibernate.org

20. A calculated date propery out of 3 (d,m,y) table columns    forum.hibernate.org

Dear All I would like to ask if your experience can offer me some solution: I have a legacy table with 3 INT columns for a date - Day Month and Year. This is done because many records do not have a specific day or month when they occur. My question is what would you suggest me to define as my ...

21. Enum to lookup table    forum.hibernate.org

22. (Diligent) Newbie Q: Strings in Lookup tables?    forum.hibernate.org

This is a very basic newbie question, and I'm sure the answer may be found somewhere in the piles of excellent documentation. I am happy to read; I just need a pointer. Thanks in advance for anyone's time who is still with me on this. :-) As I said, a very simple problem. I have a domain object that can take ...

23. How solve equals/set problem for table with no business key?    forum.hibernate.org

Dear members, I have a table (Movement) defined with no business key, so I have as primary key an autoincrement integer number. The problem comes because a shareholder makes a set of movements, so I need a relation between shareholder an movement. Tipically implemented as set. Becuase the key is generated if I want to add new movements on the shareholder, ...

24. could not insert null to table 'oa_prop.dbo.BUSINES    forum.hibernate.org

Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version: Mapping documents: Code:

25. Null object is returned even if data is present in the table    forum.hibernate.org

I have the following mapping file

26. UserType. How to do whithout a table?    forum.hibernate.org

27. Editing a table with null values    forum.hibernate.org

Is there any way to edit a table with null values inside the object? example: User object UserId = 5 UserName = null; (do not change) UserPhotoName = "bla.jpg" now when i send this over to hibernate for editing, it will set the userName to null in the database, but it should just change the UserPhoto to the "bla.jpg" and dont ...

28. My app recreate the tables each time it runs.    forum.hibernate.org

session.beginTransaction(); Mensaje elmensaje = new Mensaje(); elmensaje.setMensaje("one"); elmensaje.setFecha(new Date()); elmensaje.setTitulo("one"); session.save(elmensaje); ...

29. foreygn keys: no conection to the table and can't be null    forum.hibernate.org

We are working on an old database that is not normalized and relational so we have some problems trying to start it work with Hibernate. We can not make any changes to the configuration of the database. We have some foreign keys in a table that can not be null and they don't have connection to the table that is related ...

30. Random number of rows from oracle table using Hibernate ?    forum.hibernate.org

31. Empty table causes infamous null or transient value error    forum.hibernate.org

Hibernate version: Hibernate Core 3.3.1 GA HIbernate Annotations 3.4.0 GA Mapping documents: Code: public class QueryDefinition { @ManyToOne(cascade = { CascadeType.PERSIST, CascadeType.MERGE }) @JoinColumn(name = "qLibraryId", nullable=false) @ForeignKey(name = "fk_QueryDefinition_QueryLibrary") public QueryLibrary getQueryLibrary() { return queryLibrary; } } public class ...

32. creating new table each time with hibernate    forum.hibernate.org

33. Multiple Table Update from UserType    forum.hibernate.org

Beginner Joined: Thu Feb 19, 2009 5:48 am Posts: 37 Location: Glasgow, Scotland Hello again, I'm looking to do something that seems quite simple but I can't get my head around it. I have two tables that are linked but I'm trying to avoid JOINs. For example, I have a Network class and NetworkUser class but in the database the Network ...