HHH-6726 LONG and LONG RAW column types in Oracle
by Łukasz Antoniak
Welcome Community!
I have just subscribed to the list and wanted to discuss HHH-6726 JIRA
issue.
Gail Badner wrote
(http://lists.jboss.org/pipermail/hibernate-dev/2011-October/007208.html):
HHH-6726 (Oracle : map TextType to clob and ImageType to blob)
https://hibernate.onjira.com/browse/HHH-6726
There have been a number of issues opened since the change was made to
map TextType (LONGVARCHAR) 'long' and ImageType (LONGVARBINARY) to 'long
raw'. This change was already documented in the migration notes. Should
the mapping for Oracle (only) be changed back to clob and blob?
HHH-6726 is caused by an issue in Oracle JDBC driver (version 10.2.0.4
and later). This bug appears when LONG or LONG RAW columns are accessed
not as first or last while processing SQL statement.
I have discussed the topic of mapping TextType to CLOB and ImageType to
BLOB (only in Oracle dialect) with Strong Liu. Reasons for doing so:
- Oracle allows only one LONG / LONG RAW column per table. This might be
the most important from Hibernate's perspective.
- LONG / LONG RAW - up to 2 GB, BLOB / CLOB - up to 4 GB.
- In PL/SQL using LOBs is more efficient (random access to data). LONG
only sequential.
- LONG and LONG RAW are deprecated.
What is your opinion?
Regards,
Lukasz Antoniak
15 years
remove ID on failed flush
by Marcel Hörr
hey guys,
i'm currently facing the following situation:
we're using the current stable version of hibernate (3.6.7) as a jpa-vendor with an oracle database. the ids of our entities are generated by a sequence, which works fine. but in the case of a failure during the save action, our entities get an id although they have not been saved to the database. in case of a sequence generated id this is quite bad, because we can not use this id again. the id should be set to null.
of course i have read the comments in this ticket:
https://hibernate.onjira.com/browse/HB-1014
or the conversations in this thread (and the conversations linked in that thread):
https://forum.hibernate.org/viewtopic.php?f=1&t=942461
but reading the above articles wasn't quite helpful, because no solution or hint in the right direction was suggested. a few people stated, that this behavior was fixed in hibernate 3, but that seems not be the case.
do you guys have any suggestions how to handle this problem? or is this something application code has to deal with in your opinion (i hope not ;-))?
any help appreciated.
- marcel
15 years
Needed for 4.0.0.CR5?
by Gail Badner
A couple of new issues were opened today that seem important enough to consider for 4.0.0.CR5. Not sure there's any time left to do this, but here they are:
HHH-6727 (serializing an EntityManager should include enough information to later be unserialized with re-association to existing EntityManagerFactory (even on a different machine/jvm process))
https://hibernate.onjira.com/browse/HHH-6727
HHH-6726 (Oracle : map TextType to clob and ImageType to blob)
https://hibernate.onjira.com/browse/HHH-6726
There have been a number of issues opened since the change was made to map TextType (LONGVARCHAR) 'long' and ImageType (LONGVARBINARY) to 'long raw'. This change was already documented in the migration notes. Should the mapping for Oracle (only) be changed back to clob and blob?
Steve, if you have a chance, please take a look at: HHH-6723 (Remove extra join from eager @OneToOne). I created a pull request at: https://github.com/hibernate/hibernate-core/pull/184. If possible, I'd like to restore the performance improvement of HHH-5109 for 3.6.8 and 4.0.0.CR5.
Please let me know if I should look at any of this for CR5. I'll look into the Infinispan failure until I hear otherwise.
Thanks,
Gail
15 years
Release
by Steve Ebersole
I decided to not do the release today. Lets plan on 2 more weeks as of
right now.
steve(a)hibernate.org
http://hibernate.org
15 years
Integration test failure
by Hardy Ferentschik
Hi,
anyone else having problems with the latest integration test failure?
It's a massive stacktrace, so I posted it here -
http://pastebin.com/HMWRiAuW
Looks like Arqullian tries to download hibernate-search-orm as dependency
and fails.
--Hardy
15 years
filters
by Ankita Patil
Hey,
I wanted to know if it is possible to give two conditions on two different
fields in one filter? eg. isDeleted='false' and sversion=3. if yes then how?
Also can we apply two filters to a session? if yes how?
Thanks
Ankita
15 years
filters
by Ankita Patil
Hey,
I wanted to know if it is possible to give two conditions on two different
fields in one filter? eg. isDeleted='false' and sversion=3. if yes then how?
Also can we apply two filters to a session? if yes how?
Thanks
Ankita
15 years
