Re: [eclipselink-users] About Oracle User defined types

[Luis Dominguez <ldominguez.integra@xxxxxxxxx>]

Like this:

Map types = conn.getTypeMap();

types.put("C_PriceType", PriceType.class);

conn.setTypeMap(types);

java.sql.Array priceList  = rs.getArray("PRICE_LIST");

2012/1/20 Tom Ware <tom.ware@xxxxxxxxxx>

How would you access the fields of the object if you were using JDBC?

-Tom

On 20/01/2012 9:58 AM, Luis Dominguez wrote:

The Stored Procedures is in an oracle database. The procedure returns a
sys_refcursor, where the cursor has the following fields:

ID: it's a number field type.
Prices List: It's a list of Price type. An oracle user defined type with te
following structure:
     * Id of price item: Number field
     * priceAmount: amount. It's a NUMBER(12, 5) field.

If i used DataReadQuery with a StoredProcedureCall, the result list when the
query is executed has a list of DatabaseRecord, where the records has an object
array for the prices list.

I need to obtain the prices values, but using DataReadQuery the prices list is
returned as an Object array, with Object type elements, and no possibilities to
cast to the desired object.

Help.

   2012/1/20 Tom Ware <tom.ware@xxxxxxxxxx <mailto:tom.ware@xxxxxxxxxx>>

       Can you explain a little more about what this custom type is?  We
       provide a number of ways you can deal with special types and your choice
       will depend on how it is derived.

       At the simplest level, you can specify a Converter on the object that
       maps to the special type.  That will allow you do do some operations.

       http://wiki.eclipse.org/Using___EclipseLink_JPA_Extensions_%__28ELUG%29#Using_EclipseLink___JPA_Converters

       <http://wiki.eclipse.org/Using_EclipseLink_JPA_Extensions_%28ELUG%29#Using_EclipseLink_JPA_Converters>

       Alternately, we have an event mechanism that will allow you to access
       the data at various points in the query.

       http://www.eclipse.org/__eclipselink/api/2.3/index.html

       <http://www.eclipse.org/eclipselink/api/2.3/index.html>

       If the data structure is, in fact, a Struct, you may be able to make use
       of our StructConverter to operate on it as it enters and leaves the
       database.

       http://wiki.eclipse.org/Using___EclipseLink_JPA_Extensions_(__ELUG)#How_to_Use_the_.__40StructConverter_Annotation

       <http://wiki.eclipse.org/Using_EclipseLink_JPA_Extensions_(ELUG)#How_to_Use_the_.40StructConverter_Annotation>

       -Tom



       On 19/01/2012 4:08 PM, Luis Dominguez wrote:

           Hi everybody.

           I'm using eclipselink with JPA. Actually, i'm using eclipselink for
           a stored
           procedure call. The results of the stored procedure have a "column",
           with a
           custom type object value. The sentence

           List<DatabaseRecord> queryResultList = (List) ((JpaEntityManager)

           main.em.getDelegate()).__getActiveSession().__executeQuery(query,

           queryArgs);

           recovers a list of DatabaseRecord, with a field as
           [Ljava.lang.Object;@10010ec
           object. When i'm trying to iterate this array, only have a
           [Ljava.lang.Object;,
           with no possibilities of see the data.

           How i can do that?

           _________________________________________________
           eclipselink-users mailing list
           eclipselink-users@xxxxxxxxxxx <mailto:eclipselink-users@eclipse.org>
           https://dev.eclipse.org/__mailman/listinfo/eclipselink-__users
           <https://dev.eclipse.org/mailman/listinfo/eclipselink-users>

       _________________________________________________
       eclipselink-users mailing list
       eclipselink-users@xxxxxxxxxxx <mailto:eclipselink-users@eclipse.org>
       https://dev.eclipse.org/__mailman/listinfo/eclipselink-__users

       <https://dev.eclipse.org/mailman/listinfo/eclipselink-users>





_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users