Inserting Multiple Images into oracle database using JDBC by reading it from text file

[Raihan Jamal]

how we can insert multiple images into oracle database....

I wanted to insert multiple images into database using JDBC by reading it from the file... and i am passing photos.txt(my text file) as an input parameter... this is my content of photos.txt file and i have copied all the images into the folder
" C:\\photos "

1,in1.jpg,108,19,in-n-out
2,in2.jpg,187,21,in-n-out
3,in3.jpg,308,41,in-n-out
4,in4.jpg,477,52,in-n-out
5,in5.jpg,530,50,in-n-out


and i want to store in1.jpg,in2.jpg,in3.jpg,in4.jpg,in5.jpg into the oracle databse using JDBC.... i have tried a lot using BLOB column.... and i have created my table as

CREATE TABLE PHOTO(
ID NUMBER NOT NULL PRIMARY KEY ,
Name BLOB,
X DOUBLE PRECISION,
Y DOUBLE PRECISION,
Tags VARCHAR2(40)
);


---------------------------------------------------------------------------------------

 # try {  
#         
#              
#             // for restaurant  
#             System.out.println();System.out.println();System.out.println();  
#             System.out.print("  Creating Statement for Photo...\n");  
#               
#             stmt2 = con.createStatement ();  
#               
#             stmt2.executeUpdate("delete from PHOTO");  
#             stmt2.executeUpdate("commit");  
#               
#               
#             PreparedStatement stmt3 = con.prepareStatement ("INSERT INTO PHOTO VALUES (?, ?, ?, ?, ?)");  
#               
#             System.out.print("  Create FileReader Object for file: " + inputFileName1 + "...\n");  
#             FileReader inputFileReader2 = new FileReader(inputFileName1);  
#             System.out.print("  Create BufferedReader Object for FileReader Object...\n");  
#             BufferedReader inputStream2   = new BufferedReader(inputFileReader2);  
#             String inLine2 = null;  
#               
#             String[] tokens;  
#  //             String[] imageFilenames = {"c:\\photos\\in1.jpg","c:\\photos\\in2.jpg","c:\\photos\\in3.jpg","c:\\photos\\in4.jpg","c:\\photos\\in5.jpg",  
#  //  "c:\\photos\\in6.jpg","c:\\photos\\in7.jpg","c:\\photos\\in8.jpg","c:\\photos\\in9.jpg","c:\\photos\\in10.jpg","c:\\photos\\arb1.jpg","c:\\photos\\arb2.jpg",  
#  //  "c:\\photos\\arb3.jpg","c:\\photos\\arb4.jpg","c:\\photos\\arb5.jpg","c:\\photos\\den1.jpg","c:\\photos\\den2.jpg","c:\\photos\\den3.jpg",  
#  //  "c:\\photos\\den4.jpg","c:\\photos\\den5.jpg","c:\\photos\\hop1.jpg","c:\\photos\\hop2.jpg","c:\\photos\\hop3.jpg","c:\\photos\\hop4.jpg","c:\\photos\\hop5.jpg"};  
#       
#           File file = new File("C:\\photos\\in1.jpg");  
#           FileInputStream fs = new FileInputStream(file);  
#   
#               
#             while ((inLine2 = inputStream2.readLine()) != null) {  
#                tokens= inLine2.split(",");  
#             st2 = new StringTokenizer(inLine2, DELIM);  
#                   
#              
#                  
#                   stmt3.setString(1, tokens[0]);  
#                stmt3.setBinaryStream(2, fs, (int)(file.length()));  
#                stmt3.setString(3, tokens[2]);  
#                stmt3.setString(4, tokens[3]);  
#                stmt3.setString(5, tokens[4]);  
#                stmt3.execute(); //execute the prepared statement  
#                stmt3.clearParameters();  
#         

--------------------------------------------------------------------------------------



As i am able to read one image by my above code in1.jpg in to the oracle databse.... Any suggestions how can i insert multiple images into oracle database by looking at my code or any other changes....
Can you give me the example on the basis of the above code of mine...

[Jeanne Boyarsky]

Where are the multiple images coming from? In your example, the image is hard coded.

[Raihan Jamal]

We have to read the name of image from the text file as given above.... like in1.jpg in2.jpg
and then from that we have to store the image in the oracle database...


and images are stored in photos folder in C drive
"C:\photos"