return « SQL « JPA Q&A





1. Return row # for ranking in Hibernate SQL    coderanch.com

Is there a way to return a row #? I'm trying to rank something based on a sorted column, but i'm not sure how to get the row number w/out looping through the entire resultset with a counter and matching my expression. I'm using hibernate, but i dont even know if there is a simple method in SQL.

2. Generated SQL runs but hibernate returns no rows    forum.hibernate.org

Author Message journeyman23 Post subject: Generated SQL runs but hibernate returns no rows Posted: Thu Mar 25, 2004 5:21 pm Newbie Joined: Wed Feb 04, 2004 1:25 am Posts: 8 Hello all, I am having a problem w/ many-to-one mappings. I have a table that has a unique contraint to a reference table (code/id field in the table is ...

3. HQL vs SQL - returning different results    forum.hibernate.org

Newbie Joined: Tue Nov 18, 2003 11:56 am Posts: 16 I've problems with understanding what goes on here. When I set the showsql=true in the configuration file, I get the following SQL from Hibernate: Code: select substan0_.substans_id as substans1_, substan0_.navn as navn, substan0_.beskrivelse as beskrive3_, substan0_.aktivsubstans as aktivsub4_, substan0_.analyse_id as analyse_id from substans substan0_ inner join preparatsubstans preparats1_ on substan0_.substans_id=preparats1_.substans_id inner ...

4. No results from HQL, generated SQL returns correct value    forum.hibernate.org

Hello, I am using Oracle 10g and I have strange error that I cannot resolve. Below are tables with most data columns snipped (otherwise they would be to long) When I do Code: String query = "from BBB si WHERE si.sifra=?"; Query q = s.createQuery(query); q.setParameter(0, sifra10crk); Object o = q.uniqueResult(); ...

5. Can Native Sql return Object[] type?    forum.hibernate.org

I want to write a sql-query in the hbm file, and wanted to query with a result of two columns of integer. i.e. SELECT group_id as {i}, sum(....) as {j} from table inner join..... And I cannot use HQL because of the formula. I have tried to use Object[], int , java.lang.Integer in class of tag, but failed. It seem ...

6. Hibernate returns different result set from SQL - any ideas?    forum.hibernate.org

Page 1 of 1 [ 2 posts ] Previous topic | Next topic Author Message romanonj Post subject: Hibernate returns different result set from SQL - any ideas? Posted: Tue Apr 19, 2005 3:04 pm Newbie Joined: Mon Jul 26, 2004 11:35 am Posts: 13 Read the rules before posting! http://www.hibernate.org/ForumMailingli ...

7. Hibernate is returning a truncated value from SQL Server2000    forum.hibernate.org

Hello I am new to hibernate but have played with it enough to implement it within a product. I am working a support issue currently where a customer is seeing within a dialogue box (swing JTextField) that the value of APM_SCENARIOS_NAMED_VALUES_TAB.val is truncated to 255 characters. The DB is correct and is set to VARCHAR(2000). I even recreated all the tables ...

8. Native SQL that doesn't return a hibernate object    forum.hibernate.org

I have a piece of Oracle SQL that returns me the next available sequence number. How do I execute this in Hibernate? The object I want to return (String), is NOT any of my Hibernate objects, but all the methods I can find to execute SQL apparently must return a Hibernate object. The SQL I want to execute is this: select ...





10. JPQL and SQL Returning Different Results    forum.hibernate.org

Hello, Here is an interesting puzzle. I've got an aggregate root entity with two OneToMany relationships. One of the relationship entities can optionally have a OneToOne relationship with the other relationship entity. It looks something like this: Code: @Entity class Root{ @Id Integer id; @OneToMany Collection foos; @OneToMany Collection bars; } @Entity class Foo{ ...