1. how to pass an array to Stored proc call thru hibernate coderanch.com |
2. help with how to call from JPA oracle stored procedure with array as IN parameter coderanch.comWhat does you stored procedure look like? What type is being used for the array? I assume you are using either a VARRAY in Oracle, or a TABLE type? What JPA provider are you using? If you are using EclipseLink (or TopLink), you can define a StoredProcedureCall object that takes a JDBC java.sql.Array argument. If you need a TABLE, then you ... |
3. Passing array of values to Stored procedure using Hibernate. forum.hibernate.orgI am successfully able to execute stored procedures to fetch / query resultset from database using namedquery. Those stored procedures take simple datatypes as parameters. Now I have a requirement where stored procedure takes in Array of varchar2. I am not able to pass array of String from java to database. Mainly I am using EJB3 JPA and then I convert ... |
4. How to pass Object Array to Oracle Stored Proc thr hibernate forum.hibernate.orgHi, I'm trying to pass an Java Object Array to an Oracle Stored Procedure thro' hibernate, It gives me the following error, ====================================================================== Hibernate: {call Contact_OBJ_ARRAY_PROC(?, ?)} java.sql.SQLException: Invalid column index at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227) at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:3703) at oracle.jdbc.driver.OraclePreparedStatement.setNullInternal(OraclePreparedStatement.java:3594) at oracle.jdbc.driver.OracleCallableStatement.setNull(OracleCallableStatement.java:4162) at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:147) at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:136) at org.hibernate.type.ManyToOneType.nullSafeSet(ManyToOneType.java:110) at org.hibernate.loader.Loader.bindNamedParameters(Loader.java:1778) at org.hibernate.loader.Loader.bindParameterValues(Loader.java:1704) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1593) at org.hibernate.loader.Loader.doQuery(Loader.java:696) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:2232) ... |
5. Problem when passing array to stored proc using hibernate forum.hibernate.orgHi, I am trying to execute a stored procedure which takes i/p as an Array of integer and String values. I am calling this procedure, using jdbc connection object, which I get from hibernate session object, connection = session.connection(); Now in my code I have following statement which is generating the given exception ArrayDescriptor objArrayDescriptor= (ArrayDescriptor)ArrayDescriptor.createDescriptor("NUM_ARRAY",connection); Exception java.lang.ClassCastException at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:103) I ... |
6. How to pass an array as a parameter to a stored procedure? forum.hibernate.orgSomeone else asked this question but I think the question was misunderstood. I have a stored procedure that takes an array of strings and an int as parameters. The org.hibernate.Query class does not have a setArray method, only setInt, setString etc. If you do this invocation with straight jdbc you need to create an ArrayDescriptor and an Oracle ARRAY object and ... |
7. Passing Oracle ARRAY as stored procedure's parameter forum.hibernate.orgIt seems that Hibernate does not accept non-serializable parameters to be passed to stored procedures? Please refer to the stack trace. I was trying to pass an Oracle Array (:invisibles) to the stored procedure and I got this "Could not serialize" exception. Any one knows anything about this? I could not find relevent information in the Hibernate documentations. Really appreciate for ... |