i trying run application backend postgres. worked good, when changed dialect oracle application working falling in sequence, trying run postgres query.
domain
@column(name = "person_id", nullable = false) @generatedvalue(generator = "person_seq", strategy=generationtype.sequence) @sequencegenerator(name = "person_seq", sequencename = "person_seq", allocationsize = 1) private long id; @column(name = "title_id") private integer titleid; @column(name = "surname") private string surname; @column(name = "forename") private string forename; @column(name = "person_name_suffix") private string personnamesuffix; @manytoone(fetch = fetchtype.lazy, cascade = cascadetype.persist) @joincolumn(name = "user_id", nullable = true) error
used by: java.sql.sqlsyntaxerrorexception: ora-00923: keyword not found expected @ oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:445) @ oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:396) @ oracle.jdbc.driver.t4c8oall.processerror(t4c8oall.java:879) @ oracle.jdbc.driver.t4cttifun.receive(t4cttifun.java:450) @ oracle.jdbc.driver.t4cttifun.dorpc(t4cttifun.java:192) @ oracle.jdbc.driver.t4c8oall.dooall(t4c8oall.java:531) @ oracle.jdbc.driver.t4cpreparedstatement.dooall8(t4cpreparedstatement.java:207) @ oracle.jdbc.driver.t4cpreparedstatement.executefordescribe(t4cpreparedstatement.java:884) @ oracle.jdbc.driver.oraclestatement.executemaybedescribe(oraclestatement.java:1167) @ oracle.jdbc.driver.oraclestatement.doexecutewithtimeout(oraclestatement.java:1289) @ oracle.jdbc.driver.oraclepreparedstatement.executeinternal(oraclepreparedstatement.java:3593) @ oracle.jdbc.driver.oraclepreparedstatement.executequery(oraclepreparedstatement.java:3637) @ oracle.jdbc.driver.oraclepreparedstatementwrapper.executequery(oraclepreparedstatementwrapper.java:1495) @ weblogic.jdbc.wrapper.preparedstatement.executequery(preparedstatement.java:135) @ org.hibernate.engine.jdbc.internal.resultsetreturnimpl.extract(resultsetreturnimpl.java:79) ... 106 more 759 [[active] executethread: '19' queue: 'weblogic.kernel.default (self-tuning)'] error uk.gov.justice.cpp.dmu.service.impl.lacourtsessionserviceimpl - no record found vax.persistence.persistenceexception: org.hibernate.exception.sqlgrammarexception: not extract resultset @ org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1387) @ org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1310) @ org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1316) @ org.hibernate.ejb.abstractentitymanagerimpl.persist(abstractentitymanagerimpl.java:881) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:57) @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43) @ java.lang.reflect.method.invoke(method.java:606) @ org.springframework.orm.jpa.sharedentitymanagercreator$sharedentitymanagerinvocationhandler.invoke(sharedentitymanagercreator.java:291) @ com.sun.proxy.$proxy221.persist(unknown source) @ uk.gov.justice.cpp.dmu.dao.impl.genericdaoimpl.saveorupdate(genericdaoimpl.java:54) @ uk.gov.justice.cpp.dmu.dao.impl.genericdaoimpl.saveorupdate(genericdaoimpl.java:20) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:57)
Comments
Post a Comment