hi carlos,
with the current versions of ojb you can only set the types for all columns.
there are imo two ways to set the type of a specific column:
1.) pass the whole array of types but define a type to be ignored
as the parameter is an array of int we cannot use null, so we need to define an intvalue that is ignored.
2.) provide an additional method which allows to set the type for a single column only.
wdyt
jakob
Carlos Ch�vez schrieb:
Hi to all.
is posible to set the jdbcTypes for only one column of the result of the query ?
I know we can use the methode setJdbcTypes, but this need set the datatypes for all columns, i want to do this for only two columns, is this posible?.
I try to do this:
SELECT INVOICE_NUM, null AS USER1, null AS USER2 FROM INVOICE
The problem is when the OJB try to convert the value for a java datatype, i think.
the error are:
Exception in thread "main" java.lang.NullPointerException at org.apache.ojb.broker.metadata.JdbcTypesHelper.getObjectFromColumn(Unknown Source) at org.apache.ojb.broker.metadata.JdbcTypesHelper.getObjectFromColumn(Unknown Source) at org.apache.ojb.broker.accesslayer.ReportQueryRsIterator.getObjectFromResultSet(Unknown Source) at org.apache.ojb.broker.accesslayer.RsIterator.next(Unknown Source) at org.apache.commons.collections.IteratorUtils.toList(IteratorUtils.java:829) at org.apache.commons.collections.IteratorUtils.toList(IteratorUtils.java:805) at net.agssa.sga.forms.informes.InformesVentas.getListFacturasEmitidasInforme(InformesVentas.java:186) at ojb.ProductosFacturados.test(ProductosFacturados.java:20) at test.Test.main(Test.java:17)
Cheers,
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
