There seems to also be a similar upper/lower case issue swith "call
next value for admin.job_seq" syntax.
This is generated by Hibernate, so I can't employ the work-around you
posted above. I am using the latest
from SVN with hibernate 3.3.1.GA, and hibernate-annotations 3.4.0.ga.
org.springframework.jdbc.UncategorizedSQLException: Hibernate
operation: could not get next sequence value; uncategorized
SQLException for SQL [call next value for admin.job_seq]; SQL state
[90079]; error code [90079]; Schema ADMIN not found; SQL statement:
call next value for admin.job_seq [90079-102]; nested exception is
org.h2.jdbc.JdbcSQLException: Schema ADMIN not found; SQL statement:
call next value for admin.job_seq [90079-102]
Caused by: org.h2.jdbc.JdbcSQLException: Schema ADMIN not found; SQL
statement:
call next value for admin.job_seq [90079-102]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.getSQLException(Message.java:114)
at org.h2.message.Message.getSQLException(Message.java:77)
at org.h2.command.Parser.getSchema(Parser.java:596)
at org.h2.command.Parser.readSequence(Parser.java:4224)
at org.h2.command.Parser.readTerm(Parser.java:2222)
at org.h2.command.Parser.readFactor(Parser.java:1835)
at org.h2.command.Parser.readSum(Parser.java:1822)
at org.h2.command.Parser.readConcat(Parser.java:1795)
at org.h2.command.Parser.readCondition(Parser.java:1668)
at org.h2.command.Parser.readAnd(Parser.java:1648)
at org.h2.command.Parser.readExpression(Parser.java:1640)
at org.h2.command.Parser.parserCall(Parser.java:3540)
at org.h2.command.Parser.parsePrepared(Parser.java:323)
at org.h2.command.Parser.parse(Parser.java:288)
at org.h2.command.Parser.parse(Parser.java:260)
at org.h2.command.Parser.prepareCommand(Parser.java:232)
at org.h2.engine.Session.prepareLocal(Session.java:352)
at org.h2.engine.Session.prepareCommand(Session.java:313)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:
1042)
at
org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:
72)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:
219)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:
497)
at
org.hibernate.jdbc.AbstractBatcher.prepareSelectStatement(AbstractBatcher.java:
123)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:
73)
at
org.hibernate.id.SequenceHiLoGenerator.generate(SequenceHiLoGenerator.java:
58)
at
org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:
99)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:
187)
at
org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:
33)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:
172)
at
org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:
27)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:
70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.orm.hibernate3.HibernateTemplate
$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1202)
at $Proxy42.save(Unknown Source)
at com.example.ips.report.data.dao.admin.JobDaoHib
$5.doInHibernate(JobDaoHib.java:90)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:
372)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:
338)
at
com.example.ips.report.data.dao.admin.JobDaoHib.createJob(JobDaoHib.java:
86)
at
com.example.ips.report.data.dao.admin.JobDaoUnitTest.testGetAllJobs(JobDaoUnitTest.java:
67)
Thanks
On Oct 27, 5:02 pm, "Thomas Mueller" <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> > That new syntax does the trick, thanks. I notice that the case seems
> > to matter.
>
> Yes, this syntax is case sensitive. The regular nextval('...') is not
> however (and will not be).
>
> > The case
> > does not seem to matter in "create sequence" or "create schema".
>
> That's because the database converts unquoted names to uppercase. See also:
>
> http://www.h2database.com/html/grammar.html#namehttp://www.h2database.com/html/grammar.html#quotedname
>
> > I confess ignorance as to how this should actually work in standard SQL,
> > but it is a surprise.
>
> As far as I know, H2 works like defined by the SQL standard. Other
> databases work differently.
>
> > I work out of svn, so I'll keep an eye out for that fix.
>
> It is now in the SVN.
>
> Regards,
> Thomas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
