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

Re: connection variables problem

From: "Badawy, Mohamed" <Mohamed(dot)Badawy(at)ams-europe(dot)com>
To: "Kris Jurka" <books(at)ejurka(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: connection variables problem
Date: 2007-05-06 07:14:16
Message-ID: 8EF82CD876C6F2439EBF55C5A1D9061A429E97@amsmamx01.mannheim-germany.europe.ams.local (view raw or flat)
Thread:
Lists: pgsql-jdbc
In my case am using dbunit testing. Also I got a selfjoin in a table. So
in deleting the records in that table it fires an exception.

Thnx for ur reply

-----Original Message-----
From: Kris Jurka [mailto:books(at)ejurka(dot)com] 
Sent: Friday, May 04, 2007 7:16 PM
To: Badawy, Mohamed
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] connection variables problem



On Wed, 2 May 2007, Badawy, Mohamed wrote:

> Am working using maven framework I want to connect to the DB with no
> foreign key checking in mysql I use to write (Connection
jdbcConnection
> = DriverManager.getConnection(
>
>
"jdbc:postgresql://localhost:5432/post?sessionVariables=FOREIGN_KEY_CHEC
> KS=0", "aaa", "aaa");)
>
> I want the corresponding to in postgresql

Postgresql does not offer a similar feature and I see no reason that it 
should.  Why would you possibly want to disable your foreign keys? 
Perhaps you should be using deferred foreign keys instead?

Kris Jurka


THIS EMAIL AND ANY ATTACHED FILES ARE CONFIDENTIAL. 
If you are not the intended recipient you are notified that any disclosure, reproduction,copying, distribution, or action taken in reliance on the contents of this information is strictly prohibited. If you have received this transmission in error please notify the sender immediately and then delete this email. Email transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted, lost, destroyed,arrive late or incomplete, or contain viruses. The company/sender accepts no liability for any changes made to this email during transmission or any damage caused by any virus transmitted by this email. Any views or opinions expressed in this email are solely those of the author and do not necessarily represent those of the company. The company/sender accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing.

------------------------------------------------------------------------------------------
AMS Advanced Medical Services GmbH, Mannheim
Registered office: Am Exerzierplatz 2, 68167 Mannheim
Register court: Amtsgericht Mannheim, HRB 7462
Managing Director: Dr. Christian Carls
------------------------------------------------------------------------------------------


In response to

pgsql-jdbc by date

Next:From: romanDate: 2007-05-07 06:15:25
Subject: postgresql-8.2-504.jdbc4.jar and backslash
Previous:From: Dave CramerDate: 2007-05-05 17:03:17
Subject: Re: jdbc4 implementation errors building

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