Re: JDBC PreparedStatement crashing the Database!!

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