Products Resources Support About Us

Rocket Software

Issue (?) with UNNEST and JDBC drivers Universe

Hello there.

Using a SQL query with UNNEST via the JDBC drivers, works fine, I get the only 1 value per row and as many rows as MV are in there.

So far, so good.

The issue (I think) is that get getString method form the drivers and/or asjava implementation is returning the correct value in the 1st place altogether with a bunch on separators and trash.

Maybe I am doing something wrong ??

I am launching the app with ISO-8859-1, that works in any other circumstances with asjava.

Example:

Row 1 :
4912795831*M������;2795831������;;;0005 00002057������;38369������;3620������;�������;�������;1������;TALLER 1������;1A������;O.R. MECANICA C. PROP.������;;;;;;ARS������;10������;RECEPCIONISTA 10������;;�������;;;;;�������;1������;FC CONTADO������;1;1;M;;SE SOLUCIONO PERDIDA DE ACEITE;5.00;537.19;2685.95;;2685.95;5;OPERARIO 5;518.50;;M;MECANICA;;;1������;CONTADO������;;0������;0������;1������;CITROEN������;PRESUPUESTAR PERDIDA ACEITE / TESTIGO DEFECTO MOTOR ENCENDIDO / EN SU MOMENTO TESTIGO DE TEMPERATURA ENCENDIDO / LIQUIDPO REFRIGERANTE BAJA NIVEL MAS DE LO NORMAL������;2795831;M

Row 2:
4912795831*M������;2795831������;;;0005 00002057������;38369������;3620������;�������;�������;1������;TALLER 1������;1A������;O.R. MECANICA C. PROP.������;;;;;;ARS������;10������;RECEPCIONISTA 10������;;�������;;;;;�������;1������;FC CONTADO������;;2;M;;SE CORRIGIO TESTIGO DEFECTO MOTOR;0.00;537.19;0.00;;0.00;5;OPERARIO 5;0.00;;M;MECANICA;;;1������;CONTADO������;;0������;0������;1������;CITROEN������;PRESUPUESTAR PERDIDA ACEITE / TESTIGO DEFECTO MOTOR ENCENDIDO / EN SU MOMENTO TESTIGO DE TEMPERATURA ENCENDIDO / LIQUIDPO REFRIGERANTE BAJA NIVEL MAS DE LO NORMAL������;2795831;M

Sorry for the encoding, but I think you (all) can see what I mean. The first value is ok, but it’s followed by separators.

If you debug this on Java, it goes something like value;char(128);char(253);;char(128);char(253);
and so on.

Regards, David.