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.