i am implementing the content management tier of a j2ee web application. i am currently researching the possibility of implementing it such that it would be possible to use several database vendors (changing only the jdbc driver and the data source parameters). currently i am testing on oracle/mySql.
for blobs and clobs, there seems to be a different approach for oracle than mySql, but i might very well be missing something. that is:
insert empty lob with the normal insert/update query.
select the lob field for update
write the data using the inputStream/writer in the returned class.
pass the inputStream/writer to the prepared statement as parameter for the blob/clob field.
has anyone researched this before ? any oppinions ?
yeap, but orm is not an option because older versions of database items should be saved for auditing purposes which means that there is no update or delete and it uses a custom primary key generation. in my oppinion these cannot be implemented as they are using orm.
later edit: and about the way, the program is not supposed to cover all particular features of all DBMSs. so far insertion/selection work for oracle and mySql and should work on others too as it's plain sql. if i get the blob/clob reading and writing to work the only job left would be to test on other database types (and figure out the data type differences for creation of the tables).