Loding file into database

[venki4java]

Hi fnds, am new to this forum i hangover with a problem ( loading a text file into a database). Plz help me by sending the algorithm or any procedure....

[javarishi]

Hi Venki, I didnt try,

try it out



CREATE TABLE t1
(
file_name VARCHAR(200),
file_data BLOB SUB_TYPE 0
);

The blobs are loaded via parametrized query:

INSERT INTO t1 (file_name, file_data) VALUES (?, ?);

[Eranga]

Hi venki,

Welcome to Java Forums!

What type of text file you use. If I get correctly you need to read a file and store the content in a database, right?