andrei radu

Greenhorn
+ Follow
since Dec 09, 2009
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by andrei radu

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).

thanks for your answer
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