[opencms-dev] Importing data in MySQL via OpenCMS

[Oliver Pereira]

It's not once but it be done maybe every 15 days...

The only problem is the live server is behind a firewall and more than 1
user will be responsible for updating and uploading the data..... 

-----Original Message-----
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Markus Daniel
Sent: 05 October 2004 15:10
To: The OpenCms mailing list
Subject: Re: [opencms-dev] Importing data in MySQL via OpenCMS

Oliver Pereira wrote:
> 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
Hi,
in such a case I would upload the file via phpMyAdmin or mySqlConsole.
Maybe this is much more easy and effect the same if you want to do this
only once.

Hope this helps.

Regards,
Markus Daniel


_______________________________________________
This mail is send to you from the opencms-dev mailing list To change
your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev

_____________________________________________________________________
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