Return-Path: Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: (qmail 77769 invoked from network); 22 Sep 2009 09:05:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 22 Sep 2009 09:05:48 -0000 Received: (qmail 41578 invoked by uid 500); 22 Sep 2009 09:05:48 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 41562 invoked by uid 500); 22 Sep 2009 09:05:48 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 41551 invoked by uid 99); 22 Sep 2009 09:05:47 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 22 Sep 2009 09:05:47 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of tmueller@day.com designates 207.126.148.182 as permitted sender) Received: from [207.126.148.182] (HELO eu3sys201aog002.obsmtp.com) (207.126.148.182) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 22 Sep 2009 09:05:37 +0000 Received: from source ([74.125.78.149]) by eu3sys201aob002.postini.com ([207.126.154.11]) with SMTP ID DSNKSriTSdu9XlnBJsAslVl4PYDx9ssdiFYK@postini.com; Tue, 22 Sep 2009 09:05:17 UTC Received: by ey-out-1920.google.com with SMTP id 13so747221eye.52 for ; Tue, 22 Sep 2009 02:05:13 -0700 (PDT) MIME-Version: 1.0 Received: by 10.211.143.9 with SMTP id v9mr727071ebn.53.1253610313741; Tue, 22 Sep 2009 02:05:13 -0700 (PDT) In-Reply-To: <25530381.post@talk.nabble.com> References: <25530302.post@talk.nabble.com> <25530381.post@talk.nabble.com> Date: Tue, 22 Sep 2009 11:05:13 +0200 Message-ID: <91f3b2650909220205s29af2379h1520b9d5ad36fcb2@mail.gmail.com> Subject: Re: [OT] - DB datastore in development mode From: =?ISO-8859-1?Q?Thomas_M=FCller?= To: users@jackrabbit.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org Hi, I think that you have set both the tablePrefix and the schemaObjectPrefix to "ds_" in the configuration. Please remove the tablePrefix in the configuration, and only keep the schemaObjectPrefix. See also http://wiki.apache.org/jackrabbit/DataStore "tablePrefix: The table name prefix. The default is empty. Can be used to select an non-default schema or catalog. The table name is constructed like this: ${tablePrefix}${schemaObjectPrefix}${tableName}" That should solve the problem. If it doesn't, please provide the data store configuration you used. I would also need to know the exact version of Jackrabbit you use, and the complete stack trace of the error. Regards, Thomas On Mon, Sep 21, 2009 at 5:49 PM, freak182 wrote: > > Hello, > > I got this error: > > ERROR - RepositoryImpl =A0 =A0 =A0 =A0 =A0 =A0 - failed to start Reposito= ry: Can not > init data store, driver=3Dorg.postgresql.Driver > url=3Djdbc:postgresql://localhost:5432/jcrpm user=3Demanux > schemaObjectPrefix=3Dds_ tableSQL=3Ddatastore createTableSQL=3DCREATE TAB= LE > ds_ds_datastore(ID VARCHAR(255) PRIMARY KEY, LENGTH BIGINT, LAST_MODIFIED > BIGINT, DATA BYTEA): ERROR: relation "ds_ds_datastore" already exists > org.apache.jackrabbit.core.data.DataStoreException: Can not init data sto= re, > driver=3Dorg.postgresql.Driver url=3Djdbc:postgresql://localhost:5432/jcr= pm > user=3Demanux schemaObjectPrefix=3Dds_ tableSQL=3Ddatastore createTableSQ= L=3DCREATE > TABLE ds_ds_datastore(ID VARCHAR(255) PRIMARY KEY, LENGTH BIGINT, > LAST_MODIFIED BIGINT, DATA BYTEA): ERROR: relation "ds_ds_datastore" alre= ady > exists: ERROR: relation "ds_ds_datastore" already exists > > ...what should i do to avoid this? > > thanks a lot. > cheers. > > > freak182 wrote: >> >> Hello, >> >> I just notice that when i use DB DataStore, when I first run my >> application it works fine (it initialize the repository). But when i >> restart my app (because i made some modification in my code) the >> repository throwing an exception that the DB DataStore already exist (of >> course) but the repository is shutdown. is there a way to this not to >> shutdown the repository when DB DataStore already exist? >> >> thanks a lot. >> cheers. >> > > -- > View this message in context: http://www.nabble.com/-OT----DB-datastore-i= n-development-mode-tp25530302p25530381.html > Sent from the Jackrabbit - Users mailing list archive at Nabble.com. > >