I've got an application that uses Scott Klement's JDBCR4 code along with the SQLite JDBC driver in order to create lightweight SQLite databases which power a fleet of handheld devices. This has been in daily use since v5r3. We attempted a migration to a new Power 9 box running v7r3 last weekend, this JDBC application, along with others, no longer work. The error message indicates that the JDBC drivers have no native OS400 libraries. IBM has been zero help other than to suggest I contact the JDBC driver suppliers in order to find out how to install the drivers on the As400 with OS400 native libraries. Three different JDBC drivers no longer work; MSSQL, jTDS and SQLite.
Long story short, we aborted the migration and reverted back to a v7r1 box, the customer is not amused now that he owns a $60k paperweight.
One option is to load the Power 9 with v7r2 that supposedly will allow JDBC to run the way it has been. But, the point of upgrading was not to start by downgrading.
Very frustrating to say the least. Has anyone here hit this speed bump and found a way out? Ideas welcomed?
Long story short, we aborted the migration and reverted back to a v7r1 box, the customer is not amused now that he owns a $60k paperweight.
One option is to load the Power 9 with v7r2 that supposedly will allow JDBC to run the way it has been. But, the point of upgrading was not to start by downgrading.
Very frustrating to say the least. Has anyone here hit this speed bump and found a way out? Ideas welcomed?
Comment