a little complex sql query returns wrong recordset, and the flush command executes a lot of queries I don't have execute ...

Description

I execute a createSQLQuery select with 5 left join, last two over same table to obtain user_id and user name for 2 users.

I have 2 problems:

Problem 1: sql query executes and in 2 loaded fields in the record the data does not correspond with database field

Example wrong result with hibernate:
236, S21 - Pdte. Escanear convenio, df_demo, df_demo >>>> wrong retrieved data >>>> S21 - Pdte. Escanear convenio, S21 - Pdte. Escanear convenio

Example correct result whith jdbc:
214,S16 - Pdte. Borrador Convenio,df_demo,df_demo, >>>> correct retrieved data >>>> dfag demo,dfag demo

( pleas see attached test app )

Problem 2: I am executing only a sql select, but when tx.commit()s, hibernate¿? fire a set of deletes and insert that I can understand who is indicating this action.
This actions apparentely does not final effect in database because all deleted records are inserted newly, but I'm not peaceful with this ...

Please see attached word ( inside the .rar file )

Best regards,

Néstor Dubikin
skype: ndubikin

Environment

Ubuntu 11.10 - Eclipse Indigo 3.7.x - MySQL 5.1.54-1ubuntu4 - Java Sun JDK 1.6.0_24 / jdk 1.6.0_30
Testing with "show_sql">true and "format_sql">true

Activity

Show:
Brett Meyer
April 7, 2014, 5:48 PM

In an effort to clean up, in bulk, tickets that are most likely out of date, we're transitioning all ORM 3 tickets to an "Awaiting Test Case" state. Please see http://in.relation.to/Bloggers/HibernateORMJIRAPoliciesAndCleanUpTactics for more information.

If this is still a legitimate bug in ORM 4, please provide either a test case that reproduces it or enough detail (entities, mappings, snippets, etc.) to show that it still fails on 4. If nothing is received within 3 months or so, we'll be automatically closing them.

Thank you!

Brett Meyer
July 8, 2014, 3:10 PM

Bulk rejecting stale issues. If this is still a legitimate issue on ORM 4, feel free to comment and attach a test case. I'll address responses case-by-case. Thanks!

Rejected

Assignee

Unassigned

Reporter

Nestor Dubikin

Fix versions

None

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major