Skip site navigation (1) Skip section navigation (2)

Re: Problem for access schema in postgresl via JDBC

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Deiverson Silveira <deiverson(at)solutioncms(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem for access schema in postgresl via JDBC
Date: 2012-02-15 20:15:26
Message-ID: CADK3HHLq9h=WNgF3Fn2A7=q3OA8xaerq6VJdfMsMG6Ze8XoK1Q@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Clearly the patch was not accepted.

I would suggest just setting the search path for the connection

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca



On Wed, Feb 15, 2012 at 3:10 PM, Deiverson Silveira
<deiverson(at)solutioncms(dot)com> wrote:
> http://archives.postgresql.org/pgsql-jdbc/2002-12/msg00187.php
>
> and others links in google... but dont work....
>
>
> 2012/2/15 Dave Cramer <pg(at)fastcrypt(dot)com>
>>
>> On Wed, Feb 15, 2012 at 8:43 AM, Deiverson Silveira
>> <deiverson(at)solutioncms(dot)com> wrote:
>> > Hi List,
>> >
>> > My client need connect in dbproject, schema intranet.... but I dont work
>> > my
>> > config in opencms.
>> >
>> > I try:
>> >
>> > db.pool.intranet.jdbcUrl=jdbc:postgresql://serverdb:5432/dbproject?schema=intranet
>> > and
>> >
>> > db.pool.intranet.jdbcUrl=jdbc:postgresql://serverdb:5432/dbproject?searchpath=intranet
>> >
>> > but dont work, but in schema public work...
>> >
>> > Idea? Document very poor:
>> > http://jdbc.postgresql.org/documentation/83/connect.html
>> >
>> > Regards,
>> >
>> > Deiverson
>> >
>> > --
>>
>> Where in the docs does it suggest the above will work ?
>>
>> Dave Cramer
>>
>> dave.cramer(at)credativ(dot)ca
>> http://www.credativ.ca
>
>
>
>
> --
> www.solutioncms.com
> The Brazilian
> Official Provider OpenCms
>

In response to

pgsql-jdbc by date

Next:From: Віталій ТимчишинDate: 2012-02-15 20:38:48
Subject: Re: non-trivial finalize() on AbstractJdbc2Statement
Previous:From: Deiverson SilveiraDate: 2012-02-15 20:10:52
Subject: Re: Problem for access schema in postgresl via JDBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group