JDBC PreparedStatement crashing the Database!!
Hi, I recently faced an issue with MonetDB JDBC PreparedStatement. I have a table with 15 columns out of which 14 are foreign keys to columns in another 14 tables. When I try to insert a valid record (that satisfies all the FK relations) using PreparedStatement, the database gets crashed while executing the line, preparedStatement = connection.prepareStatement(sqlString); On trial and error testing, I found that this works very fine until a table has 13 FK relations. If the tables has 14 FKs, then the database crashes. On a brighter side, this operation works very fine in terminal (mclient) with 14 FKs even. Is there any limit on the FKs with prepared statement? Or what am I doing wrong here? Any help much appreciated. Thanks in advance. Regards, Vijayakrishna.P. Mobile : (+91) 9500402305.
Hello,
Am I the only one facing this problem?
What am I missing here?
Thanks & Regards,
Vijayakrishna.P.
Mobile : (+91) 9500402305.
On Fri, Jun 26, 2015 at 4:09 PM, Vijay Krishna
Hi,
I recently faced an issue with MonetDB JDBC PreparedStatement.
I have a table with 15 columns out of which 14 are foreign keys to columns in another 14 tables.
When I try to insert a valid record (that satisfies all the FK relations) using PreparedStatement, the database gets crashed while executing the line,
preparedStatement = connection.prepareStatement(sqlString); On trial and error testing, I found that this works very fine until a table has 13 FK relations. If the tables has 14 FKs, then the database crashes.
On a brighter side, this operation works very fine in terminal (mclient) with 14 FKs even.
Is there any limit on the FKs with prepared statement? Or what am I doing wrong here?
Any help much appreciated. Thanks in advance.
Regards,
Vijayakrishna.P. Mobile : (+91) 9500402305.
On Mon, Jun 29, 2015 at 11:43:28AM +0530, Vijay Krishna wrote:
Hello,
Am I the only one facing this problem?
Vijay Could you report your bug on the bugs.monetdb.org bugtracker? Preferably including example sql code? Niels
What am I missing here?
Thanks & Regards,
Vijayakrishna.P. Mobile : (+91) 9500402305.
On Fri, Jun 26, 2015 at 4:09 PM, Vijay Krishna < vijayakrishna55@gmail.com> wrote:
Hi,
I recently faced an issue with MonetDB JDBC PreparedStatement.
I have a table with 15 columns out of which 14 are foreign keys to columns in another 14 tables.
When I try to insert a valid record (that satisfies all the FK relations) using PreparedStatement, the database gets crashed while executing the line,
preparedStatement = connection.prepareStatement(sqlString);
On trial and error testing, I found that this works very fine until a table has 13 FK relations. If the tables has 14 FKs, then the database crashes.
On a brighter side, this operation works very fine in terminal (mclient) with 14 FKs even.
Is there any limit on the FKs with prepared statement? Or what am I doing wrong here?
Any help much appreciated. Thanks in advance.
Regards,
Vijayakrishna.P. Mobile : (+91) 9500402305.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl
participants (2)
-
Niels Nes -
Vijay Krishna