Re: JDBC and LOAD DATA LOCAL INFILE :

2003-02-13 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: HI, Thanks all for the suggestions given for load data... It indeed helped me a lot. Right now i am using J/connector version 3 . Load data local works fine with version 3. I hit a new problem. It works fine when th

Re: JDBC and LOAD DATA LOCAL INFILE :

2003-02-13 Thread Ahmed S K Anis
HI, Thanks all for the suggestions given for load data... It indeed helped me a lot. Right now i am using J/connector version 3 . Load data local works fine with version 3. I hit a new problem. It works fine when there are below 2 records in the file. When i tried wiht 4,00,000

Re: JDBC and LOAD DATA LOCAL INFILE :

2003-02-12 Thread Roger Baklund
* Ahmed S K Anis [...] > String filepath = "sys:\\restore\\data1.txt"; > String query = "load data local infile \'" + filepath + "\' into table > x > > it takes as estoredata1.txt as file name not clear why ? A double backslash will in many environments be reduced to a single backslash. Your

Re: JDBC and LOAD DATA LOCAL INFILE :

2003-02-12 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: Yes Mark it worked from the command line. The Archived resides at the server side. I ran Load data local infile 'sys:\\mail\\dump.txt" into table X it worked. The from a different machine i ran this java program. The Arch

Re: JDBC and LOAD DATA LOCAL INFILE :

2003-02-12 Thread Ahmed S K Anis
Yes Mark it worked from the command line. The Archived resides at the server side. I ran Load data local infile 'sys:\\mail\\dump.txt" into table X it worked. The from a different machine i ran this java program. The Archived file still exists at the DB server side. So i guess local option

Re: JDBC and LOAD DATA LOCAL INFILE :

2003-02-12 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: Thanks Mark, I tried to work with the latest driver. 3.0.4 Now it gave error shown below . Also see code snippet below at the end Error code is0 estoredata1.txt'for 'LOAD DATA LOCAL INFILE' command.Due to underlying IOExcepti

Re: JDBC and LOAD DATA LOCAL INFILE :

2003-02-12 Thread Ahmed S K Anis
Thanks Mark, I tried to work with the latest driver. 3.0.4 Now it gave error shown below . Also see code snippet below at the end Error code is0 estoredata1.txt'for 'LOAD DATA LOCAL INFILE' command.Due to underlying IOExcepti on: ** BEGIN NESTED EXCEPTION ** java.io.FileNotFoundException esto

Re: JDBC and LOAD DATA LOCAL INFILE : The used command is not allowedwith this MySQL version

2003-02-12 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: Hi all, please let me now if there is a solution to this. I am facing the same problem. Anis "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Wednesday, February 12, 2003 3:48:16 PM >>> Hello, I'm using this command into a Java se

Re: JDBC and LOAD DATA LOCAL INFILE : The used command is notallowed with this MySQL version

2003-02-12 Thread Ahmed S K Anis
Hi all, please let me now if there is a solution to this. I am facing the same problem. Anis >>> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Wednesday, February 12, >2003 3:48:16 PM >>> Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \"" + FIC_DB + "\" REPLACE INT

JDBC and LOAD DATA LOCAL INFILE : The used command is not allowed with this MySQL version

2003-02-12 Thread [EMAIL PROTECTED]
Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \"" + FIC_DB + "\" REPLACE INTO TABLE news"; It runs well with mysql-3.23.45 but not with mysql-3.23.55 The error message is : java.sql.SQLException: General error: The used command is not allo