In line 23 you are executing a SQL statement but in line 25 you are reading from an XML file, so I would think the data you are seeing is from the XML file, not the SQL. I'm not sure why you would ever want to do this. What are you trying to do?
All things are lawful, but not all things are profitable.
posted 4 months ago
I’m setting my WebRowSet object to a “Select” command and emp1 table is empty.
So, at this moment my WebRowSet object is empty.
Next, i’m reading from an xml file (containing employee data which i wrote using wrs.writeXml() in another program) into this WebRowSet object. So, my WebRowSet now contains employee data which i’m able to print to console.
Since WebRowSet is updatable by default i’m expecting this data in emp1 table.
But, this ain’t happening in the first piece of code where auto commit is on by default.
When i turn off auto commit and accept changes explicitly then the data is reflecting in emp1 table.
I’m wondering why the first piece of code is not working since all rowsets are updatable by default