Postgres Pro
Downloads
Home   >   mailing lists

Thread: Problem for access schema in postgresl via JDBC

Problem for access schema in postgresl via JDBC

From
Deiverson Silveira
Date:
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:

Regards,

Deiverson

--
The Brazilian 
Official Provider OpenCms

Re: Problem for access schema in postgresl via JDBC

From
Dave Cramer
Date:
On Wed, Feb 15, 2012 at 8:43 AM, Deiverson Silveira
<deiverson@solutioncms.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

Re: Problem for access schema in postgresl via JDBC

From
Dave Cramer
Date:
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@solutioncms.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@fastcrypt.com>
>>
>> On Wed, Feb 15, 2012 at 8:43 AM, Deiverson Silveira
>> <deiverson@solutioncms.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
>

Re: Problem for access schema in postgresl via JDBC

From
Deiverson Silveira
Date:
Do you have any knowledge to solve this issue? Definition of connection toa schema through the string? 

Regards,

Deiverson

2012/2/15 Dave Cramer <pg@fastcrypt.com>
On Wed, Feb 15, 2012 at 8:43 AM, Deiverson Silveira
<deiverson@solutioncms.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



--
The Brazilian 
Official Provider OpenCms

Re: Problem for access schema in postgresl via JDBC

From
Deiverson Silveira
Date:
http://archives.postgresql.org/pgsql-jdbc/2002-12/msg00187.php 

and others links in google... but dont work....

2012/2/15 Dave Cramer <pg@fastcrypt.com>
On Wed, Feb 15, 2012 at 8:43 AM, Deiverson Silveira
<deiverson@solutioncms.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



--
The Brazilian 
Official Provider OpenCms

Re: Problem for access schema in postgresl via JDBC

From
Віталій Тимчишин
Date:
You can set search_path for given user with "alter user set search_path"

2012/2/15 Deiverson Silveira <deiverson@solutioncms.com>
Do you have any knowledge to solve this issue? Definition of connection toa schema through the string? 

Regards,

Deiverson

2012/2/15 Dave Cramer <pg@fastcrypt.com>
On Wed, Feb 15, 2012 at 8:43 AM, Deiverson Silveira
<deiverson@solutioncms.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



--
The Brazilian 
Official Provider OpenCms




--
Best regards,
 Vitalii Tymchyshyn