Results 1 to 1 of 1
- 02-03-2012, 02:49 PM #1
Member
- Join Date
- Jan 2012
- Posts
- 7
- Rep Power
- 0
JPA + StoredProcedureCall + object type IN parameter = problem
I'm trying to do a simple thing: call stored procedure which have a object type parameter.
This is what I have in db:
Java Code:create or replace TYPE TEST_TYPE AS OBJECT ( test_field varchar(100) )
Java Code:CREATE OR REPLACE PROCEDURE TEST_PROC ( PARAM1 IN TEST_TYPE ) AS BEGIN END TEST_PROC;
Java Code:@Embeddable @Struct(name = "TEST_TYPE", fields = {"TEST_FIELD"}) public class TestStruct { private String testField; public String getTestField() { return testField; } public void setTestField(String testField) { this.testField = testField; } }
Java Code:@PostConstruct public void init() { StoredProcedureCall call = new StoredProcedureCall(); call.setProcedureName("TEST_PROC"); call.addNamedArgument("PARAM1", "PARAM1", Types.STRUCT, "TEST_TYPE", TestStruct.class); DataReadQuery dataReadQuery = new DataReadQuery(call); dataReadQuery.addArgument("PARAM1"); TestStruct testStruct = new TestStruct(); List args = new ArrayList(); args.add(testStruct); Object result = ((EntityManagerImpl)em.getDelegate()).getSession().executeQuery(dataReadQuery,args); }
Java Code:Internal Exception: java.sql.SQLException: Invalid column type Error Code: 17004 Call: BEGIN TEST_PROC(PARAM1=>?); END; bind => [1 parameter bound] Query: DataReadQuery()
please help me, good people :)
What is the shortest way to make this working?
Similar Threads
-
HELP!!! How to create an object with parameter problem
By HolyPK in forum New To JavaReplies: 2Last Post: 01-06-2012, 11:10 PM -
Type parameter
By Pojahn_M in forum New To JavaReplies: 10Last Post: 09-20-2011, 12:20 AM -
Getting the class of a type parameter
By Muskar in forum Advanced JavaReplies: 21Last Post: 06-04-2011, 03:28 PM -
doubt regarding <type parameter>
By subith86 in forum New To JavaReplies: 7Last Post: 03-01-2011, 03:35 PM -
passing an enum type as a parameter ??!
By SCS17 in forum New To JavaReplies: 11Last Post: 07-13-2008, 01:44 PM
Bookmarks