1. Return row # for ranking in Hibernate SQL coderanch.comIs 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.orgAuthor 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.orgNewbie 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.orgHello, 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.orgI 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 |
6. Hibernate returns different result set from SQL - any ideas? forum.hibernate.orgPage 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.orgHello 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.orgI 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 ... |
9. Not returning all results from db though generated sql does! forum.hibernate.org |
10. JPQL and SQL Returning Different Results forum.hibernate.orgHello, 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 |
11. org.hibernate.sql.InFragment returns no result set forum.hibernate.org |