[opencms-dev] Importing data in MySQL via OpenCMS

[Oliver Pereira]

i fixed my first problem. i was using the wrong command
 
but i still getting the file not found error.......

________________________________

From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Oliver Pereira
Sent: 05 October 2004 14:28
To: The OpenCms mailing list
Subject: [opencms-dev] Importing data in MySQL via OpenCMS
Importance: High



Hi, 

I have got a tab delimited text file which I want to upload it into a
MySQL table via opencms. 

The text file is uploaded to a folder in OpenCMS 

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

java.sql.SQLException: Can not issue INSERT/UPDATE/DELETE with
executeQuery() 
I am using a instance of the Statement object to execute the query and
query is 
"LOAD DATA LOCAL INFILE " + '"' + strFilePath + '"' + " INTO TABLE
`productmaster`" 
Any ideas / tips / sample code to upload a file into a table via OpenCMS
is welcome 
Regards, 
Oliver 


_____________________________________________________________________
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

_____________________________________________________________________
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20041005/13fca1a0/attachment.htm>