Menu
▾
▴
RE: [Csvjdbc-develop] JDBC driver for CSV
|
From: John W. <jw...@bl...> - 2003-01-08 20:12:49
|
I am just using csv files as a way to integrate with other applications. I only need to do select's and have grown to not expect a where or order by, etc.. If someone could give me an up-to-date JAR file, I would be very thankful. If you cannot run the ANT script, then I am sure I would bother you guys to death trying to get it done. 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... Jonathan Ackerman <jon...@op...> 01/09/2003 03:41 AM To: 'John Walker' <jw...@bl...> cc: csv...@li..., 'Tomasz Skutnik' <Tom...@e-...> Subject: RE: [Csvjdbc-develop] JDBC driver for CSV ANT is not a problem to use at all. CVS can be a real pain in the ass ! I would still suggest you give it a try (the driver is free after all). Maybe Tomasz can give you an up-to-date copy of the driver and the source. My machine was recently rebuilt so I don't have the capability to do it at the moment. The other thing to note is that the driver only does basic selects and does NOT support WHERE, ORDER BY, UPDATE or DELETE statements. Later Jonathan ------------------------------------------------------------------- Jonathan Ackerman Principal Consultant Optimation Phone: +64 9 3075567 L4, Optimation House, Fax: +64 9 3097919 43 College Hill Rd, Mobile: +64 21 566225 Auckland, mailto:jon...@op... New Zealand http://www.optimation.co.nz/ -----Original Message----- From: John Walker [mailto:jw...@bl...] Sent: Thursday, 9 January 2003 8:40 a.m. To: Jonathan Ackerman Cc: csv...@li...; csv...@li...; 'Tomasz Skutnik' Subject: RE: [Csvjdbc-develop] JDBC driver for CSV I used the / slash and that did not get the driver to work, but thanks for the trying. Do you feel it is worth my time to try the new version, and create the JAR file? I am not familiar with CVS or ANT build scripts, so I am starting from scratch. 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... Jonathan Ackerman <jon...@op...> Sent by: csv...@li... 01/09/2003 03:18 AM To: 'Tomasz Skutnik' <Tom...@e-...>, csv...@li... cc: Subject: RE: [Csvjdbc-develop] JDBC driver for CSV The project has not been abandoned... I've just been slack in releasing a new version :( The URL you have should work fine. Note if you want to use a "\" in a java string then you need to escape it i.e. put a double slash "e:\\cf\\...". However a "/" should work as well. The code in CVS has a number of bug fixes and some new features in it. If you grab a copy there is a very simple ANT build script that will create a new jar for you. Jonathan -----Original Message----- From: Tomasz Skutnik [mailto:Tom...@e-...] Sent: Thursday, 9 January 2003 12:48 a.m. To: csv...@li... 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 ------------------------------------------------------- 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 |
