Win a copy of Java 9 Modularity: Patterns and Practices for Developing Maintainable Applications this week in the Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

selecting nexval from a db sequence  RSS feed

 
Yellapa Adepu
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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,
 
Mark Spritzler
ranger
Sheriff
Posts: 17309
11
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!