From continuum-users-return-1791-apmail-maven-continuum-users-archive=maven.apache.org@maven.apache.org Thu Jun 01 15:03:40 2006 Return-Path: Delivered-To: apmail-maven-continuum-users-archive@www.apache.org Received: (qmail 71424 invoked from network); 1 Jun 2006 15:03:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Jun 2006 15:03:40 -0000 Received: (qmail 86212 invoked by uid 500); 1 Jun 2006 15:03:39 -0000 Delivered-To: apmail-maven-continuum-users-archive@maven.apache.org Received: (qmail 86187 invoked by uid 500); 1 Jun 2006 15:03:39 -0000 Mailing-List: contact continuum-users-help@maven.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: continuum-users@maven.apache.org Delivered-To: mailing list continuum-users@maven.apache.org Received: (qmail 86176 invoked by uid 99); 1 Jun 2006 15:03:39 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jun 2006 08:03:39 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [62.193.206.9] (HELO webmail9.amenworld.com) (62.193.206.9) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 01 Jun 2006 08:03:37 -0700 Received: (qmail 28449 invoked from network); 1 Jun 2006 15:03:22 -0000 Received: from 65.29.98-84.rev.gaoland.net (HELO ?127.0.0.1?) (84.98.29.65) by 0 with SMTP; 1 Jun 2006 15:03:22 -0000 Message-ID: <447F01AC.9070408@venisse.net> Date: Thu, 01 Jun 2006 17:03:08 +0200 From: Emmanuel Venisse User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: fr, en MIME-Version: 1.0 To: continuum-users@maven.apache.org Subject: Re: Using continuum with Sybase SQLServer References: <00bc01c68589$fb47ac70$cad9c839@eu.accor.net> In-Reply-To: <00bc01c68589$fb47ac70$cad9c839@eu.accor.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N I think you're the first one that try to use sybase SQLServer. What is the column that generate the warning? I think all tables are created in a transaction but I'm not sure because we don't have the hand on it. It's the work of jpox at startup. Emmanuel Olivier Lamy a écrit : > Hi, > I'm trying to use continuum with Sybase SQLServer. > I have the following errors : > > 006-06-01 16:38:20,930 [main] DEBUG DDL - > CREATE TABLE SYSTEMCONFIGURATI > ON > ( > SYSTEMCONFIGURATION_ID int NOT NULL, > BASE_URL nvarchar(255) NULL, > BUILD_OUTPUT_DIRECTORY nvarchar(255) NULL, > COMPANY_LOGO_URL nvarchar(255) NULL, > COMPANY_NAME nvarchar(255) NULL, > COMPANY_URL nvarchar(255) NULL, > DEFAULT_SCHEDULE_CRON_EXCC nvarchar(255) NULL, > DEFAULT_SCHEDULE_DESCRIPZ8 nvarchar(255) NULL, > DEPLOYMENT_REPOSITORY_DIOA nvarchar(255) NULL, > GUEST_ACCOUNT_ENABLED bit NOT NULL, > INITIALIZED bit NOT NULL, > MODEL_ENCODING nvarchar(255) NULL, > WORKING_DIRECTORY nvarchar(255) NULL > ) > 2006-06-01 16:38:20,974 [main] DEBUG DDL - > Execution Time = 44 ms > 2006-06-01 16:38:20,974 [main] WARN General - > SQL warning: com.sybase.jdbc2. > jdbc.SybSQLWarning: Warning: Row size (2580 bytes) could exceed row size > limit, which is 1962 bytes. > > > It's just a warning. > But at the end ersistenceManagerImpl@146e381" closed > Error while deploying application > 'continuum-plexus-application-1.0.3.jar'. > org.codehaus.plexus.application.ApplicationServerException: Could not > deploy the JAR > at > org.codehaus.plexus.application.deploy.DefaultApplicationDeployer.deploy > Jar(DefaultApplic > ationDeployer.java:216) > at > org.codehaus.plexus.application.deploy.DefaultApplicationDeployer.deploy > (DefaultApplicati > onDeployer.java:136) > at > org.codehaus.plexus.application.deploy.DefaultApplicationDeployer.deploy > (DefaultApplicati > onDeployer.java:116) > > ....... > > > aused by: org.jpox.store.poid.PoidException: Couldnt obtain a new > sequence (unique id) : The optimi > zer could not find a unique index which it could use to perform an > isolation level 0 scan on table ' > SEQUENCE_TABLE'. > > at > org.jpox.store.rdbms.table.SequenceTable.getNextVal(SequenceTable.java:2 > 32) > at > org.jpox.store.rdbms.poid.SequenceTablePoidGenerator.reserveBlock(Sequen > ceTablePoidGenera > tor.java:86) > at > org.jpox.store.poid.AbstractPoidGenerator.reserveBlock(AbstractPoidGener > ator.java:35) > at > org.jpox.store.poid.PoidManager.obtainPoidBlock(PoidManager.java:230) > at > org.jpox.store.poid.PoidManager.obtainPoidBlock(PoidManager.java:141) > at org.jpox.store.poid.PoidManager.getNext(PoidManager.java:94) > at > org.jpox.store.rdbms.RDBMSManager.getStrategyValue(RDBMSManager.java:128 > 5) > at > org.jpox.store.rdbms.table.ClassTable.newOID(ClassTable.java:784) > > > [INFO] The application server has started. > > > But nothing works, tables are created in the databases. > Questions : are tables created within a transaction ? > Someone else has experimented this ? > > Thanks > -- > Olivier > > > > This e-mail, any attachments and the information contained therein ("this message") are confidential and intended solely for the use of the addressee(s). If you have received this message in error please send it back to the sender and delete it. Unauthorized publication, use, dissemination or disclosure of this message, either in whole or in part is strictly prohibited. > ********************************************************************** > Ce message electronique et tous les fichiers joints ainsi que les informations contenues dans ce message ( ci apres "le message" ), sont confidentiels et destines exclusivement a l'usage de la personne a laquelle ils sont adresses. Si vous avez recu ce message par erreur, merci de le renvoyer a son emetteur et de le detruire. Toutes diffusion, publication, totale ou partielle ou divulgation sous quelque forme que se soit non expressement autorisees de ce message, sont interdites. > ********************************************************************** > > > >