Hi,
I'm trying to develop a migration script to retrieve data from a table that is storing "settings" data for an application in a BLOB. The legacy application is using JPA to store "setting" entities ('userID','settingKey','value') into a table with the same name, but the problem is that since the 'value' is stored in a BLOB column, it is not possible to retrieve/migrate the settings using a SQL statement.
I would like to incorporate my "migration script" into our PL/SQL install/upgrade script, and that's why I'm looking to use SQLJ, but I've got no clue that (for example) where should I put the "Persistence.xml" file, and whether I need it, at all?
Regards,
Babak.