[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2680?page=c... ] Phil Rice commented on HHH-2680: -------------------------------- I also have been hit by this bug. I am using Mysql, and Oracle The Mysql code works correctly and the blob is udated The Oracle code doesnt work and th -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2680?page=c... ] Christian Bauer commented on HHH-2680: -------------------------------------- Submit a patch. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2680?page=c... ] Steve Ebersole updated HHH-2680: -------------------------------- Comment: was deleted -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2680?page=c... ] Chris Bredesen commented on HHH-2680: ------------------------------------- A workaround is to manually copy the BLOB data after the merge. Line 94 shows the bug: session.merge(domain); // changes blob value to 44 Changing it to this avoids the problem: Domain merged = (Domain) session.merge(domain); merged.setBlob(Hibernate.createBlob(domain.getBlob().getBinaryStream())); -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2680?page=c... ] Mike Heath updated HHH-2680: ---------------------------- Attachment: blobmerge.patch I've attached a patch that seams to fix this problem. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2680?page=c... ] Suresh Vayugundla commented on HHH-2680: ---------------------------------------- Hi Vladimir, Thanks for the fix and details. I did not get it on how to use your fix in attached files. Could you please tell me more details on how to use. Below are the steps on how I am using: Bean Class: (Person) @Type(type="com.mycompany.hibernate.util.FixedBlobType") @Basic(fetch=FetchType.LAZY) private Blob file; Action Class: person.setFile(Hibernate.createBlob(new FileInputStream(attachFile))); Dao class: session.merge(person); Am I missing anything? It is still not working for me. Very much appreciated. Thanks, Suresh -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2680?page=c... ] Suresh Vayugundla commented on HHH-2680: ---------------------------------------- A Big Thanks to Chris Bredesen. Earlier I over looked in whole thread. The solution is right there in the middle. The recommendation that Chris mentioned works for me to update BLOB data. Thank you all. -Suresh -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2680?page=c... ] Steve Ebersole commented on HHH-2680: ------------------------------------- BTW, I am not suggesting that this *only* fails on Oracle. All I am suggesting is to ferret out which databases (dialects) need what approach to handle this. The solution mentioned here afaiu should work on all because it creates a new BLOB instance. I guess my point is that perhaps this is overkill on most databases. For sure I think Dialect should have a hand to play in this. So maybe something like: {code} public Object replace( Object original, Object target, SessionImplementor session, Object owner, Map copyCache) throws HibernateException { if ( original != target && session.getFactory().getDialect().useLobStateTransferOnMerge() ) { OutputStream connectedStream = ( (Blob) target ).setBinaryStream( 1L ); // the BLOB just read during the load phase of merge InputStream detachedStream = ( (Blob) original ).getBinaryStream(); // the BLOB from the detached state copy( detachedStream, connectedStream ); // from, into return target; } else { // return the incoming detached state by default. return original; } } {code} or: {code} public Object replace( Object original, Object target, SessionImplementor session, Object owner, Map copyCache) throws HibernateException { if ( original != target && session.getFactory().getDialect().useNewLobsOnMerge() ) { Blob detachedBlob = (Blob) original; return session.getFactory().getSettings().getJdbcSupport().getLobCreator( session ) .createBlob( original.getBinaryStream(), original.length() ); } else { // return the incoming detached state by default. return original; } } {code} Or maybe even: {code} public Object replace( Object original, Object target, SessionImplementor session, Object owner, Map copyCache) throws HibernateException { if ( original != target && session.getFactory().getDialect().useLobStateTransferOnMerge() ) { OutputStream connectedStream = ( (Blob) target ).setBinaryStream( 1L ); // the BLOB just read during the load phase of merge InputStream detachedStream = ( (Blob) original ).getBinaryStream(); // the BLOB from the detached state copy( detachedStream, connectedStream ); // from, into return target; } else { Blob detachedBlob = (Blob) original; return session.getFactory().getSettings().getJdbcSupport().getLobCreator( session ) .createBlob( original.getBinaryStream(), original.length() ); } } {code} -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2680?page=c... ] Gail Badner updated HHH-2680: ----------------------------- Fix Version/s: (was: 3.5.3) 3.5.x -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2680?page=c... ] Steve Ebersole updated HHH-2680: -------------------------------- Fix Version/s: (was: 3.6.0.Beta1) 3.6.x -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2680?page=c... ] Steve Ebersole updated HHH-2680: -------------------------------- Fix Version/s: (was: 3.6.0.CR2) (was: 3.5.x) 3.6.x -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2680?page=c... ] Gail Badner updated HHH-2680: ----------------------------- Fix Version/s: (was: 3.6.1) 4.0.0.Alpha1 3.6.2 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2680?page=c... ] Steve Ebersole updated HHH-2680: -------------------------------- Fix Version/s: (was: 3.6.3) Issue Type: Improvement (was: Bug) Moving to fix for just 4.0.0.Alpha2 since we have gotten no feedback on this in terms of which dialects require which precess. And technically this is not a bug, but an improvement, since the explicitly coded-for behavior was to in fact ignore the lob data. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira