Missing Inserted DAta rows..need help!!!

tech_nerd · #1 (**permalink**) 12-13-11, 11:54

Hello folks,

i am currently having an issue with my data not getting persisted properly.

Basically with the code below i am able to insert rows into my table, but the data disappears after few hours. I have no clue why this is happening. Any insight will be appreciated. thank you for ur time.

Code:

 String SQLIns = "insert into xyx values ...";

                String connectionstring = "ConnectionString";
                OracleConnection conn = new OracleConnection(connectionstring);
                conn.Open();
                OracleCommand DbCommand = conn.CreateCommand();
                DbCommand.CommandText = SQLIns;
                DbCommand.ExecuteNonQuery();
                DbCommand.Dispose(); 
                conn.Close();

shammat · #2 (**permalink**) 12-13-11, 11:58

I don't see a commit in that code. Are you committing your changes properly?

If they are intially there and then disappear "after a few hours" apprently some other program is deleting the data. Rows in a table don't just vanish

tech_nerd · #3 (**permalink**) 12-13-11, 12:13

nope i am not commiting the insert. shud'nt i commit only if i use a transaction based sql insert in my code ?

This code is working, but the data jus disappears after few hours. And i am so struck...

anacedent · #4 (**permalink**) 12-13-11, 12:34

COMMIT make DML changes permanent.
without COMMIT other sessions can not see changed data
& DML changes are subject to ROLLBACK

tech_nerd · #5 (**permalink**) 12-13-11, 14:51

Quote:

Originally Posted by anacedent

COMMIT make DML changes permanent.
without COMMIT other sessions can not see changed data
& DML changes are subject to ROLLBACK

ok did this..i will let u know how this goes..thank u

tech_nerd · #6 (**permalink**) 12-16-11, 08:16

Quote:

Originally Posted by anacedent

COMMIT make DML changes permanent.
without COMMIT other sessions can not see changed data
& DML changes are subject to ROLLBACK

ok, tried commiting the data. Again the data vanished overnight. Is there some kind of server setting that might be triggering this data loss.

Also planning on enabling logging for this table and see what making this data disappear...

again, any suggestions/recommendation is welcomed. thank you.

beilstwh · #7 (**permalink**) 12-16-11, 08:38

someone or a scheduled process is removing the data. Oracle will never automatically remove rows

Littlefoot · #8 (**permalink**) 12-16-11, 11:18

If you are using a database / schema that is daily overwritten by its "backup" copy (for example, a schema used by students or a testing database or similar), maybe that's why you are losing your data.

anacedent · #9 (**permalink**) 12-16-11, 20:20

>Again the data vanished overnight.
DBMS_LOGMNR can tell when & which process changed the data.
If you knew these 2 details, you might get closer to the root cause.

Internet Services

Web Development

Digital Marketing

Consumer Tech