-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
 Post subject: Mappring ROWID with Hibernate andJPA
PostPosted: Thu Jul 23, 2009 9:24 am 
Newbie

Joined: Thu Nov 22, 2007 11:43 am
Posts: 8
Hello all,
i am using HIbernate with JPA to retrieve data from table MY_TABLE which has followign column
TABLE_NAME VARCHAR
ROW_ID ROWID
EVENT_TYPE VARCHAR
EVENT_TIME TIMESTAMP

I am using Oracle 9

i am unable to map ROWID ..

If i use the java.sql.RowId hibernate complains that it cannot map it
If i use Oracle ROWID, i get a Serlialization exception


could anyone help me out?

thansk and regards
marco


Top
 Profile  
 
 Post subject: Re: Mappring ROWID with Hibernate andJPA
PostPosted: Thu Jul 23, 2009 12:09 pm 
Newbie

Joined: Thu Nov 22, 2007 11:43 am
Posts: 8
Hello
i sorted it by mappign ROWID to a String (instead of LONG as i saw in some hibernate docs)..

does anyone have better solution?

regards
marco


Top
 Profile  
 
 Post subject: Re: Mappring ROWID with Hibernate andJPA
PostPosted: Tue Jul 28, 2009 4:11 am 
Newbie

Joined: Thu Nov 22, 2007 11:43 am
Posts: 8
Hello
rowid is still causing a problemw hen deleting an object...

it gives me an ORA-01722 invalid number exception and i dont know why

copying and pasting the SQL

select * from mytype where
event_type = ? and ROW_ID = ?

works fine when i run the statement from toad (using a string as rowid)..

anyone has any ideas?

i m trying to use java.sql.Rowid but it appears hibernate does not know what it its asi am receiving this exception

Could not determine type for: java.sql.RowId,


regards
marco


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.