Hi Jakob. Jakob Braeuchi Escribio :-) > 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.
well, i think the both way are useful. for example if you have 10 field and you only need set the datatype for only one field, i'm think we do not need pass a array for only one field. the problem what i have is what i try to create a field that have a null value in the SQL(SELECT ..., null as field, for example), and the collection retrieve this value, maybe is strange, but later a set the correct value of that field. i'm not always do this. Then i presume OBJ do not know wich datatype use because this value is not based in another field. Cheers. Carlos Ch�vez. > > 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] > -- Carlos Ch�vez --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
