Forum Stats

  • 3,770,127 Users
  • 2,253,073 Discussions


Developing a JPA entity using SQLJ

Hello Everyone,

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: Saleena