Bookmark Topic Watch Topic
  • New Topic

Store file in access

 
visu Nekk
Ranch Hand
Posts: 122
  • Mark post as helpful
  • send pies
  • Report post to moderator

using the above code i could read the file.Now can anyone guide me to store it in access or oracle database.Thanx in advance.

[added code tags]
[ September 21, 2005: Message edited by: Jeanne Boyarsky ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Report post to moderator
Visu,
You have the right idea with the commented out part. Good start!

I think you need to use a PreparedStatement since you are inserting a BLOB. It seems tough to represent a file in a SQL query. You can pass a byte[] or ByteArrayInputStream to the prepared statement.
 
visu Nekk
Ranch Hand
Posts: 122
  • Mark post as helpful
  • send pies
  • Report post to moderator
hi Jeanne,

i have tried out with prepared statement but the microsoft access driver does'nt support prepared statement.can u help me anyother way out?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Report post to moderator
Visu,
Please don't post duplicate threads about the same question. Continue conversation in your other thread.

Thanks,
Jeanne
JDBC Forum Bartender
 
    Bookmark Topic Watch Topic
  • New Topic