From derby-user-return-15013-apmail-db-derby-user-archive=db.apache.org@db.apache.org Mon Apr 29 13:48:21 2013 Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A3DAD1030C for ; Mon, 29 Apr 2013 13:48:21 +0000 (UTC) Received: (qmail 46661 invoked by uid 500); 29 Apr 2013 13:48:21 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 45964 invoked by uid 500); 29 Apr 2013 13:48:15 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 45618 invoked by uid 99); 29 Apr 2013 13:48:13 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 29 Apr 2013 13:48:13 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE X-Spam-Check-By: apache.org Received-SPF: error (nike.apache.org: local policy) Received: from [80.12.242.126] (HELO smtp.smtpout.orange.fr) (80.12.242.126) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 29 Apr 2013 13:48:05 +0000 Received: from mail.qualiformed.com ([80.11.238.124]) by mwinf5d27 with ME id VpnP1l00P2hjbLo03pnQle; Mon, 29 Apr 2013 15:47:24 +0200 Received: from SRV-EXCHANGE.qualiformed.lan ([fe80::b836:e434:fc11:6d39]) by srv-exchange.qualiformed.lan ([fe80::b836:e434:fc11:6d39%10]) with mapi id 14.02.0247.003; Mon, 29 Apr 2013 15:45:04 +0200 From: Guillaume CHAUVET To: "'derby-user@db.apache.org'" Subject: CallableStatement: SYSCS_(S/G)ET_DATABASE_PROPERTY behaviours Thread-Topic: CallableStatement: SYSCS_(S/G)ET_DATABASE_PROPERTY behaviours Thread-Index: Ac5E36UqMTKDvrx/QJ+t8nGIN428tw== Date: Mon, 29 Apr 2013 13:45:03 +0000 Message-ID: Accept-Language: fr-FR, en-US Content-Language: fr-FR X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [fe80::9c2d:2cc7:b023:2ee3] Content-Type: multipart/mixed; boundary="_004_AC7EE6BD73B6B247A98C4FA5571DBDB91DAEC0E7srvexchangequal_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_004_AC7EE6BD73B6B247A98C4FA5571DBDB91DAEC0E7srvexchangequal_ Content-Type: multipart/alternative; boundary="_000_AC7EE6BD73B6B247A98C4FA5571DBDB91DAEC0E7srvexchangequal_" --_000_AC7EE6BD73B6B247A98C4FA5571DBDB91DAEC0E7srvexchangequal_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello Derby users ! I encountered some difficulties with Derby and CallableStatement. In my cas= e, I try to save a custom property into DB Derby properties (A database int= ernal version number). To do that, I use SYSCS_SET_DATABASE_PROPERTY and SYSCS_GET_DATABASE_PROPER= TY functions. Below, the SQL requests successfully executed from the default Netbeans SQL= plugin : =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('softrev', '1.0.0'); >Executed successfully in 0,001 s, 0 rows affected. >Line 1, column 1 VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('softrev'); >Executed successfully in 0 s. >Line 2, column 1 >1# '1.0.0' (the expected result). Now, I tried to do the same thing in Java (see the attached unitary test) ,= but nothing happens as expected... Attached, please find a maven draft with a unitary test that reproduce the = unexpected behaviour. Regards, Guillaume --_000_AC7EE6BD73B6B247A98C4FA5571DBDB91DAEC0E7srvexchangequal_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello Derby users !

 

I encountered some difficulties with Derby and Calla= bleStatement. In my case, I try to save a custom property into DB Derby pro= perties (A database internal version number).

To do that, I use SYSCS_SET_DATABASE_PROPERTY and SY= SCS_GET_DATABASE_PROPERTY functions.

Below, the SQL requests successfully executed from t= he default Netbeans SQL plugin :

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('softrev= ', '1.0.0');

>Executed successfully in 0,001 s, 0 rows affecte= d.

>Line 1, column 1

VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('softr= ev');

>Executed successfully in 0 s.

>Line 2, column 1

>1#  ‘1.0.0’   &n= bsp;            = ;         (the expected result).

 

Now, I tried to do the same thing in Java (see the a= ttached unitary test) , but nothing happens as expected…

 

Attached, please find a maven draft with a unitary t= est that reproduce the unexpected behaviour.

 

Regards,

