hibernate - Any idea why H2 parser throws an exception at Oracle SQL statement "Syntax error in SQL statement "SELECT SUBJECT_SEQ.NEXTVAL FROM[*] DUAL"? -

-

i've following error when injecting entitymanager:

 caused by: org.hibernate.exception.sqlgrammarexception: not prepare statement     @ org.hibernate.exception.internal.sqlstateconversiondelegate.convert (sqlstateconversiondelegate.java:123) [hibernate-core-4.3.5.final.jar:4.3.5.final]     @ org.hibernate.exception.internal.standardsqlexceptionconverter.convert (standardsqlexceptionconverter.java:49) [hibernate-core-4.3.5.final.jar:4.3.5.final]  caused by: org.h2.jdbc.jdbcsqlexception: syntax error in sql statement "select subject_seq.nextval  from[*] dual "; expected "identifier"; sql statement: select subject_seq.nextval dual [42001-173]     @ org.h2.message.dbexception.getjdbcsqlexception(dbexception.java:331)     @ org.h2.message.dbexception.get(dbexception.java:171)     @ org.h2.message.dbexception.getsyntaxerror(dbexception.java:196)     @ org.h2.command.parser.readcolumnidentifier(parser.java:2846)     @ org.h2.command.parser.readtermobjectdot(parser.java:2401)

snippet of persistence.cfg:

    <class>gov.dhs.obim.domain.bm.vendor</class>     <properties>         <property name="hibernate.dialect" value="org.hibernate.dialect.oracle10gdialect"/>         <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.oracledriver"/>         <property name="hibernate.connection.url" value="jdbc:oracle:thin:bm/password@localhost:1521:xe"/>         <property name="hibernate.connection.password" value="password"/>         <property name="hibernate.connection.username" value="obim"/>         <property name="hibernate.show_sql" value="true"/>         <property name="hibernate.format_sql" value="true"/>     </properties>     </persistence-unit>  @transactionattribute(transactionattributetype.required) @stateless   @webservice(targetnamespace = "http://docs.oasis- open.org/org.oasis.bias/ns/org.oasis.bias-1.0/", name = "bias_v1") public class biasv1impl implements biasv1 { @persistencecontext(unitname = "obim_bias2")     entitymanager em;    @override public enrollresponsepackage enroll(enrollrequest enrollrequest)         throws biasfaultmessage {       subject subject = new subject();     encounter encounter = new encounter();     subject.addencounter(encounter);      assert(subject.getencounters().contains(encounter));     assert(encounter.getsubject() == subject);       em.persist(subject);     em.persist(encounter);      return null; }

any idea why injection of entitymanager caused parser revalidate sql statement select subject_seq.nextval from[*] dual?

this caused resulting error 

  org.hibernate.exception.sqlgrammarexception: not prepare statement     @ org.hibernate.exception.internal.sqlstateconversiondelegate.convert (sqlstateconversiondelegate.java:123) [hibernate-core-4.3.5.final.jar:4.3.5.final]     @ org.hibernate.exception.internal.standardsqlexceptionconverter.convert (standardsqlexceptionconverter.java:49) [hibernate-core-4.3.5.final.jar:4.3.5.final]


Comments

Post a Comment

Popular posts from this blog

javascript - how to protect a flash video from refresh？ -

-
<!doctype html> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <title>flash video refresh</title> </head> <body> <div id="playerzone"><embed height="496" width="580" flashvars="flvid=19742822&amp;createtime=2012-4-19 13:46:33" wmode="opaque" allowscriptaccess="always" allowfullscreen="true" quality="high" bgcolor="#000000" name="player" id="player" src="swf/mine.swf" type="application/x-shockwave-flash"></div> <a onclick="return test();" id="test">click me popup div,and hide scrollbar</a> </body> the code upon： for example,when click a#test button,popup div,it's no problem,but want hide scrollbar while div popup. i used $('html').css('overflow','hidden') in
Read more

android - Associate same looper with different threads -

-
Image
in application, want create multiple threads working on single queue. create queue know need call looper.prepare() . i want other threads create should associated looper created first thread, how can achieve this? use 1 of java thread safe queue class java.util.concurrent package instead of looper achieve goal. it's more common practice. share queue between threads , post task queue entry 1 thread can entry thread. blockingqueue can - in 1 thread call take() , block thread until thread put() entry queue. that's all. producer consumer pattern example blockingqueue or concurrentlinkedqueue about blockingqueue
Read more

visual studio 2010 - Connect to informix database windows form application -

-
i trying figure out how connect ibm informix database. have been doing research , have found threads 5 years ago examples not working. i have installed latest sdk ibm informix. i have included ibm.data.informix.dll references in project. i have included using ibm.data.informix; i adding button , on click testing conenction. debug error "sql0035n file "c:\users\adam\documents\visual studio 2010\projects\test\test\msg\en_us\db2nmp.xml" cannot opened." this file not exist , dont see anywhere in program files (x86)\ibm informix client sdk directory. my on click code is private void button1_click(object sender, eventargs e) { const string host = "192.168.obfuscated"; const string servicenum = "1525"; //port? const string server = "serverobfuscated"; const string database = "dbobfuscatedy"; const string user = "myusername"; const string password = &
Read more