Re: [Csvjdbc-develop] JDBC driver for CSV

[John W. <jw...@bl...>]

I am going to have to investigate commercial solutions.  We are a 
ColdFusion web applications development shop and I am looking for a 
working CSV JDBC driver in the form of a JAR file.   Therefore, getting 
into the source would cost me more than other available drivers.  Thanks 
for the help,

John Walker
Macromedia Solutions Manager
Black Oak Technology Solutions 
805 N. Salisbury Blvd. Suite 3100 
Salisbury MD,  21801
http://www.black-oak.com
Office: 410-546-8100 x:2258
Cell:    410-430-6706
jw...@bl...





Tomasz Skutnik <Tom...@e-...>
Sent by: csv...@li...
01/08/2003 06:47 AM
 
        To:     csv...@li...
        cc: 
        Subject:        Re: [Csvjdbc-develop] JDBC driver for CSV


-----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-----



-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
Csvjdbc-develop mailing list
Csv...@li...
https://lists.sourceforge.net/lists/listinfo/csvjdbc-develop