From activemq-users-return-202-apmail-geronimo-activemq-users-archive=geronimo.apache.org@geronimo.apache.org Fri Mar 24 13:57:56 2006 Return-Path: Delivered-To: apmail-geronimo-activemq-users-archive@www.apache.org Received: (qmail 33437 invoked from network); 24 Mar 2006 13:57:56 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 24 Mar 2006 13:57:56 -0000 Received: (qmail 50269 invoked by uid 500); 24 Mar 2006 13:57:56 -0000 Delivered-To: apmail-geronimo-activemq-users-archive@geronimo.apache.org Received: (qmail 50244 invoked by uid 500); 24 Mar 2006 13:57:55 -0000 Mailing-List: contact activemq-users-help@geronimo.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: activemq-users@geronimo.apache.org Delivered-To: mailing list activemq-users@geronimo.apache.org Received: (qmail 50235 invoked by uid 99); 24 Mar 2006 13:57:55 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Mar 2006 05:57:55 -0800 X-ASF-Spam-Status: No, hits=1.3 required=10.0 tests=RCVD_IN_BL_SPAMCOP_NET,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of james.strachan@gmail.com designates 64.233.182.189 as permitted sender) Received: from [64.233.182.189] (HELO nproxy.gmail.com) (64.233.182.189) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Mar 2006 05:57:54 -0800 Received: by nproxy.gmail.com with SMTP id o25so583487nfa for ; Fri, 24 Mar 2006 05:57:33 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=UYigrouCnk8Z8WGGyJazrOsGCrd0S5mMpaYAr0s36qWGtkTbHzQdoa9IgBknBnC2XUF2rkpT5sXaZFByvQkatSZY8faa0FifkDxmM3w2+WQBmlPM6fnfo1vvmUlMrdwLJR+s7vtKauxvayEwq0+xMwuFamF2c+lgLFOB8BBLfDs= Received: by 10.48.217.10 with SMTP id p10mr283735nfg; Fri, 24 Mar 2006 05:57:33 -0800 (PST) Received: by 10.48.209.20 with HTTP; Fri, 24 Mar 2006 05:57:33 -0800 (PST) Message-ID: Date: Fri, 24 Mar 2006 05:57:33 -0800 From: "James Strachan" To: activemq-users@geronimo.apache.org Subject: Re: Adding support for MaxDB in ActiveMQ JDBC persistence layer In-Reply-To: <3834E2B49C8B5342837E7D6F68E8D21922B181@apiexchsrv19.APIMEM.apiparts.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <3834E2B49C8B5342837E7D6F68E8D21922B181@apiexchsrv19.APIMEM.apiparts.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi Johan So mostly we need to work out the flavour of SQL that MaxDB supports and to figure out what the DDL should look like etc. We have a number of JDBC adaptors for the various different drives together with how they handle data types and blobs etc. It could be we just need to write one for MaxDB. Also it could be we need to tweak a little the SQL data types we use - I"ve just added a new section to this page describing how to do that.... http://docs.codehaus.org/display/ACTIVEMQ/JDBC+Support Once we basically know the right combination of options that work for MaxDB, we can add an entry into ActiveMQ so that we auto-discover the database from the JDBC connection type name and do the right thing. e.g. here is the current list of auto-discovered configurations of JDBC, where the file name is the JDBC connection type name returned from the JDBC driver http://svn.apache.org/repos/asf/incubator/activemq/trunk/activemq-core/src/= main/resources/META-INF/services/org/apache/activemq/store/jdbc/ James On 3/23/06, Johan Hallgren wrote: > Hi list, > > I am currently in the process of evaluating ActiveMQ. Reading http://acti= vemq.org/JDBC+Support I see that it supports quite a lot of databases, but = unfortunately not the one that my company is using (MaxDB (formerly SAPDB),= http://www.mysql.com/products/maxdb/). I try to configure activemq to use = it by copying its JDBC jar file to activemq's lib directory, and configurin= g activemq.xml to use it like this: > > > > > > > > > I used the MySQL sample config section as a template and substituted valu= es for my MaxDB instance (the class value I used as is, since I didn't know= what to use there). However, when starting ActiveMQ, I get these errors (I= have created the database user mentioned above, but not created any tables= in that schema): > > ACTIVEMQ_HOME: /usr/local/activemq-4.0-M4 > Loading message broker from: xbean:activemq.xml > INFO BrokerService - ActiveMQ 4.0-M4 JMS Message Broker= (localhost) is starting > INFO BrokerService - For help or more information pleas= e see:http://www.logicblaze.com > WARN JDBCPersistenceAdapter - Database driver NOT recognized: [s= ap_db]. Will use default JDBC implementation. > WARN DefaultJDBCAdapter - Could not create JDBC tables; they= couldalready exist. Failure was: CREATE TABLE ACTIVEMQ_MSGS(ID INTEGER NOT= NULL, CONTAINER VARCHAR(250), MSGID_PROD VARCHAR(250), MSGID_SEQ INTEGER, = EXPIRATION BIGINT, MSG BLOB, PRIMARY KEY ( ID ) ) Message: [-4006] (at 128)= : Unknown domain name:BIGINT SQLState: I4006 Vendor code: -4006 > > ...Further similar errors snipped. > > From my understanding of what is happening, it seems that the SQL stateme= nts that are used by ActiveMQ won't work on MaxDB (BIGINT is indeed a field= type that is not recognized by that database). My questions are thus: > > * Does anyone successfully use ActiveMQ with MaxDB, and if so, how should= I configure activemq.xml to make it work? > * If it does indeed not work, what would it take to add support for MaxDB= to ActiveMQ? The ActiveMQ web site further mentions that "If you have a JD= BC database which we don't support then please let us know what JDBC driver= string you're getting." If someone would tell me how, I'd be happy to prov= ide the JDBC string I'm getting (could it be "sap_db", as seen in the outpu= t snippet above?), and help in any other way I can to add support for this = database. > > Thanks in advance for any insight! > > Regards, > Johan Hallgren > > -- James ------- http://radio.weblogs.com/0112098/