wood burning stoves 2.0*
The moose likes JDBC and the fly likes Store file in access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic
Author

Store file in access

visu Nekk
Ranch Hand

Joined: Sep 06, 2005
Posts: 122

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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30116
    
150

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
visu Nekk
Ranch Hand

Joined: Sep 06, 2005
Posts: 122
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30116
    
150

Visu,
Please don't post duplicate threads about the same question. Continue conversation in your other thread.

Thanks,
Jeanne
JDBC Forum Bartender
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Store file in access
 
Similar Threads
How do I get request parameters when the form is encoded?
how to upload file
upload file question
How can I solve this problem? servlet with strong process and Time out.
upload file - different browsers send different path name