openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From get_it_done <dude.on.j...@gmail.com>
Subject Re: Access Oracle Sequence using OpenJPA
Date Thu, 29 Jan 2009 20:32:48 GMT

Thanks for the below suggestion.

More inclined towards openJPA approach.

Can you provide more details as to how to let spring inject the below JDBC
configuration into a DAO class.




Alexey Ousov wrote:
> 
> Hello.
> This one works fine with Oracle:
> Number n = (Number)session.createNativeQuery("SELECT SEQ.NEXTVAL from 
> dual").getUniqueResult();
> 
> This one uses custom OpenJPA features, but works with any database (not 
> just Oracle):
> factory = Persistence.createEntityManagerFactory("store");
> configuration = 
> (JDBCConfiguration)((OpenJPAEntityManagerFactorySPI)factory).getConfiguration();
> String format = configuration.getDBDictionaryInstance().nextSequenceQuery;
> String query = MessageFormat.format(format, new Object[]{
> "SEQENCE_NAME"});
> Number n = (Number)session.createNativeQuery(query).getUniqueResult();
>> My environment: JBOSS 4.2.1, OpenJPA 1.1, Java 5, EJB 3 (+JPA), Oracle
>> 10g
>>
>> I need to access custom Oracle Sequence using OpenJpa. 
>> Only need the next value from the sequence. I dont need to slap that next
>> value
>> as id on any entity. 
>>
>> SELECT SEQ.NEXTVAL from dual; 
>>
>> Most probably create a DAO service which will just return the next
>> sequence
>>
>> Any suggestions
>>   
> 
> 
> 

-- 
View this message in context: http://n2.nabble.com/Access-Oracle-Sequence-using-OpenJPA-tp2227943p2241109.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.


Mime
View raw message