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.