table « SQL « JPA Q&A





1. Hibernate Restrictions: Object betweeen two DB.table.propertyName    stackoverflow.com

This is the normal use of Hibernate's between constraint

Criterion critDate = Restrictions.between("fromDatePropName", model.getFromDate(), model.getToDate()) ;
But I want the constraint between Object with two or more propertyName in hibernate. For ex: ...

2. Hibernate class - Read from one view(table), and write to another    stackoverflow.com

I need to connect to a DB that has for each entity, a view for reading and a view for writing. This is done to control the update process of values ...

4. JPA TableGenerator problem: SQL contains table name thrice?!    forum.hibernate.org

@Entity(name = "PostalAddress") @Table(name = "PostalAddress") @TableGenerator( name = "PostalAddressEntityIDGenerator", table = "JPAGenerators", pkColumnName = "generatorName", pkColumnValue = "PostalAddressEntityIDGenerator", valueColumnName = "generatorValue", allocationSize = 1 ) public class PostalAddressEntity { @Column(name = "id") @GeneratedValue(strategy = GenerationType.TABLE, generator = "PostalAddressEntityIDGenerator") @Id private ...

5. create tables with sql or hibernate    forum.hibernate.org

Hello, Im new to Hibernate and Im working on a small webapplication using Spring and Hibernate. Until now, I created my tables using MySQL Server 5.1. with the normal create table commands manually. I used then hibernate in my project to get the data from my database as objects and to use them. everything works fine. now Im wondering if it ...

7. SQLGrammarException/wrong table name in generated SQL    forum.hibernate.org

Hello! I have been working with Hibernate2/3 for over a year now, but i am currently stuck which a problem, which seems to be caused by invalid sql. I am trying to build a kind of hierarchical map-structure with two tables data_nodes/data_node_children (see below for details). Every node can have subnodes which are associated with a string key. The node contains ...

8. java.sql.SQLException: Table not found    forum.hibernate.org

Newbie Joined: Fri Apr 28, 2006 12:07 pm Posts: 14 Hello! I'm a new user of Hibernate and I can't fix a problem with the configuration. I'm following the steps of the reference documentation and at the time of storing I have this problem: ant run -Daction=store Buildfile: build.xml clean: [delete] Deleting directory /home/mjimenez/workspace/HibernatePrueba/bin [mkdir] Created dir: /home/mjimenez/workspace/HibernatePrueba/bin copy-resources: [copy] Copying ...

9. how can I see the SQL which creates the TABLE    forum.hibernate.org





10. Creating tables that use sql keywords?    forum.hibernate.org

Hi, The forum search is broken and has been for a long time. Someone needs to get on that, everytime I have a question I have to make a thread since I can't go to page 2 on the search! I know this has been covered before but I've got to ask it again. I have a simple entity class like ...

11. SQL Grammer error, missing linkage table    forum.hibernate.org

Hibernate version: 3.1.3 Mapping documents: Code:

12. Does Hibernate CREATE SQL Tables if necessary?    forum.hibernate.org

13. sql statement stripped of tables    forum.hibernate.org

Hibernate version 2.1. Oracle 10 Hello I am using hibernate version 2.1 (only used 3 before but client is now forcing 2). Whenever I make a simple query I get an ORA-00936: missing expression. The reason for this, I think, is this. When I look in the logs with debug I see this: Code: 2009-06-26 11:11:00,914 DEBUG [WebContainer : 2] impl.SessionImpl ...