Hello,
I try to write to our oracle database using query like:
MERGE INTO DAT_TESTJ7_DS_TBL A USING (SELECT 6 PID, 4000000 GENTIME, 4000001
VALUE, 1240554681091 STORAGETIME, 1 VALIDITY FROM DUAL) B ON (A.PID = B.PID AND
A.GENTIME = B.GENTIME)WHEN MATCHED THEN UPDATE SET A.VALUE = B.VALUE WHEN NOT
MATCHED THEN INSERT (PID,GENTIME,VALUE,STORAGETIME,VALIDITY) VALUES
(B.PID,B.GENTIME,B.VALUE,B.STORAGETIME,B.VALIDITY)
It works fine, I don't get any oracle/soci exception, but:
The select query on this table (from iSQLPlus-client) shows, that the data
were not stored to the database.
What could be a reason for it:
Do I need to close the connection to the database explicitly?
The read-access to the database via soci works fine.
Many thanks and kind regards,
Anna Pitaev
Anna Pitaev
_________________________________________
Logica - Releasing your potential
Logica Deutschland GmbH & Co. KG
Rheinstrasse 95
64295 Darmstadt
Germany
Tel.: +49 6151 36860-121
E-Mail: [email protected]
www.logica.com
Logica Deutschland GmbH & Co. KG
Zettachring 4, 70567 Stuttgart; Amtsgericht Stuttgart HRA 722072
Persönlich haftender Gesellschafter: Logica Verwaltungs GmbH
Geschäftsführer: Torsten Straß (Vors.) / Dr. Thomas Elsner / Eric Guyot /
Andreas Manganaro / Olaf Scholz / Oliver Starzonek; Handelsregister AG
Stuttgart HRB 724084
Please help Logica to respect the environment by not printing this email /
Pour contribuer comme Logica au respect de l'environnement, merci de ne pas
imprimer ce mail / Bitte drucken Sie diese Nachricht nicht aus und helfen Sie
so Logica dabei die Umwelt zu schuetzen / Por favor ajude a Logica a
respeitar o ambiente nao imprimindo este correio electronico.
This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an intended
recipient then please promptly delete this e-mail and any attachment and all
copies and inform the sender. Thank you.
------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today.
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
