RE: issue wtih foreign keys

2017-03-17 Thread mathieu ferlay
é : vendredi 17 mars 2017 08:02 À : user@trafodion.incubator.apache.org Objet : RE: issue wtih foreign keys Hi everybody, Thanks to all for your help. So I’ll waiting for the 2.1 and see the behavior. Regards, Mathieu De : Sandhya Sundaresan [mailto:sandhya.sundare...@esgyn.com] En

RE: issue wtih foreign keys

2017-03-17 Thread mathieu ferlay
Hi everybody, Thanks to all for your help. So I’ll waiting for the 2.1 and see the behavior. Regards, Mathieu De : Sandhya Sundaresan [mailto:sandhya.sundare...@esgyn.com] Envoyé : jeudi 16 mars 2017 18:12 À : user@trafodion.incubator.apache.org Objet : RE: issue wtih foreign keys

RE: issue wtih foreign keys

2017-03-16 Thread Sandhya Sundaresan
@trafodion.incubator.apache.org Subject: Re: issue wtih foreign keys Hi Dave and Eric, I wonder if providing Mathieu with the latest Trafodion is an option. I did not recall similar bugs in this area. Thanks --Qifan From: Dave Birdsall mailto:dave.birds...@esgyn.com

Re: issue wtih foreign keys

2017-03-16 Thread Qifan Chen
: RE: issue wtih foreign keys So, evidently this is a bug that has been fixed? I wonder if we can find a JIRA reference. From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Thursday, March 16, 2017 8:55 AM To: user@trafodion.incubator.apache.org Subject: RE: issue wtih foreign keys With

RE: issue wtih foreign keys

2017-03-16 Thread Anoop Sharma
@trafodion.incubator.apache.org Subject: RE: issue wtih foreign keys So, evidently this is a bug that has been fixed? I wonder if we can find a JIRA reference. From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Thursday, March 16, 2017 8:55 AM To: user@trafodion.incubator.apache.org<mailto:u

RE: issue wtih foreign keys

2017-03-16 Thread Dave Birdsall
So, evidently this is a bug that has been fixed? I wonder if we can find a JIRA reference. From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Thursday, March 16, 2017 8:55 AM To: user@trafodion.incubator.apache.org Subject: RE: issue wtih foreign keys With trafci on latest of esgynDB

RE: issue wtih foreign keys

2017-03-16 Thread Eric Owhadi
trafci... maybe the behavior is different? Dave From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Thursday, March 16, 2017 8:25 AM To: user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org> Subject: RE: issue wtih foreign keys Are you saying that autocommit is o

RE: issue wtih foreign keys

2017-03-16 Thread mathieu ferlay
Hi Dave, I’m using the version of the docker image trafodion\incubator and I believe it’s the 2.0.0 . Regards, Mathieu De : Dave Birdsall [mailto:dave.birds...@esgyn.com] Envoyé : jeudi 16 mars 2017 16:26 À : user@trafodion.incubator.apache.org Objet : RE: issue wtih foreign keys Hi

RE: issue wtih foreign keys

2017-03-16 Thread mathieu ferlay
. Regards, Mathieu De : Eric Owhadi [mailto:eric.owh...@esgyn.com] Envoyé : jeudi 16 mars 2017 16:25 À : user@trafodion.incubator.apache.org Objet : RE: issue wtih foreign keys Are you saying that autocommit is off, and you are executing the 3 ddl statement then manual commit? Then you see

RE: issue wtih foreign keys

2017-03-16 Thread Dave Birdsall
maybe the behavior is different? Dave From: Eric Owhadi [mailto:eric.owh...@esgyn.com] Sent: Thursday, March 16, 2017 8:25 AM To: user@trafodion.incubator.apache.org Subject: RE: issue wtih foreign keys Are you saying that autocommit is off, and you are executing the 3 ddl statement then manu

RE: issue wtih foreign keys

2017-03-16 Thread Dave Birdsall
or me. Dave From: mathieu ferlay [mailto:mfer...@gnubila.fr] Sent: Thursday, March 16, 2017 7:46 AM To: user@trafodion.incubator.apache.org Subject: RE: issue wtih foreign keys Hi again, I don't know if explain my process will help but maybe: try (Connection connection = DriverManager.get

RE: issue wtih foreign keys

2017-03-16 Thread Eric Owhadi
[mailto:mfer...@gnubila.fr] Sent: Thursday, March 16, 2017 9:46 AM To: user@trafodion.incubator.apache.org Subject: RE: issue wtih foreign keys Hi again, I don't know if explain my process will help but maybe: try (Connection connection = DriverManager.getConnection(dbUrl, dbUser,

RE: issue wtih foreign keys

2017-03-16 Thread mathieu ferlay
equest. I start to think that’s due to the autocommit and so by consequence the “database” access. Regards, Mathieu De : mathieu ferlay [mailto:mfer...@gnubila.fr] Envoyé : jeudi 16 mars 2017 15:02 À : user@trafodion.incubator.apache.org Objet : RE: issue wtih foreign keys Hi, I h

RE: issue wtih foreign keys

2017-03-16 Thread mathieu ferlay
Hi, I have change my request by using alter table do it but I still have some “lost” of process. It’s look like an infinite loop inside the execute statement. I don’t know what it could causes that. Regards, Mathieu De : mathieu ferlay [mailto:mfer...@gnubila.fr] Envoyé : jeudi 16 mars