Hello, Pitaev, Anna wrote:
> I try to write to our oracle database using query like: [...] > 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. Very likely you did not commit your transaction and another user application (iSQLPlus) did not see your data - exactly as it should be. > Do I need to close the connection to the database explicitly? It is enough to commit after you reach the point when you would like to "propagate" your changes to potential other users of the database. Committing in SOCI is very easy: sql.commit(); Regards, -- Maciej Sobczak * www.msobczak.com * www.inspirel.com ------------------------------------------------------------------------------ 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
