SQLJ and Object storage

From: <murkes_at_my-dejanews.com>
Date: Wed, 12 May 1999 16:49:48 GMT
Message-ID: <7hcbfb$d3i$1@nnrp1.deja.com>

We are building a system in Java, but none of us has used SQLJ and OO capabilities of Oracle. I would like to get a feel for what people's experiences are like with these technologies.

I have used Pro*C before, so i think i have an idea of what SQLJ is like.

Do user-defined types work well in Oracle? Does SQLJ work well with those user-defined types? Is object storage implemented efficiently - for example, if i want to store A and B that both contain (have a pointer to) C, will it store only one copy of C? Is it easy to specify which member variables map to which columns in the DB, and which shouldn't be saved at all?

What are major cons of using SQLJ, and what's better (if anything) about straight JDBC?

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 12 1999 - 11:49:48 CDT