7:47 a.m.
CLOB Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-7264
URL: https://hibernate.onjira.com/browse/HHH-7264
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.1
Environment: Derby 10.8.2.2
Reporter: ian mockford
Attachments: hibernate-derby-test.zip
When using JPA/Hibernate with a Derby DB, an @Lob annotation on a String gets truncated to
a max of 255 chars.
For example:
private String message;
@Lob
@Column(name = "MESSAGE")
public String getMessage() {
return message;
}
Attached is a Maven project with a test case showing the problem; the Derby can be changed
to H2 to make the tests pass.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:57 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-7264) CLOB Length Set to 255 By Default With Derby DB
[
https://hibernate.onjira.com/browse/HHH-7264?page=com.atlassian.jira.plug...
]
ian mockford commented on HHH-7264:
-----------------------------------
Creating a custom dialect FixedDerbyDialect.java
{code:java}
package org.hibernate.testing.derby;
import java.sql.Types;
import org.hibernate.dialect.DerbyTenSevenDialect;
public class FixedDerbyDialect extends DerbyTenSevenDialect {
public FixedDerbyDialect() {
super();
registerColumnType(Types.CLOB, "clob");
}
}
{code}
Seems to fix the problem, so maybe this could be added into
org.hibernate.dialect.DerbyDialect.java as was done for BLOB in commit
https://github.com/hibernate/hibernate-orm/commit/a2bae5a18c23f4916a5c3c6...
CLOB Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-7264
URL: https://hibernate.onjira.com/browse/HHH-7264
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.1
Environment: Derby 10.8.2.2
Reporter: ian mockford
Attachments: hibernate-derby-test.zip
When using JPA/Hibernate with a Derby DB, an @Lob annotation on a String gets truncated
to a max of 255 chars.
For example:
private String message;
@Lob
@Column(name = "MESSAGE")
public String getMessage() {
return message;
}
Attached is a Maven project with a test case showing the problem; the Derby can be
changed to H2 to make the tests pass.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:31 a.m.
New subject: [Hibernate-JIRA] Assigned: (HHH-7264) CLOB Length Set to 255 By Default With Derby DB
[
https://hibernate.onjira.com/browse/HHH-7264?page=com.atlassian.jira.plug...
]
Strong Liu reassigned HHH-7264:
-------------------------------
Assignee: Strong Liu
CLOB Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-7264
URL: https://hibernate.onjira.com/browse/HHH-7264
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.1
Environment: Derby 10.8.2.2
Reporter: ian mockford
Assignee: Strong Liu
Attachments: hibernate-derby-test.zip
When using JPA/Hibernate with a Derby DB, an @Lob annotation on a String gets truncated
to a max of 255 chars.
For example:
private String message;
@Lob
@Column(name = "MESSAGE")
public String getMessage() {
return message;
}
Attached is a Maven project with a test case showing the problem; the Derby can be
changed to H2 to make the tests pass.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:39 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-7264) CLOB Length Set to 255 By Default With Derby DB
[
https://hibernate.onjira.com/browse/HHH-7264?page=com.atlassian.jira.plug...
]
Venkatesh commented on HHH-7264:
--------------------------------
Hi Strong Liu,
I originally had the error below and I could solve it with the fix mentioned above.
But this fix only wrapped this original error into a new one as described below.
Requesting you to provide if there is a fix for the new error too.
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)
...
FIX
public class ASMDerbyDialect extends org.hibernate.dialect.DerbyDialect {
public ASMDerbyDialect()
{
super();
registerColumnType(Types.BLOB, "blob");
}
}
----------------------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)
Thanks in advance!
Venkatesh
CLOB Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-7264
URL: https://hibernate.onjira.com/browse/HHH-7264
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.1
Environment: Derby 10.8.2.2
Reporter: ian mockford
Assignee: Strong Liu
Attachments: hibernate-derby-test.zip
When using JPA/Hibernate with a Derby DB, an @Lob annotation on a String gets truncated
to a max of 255 chars.
For example:
private String message;
@Lob
@Column(name = "MESSAGE")
public String getMessage() {
return message;
}
Attached is a Maven project with a test case showing the problem; the Derby can be
changed to H2 to make the tests pass.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:43 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-7264) CLOB Length Set to 255 By Default With Derby DB
[
https://hibernate.onjira.com/browse/HHH-7264?page=com.atlassian.jira.plug...
]
Venkatesh commented on HHH-7264:
--------------------------------
With reference to my previous post above.
The gist of the lengthy trace is "ERROR 42X61: Types 'BLOB' and
'INTEGER' are not UNION compatible."
Thanks a lot!
Venkatesh
CLOB Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-7264
URL: https://hibernate.onjira.com/browse/HHH-7264
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.1
Environment: Derby 10.8.2.2
Reporter: ian mockford
Assignee: Strong Liu
Attachments: hibernate-derby-test.zip
When using JPA/Hibernate with a Derby DB, an @Lob annotation on a String gets truncated
to a max of 255 chars.
For example:
private String message;
@Lob
@Column(name = "MESSAGE")
public String getMessage() {
return message;
}
Attached is a Maven project with a test case showing the problem; the Derby can be
changed to H2 to make the tests pass.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:27 a.m.
New subject: [Hibernate-JIRA] Issue Comment Edited: (HHH-7264) CLOB Length Set to 255 By Default With Derby DB
[
https://hibernate.onjira.com/browse/HHH-7264?page=com.atlassian.jira.plug...
]
ian mockford edited comment on HHH-7264 at 4/20/12 1:26 AM:
------------------------------------------------------------
The comment/fix above from Venkatesh refers to BLOB, but this issue (HHH-7264) is about
CLOB. BLOB is covered by (and already fixed by) HHH-2614.
was (Author: trtdev87):
The comment/fix above from Venkatesh refers to BLOB, but this issue () HHH-7264) is
about CLOB. BLOB is covered by (and already fixed by) HHH-2614.
CLOB Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-7264
URL: https://hibernate.onjira.com/browse/HHH-7264
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.1
Environment: Derby 10.8.2.2
Reporter: ian mockford
Assignee: Strong Liu
Attachments: hibernate-derby-test.zip
When using JPA/Hibernate with a Derby DB, an @Lob annotation on a String gets truncated
to a max of 255 chars.
For example:
private String message;
@Lob
@Column(name = "MESSAGE")
public String getMessage() {
return message;
}
Attached is a Maven project with a test case showing the problem; the Derby can be
changed to H2 to make the tests pass.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:27 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-7264) CLOB Length Set to 255 By Default With Derby DB
[
https://hibernate.onjira.com/browse/HHH-7264?page=com.atlassian.jira.plug...
]
ian mockford commented on HHH-7264:
-----------------------------------
The comment/fix above from Venkatesh refers to BLOB, but this issue () HHH-7264) is about
CLOB. BLOB is covered by (and already fixed by) HHH-2614.
CLOB Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-7264
URL: https://hibernate.onjira.com/browse/HHH-7264
Project: Hibernate ORM
Issue Type: Bug
Components: core
Affects Versions: 4.0.1
Environment: Derby 10.8.2.2
Reporter: ian mockford
Assignee: Strong Liu
Attachments: hibernate-derby-test.zip
When using JPA/Hibernate with a Derby DB, an @Lob annotation on a String gets truncated
to a max of 255 chars.
For example:
private String message;
@Lob
@Column(name = "MESSAGE")
public String getMessage() {
return message;
}
Attached is a Maven project with a test case showing the problem; the Derby can be
changed to H2 to make the tests pass.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4414
days inactive
4416
days old
hibernate-issues@lists.jboss.org
6 comments
3 participants
participants (3)
-
ian mockford (JIRA) -
Strong Liu (JIRA)
-
Venkatesh (JIRA)