[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] About Oracle User defined types
|
Atte.,
Luis Alberto Domínguez Ruiz
Integra Consultores C.A.
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.
2012/1/20 Tom Ware
<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
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
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
-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
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users