[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2614) Blob Length Set to 255 By Default With Derby DB
Venkatesh (JIRA)
noreply at atlassian.com
Fri Apr 20 04:25:50 EDT 2012
[ https://hibernate.onjira.com/browse/HHH-2614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=46360#comment-46360 ]
Venkatesh commented on HHH-2614:
--------------------------------
Hi Strong Liu,
My error is related to BLOB and I have provided the relevant stack trace below. The work around in HHH-7264 is for CLOB.(However, I tried the fix HHH-7264 and it did not solve the issue of BLOB data being truncated to 255).
-----------------------------ORIGINAL ERROR----------------------
"Caused by: java.sql.SQLException: A truncation error was encountered trying to shrink BLOB '(Binary data value not displ
ayed)' to length 255.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 68 more
Caused by: ERROR 22001: A truncation error was encountered trying to shrink BLOB '(Binary data value not displayed)' to
length 255.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
...
And this fix mentioned here in HHH-2614 by Mike Douglass did not fix my original error and it only wrapped it into a new error
"ERROR 42X61: Types 'BLOB' and 'INTEGER' are not UNION compatible."
Requesting you to provide if there is a fix for the new error "ERROR 42X61".
Thanks a lot in advance,
Venkatesh
---------------------NEW ERROR---------------------------
---------------------NEW ERROR---------------------------
---------------------NEW ERROR---------------------------
javax.servlet.ServletException: java.lang.ExceptionInInitializerError
com.vaadin.terminal.gwt.server.AbstractApplicationServlet.handleServiceException(AbstractApplicationServlet.java:1004)
com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:548)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
java.lang.ExceptionInInitializerError
com.axiomatics.acs.ui.app.AcsApplication.init(AcsApplication.java:172)
com.vaadin.Application.start(Application.java:554)
com.vaadin.terminal.gwt.server.AbstractApplicationServlet.startApplication(AbstractApplicationServlet.java:1213)
com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:484)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not load an entity: com.axiomatics.acs.persistence.entities.ManagedEntityBase#10c90db0-5d64-11e1-b86c-0800200c9a66
org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1215)
org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:635)
org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:589)
com.axiomatics.acs.persistence.dao.jpa.AbstractJpaDao.read(AbstractJpaDao.java:276)
com.axiomatics.acs.persistence.dao.jpa.AbstractJpaDao.read(AbstractJpaDao.java:58)
com.axiomatics.acs.persistence.AbstractPersistence.read(AbstractPersistence.java:71)
com.axiomatics.acs.plugin.persistance.DefaultPersistenceFacade.find(DefaultPersistenceFacade.java:158)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService$PdpGroupManager.generalFind(DefaultPdpManagementService.java:455)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService$PdpGroupManager.getInternalPdp(DefaultPdpManagementService.java:419)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService.initialize(DefaultPdpManagementService.java:109)
com.axiomatics.acs.coremodule.DefaultAcsCoreModule.initialize(DefaultAcsCoreModule.java:400)
com.axiomatics.acs.api.secured.SecuredAPI.init(SecuredAPI.java:57)
com.axiomatics.acs.api.secured.SecuredAPI.<init>(SecuredAPI.java:34)
com.axiomatics.acs.util.AcsBackendContext.<clinit>(AcsBackendContext.java:30)
com.axiomatics.acs.ui.app.AcsApplication.init(AcsApplication.java:172)
com.vaadin.Application.start(Application.java:554)
com.vaadin.terminal.gwt.server.AbstractApplicationServlet.startApplication(AbstractApplicationServlet.java:1213)
com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:484)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
org.hibernate.exception.SQLGrammarException: could not load an entity: com.axiomatics.acs.persistence.entities.ManagedEntityBase#10c90db0-5d64-11e1-b86c-0800200c9a66
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
org.hibernate.loader.Loader.loadEntity(Loader.java:2041)
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3293)
org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)
org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)
org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:614)
org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:589)
com.axiomatics.acs.persistence.dao.jpa.AbstractJpaDao.read(AbstractJpaDao.java:276)
com.axiomatics.acs.persistence.dao.jpa.AbstractJpaDao.read(AbstractJpaDao.java:58)
com.axiomatics.acs.persistence.AbstractPersistence.read(AbstractPersistence.java:71)
com.axiomatics.acs.plugin.persistance.DefaultPersistenceFacade.find(DefaultPersistenceFacade.java:158)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService$PdpGroupManager.generalFind(DefaultPdpManagementService.java:455)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService$PdpGroupManager.getInternalPdp(DefaultPdpManagementService.java:419)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService.initialize(DefaultPdpManagementService.java:109)
com.axiomatics.acs.coremodule.DefaultAcsCoreModule.initialize(DefaultAcsCoreModule.java:400)
com.axiomatics.acs.api.secured.SecuredAPI.init(SecuredAPI.java:57)
com.axiomatics.acs.api.secured.SecuredAPI.<init>(SecuredAPI.java:34)
com.axiomatics.acs.util.AcsBackendContext.<clinit>(AcsBackendContext.java:30)
com.axiomatics.acs.ui.app.AcsApplication.init(AcsApplication.java:172)
com.vaadin.Application.start(Application.java:554)
com.vaadin.terminal.gwt.server.AbstractApplicationServlet.startApplication(AbstractApplicationServlet.java:1213)
com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:484)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
java.sql.SQLSyntaxErrorException: Types 'BLOB' and 'INTEGER' are not UNION compatible.
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
org.hibernate.loader.Loader.doQuery(Loader.java:801)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
org.hibernate.loader.Loader.loadEntity(Loader.java:2037)
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3293)
org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)
org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)
org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:614)
org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:589)
com.axiomatics.acs.persistence.dao.jpa.AbstractJpaDao.read(AbstractJpaDao.java:276)
com.axiomatics.acs.persistence.dao.jpa.AbstractJpaDao.read(AbstractJpaDao.java:58)
com.axiomatics.acs.persistence.AbstractPersistence.read(AbstractPersistence.java:71)
com.axiomatics.acs.plugin.persistance.DefaultPersistenceFacade.find(DefaultPersistenceFacade.java:158)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService$PdpGroupManager.generalFind(DefaultPdpManagementService.java:455)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService$PdpGroupManager.getInternalPdp(DefaultPdpManagementService.java:419)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService.initialize(DefaultPdpManagementService.java:109)
com.axiomatics.acs.coremodule.DefaultAcsCoreModule.initialize(DefaultAcsCoreModule.java:400)
com.axiomatics.acs.api.secured.SecuredAPI.init(SecuredAPI.java:57)
com.axiomatics.acs.api.secured.SecuredAPI.<init>(SecuredAPI.java:34)
com.axiomatics.acs.util.AcsBackendContext.<clinit>(AcsBackendContext.java:30)
com.axiomatics.acs.ui.app.AcsApplication.init(AcsApplication.java:172)
com.vaadin.Application.start(Application.java:554)
com.vaadin.terminal.gwt.server.AbstractApplicationServlet.startApplication(AbstractApplicationServlet.java:1213)
com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:484)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
java.sql.SQLException: Types 'BLOB' and 'INTEGER' are not UNION compatible.
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
org.hibernate.loader.Loader.doQuery(Loader.java:801)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
org.hibernate.loader.Loader.loadEntity(Loader.java:2037)
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3293)
org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)
org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)
org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:614)
org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:589)
com.axiomatics.acs.persistence.dao.jpa.AbstractJpaDao.read(AbstractJpaDao.java:276)
com.axiomatics.acs.persistence.dao.jpa.AbstractJpaDao.read(AbstractJpaDao.java:58)
com.axiomatics.acs.persistence.AbstractPersistence.read(AbstractPersistence.java:71)
com.axiomatics.acs.plugin.persistance.DefaultPersistenceFacade.find(DefaultPersistenceFacade.java:158)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService$PdpGroupManager.generalFind(DefaultPdpManagementService.java:455)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService$PdpGroupManager.getInternalPdp(DefaultPdpManagementService.java:419)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService.initialize(DefaultPdpManagementService.java:109)
com.axiomatics.acs.coremodule.DefaultAcsCoreModule.initialize(DefaultAcsCoreModule.java:400)
com.axiomatics.acs.api.secured.SecuredAPI.init(SecuredAPI.java:57)
com.axiomatics.acs.api.secured.SecuredAPI.<init>(SecuredAPI.java:34)
com.axiomatics.acs.util.AcsBackendContext.<clinit>(AcsBackendContext.java:30)
com.axiomatics.acs.ui.app.AcsApplication.init(AcsApplication.java:172)
com.vaadin.Application.start(Application.java:554)
com.vaadin.terminal.gwt.server.AbstractApplicationServlet.startApplication(AbstractApplicationServlet.java:1213)
com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:484)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
ERROR 42X61: Types 'BLOB' and 'INTEGER' are not UNION compatible.
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
org.apache.derby.impl.sql.compile.ResultColumnList.setUnionResultExpression(Unknown Source)
org.apache.derby.impl.sql.compile.SetOperatorNode.buildRCL(Unknown Source)
org.apache.derby.impl.sql.compile.SetOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.SetOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.SetOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.SetOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.SetOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.SetOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.SetOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.SetOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.SetOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.SetOperatorNode.bindResultColumns(Unknown Source)
org.apache.derby.impl.sql.compile.FromSubquery.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.TableOperatorNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.JoinNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.FromList.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
org.hibernate.loader.Loader.doQuery(Loader.java:801)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
org.hibernate.loader.Loader.loadEntity(Loader.java:2037)
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3293)
org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)
org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)
org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:614)
org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:589)
com.axiomatics.acs.persistence.dao.jpa.AbstractJpaDao.read(AbstractJpaDao.java:276)
com.axiomatics.acs.persistence.dao.jpa.AbstractJpaDao.read(AbstractJpaDao.java:58)
com.axiomatics.acs.persistence.AbstractPersistence.read(AbstractPersistence.java:71)
com.axiomatics.acs.plugin.persistance.DefaultPersistenceFacade.find(DefaultPersistenceFacade.java:158)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService$PdpGroupManager.generalFind(DefaultPdpManagementService.java:455)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService$PdpGroupManager.getInternalPdp(DefaultPdpManagementService.java:419)
com.axiomatics.acs.plugin.business.DefaultPdpManagementService.initialize(DefaultPdpManagementService.java:109)
com.axiomatics.acs.coremodule.DefaultAcsCoreModule.initialize(DefaultAcsCoreModule.java:400)
com.axiomatics.acs.api.secured.SecuredAPI.init(SecuredAPI.java:57)
com.axiomatics.acs.api.secured.SecuredAPI.<init>(SecuredAPI.java:34)
com.axiomatics.acs.util.AcsBackendContext.<clinit>(AcsBackendContext.java:30)
com.axiomatics.acs.ui.app.AcsApplication.init(AcsApplication.java:172)
com.vaadin.Application.start(Application.java:554)
com.vaadin.terminal.gwt.server.AbstractApplicationServlet.startApplication(AbstractApplicationServlet.java:1213)
com.vaadin.terminal.gwt.server.AbstractApplicationServlet.service(AbstractApplicationServlet.java:484)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> Blob Length Set to 255 By Default With Derby DB
> -----------------------------------------------
>
> Key: HHH-2614
> URL: https://hibernate.onjira.com/browse/HHH-2614
> Project: Hibernate ORM
> Issue Type: Bug
> Components: core
> Affects Versions: 3.2.3
> Environment: Apache Derby 10.2.2, Java 1.6.0
> Reporter: Sean Sylvis
> Assignee: Strong Liu
> Fix For: 3.6.6, 4.0.0.Beta4
>
>
> When the (Hibernate) type "blob" is used in an object mapping file and a length is not specified, Hibernate converts this type as "blob (255)" to the Apache Derby database table definition. (This seems to be the same as the conversion behavior of a Java String to "varchar (255).") The same behavior results when using a CustomType that returns a Java SQL Types.BLOB. This is not the behavior I expected.
> Hibernate converts the same type as simply "blob" (which has a maximum length of 65535 bytes when no length is specified) when using MySQL version 5.0 (http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html). Furthermore, the Derby specification (http://db.apache.org/derby/docs/10.2/ref/rrefblob.html) states that a blob type without a length value will default to a length of 2M-1 bytes.
> I could not find a length specification for the Java SQL Blob type (http://java.sun.com/javase/6/docs/api/), but the current default length does seem to conform to other Hibernate type standards. That is, if a length is not specified, the length defaults to the maximum length defined for that type by the database.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list