From continuum-dev-return-5872-apmail-maven-continuum-dev-archive=maven.apache.org@maven.apache.org Thu Mar 15 17:35:33 2007 Return-Path: Delivered-To: apmail-maven-continuum-dev-archive@www.apache.org Received: (qmail 25227 invoked from network); 15 Mar 2007 17:35:32 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 15 Mar 2007 17:35:32 -0000 Received: (qmail 57676 invoked by uid 500); 15 Mar 2007 17:35:39 -0000 Delivered-To: apmail-maven-continuum-dev-archive@maven.apache.org Received: (qmail 57646 invoked by uid 500); 15 Mar 2007 17:35:39 -0000 Mailing-List: contact continuum-dev-help@maven.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: continuum-dev@maven.apache.org Delivered-To: mailing list continuum-dev@maven.apache.org Received: (qmail 57635 invoked by uid 99); 15 Mar 2007 17:35:39 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Mar 2007 10:35:39 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of thierry.lach@gmail.com designates 66.249.82.236 as permitted sender) Received: from [66.249.82.236] (HELO wx-out-0506.google.com) (66.249.82.236) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 15 Mar 2007 10:35:28 -0700 Received: by wx-out-0506.google.com with SMTP id t14so267476wxc for ; Thu, 15 Mar 2007 10:35:07 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=o39XnT/lJHq0EmFD7/QWnrUwoYtpMyekJBGZM2BiH9fNKxVGksx6rX5iL4ZVL72zaxa4UGd9X2XOKkGwb177XtX9dR1SfX10eZ5aEJwSLFkAfCKKLuUKt1tsCegAO7yIG6aDX2W4CXpBOHa3TdhjCYcXGSR0ihoCdtCbcadzOik= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=GP2ppAUCkWOG7pLg1lCm/teVQx+sogWqMJm4wcXJAXyDQneNffIgmma89isT/i2o3oHJkS5eO3WyUIw+FFJpTQ9zA+of3JIMb018V3OCcdIy0uSy8LSrfah3wgnwU6VYRcmItvYiY9HyCQqzMhHkDF2gPov2QD0mPI4A/mksRdI= Received: by 10.90.118.12 with SMTP id q12mr801586agc.1173980107543; Thu, 15 Mar 2007 10:35:07 -0700 (PDT) Received: by 10.90.50.3 with HTTP; Thu, 15 Mar 2007 10:35:07 -0700 (PDT) Message-ID: <495914f00703151035u20194f23s1a55a2676dce878e@mail.gmail.com> Date: Thu, 15 Mar 2007 13:35:07 -0400 From: "Thierry Lach" To: continuum-dev@maven.apache.org Subject: Re: JPOX 1.1.7 ? In-Reply-To: <495914f00703150947s41984af7se3eb1d20631f103@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_157732_20403939.1173980107439" References: <495914f00703131204j123d08fbt9efe5b5e9c1b2d7f@mail.gmail.com> <495914f00703131436s470fcd5bo6359a9680e8d0b2f@mail.gmail.com> <495914f00703140644q25b58c47g4a7d1c663f66d043@mail.gmail.com> <495914f00703140722n6a1c1786hf43813f5a5829b32@mail.gmail.com> <495914f00703141136t7db783aaued5f65372ffa079f@mail.gmail.com> <495914f00703150947s41984af7se3eb1d20631f103@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_157732_20403939.1173980107439 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I've posted a patch to JIRA that enables (at least for me, using postgres 8.1) running continuum against postgres using the built-in jetty. It should be very simple to add support for a different version of postgres also by cloning the profile. On 3/15/07, Thierry Lach wrote: > > OK, it seems to be something that JBoss is doing to get in the way. I > used the instructions at http://docs.codehaus.org/display/CONTINUUM/Database+Configuration > (with the 8.1 jdbc jar) and was able to get Continuum up and running using > jetty. > > On 3/14/07, Jesse McConnell < jesse.mcconnell@gmail.com> wrote: > > > > server 8.2.3-1 > > jdbc version: 8.2-504.jdbc3 (and jdbc4) > > > > so I sure hope its not a matter of being that tight :) > > > > I'll monkey around a bit more, right now I am just making sure it > > works with the internal derby > > > > jesse > > > > On 3/14/07, Thierry Lach < thierry.lach@gmail.com> wrote: > > > I ran into something similar some time back. Check to make sure that > > you're > > > using the same version of the postgres jdbc jar as you are the > > postgres > > > database. The example on > > > http://docs.codehaus.org/display/CONTINUUM/Database+Configuration uses > > the > > > 8.0 jar. > > > > > > On 3/14/07, Jesse McConnell wrote: > > > > > > > > I am getting issues with starting continuum with the jpox 1.1.7 and > > > > postgres myself > > > > > > > > different stacks though > > > > > > > > g: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > > > > "PROJECTGROUP_BUILDDEFINITIONS_pkey" for table > > > > "PROJECTGROUP_BUILDDEFINITIONS" > > > > 2007-03-14 12:48:37,539 [main] > > WARN General - > > > > SQL warning: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit > > > > index "PROJECTNOTIFIER_CONFIGURATION_pkey" for table > > > > "PROJECTNOTIFIER_CONFIGURATION" > > > > 2007-03-14 12:48:37,676 [main] ERROR Schema > > - > > > > An exception was thrown while adding/validating class(es) : ERROR: > > > > function information_schema._pg_keypositions() does not exist > > > > java.sql.SQLException: ERROR: function > > > > information_schema._pg_keypositions() does not exist > > > > at > > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse ( > > > > QueryExecutorImpl.java:1471) > > > > at org.postgresql.core.v3.QueryExecutorImpl.processResults( > > > > QueryExecutorImpl.java:1256) > > > > at org.postgresql.core.v3.QueryExecutorImpl.execute ( > > > > QueryExecutorImpl.java:175) > > > > at org.postgresql.jdbc2.AbstractJdbc2Statement.execute( > > > > AbstractJdbc2Statement.java:389) > > > > at > > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags ( > > > > AbstractJdbc2Statement.java:314) > > > > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery( > > > > AbstractJdbc2Statement.java:221) > > > > at > > > > > > org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedExportedKeys > > > > (AbstractJdbc2DatabaseMetaData.java:3237) > > > > at > > > > org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedKeys( > > > > AbstractJdbc2DatabaseMetaData.java:3533) > > > > at > > org.jpox.store.rdbms.RDBMSStoreHelper.getForeignKeyInfoForTable > > > > (RDBMSStoreHelper.java:376) > > > > at > > org.jpox.store.rdbms.table.TableImpl.getExistingForeignKeys( > > > > TableImpl.java:937) > > > > at org.jpox.store.rdbms.table.TableImpl.validateForeignKeys( > > > > TableImpl.java:421) > > > > at org.jpox.store.rdbms.table.TableImpl.validateConstraints( > > > > TableImpl.java :394) > > > > at org.jpox.store.rdbms.table.ClassTable.validateConstraints > > ( > > > > ClassTable.java:2875) > > > > at > > > > org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation( > > > > RDBMSManager.java:3110) > > > > > > > > On 3/14/07, Thierry Lach wrote: > > > > > Yeah, that was my thought also. > > > > > > > > > > On 3/14/07, Jesse McConnell wrote: > > > > > > > > > > > > have you tried it with postgres outside of jboss? I want to > > narrow > > > > > > down the factors here > > > > > > > > > > > > > > > > > > > > > > > > On 3/14/07, Thierry Lach wrote: > > > > > > > That's right. I knew that patch for transaction levels didn't > > solve > > > > it > > > > > > on > > > > > > > its own, so my hopes got up with the mention of JPOX 1.1.7 and > > > > postgres > > > > > > last > > > > > > > week. > > > > > > > > > > > > > > On 3/13/07, Jesse McConnell < jesse.mcconnell@gmail.com> > > wrote: > > > > > > > > > > > > > > > > I set the transaction lvls to READ_COMMITTED as well, so > > that > > > > didn't > > > > > > > > fix you either huh? > > > > > > > > > > > > > > > > hrm > > > > > > > > > > > > > > > > On 3/13/07, Thierry Lach wrote: > > > > > > > > > JPOX 1.1.7 doesn't correct the problems with > > Postgres. I've > > > > added > > > > > > an > > > > > > > > > updated stack trace to > > > > > > http://jira.codehaus.org/browse/CONTINUUM-1181 > > > > > > > > > > > > > > > > > > On 3/13/07, Jesse McConnell < jesse.mcconnell@gmail.com> > > wrote: > > > > > > > > > > > > > > > > > > > > yes, and I setup the bundled for m2 and got them into > > place > > > > about > > > > > > an > > > > > > > > > > hour ago...will be synced into the main repos sometime > > soon > > > > > > > > > > > > > > > > > > > > jesse > > > > > > > > > > > > > > > > > > > > On 3/13/07, Thierry Lach wrote: > > > > > > > > > > > Did JPOX 1.1.7 get released yesterday? > > > > > > > > > > > > > > > > > > > > > > On 3/7/07, Erik Bengtson wrote: > > > > > > > > > > > > > > > > > > > > > > > > FYI, JPOX 1.1.7 will be released next monday. It > > fixes the > > > > > > issue > > > > > > > > with > > > > > > > > > > > > postgres. > > > > > > > > > > > > > > > > > > > > > > > > You can try it out, if you like, before we release. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > http://www.jpox.org/downloads/maven/jpox/jars/jpox-1.1-SNAPSHOT.jar > > > > > > > > > > > > > > > > > > > > > > > > Regards > > > > > > > > > > > > > > > > > > > > > > > > Quoting Jesse McConnell < jesse.mcconnell@gmail.com > > >: > > > > > > > > > > > > > > > > > > > > > > > > > Ok, well the little poll thread I made seemed to > > be > > > > strongly > > > > > > in > > > > > > > > > > favor > > > > > > > > > > > > > of getting things pulled together to start getting > > alpha > > > > > > > > releases > > > > > > > > > > out > > > > > > > > > > > > > of continuum. So with that in mind here is a list > > of a > > > > few > > > > > > > > things > > > > > > > > > > > > > that we need to get in order for an alpha release > > that I > > > > > > > > shamelessly > > > > > > > > > > > > > started base on bretts comments > > > > > > > > > > > > > > > > > > > > > > > > > > - properly mark up the model as it was for 1.0.3release > > > > > > > > > > > > > - add methods to continuum-data-management to > > utilise > > > > that > > > > > > and > > > > > > > > then > > > > > > > > > > > > > make any necessary transformations (c-d-m will do > > the > > > > basic > > > > > > > > 1-to-1 > > > > > > > > > > > > > conversions) > > > > > > > > > > > > > - probably write a little CLI to fire it off. > > > > > > > > > > > > > - vet jira for a 1.1 alpha 1 release version and > > maybe > > > > > > schedule > > > > > > > > out > > > > > > > > > > a > > > > > > > > > > > > > couple of alpha-# releases. > > > > > > > > > > > > > > > > > > > > > > > > > > I think I'll start in on the data management bit > > now > > > > since > > > > > > that > > > > > > > > > > seems > > > > > > > > > > > > > like the biggest hurdle. I am not convinced we > > really > > > > need > > > > > > to > > > > > > > > worry > > > > > > > > > > > > > about a continuum 1.0.3 -> continuum 1.1 migration > > > > > > ability...its > > > > > > > > not > > > > > > > > > > a > > > > > > > > > > > > > difficult thing to get projects loaded back up > > into > > > > > > > > continuum...but > > > > > > > > > > > > > we'll see I guess. > > > > > > > > > > > > > > > > > > > > > > > > > > anyone have anything to add? > > > > > > > > > > > > > > > > > > > > > > > > > > jesse > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > > > > jesse mcconnell > > > > > > > > > > > > > jesse.mcconnell@gmail.com > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > > jesse mcconnell > > > > > > > > > > jesse.mcconnell@gmail.com > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > jesse mcconnell > > > > > > > > jesse.mcconnell@gmail.com > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > jesse mcconnell > > > > > > jesse.mcconnell@gmail.com > > > > > > > > > > > > > > > > > > > > > > > -- > > > > jesse mcconnell > > > > jesse.mcconnell@gmail.com > > > > > > > > > > > > > -- > > jesse mcconnell > > jesse.mcconnell@gmail.com > > > > ------=_Part_157732_20403939.1173980107439--