It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Storing an Java object in Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Storing an Java object in Access" Watch "Storing an Java object in Access" New topic
Author

Storing an Java object in Access

Abhisar Singh
Greenhorn

Joined: Aug 02, 2006
Posts: 16
Hi,

can we store a java object in MS access.. for example if I want to store a vector in an access table is it possible....
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1321

hi Abhisar Singh,

its required a ORDBMS (Object Relational Database Management System)
based on my research MS Access is not a ORDBMS you cannot persist the java Object into MS Access Database.

For More Information you can check this JDBC 2.1 API Spec

Core JDBC 2.1 API.

Regards,
[ August 08, 2006: Message edited by: saif uddin ]

Saifuddin..
[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
Mr. C Lamont Gilbert
Ranch Hand

Joined: Oct 05, 2001
Posts: 1170

I believe the JET database engine does support some form of BLOB which is all you need to store an object in a database. Access is an application not a database.

I use it, but I store my objects based on their attributes, and not in a binary form.
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Originally posted by Mr. C Lamont Gilbert:
Access is an application not a database.


Quite right. Now, know it for sure.
[ August 08, 2006: Message edited by: Adeel Ansari ]
Abhisar Singh
Greenhorn

Joined: Aug 02, 2006
Posts: 16
Hi thanks you all..

Mr. C Lamont Gilbert can you please tell me more about this BLOB thing..
can you give me some sample code which shows how to use the JET & BLOB to store objects...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Storing an Java object in Access
 
It's not a secret anymore!