Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Storing an Java object in Access

 
Abhisar Singh
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1324
Android Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Mr. C Lamont Gilbert
Ranch Hand
Posts: 1170
Eclipse IDE Hibernate Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic