hello all,
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:
oracle:
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.
mySql:
pass the inputStream/writer to the prepared statement as parameter for the blob/clob field.
has anyone researched this before ? any oppinions ?
thank you very much for your time,
andrei