aspose file tools*
The moose likes JDBC 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
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
 
Similar Threads
Accessing objects already created in memory ?
Storing Picture in Access DataBase
Accessing objects already created in memory ?
how to store object in "ms access database" through java?
file selected by JFileChooser and storing that image file in ms-access