Please help how to import text data file in MySql using JDBC application

1) I do not know if there is a way to do this in JDBC, and I am not sure the "load" command is an actual SQL command. Maybe someone else can confirm this for you.

2) The load command you list is functionality available to the mySQL CLI, or command line interface. Instead of JDBC, you may need to use a system execute process, like this:

Runtime runtime = Runtime.getRuntime();

Process process = runtime.exec( stringLoadRequest );

-- read the DOS output if needed

InputStream inputStream = process.getInputStream();

-- read the inputStream

3) Also, you may need to use the older DOS 8.3 filename protocol for folder and file names. Many path readers (especially CLI driven utilities) do not handle the spaces, special symbols, or name lengths over 8 characters that newer GUI software of Windows programs use.

For example, the filename "bumblyburg.process" has 10 letters in the filename, the dot delimiter, and 7 characters in the extension. Older Dos path readers translate this filename as "bumbly~1.pro". If you set a path to the long name, the filename reader does not see it. This applies to all the foldernames in a path as well.

The good news is you can see for yourself how the DOS shell translates it by going to a command shell and doing a directory listing like this: dir /x. The "/x"displays the names in the older format. Unfortunately, you may have to do this for every foldername in your path. Your input file is probably something like this:

'D:\\01-Pre~1\prevoz~1\sifarn~1\new_MB~1.txt'

Hope this helps!

mamgeorgea at 2007-7-12 16:42:00 >