Re: csv to Tomcat to Mysql upload / import
Mark Matthews <[email protected]>
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Tim Lucia said the following on 5/23/2006 10:51 AM: > I've used a CSV JDBC driver once before with success. It becomes an > exercise of reading from one JDBC connection and writing to the other. > > http://csvjdbc.sourceforge.net > > Tim Christopher, If you don't mind being MySQL-specific, you can always use "LOAD DATA LOCAL INFILE" with our JDBC driver. This will send the "local" file from your application server to the MySQL server for parsing/processing directly into table(s), see: http://dev.mysql.com/doc/refman/5.0/en/load-data.html -Mark -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEc1dvtvXNTca6JD8RAoj3AKCxnmfGId7z7Z0UEIVZ/kuDDjmtmgCeNhm8 bEdsZIz1ZSHvoSUQqls2WNs= =ZJk9 -----END PGP SIGNATURE----- -- MySQL Java Mailing List For list archives: http://lists.mysql.com/java To unsubscribe: http://lists.mysql.com/[email protected]