Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FireBird 1.5 to Oracle

436253Feb 14 2008 — edited Oct 20 2008

Hi,

I need to migrate structure and data from FireBird1.5 to Oracle 10gR2 (WindowsXP)
I've installed a new driver for FireBird : Jaybird-2.1.2JDK_1.6.zip,
and created my DataServer --> all it's ok.

Now with ODI I've a problem with the column from FireBird : Blob Sub_Type1
I reverse with succes all tables but the columns with the type "Blob Sub_Type1" are empty in ODI (10.1.3.4), so the conversion is not possible!

The error in ODI when a try to read the data is :
com.borland.dx.dataset.DataSetException : BASE+62
com.borland.dx.dataset.DataSetException: Request don't succedL'exécution de la requête a échoué.
rg.firebirdsql.jdbc.field.TypeConvertionException: Types.ARRAY: SQL type for this field is not yet supported.

Please, I need your help.

Thanks a lot.

Vick

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 17 2008

Added on Feb 14 2008

#business-intelligence-applications, #data-integrator, #system-management-and-integration

1 comment

1,106 views