[Objectbridge-jdo-dev] Object store (automated database creation)

[<tr...@th...>]

I've been having this idea running through my head for the past couple weeks so I thought i'd run it by the list.

Lets say you wanted to make the database transparent (other than the connection info obviously) so we could have a quasi object store.  

My thoughts on how to implement speaking from jdo implementation perspective.  

Basically you have jdo file with persistent fields.  If a table not found error occurs on a query, you create the table on the fly.  If a column not found error occurs, you compare ResultSet metadata with jdo metadata and create any columns that dont' match.  

This could be done at load time when jdo file is first read, or on the fly on an as needed basis.  

The benefit of this is that the jdo file would become a sort of database schema that the programmer wouldn't even think about.  And ojb would be very, very easy to install and implement.

Thoughts?

Travis