Guillaume

--_000_AC7EE6BD73B6B247A98C4FA5571DBDB91DAEC0E7srvexchangequal_-- --_004_AC7EE6BD73B6B247A98C4FA5571DBDB91DAEC0E7srvexchangequal_ Content-Type: application/x-zip-compressed; name="DERBY-CALLSTATEMENT.zip" Content-Description: DERBY-CALLSTATEMENT.zip Content-Disposition: attachment; filename="DERBY-CALLSTATEMENT.zip"; size=3727; creation-date="Mon, 29 Apr 2013 13:25:55 GMT"; modification-date="Mon, 29 Apr 2013 13:25:55 GMT" Content-Transfer-Encoding: base64 UEsDBBQAAAAAADF7nUIAAAAAAAAAAAAAAAAUAAAAREVSQlktQ0FMTFNUQVRFTUVOVC9QSwMEFAAA AAgAtnWdQvIb1O9/AQAABgQAABsAAABERVJCWS1DQUxMU1RBVEVNRU5UL3BvbS54bWyNUsFuwjAM vU/aP1TcmxS2A0JZb5s0CTQktmnXkJgS1iZdklL4+4U2bYCKaTklz8/xs59JqdUOmI0ORS7N02hr bTnDuKB7kIiWlG0BKZ3h5dsCP6IEJaOWOTsY0bPrukb1Q8ObJMkYfy3mK5dY0FhIY6lkMLq/i7rj MmemCc8Vo1Yo+Y+y0S3GwfAWjBsecu9R2lYjheKQf4I2rkbahAk+xxzPMzOtqvKVp0wV6Keiudgo XQBHHPT6iCwYS3DH8SlUW7GhzDqkYcVukiVoeyS4CwXy3hcctyL8s4u6br5pJmSW7qgmuH8GfZIW kK6s0hAtfZlISKuiU2lXsYl7bqXz9Ma0CHbB8KtXLMCccv3pNgKtK5FzZFSlGTxLpvhJ0cf7Szwl +E+O/x0PviccSpAcJAvYJX48Qy+M2VVSXHoQTvAiEDtkyN33+zAOTlyTDHPS09b35n6uFl/JHbYw kO9m39nQOjbsZLhRN7oIy5SgKZqgyXUXQ4kBCsPvTXT3X1BLAwQUAAAAAAD7ep1CAAAAAAAAAAAA AAAAGAAAAERFUkJZLUNBTExTVEFURU1FTlQvc3JjL1BLAwQUAAAAAAD7ep1CAAAAAAAAAAAAAAAA HQAAAERFUkJZLUNBTExTVEFURU1FTlQvc3JjL21haW4vUEsDBBQAAAAAALF1nUIAAAAAAAAAAAAA AAAnAAAAREVSQlktQ0FMTFNUQVRFTUVOVC9zcmMvbWFpbi9yZXNvdXJjZXMvUEsDBBQAAAAAAPt6 nUIAAAAAAAAAAAAAAAAdAAAAREVSQlktQ0FMTFNUQVRFTUVOVC9zcmMvdGVzdC9QSwMEFAAAAAAA +3qdQgAAAAAAAAAAAAAAACIAAABERVJCWS1DQUxMU1RBVEVNRU5UL3NyYy90ZXN0L2phdmEvUEsD BBQAAAAAAPt6nUIAAAAAAAAAAAAAAAAmAAAAREVSQlktQ0FMTFNUQVRFTUVOVC9zcmMvdGVzdC9q YXZhL2NvbS9QSwMEFAAAAAAA+3qdQgAAAAAAAAAAAAAAADIAAABERVJCWS1DQUxMU1RBVEVNRU5U L3NyYy90ZXN0L2phdmEvY29tL3F1YWxpZm9ybWVkL1BLAwQUAAAAAAD7ep1CAAAAAAAAAAAAAAAA OAAAAERFUkJZLUNBTExTVEFURU1FTlQvc3JjL3Rlc3QvamF2YS9jb20vcXVhbGlmb3JtZWQvZGVy YnkvUEsDBBQAAAAAAPt6nUIAAAAAAAAAAAAAAAA9AAAAREVSQlktQ0FMTFNUQVRFTUVOVC9zcmMv dGVzdC9qYXZhL2NvbS9xdWFsaWZvcm1lZC9kZXJieS90ZXN0L1BLAwQUAAAACADOep1C85WAXOYD AADKCQAAUwAAAERFUkJZLUNBTExTVEFURU1FTlQvc3JjL3Rlc3QvamF2YS9jb20vcXVhbGlmb3Jt ZWQvZGVyYnkvdGVzdC9UZXN0RGVyYnlQcm9wZXJ0eS5qYXZhtVbfb9owEH6v1P/hxlOYWNj2WFRt GWQbWgeIZN36VJnkAHfBTm2HDFX933d2CIGOddN+ICSIfd/d9913NnSfnp7AU7jgCQqNKRgJZokQ 5Cyhj0jOTckUwltZiJQZLgV4QfS2DfSICqRAB5cKVpLCEimM4rPC0EJWpQS2UIgrFEb7ABGiyz8a x8N+CHOeVQlSrisgUSi5WVIQ11BK9RXmlIulKbfFWQZc0MLKUXFIhQumUi4WVDzfKL5YGpClQKWX PKeKMVUjxjUd7TLvClu9G1ls5TTK64Z04JIyWdkv/efgUYBDtbbbrXbPwVdsA0IaKDQ2+QG/JZgb YkzUVnnGmUgcfKuwqUI0r7ZZ5MwwAjCrhp7mVVjdSmPhLsXSmPys2y3L0meOsS/VoluL7F5Qd0dR +IxY7yCfRIZaU8NuC66oz7MNsDwnCJsR2YyVZKNzy42BpV0qbqizHQfX21nY92rXt4Yj1wcBkrSI qmdBBMOoBW+CaBh14PMwfj/+FMPnYDoNRvEwjGA8hf54NBjGw/GInt5CMLpy0A/D0aADyKmOoq7m inRYstx2FdN6rhoWbmhqs3SOCZ/zhCSKRcEWCAu5RiXszOSoVlxbgzXxTGlKVty44dIW2+hrrKKX 3eqenlDfv1I6665/W7CM28kkOgSZbXyD2vROT05PiKVUBm7Ymvn6NvP7LMtsyyMq5A5G70iMFAIT y+PI5kBx4v+RCSqujuzHmxx1s06DsZ2RLbObdJb44WqGaYppleww+qYQ3PhPm0Vte5Ls7QVao6pC qA/FLKPdJGNkS0yyB7bMRMmcYjZwZ2Ns23IqRZLrbJFR1oLLcBqR4dfjSQzn0LJjpnDd6j2GCb9M wn4cDq63YAt84T/3n/8E1rTTXlG9mtDrN0iWYd8Sr1YqKTVsLTkdkybGa9MoKFlqCO3RdvnuCLh9 HbbUd/3wBZZDQfno7Hvt3i7Y8iDWB1b6CzQNU69lfTpzlp2tkO7XzZmbqUQhSTs3qsBWnfF+JymY G1SPK9JomI36HU18Dp6l+uQcRJFl7d1eI4OESn0o7v4hKzsVDZ+aiJUTsTVu79h6Yn5B6YfzAwmt wLnjQndDTpeUjfFa/eDiAqKrqB9df4qHF371NQrj60EQB3QRhdeT6XgSTuMr71UHXrVb+yKM2jxQ 6wr51L5qDL0Xnf3pJexjwS87P4ztQwRzpyomYz0Hxm+YFIZae9Bb+nERtHuU3N95MUWiiv/Pj7tX tHrclHfHTWnf/5Yl9CeAa5rocWEmTLEV0nfrjrsJ/ctg2n8fTH/tz56Zf2RNExja3wPtPTS8UxVd NBP0j6yl93dQSwECPwAUAAAAAAAxe51CAAAAAAAAAAAAAAAAFAAkAAAAAAAAABAAAAAAAAAAREVS QlktQ0FMTFNUQVRFTUVOVC8KACAAAAAAAAEAGACjuDMG3UTOAaO4MwbdRM4BAtTnytxEzgFQSwEC PwAUAAAACAC2dZ1C8hvU738BAAAGBAAAGwAkAAAAAAAAACAAAAAyAAAAREVSQlktQ0FMTFNUQVRF TUVOVC9wb20ueG1sCgAgAAAAAAABABgAAIysdtdEzgFovujK3ETOAWi+6MrcRM4BUEsBAj8AFAAA AAAA+3qdQgAAAAAAAAAAAAAAABgAJAAAAAAAAAAQAAAA6gEAAERFUkJZLUNBTExTVEFURU1FTlQv c3JjLwoAIAAAAAAAAQAYAJsz6crcRM4BmzPpytxEzgF55ejK3ETOAVBLAQI/ABQAAAAAAPt6nUIA AAAAAAAAAAAAAAAdACQAAAAAAAAAEAAAACACAABERVJCWS1DQUxMU1RBVEVNRU5UL3NyYy9tYWlu LwoAIAAAAAAAAQAYAIoM6crcRM4BigzpytxEzgF55ejK3ETOAVBLAQI/ABQAAAAAALF1nUIAAAAA AAAAAAAAAAAnACQAAAAAAAAAEAAAAFsCAABERVJCWS1DQUxMU1RBVEVNRU5UL3NyYy9tYWluL3Jl c291cmNlcy8KACAAAAAAAAEAGAAAq7Zw10TOAYoM6crcRM4BigzpytxEzgFQSwECPwAUAAAAAAD7 ep1CAAAAAAAAAAAAAAAAHQAkAAAAAAAAABAAAACgAgAAREVSQlktQ0FMTFNUQVRFTUVOVC9zcmMv dGVzdC8KACAAAAAAAAEAGACsWunK3ETOAaxa6crcRM4BmzPpytxEzgFQSwECPwAUAAAAAAD7ep1C AAAAAAAAAAAAAAAAIgAkAAAAAAAAABAAAADbAgAAREVSQlktQ0FMTFNUQVRFTUVOVC9zcmMvdGVz dC9qYXZhLwoAIAAAAAAAAQAYAL2B6crcRM4BvYHpytxEzgGsWunK3ETOAVBLAQI/ABQAAAAAAPt6 nUIAAAAAAAAAAAAAAAAmACQAAAAAAAAAEAAAABsDAABERVJCWS1DQUxMU1RBVEVNRU5UL3NyYy90 ZXN0L2phdmEvY29tLwoAIAAAAAAAAQAYAM6o6crcRM4BzqjpytxEzgG9genK3ETOAVBLAQI/ABQA AAAAAPt6nUIAAAAAAAAAAAAAAAAyACQAAAAAAAAAEAAAAF8DAABERVJCWS1DQUxMU1RBVEVNRU5U L3NyYy90ZXN0L2phdmEvY29tL3F1YWxpZm9ybWVkLwoAIAAAAAAAAQAYAN/P6crcRM4B38/pytxE zgHOqOnK3ETOAVBLAQI/ABQAAAAAAPt6nUIAAAAAAAAAAAAAAAA4ACQAAAAAAAAAEAAAAK8DAABE RVJCWS1DQUxMU1RBVEVNRU5UL3NyYy90ZXN0L2phdmEvY29tL3F1YWxpZm9ybWVkL2RlcmJ5LwoA IAAAAAAAAQAYAPD26crcRM4B8PbpytxEzgHfz+nK3ETOAVBLAQI/ABQAAAAAAPt6nUIAAAAAAAAA AAAAAAA9ACQAAAAAAAAAEAAAAAUEAABERVJCWS1DQUxMU1RBVEVNRU5UL3NyYy90ZXN0L2phdmEv Y29tL3F1YWxpZm9ybWVkL2RlcmJ5L3Rlc3QvCgAgAAAAAAABABgAEkXqytxEzgESRerK3ETOAfD2 6crcRM4BUEsBAj8AFAAAAAgAznqdQvOVgFzmAwAAygkAAFMAJAAAAAAAAAAgAAAAYAQAAERFUkJZ LUNBTExTVEFURU1FTlQvc3JjL3Rlc3QvamF2YS9jb20vcXVhbGlmb3JtZWQvZGVyYnkvdGVzdC9U ZXN0RGVyYnlQcm9wZXJ0eS5qYXZhCgAgAAAAAAABABgAAEJcmNxEzgESRerK3ETOARJF6srcRM4B UEsFBgAAAAAMAAwAwgUAALcIAAAAAA== --_004_AC7EE6BD73B6B247A98C4FA5571DBDB91DAEC0E7srvexchangequal_--