Return-Path: X-Original-To: apmail-activemq-dev-archive@www.apache.org Delivered-To: apmail-activemq-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EB57397DE for ; Wed, 11 Jul 2012 12:18:36 +0000 (UTC) Received: (qmail 66303 invoked by uid 500); 11 Jul 2012 12:18:36 -0000 Delivered-To: apmail-activemq-dev-archive@activemq.apache.org Received: (qmail 66206 invoked by uid 500); 11 Jul 2012 12:18:36 -0000 Mailing-List: contact dev-help@activemq.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@activemq.apache.org Delivered-To: mailing list dev@activemq.apache.org Received: (qmail 65927 invoked by uid 99); 11 Jul 2012 12:18:35 -0000 Received: from issues-vm.apache.org (HELO issues-vm) (140.211.11.160) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jul 2012 12:18:35 +0000 Received: from isssues-vm.apache.org (localhost [127.0.0.1]) by issues-vm (Postfix) with ESMTP id 14AD414052D for ; Wed, 11 Jul 2012 12:18:35 +0000 (UTC) Date: Wed, 11 Jul 2012 12:18:35 +0000 (UTC) From: "Fred Toussi (JIRA)" To: dev@activemq.apache.org Message-ID: <1689299306.34877.1342009115087.JavaMail.jiratomcat@issues-vm> In-Reply-To: <1269006453.34876.1342009115050.JavaMail.jiratomcat@issues-vm> Subject: [jira] [Updated] (AMQ-3922) HSQLDB support is broken as wrong data type is used in HsqldbJDBCAdapter.java MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/AMQ-3922?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Fred Toussi updated AMQ-3922: ----------------------------- Summary: HSQLDB support is broken as wrong data type is used in HsqldbJDBCAdapter.java (was: HSQLDB support is broken as data type is used in HsqldbJDBCAdapter.java) > HSQLDB support is broken as wrong data type is used in HsqldbJDBCAdapter.java > ----------------------------------------------------------------------------- > > Key: AMQ-3922 > URL: https://issues.apache.org/jira/browse/AMQ-3922 > Project: ActiveMQ > Issue Type: Bug > Affects Versions: 5.6.0 > Reporter: Fred Toussi > > The HsqldbJDBCAdaptor defines the SQL type used for storing a lob as "OTHER". This is wrong in principle, as this type is intended for storing complex serialized object, not specifically lobs. With this type, the JDBC setObject and getObject methods must be used to store and retrieved the object (which is not the case with ActiveMQ). > The problem has been encountered and reported in TOMEE-233 and elsewhere. > With HSQLDB version 2.x, the type "BLOB" should be used for maximum storage capacity and minimum memory use by the database engine. This type is supported in all modes of operation, inclusing in-memory and file databases. > It seems a simple switch from "OBJECT" to "BLOB" in the code should do the job, as the JDBC setBytes and getBytes methods used by the superclass are compatible with the BLOB type. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira