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 <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.