<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Importing data in MySQL via OpenCMS</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=968370514-05102004><FONT face=Arial size=2>i
fixed my first problem. i was using the wrong command</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=968370514-05102004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=968370514-05102004><FONT face=Arial
size=2>but i still getting the file not found
error.......</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> opencms-dev-bounces@opencms.org
[mailto:opencms-dev-bounces@opencms.org] <B>On Behalf Of </B>Oliver
Pereira<BR><B>Sent:</B> 05 October 2004 14:28<BR><B>To:</B> The OpenCms mailing
list<BR><B>Subject:</B> [opencms-dev] Importing data in MySQL via
OpenCMS<BR><B>Importance:</B> High<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>Hi,</FONT> </P>
<P><FONT face=Arial size=2>I have got a tab delimited text file which I want to
upload it into a MySQL table via opencms.</FONT> </P>
<P><FONT face=Arial size=2>The text file is uploaded to a folder in OpenCMS
</FONT></P>
<P><FONT face=Arial size=2>When it try to execute the code I am getting an error
that the file is not found and if I try to upload the file from my local drive I
get the following error</FONT></P>
<P><FONT face=Arial size=2>java.sql.SQLException: Can not issue
INSERT/UPDATE/DELETE with executeQuery() </FONT><BR><FONT face=Arial size=2>I am
using a instance of the Statement object to execute the query and query is
</FONT><BR><FONT face=Arial size=2>"LOAD DATA LOCAL INFILE " + '"' + strFilePath
+ '"' + " INTO TABLE `productmaster`"</FONT> <BR><FONT face=Arial size=2>Any
ideas / tips / sample code to upload a file into a table via OpenCMS is
welcome</FONT> <BR><FONT face=Arial size=2>Regards,</FONT> <BR><FONT face=Arial
size=2>Oliver</FONT>
</P><BR>_____________________________________________________________________<BR>This
e-mail has been scanned for viruses by MCI's Internet Managed Scanning Services
- powered by MessageLabs. For further information visit
http://www.mci.com<BR><BR>_____________________________________________________________________<BR>This
e-mail has been scanned for viruses by MCI's Internet Managed Scanning Services
- powered by MessageLabs. For further information visit
http://www.mci.com<BR></BODY></HTML>