I use the hibernate2.1.3 ,the db is oracle9i.first i using the session.save(obj), then i using the session.find ,it can display the object that i inserted ,but when I using the sqlplus to connection the oralce,execute the sql:select * from cat,no record to find,why?
but when using the mysql db,it's fine,why?
help me,plz,thk!

Did you even commit? (either auto or manual)

yes,I do it with session.flush()

select * from cat; - is specific select on oracle db, cat returns list of tables that you have in your schema on oracle. Are you sure you are not mixing it with your table? (cat is your table?)

in SQL plus try:



schema_name is probably your user_name...

yes,cat is my table.
execute desc cat it display the cat table define:
CAT_ID NOT NULL VARCHAR2(32)
NAME NOT NULL VARCHAR2(16)
SEX NOT NULL VARCHAR2(1)
WEIGHT NOT NULL NUMBER(10,2)

I using the ownter of table to connect the oracle,so do'nt need to add the schema , envn add ,it don't work .

I think the cause is the ehcache, in the frist I can't add the cache,but the initial of hibennate has some wrong,so I add the ehcache.jar to my classpath.
is it any method to set that do'nt using the cache in the hibernate.cfg.xml?
thk very much!

this doesn't commit!!!

1- beginTx
2- do your job
3- optionnal if flushMode = auto, session.flush
4- commitTx

:) As I suspected.....