Simple check. Are you running both JDBC and mclient in parallel? And what are your commit option settings?
Beware that running both in parallel are different users from a database point off view. At least during the transaction.
Sander Kruseman wrote:
Nothing fancy: I use the default user monetdb in both clients, working in the sys schema. I start the JDBC client using:
java -jar "C:\Program Files\CWI\MonetDB5\share\MonetDB\lib\jdbcclient.jar" -l sql -u monetdb (java version "1.6.0_02")
Happy hunting! Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
Romulo,
I can confirm your results when setting up the tables from mclient. But I still get the failure when setting up the tables over JDBC and then delete the parent record from mclient.
Ok I will debug that problem tomorrow morning. I just need to know how do you connect with your JDBC. Which user do you use? The same as mclient? Give me the commands and then I will debug the problem.
Regards, Romulo
(Not that this is my intended way of working. I just stubled upon this, developing my mapi client code and using the JDBC terminal for import of SQL scripts.)
Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
Hi Romulo,
Thanks for your response. I downloaded the latest Windows installer today, and installed on XP.
Me too and everything works fine. I used the SQL client (which is the mclient -lsql) from the start menu to execute the queries on the Mserver5 with SQL module loaded (also from the start menu).
I did a select after the delete and both tables are empty.
You need to find a solution to simulate this in my machine if not I am not able to help you.
Regards, Romulo
# MonetDB server v5.2.0, based on kernel v1.20.0 ... # MonetDB/SQL module v2.20.0 loaded
Good to hear that apparently this has been fixed in the CVS trunk.
Regards, Sander
Romulo Goncalves wrote:
Sander Kruseman wrote:
> Consider the following setup: > > CREATE TABLE parent (key int PRIMARY KEY); > CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE > CASCADE); > > INSERT INTO parent VALUES (1); > INSERT INTO child VALUES (1); > > Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1; > properly results in deletion of both records. > > However, when issued over mapi, either from my custom C++ code or from > the provided Monet SQL client console, the same statement only deletes > the row from 'parent', ignoring the cascading constraint. > I just used my mclient to execute the queries on my MonetDB5 (5.21 current cvs branch) with the SQL module loaded and it works.
Which version are you using and platform?
Regards, Romulo
> Kind regards, > Sander Kruseman > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > MonetDB-users mailing list > MonetDB-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users
>
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users