jpa - Hibernate fail to register REF_CURSOR parameter -
i new hibernate. using 5.2.10 final version connecting oracle 11g using oracle10gdialect jpa 2.1 , ojdbc8.jar
i try access simple stored procedure taking string input parameter , output oracle sys_refcursor.
storedprocedurequery call = session.createstoredprocedurecall("sp_get_profile"); call.registerstoredprocedureparameter(1, string.class, parametermode.in); call.registerstoredprocedureparameter(2, class.class, parametermode.ref_cursor); call.execute();
an exception occur when access function
error sqlexceptionhelper invalid column type: 2012 databaseexception::error=[error registering ref_cursor parameter [2]]
i try write simple program connecting db oracle driver only. have same error if register types.ref_cusor output parameter callablestatement.
cs.registeroutparameter(2, types.ref_cursor);
and problem can solved changing oracletypes
cs.registeroutparameter(2, oracletypes.cursor);
anyone know wrong? need fall use traditional sql programming if cannot stored procedure access success. . . please help.
finally got work, should check oracle jdbc document first before implementation.
ojdbc8 should oracle 12c + jdk8 + jpa2.1 oracle12cdialect.
for oracle 11g, need use ojdbc6.jar
Comments
Post a Comment