aspose file tools
The moose likes Object Relational Mapping and the fly likes selecting nexval from a db sequence Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Reply Bookmark "selecting nexval from a db sequence" Watch "selecting nexval from a db sequence" New topic
Author

selecting nexval from a db sequence

Yellapa Adepu
Ranch Hand

Joined: Jan 17, 2006
Posts: 34
posted private message
0
Quote
when I try to select the NEXTVAL from a DB Sequence entity. Hibernate is appending the logged in user id as a schema rather the schema defined in hibernate.properties.

Any ideas on why it is doing so. Please suggest.

Thanks,

Yellapa Adepu<br />SCEA
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17234
    
    1

I like...
IntelliJ IDE Mac Spring
posted
0
Quote
Can you show the query?

How are you selecting the nextval?

Personally, I would use an SQLQuery object for it and just use the

"select mySeq.nextval from dual" query for it. Just straight SQL.

Mark

Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: selecting nexval from a db sequence
 
Similar Threads
URLyBird: Database schema
What should be the connection URL
Testing of data class instance(s)
using java.util.UUID
Import data from database with sequence as primary key