1:49 a.m.
Blob Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-2614
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.3
Environment: Apache Derby 10.2.2, Java 1.6.0
Reporter: Sean Sylvis
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.
-
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
1:04 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2614) Blob Length Set to 255 By Default With Derby DB
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614?page=c...
]
Michael Rimov commented on HHH-2614:
------------------------------------
I wanted to add that something like:
@Lob
@Column(name="content", length=Integer.MAX_VALUE - 1)
@Basic(fetch=FetchType.LAZY)
Blob content;
works with a simple Read/Write exploratory test with Derby -- so for those using Derby
only -- there's at least a workaround here.
Blob Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-2614
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.3
Environment: Apache Derby 10.2.2, Java 1.6.0
Reporter: Sean Sylvis
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.
-
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
10:51 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2614) Blob Length Set to 255 By Default With Derby DB
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614?page=c...
]
Vincent Cautaerts commented on HHH-2614:
----------------------------------------
Bug still there with hibernate-3.2.5.ga and hibernate-annotations-3.3.0.ga
Blob Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-2614
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.3
Environment: Apache Derby 10.2.2, Java 1.6.0
Reporter: Sean Sylvis
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.
-
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
11:40 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2614) Blob Length Set to 255 By Default With Derby DB
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614?page=c...
]
Penkov Vladimir commented on HHH-2614:
--------------------------------------
This bug prevent jbpm to deploy new process:
{code:title=Test.java|borderStyle=solid}
NewDeployment deployment = repositoryService.createDeployment();
deployment.addResourceFromUrl(new ClassPathResource(processDefinition).getURL());
deployment.deploy();
{code}
{noformat}
Caused by: org.hibernate.exception.DataException: could not insert:
[org.jbpm.pvm.internal.lob.Lob]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2140)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2503)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:962)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1107)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.jbpm.pvm.internal.query.AbstractQuery.execute(AbstractQuery.java:95)
at
org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.execute(ProcessDefinitionQueryImpl.java:65)
at org.jbpm.pvm.internal.query.AbstractQuery.untypedList(AbstractQuery.java:70)
at
org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.list(ProcessDefinitionQueryImpl.java:141)
at org.jbpm.pvm.internal.repository.ProcessDeployer.checkKey(ProcessDeployer.java:134)
at org.jbpm.pvm.internal.repository.ProcessDeployer.deploy(ProcessDeployer.java:93)
at org.jbpm.pvm.internal.repository.DeployerManager.deploy(DeployerManager.java:46)
at
org.jbpm.pvm.internal.repository.RepositorySessionImpl.deploy(RepositorySessionImpl.java:61)
at org.jbpm.pvm.internal.cmd.DeployCmd.execute(DeployCmd.java:47)
at org.jbpm.pvm.internal.cmd.DeployCmd.execute(DeployCmd.java:33)
at
org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
at
org.jbpm.pvm.internal.spring.CommandTransactionCallback.doInTransaction(CommandTransactionCallback.java:50)
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
at
org.jbpm.pvm.internal.tx.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:77)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:55)
at org.jbpm.pvm.internal.repository.DeploymentImpl.deploy(DeploymentImpl.java:91)
at
fotobank.web.cms.admin.workflow.Workflow2Bean.setupProcessDefinitions(Workflow2Bean.java:51)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:297)
at
org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:250)
at
org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:144)
... 36 more
Caused by: java.sql.SQLException: A truncation error was encountered trying to shrink BLOB
'(Binary data value not displayed)' to length 255.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2120)
... 72 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)
at org.apache.derby.iapi.types.SQLBinary.checkHostVariable(Unknown Source)
at org.apache.derby.exe.ac691b824dx0125xc03ax921ax000000189a102.e0(Unknown Source)
{noformat}
Blob Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-2614
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.3
Environment: Apache Derby 10.2.2, Java 1.6.0
Reporter: Sean Sylvis
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.
-
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
12:24 p.m.
New subject: [Hibernate-JIRA] Assigned: (HHH-2614) Blob Length Set to 255 By Default With Derby DB
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614?page=c...
]
Strong Liu reassigned HHH-2614:
-------------------------------
Assignee: Strong Liu
Blob Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-2614
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614
Project: Hibernate Core
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
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.
-
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
6:34 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2614) Blob Length Set to 255 By Default With Derby DB
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614?page=c...
]
Mike Douglass commented on HHH-2614:
------------------------------------
I created a new dialect which seems to have resolved this - I'm a little suspicious
that it was so easy. Am I missing something? My dialect is
public class DerbyDialect extends org.hibernate.dialect.DerbyDialect {
/**
*
*/
public DerbyDialect() {
super();
registerColumnType( Types.BLOB, "blob" );
registerColumnType( Types.CLOB, "clob" );
}
}
Blob Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-2614
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614
Project: Hibernate Core
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
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.
-
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
8:07 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2614) Blob Length Set to 255 By Default With Derby DB
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614?page=c...
]
Strong Liu commented on HHH-2614:
---------------------------------
if you make the change above, then how do you add a length to a Lob property ? :)
Blob Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-2614
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614
Project: Hibernate Core
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
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.
-
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
6:23 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2614) Blob Length Set to 255 By Default With Derby DB
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614?page=c...
]
Jeff Jensen commented on HHH-2614:
----------------------------------
Just encountered this problem too. With supporting multiple databases, having to
determine a legitimate single value for all databases is not desirable. Different
databases can have different max values. Our preference is to use the database applicable
value, i.e. the default. Of course, this breaks with Derby.
Mike's custom dialect seems the best approach to try workaround this problem (and
Strong Liu: we don't want to set a length!).
Blob Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-2614
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614
Project: Hibernate Core
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
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.
-
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
8:34 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2614) Blob Length Set to 255 By Default With Derby DB
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614?page=c...
]
Eric Shoemaker commented on HHH-2614:
-------------------------------------
I hit this bug today. Just curious if anyone will ever fix this? It's a major bug in
core that was opened in 2007 and has been assigned to Strong Liu since 2009. I'm
using the custom dialect workaround but I hope this will actually get fixed at some
point.
Blob Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-2614
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614
Project: Hibernate Core
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
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.
-
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
11:43 a.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-2614) Blob Length Set to 255 By Default With Derby DB
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614?page=c...
]
Strong Liu resolved HHH-2614.
-----------------------------
Resolution: Fixed
Fix Version/s: 4.0.0.next
3.6.6
okay, you get what you want
Blob Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-2614
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614
Project: Hibernate Core
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.next
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
1:41 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2614) Blob Length Set to 255 By Default With Derby DB
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614?page=c...
]
Eric Shoemaker commented on HHH-2614:
-------------------------------------
Thank you for fixing this.
Blob Length Set to 255 By Default With Derby DB
-----------------------------------------------
Key: HHH-2614
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2614
Project: Hibernate Core
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.next
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
1:43 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2614) Blob Length Set to 255 By Default With Derby DB
[
https://hibernate.onjira.com/browse/HHH-2614?page=com.atlassian.jira.plug...
]
Venkatesh commented on HHH-2614:
--------------------------------
Hi Strong Liu and others,
I am also in need of this fix.
Please provide me the new Dialect implementation or direct me to where I can obtain the
same.
Please note that I do not need the latest Hibernate jar, but only the minimal fix for this
error alone.
Thanks in advance!
Venkatesh
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
1:54 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2614) Blob Length Set to 255 By Default With Derby DB
[
https://hibernate.onjira.com/browse/HHH-2614?page=com.atlassian.jira.plug...
]
Strong Liu commented on HHH-2614:
---------------------------------
@Venkatesh
there is a workaround provided in HHH-7264
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
10:25 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2614) Blob Length Set to 255 By Default With Derby DB
[
https://hibernate.onjira.com/browse/HHH-2614?page=com.atlassian.jira.plug...
]
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
4393
days inactive
6195
days old
hibernate-issues@lists.jboss.org
13 comments
9 participants
participants (9)
-
Eric Shoemaker (JIRA) -
Jeff Jensen (JIRA)
-
Michael Rimov (JIRA)
-
Mike Douglass (JIRA)
-
Penkov Vladimir (JIRA)
-
Sean Sylvis (JIRA)
-
Strong Liu (JIRA)
-
Venkatesh (JIRA)
-
Vincent Cautaerts (JIRA)