Re: [Csvjdbc-develop] JDBC driver for CSV

[Tomasz S. <Tom...@e-...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

John Walker wrote:
|
| I had already tried the /, but tried it again with no luck.
|
| url: jdbc:relique:csv:e:/cf/bocs/PFVMI/SAPData
| class: org.relique.jdbc.csv.CsvDriver
|

seems ok 4 me.

| SQL:         SELECT field1
|         FROM vendors
|
| vendors.csv is in the e:/cf/bocs/PFVMI/SAPData folder.
|
| The error I am getting is:
|
| code: 0 Dtl: Not Supported !
|
| You suggest I read the manual.  I read the readme and releasenotes from
| the zip file.  I see no documentation on the web site in sourceforge.
|  If there is a manual, please direct me to it and I will likely find
| reasons for the error I am getting, and answers to my other questions.

Sorry if i didn't myself clear enough - there is NO other documentation
than that single HTML page found at http://csvjdbc.sourceforge.net/ -
this project seems a little bit... abandoned? I've only suggested that
you should read the *SOURCE* to find out what's wrong - at least that's
what I did when hacking CsvJdbc for my project. BTW. Are you using
latest CVS version or one of the realeases?

But getting back to your question(s) - use 'SELECT * FROM vendors' and
then pull appriopriate value using integer indexing, or make first row a
header row - just put column names in the first row (FWIR that's default
behaviour) - but it seems that you've already done that. If you want to
omit these use "suppressHeaders" property set to "false" when retrieving
connection.

Last point of advice - *USE THE SOURCE* (Luke ;) - get lastest version
from CVS, compile it, and than debug your project. If you have the
source you have all data you need to solve your problems. Sorry, but I
can't help you more with that, unless pointing to look for a different
tool :). You have to remember of LGPL implications, of course, but
should already have known that :)

See ya, and good luck with your project(s).

- --

Tomasz Skutnik, R&D Director, www.e-point.pl
tel +48 (22) 853 48 30, mob +48 501 555 705, fax +48 (22) 853 48 30
e-point S.A., ul. Filona 16, 02-658 Warsaw, Poland
PGP/GPG public key: http://scooter.ext.e-point.pl/tomasz.skutnik.gpg
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+HA/ZZe1f4n3990IRAlPfAKCYsd11GSysG6oC5jyBqZP4qtxAQACgjOLN
qJy8CKBeHD6BlgQqmh55wLA=
=2Lfw
-----END PGP SIGNATURE-----