Return-Path: Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: (qmail 74182 invoked from network); 27 Aug 2010 09:27:58 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 27 Aug 2010 09:27:58 -0000 Received: (qmail 37755 invoked by uid 500); 27 Aug 2010 09:27:58 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 37701 invoked by uid 500); 27 Aug 2010 09:27:56 -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 37692 invoked by uid 99); 27 Aug 2010 09:27:56 -0000 Received: from Unknown (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Aug 2010 09:27:56 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of mkhatrijava@gmail.com designates 74.125.82.170 as permitted sender) Received: from [74.125.82.170] (HELO mail-wy0-f170.google.com) (74.125.82.170) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Aug 2010 09:27:33 +0000 Received: by wyf19 with SMTP id 19so5240826wyf.1 for ; Fri, 27 Aug 2010 02:27:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:content-type; bh=BuIz596W4nmsLImuTyMj8wxdvfctTMxgAITIsIa08WI=; b=NdLN0zNjxTOimt1jxwVuHxW7zaFSwd3RliVk1pnsP6Jl/6yWocCPqmxNwoMXGS+Oug ze2Fno5EARbgofCtNkWRq0PvHp6hXi05oPIoDAxwa2abNiAYZb3czIet4itOwkx2QSFW aSMg4cB6dYRTaUrBkB4zfWAxuGQdlloYd59Y4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=KrPo1XAQbAlCBiPkPjr6MzfU46a150sNDheqAily4EhP62IytSRwErcwGF6af2jnLa zTrZwJyG5Q1LkZ7La2hPteUBZGnGqFJIFYNxylz//+b/a9MG7v0n/8tp/S3IqZVYRxvH HmLMtA5+be9f4tr3taNgSOPSsrYg9MERSo/o4= MIME-Version: 1.0 Received: by 10.227.145.66 with SMTP id c2mr434014wbv.42.1282901231549; Fri, 27 Aug 2010 02:27:11 -0700 (PDT) Received: by 10.227.156.134 with HTTP; Fri, 27 Aug 2010 02:27:11 -0700 (PDT) In-Reply-To: References: Date: Fri, 27 Aug 2010 11:27:11 +0200 Message-ID: Subject: Re: Facing error when running Jackrabbit with Postgres + Jboss From: Meenakshi Khatri To: users@jackrabbit.apache.org Content-Type: multipart/alternative; boundary=0016e65b5ec4304d92048ecab82b X-Virus-Checked: Checked by ClamAV on apache.org --0016e65b5ec4304d92048ecab82b Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hello again, I fixed the problem with jackrabbit and Postgres seems to be working properly and saving data properly. Thanks & Regards, Meenakshi On Tue, Aug 24, 2010 at 2:45 PM, Meenakshi Khatri wr= ote: > Hi Thomas, > > Thanks for your reply. Could you please also help me with the second > problem, which is that why it doesnt create tables in the Postgres databa= se? > > Is there some work around it? I have actually spend few days trying to ge= t > this working and it is becomign very tricky to create tables in the postg= res > database. > > Thanks and Regards, > Meenakshi > > On Tue, Aug 24, 2010 at 1:33 PM, Thomas M=FCller wrote: > >> Hi, >> >> I think you can ignore this warning. It looks like the reason is that >> PostgreSQL is not supported in ConnectionFactory.guessValidationQuery, >> which should also contain: >> >> } else if (url.contains("postgresql")) { >> return "select 1"; >> >> Regards, >> Thomas >> >> On Fri, Aug 20, 2010 at 3:37 PM, Meenakshi Khatri >> wrote: >> > Hi Thomas, >> > >> > Thanks for your reply. I did made those changes, and one of the error >> > disappeared. [ERROR: type "varbinary" does not exist] But I still get = a >> > warning message: >> > >> > WARN [org.apache.jackrabbit.core.util.db.ConnectionFactory] (main) >> Failed >> > to guess validation query for URL >> jdbc:postgresql://localhost:5432/database >> > >> > In my postgres-ds.xml file which is inside jboss/server/default/deploy >> > folder, My settings are as follows: >> > >> >> >> >> >> >> >> >> DefaultDS >> >> >> >> >> jdbc:postgresql://localhost:5432/database >> >> org.postgresql.Driver >> >> username >> >> password >> >> select 1 >> >> select 1 >> >> >> >> >> >> PostgreSQL 8.0 >> >> >> >> >> >> >> > >> > I assume that when we switch from derby to postgres, Jackrabbit's >> repository >> > file should automatically create the tables in the database. But, I do= nt >> see >> > any tables in my database. I do see that jackrabbit connects to Postgr= es >> > properly >> > >> >> >> >> WARN [ConnectionFactory] Failed to guess validation query for URL >> >> jdbc:postgresql://localhost:5432/factsheet >> >> INFO [NodeTypeRegistry] no custom node type definitions found >> >> INFO [DatabasePersistenceManager] Database: PostgreSQL / 8.4.4 >> >> INFO [DatabasePersistenceManager] Driver: PostgreSQL Native Driver / >> >> PostgreSQL 8.4 JDBC4 (build 701) >> >> INFO [RepositoryImpl] initializing workspace 'default'... >> >> INFO [DatabasePersistenceManager] Database: PostgreSQL / 8.4.4 >> >> INFO [DatabasePersistenceManager] Driver: PostgreSQL Native Driver / >> >> PostgreSQL 8.4 JDBC4 (build 701) >> >> INFO [LocalFileSystem] LocalFileSystem initialized at path >> >> \jackrabbit\workspaces\default\blobs >> >> INFO [SearchIndex] Index initialized: /jackrabbit/repository/index >> >> Version: 3 >> >> INFO [SearchIndex] Index initialized: >> >> \jackrabbit\workspaces\default/index Version: 3 >> >> INFO [RepositoryImpl] workspace 'default' initialized >> >> INFO [RepositoryImpl] Repository started >> >> INFO [TransientRepository] Transient repository initialized >> >> INFO [RepositoryImpl] initializing workspace 'security'... >> >> INFO [DatabasePersistenceManager] Database: PostgreSQL / 8.4.4 >> >> INFO [DatabasePersistenceManager] Driver: PostgreSQL Native Driver / >> >> PostgreSQL 8.4 JDBC4 (build 701) >> >> INFO [LocalFileSystem] LocalFileSystem initialized at path >> >> \jackrabbit\workspaces\security\blobs >> >> INFO [SearchIndex] Index initialized: >> >> \jackrabbit\workspaces\security/index Version: 3 >> >> INFO [RepositoryImpl] workspace 'security' initialized >> > >> > I think that my = field >> is >> > not defined properly. >> > >> > Could you please help me on this? >> > >> > Thanks & Regards, >> > Meenakshi >> > >> > On Thu, Aug 19, 2010 at 10:19 AM, Thomas M=FCller > > >> > wrote: >> >> >> >> Hi, >> >> >> >> In the FileSystem entry, you need add: >> >> >> >> >> >> Regards, >> >> Thomas >> >> >> >> On Wed, Aug 18, 2010 at 5:54 PM, Meenakshi Khatri < >> mkhatrijava@gmail.com> >> >> wrote: >> >> > Hello everyone, >> >> > >> >> > I am a beginner with Jackrabbit and am currently replacing Derby wi= th >> >> > Postgres 8.4 >> >> > >> >> > I was initially facing errors with Jboss but after making the chang= e, >> >> > Jboss >> >> > is able to set the Postgres JNDI name properly. >> >> > >> >> > I was searching thru the mailing list of Jackrabbit but I hardly ca= me >> >> > across >> >> > any dicsussion which might help me solve this problem. >> >> > >> >> > I have made the necessary changes in my repository.xml file but I g= et >> >> > the >> >> > following error when I run my application with Jboss. >> >> > >> >> > >> >> >> INFO [org.apache.jackrabbit.core.RepositoryImpl] (main) Starting >> >> >> repository... >> >> >> *WARN [org.apache.jackrabbit.core.util.db.ConnectionFactory] (mai= n) >> >> >> Failed to guess validation query for URL >> >> >> jdbc:postgresql://localhost:5432/database* >> >> > >> >> > * ERROR [org.apache.jackrabbit.core.util.db.ConnectionHelper] (main= ) >> >> > Failed >> >> >> to execute SQL (stacktrace on DEBUG log level) >> >> >> org.postgresql.util.PSQLException: ERROR: type "varbinary" does no= t >> >> >> exist* >> >> >> Position: 98 >> >> >> at >> >> >> >> >> >> >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu= torImpl.java:2062) >> >> >> at >> >> >> >> >> >> >> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp= l.java:1795) >> >> >> at >> >> >> >> >> >> >> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:= 257) >> >> >> at >> >> >> >> >> >> >> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme= nt.java:479) >> >> >> at >> >> >> >> >> >> >> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb= c2Statement.java:353) >> >> >> at >> >> >> >> >> >> >> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme= nt.java:345) >> >> >> at >> >> >> >> >> >> >> org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.= java:264) >> >> >> at >> >> >> >> >> >> >> org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.= java:264) >> >> > >> >> > ..... >> >> > >> >> > I have made the following changes in the repository.xml file to >> replace >> >> > Derby with Postgres. >> >> > >> >> >> >> >> >> >> >> >> >> >> >> > value=3D"jdbc:postgresql://localhost:5432/database"/> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > value=3D"jdbc:postgresql://localhost:5432/database"/> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > >> >> >> >> >> >> class=3D"org.apache.jackrabbit.core.security.simple.SimpleSecurityManage= r" >> >> >> workspaceName=3D"security"> >> >> >> >> >> >> >> >> >> > >> >> >> class=3D"org.apache.jackrabbit.core.security.simple.SimpleAccessManager"= > >> >> >> >> >> >> >> >> >> >> >> >> > >> >> >> class=3D"org.apache.jackrabbit.core.security.simple.SimpleLoginModule"> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > >> >> defaultWorkspace=3D"default"/> >> >> >> >> >> >> >> >> >> >> >> >> > value=3D"jdbc:postgresql://localhost:5432/database"/> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > > >> >> >> >> >> >> class=3D"org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceMa= nager"> >> >> >> >> >> >> > value=3D"jdbc:postgresql://localhost:5432/database"/> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > >> >> class=3D"org.apache.jackrabbit.core.query.lucene.SearchIndex"> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > value=3D"jdbc:postgresql://localhost:5432/database"/> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > >> >> >> >> >> >> class=3D"org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceMa= nager"> >> >> >> >> >> >> > value=3D"jdbc:postgresql://localhost:5432/database"/> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > >> >> class=3D"org.apache.jackrabbit.core.query.lucene.SearchIndex"> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > >> >> > Also, I read somewhere in one of the mailing list that I need to >> change >> >> > even >> >> > workspace.xml file so my workspace.xml file inside /workspace/defau= lt >> >> > folder >> >> > and /workspace/security folder looks like this >> >> > >> >> > >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > value=3D"jdbc:postgresql://localhost:5432/database"/> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > >> >> >> >> >> >> class=3D"org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceMa= nager"> >> >> >> >> >> >> > value=3D"jdbc:postgresql://localhost:5432/database"/> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > >> >> class=3D"org.apache.jackrabbit.core.query.lucene.SearchIndex"> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > >> >> > Can someone please help me and guide me on how to solve this proble= m? >> >> > What >> >> > am I missing ? >> >> > >> >> > Thanks in advace, >> >> > >> >> > Meenakshi >> >> > >> > >> > >> > > --0016e65b5ec4304d92048ecab82b--