Menu
▾
▴
csvjdbc-develop — Development mailing list for CsvJdbc
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(8) |
Dec
(2) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
(1) |
Feb
(2) |
Mar
|
Apr
|
May
(2) |
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
| 2003 |
Jan
(17) |
Feb
(11) |
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2004 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2005 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2017 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(2) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(5) |
Jun
|
Jul
(1) |
Aug
(1) |
Sep
|
Oct
|
Nov
(1) |
Dec
(5) |
| 2022 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
(1) |
Oct
|
Nov
|
Dec
|
| 2024 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
(1) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Tomasz S. <Tom...@e-...> - 2003-02-13 07:22:22
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello everybody. Here's the message I've received from Sinisa today: |Hi, | |Are you interested in some new features in csvjdbc. We |implemented write option (implementing simple UPDATE, |INSERT and DELETE SQL commands) in our project. We |use csvjdbc0.8, but I can see that this version is updated last |days. It will be useful for us to have only one version of driver. | |Please send me your opinion. | |Best regards, | |Sinisa Milosevic, |Together, Belgrade Cool! Go for it. If you can submit patch against latest CVS it'd be great. Cheers. - -- 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+S0eNZe1f4n3990IRAsM3AJsEP3A/Td3n72LKE7M7EDgti4B2VQCgnPyt UqqjYW/520zrehFhktlUEbs= =7IUx -----END PGP SIGNATURE----- |
|
From: John W. <jw...@bl...> - 2003-02-05 14:07:28
|
I am using ColdFusion standalone, that is really what 99.9% of the CF shops are using today, although these new options are intriguing. With CF standalone, there is JRUN underneath, but we don't have access to it directly. The CF Administator allows us to set the JRE, classpath, and configure JDBC drivers. We can also access Java classes directly, but it negates much of the simple/clean code in CF for handling databases. 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... 02/05/2003 03:09 AM To csvjdbc-develop <csv...@li...> cc Subject Re: [Csvjdbc-develop] New CVS version of CsvJdbc -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 One more thing. I've just checked - ColdFusion is just framework for J2EE servers - so I think you have to setup JDBC resource in your *J2EE server*. This depends on the server you're using - what is it? JRun? JBoss? WebSphere? Weblogic? - -- 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+QMa8Ze1f4n3990IRAiXKAJ4qHGq+b+BJVs6yXQ/s0zp0MzdRaACgl8F/ tNJaUdDbxQYmDcWv03mfPZ0= =MPk4 -----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 |
|
From: John W. <jw...@bl...> - 2003-02-05 14:05:25
|
Non XA resource? I looked through all the Java settings, JDBC settings and documentation. No reference to XA. 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... 02/05/2003 03:05 AM To csvjdbc-develop <csv...@li...> cc Subject Re: [Csvjdbc-develop] New CVS version of CsvJdbc -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 John Walker wrote: | | I told ColdFusion we would only do SELECT statements, but when it | verifies the datasource, I guess it invokes that method. I love the | idea of ignorning the call. | <snip/> Jonathan Ackerman wrote: | | However instead of throwing an error for methods like | setTransactionIsolation() perhaps the driver should just ignore the | call. What do you think Tomasz ? | <snip/> I think it's not very clean to silently ignore *any* method invocation, especially in such sensitive piece of software as JDBC driver (even if it's such feature-poor one as ours). This breaks many things, and is against many programming principles (e.g. reliable failure, not surprising user, code consistency). I don't know ColdFusion at all, but I'd like John to try first using non-XA resource in it's app-server (FWIK at least JBoss is able to do such trick). OTOH many JDBC drivers I know do just that - ignore method invocations they don't implement, and simply put that in documentation. So it *may* be possible to do just that. However if we decide to do so, I'd rather make *whole* csvjdbc driver behave consistently - either throw UnsupportedOperationException everywhere, or ignore/return empty results everywhere. *Or* we could use some sort of preprocessor for Java (there are few such tools - free of course). Final message: John: Try to setup non-XA resource first. If it fails we'll make something out. Jonathan: If we make this move we'll spend more time maintaing/supporting csvjdbc in the future (I think it's worth it if project will, slowly but surely, evolve). Just my 2(euro)c. Cheers. - -- 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+QMWxZe1f4n3990IRAtyOAJ4jnqESUY+E6lcAm3mYab6rcH0EXgCfYGWc A8EpM9hhTIM0wroCJcxWemo= =qC4z -----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 |
|
From: Tomasz S. <Tom...@e-...> - 2003-02-05 08:09:52
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 One more thing. I've just checked - ColdFusion is just framework for J2EE servers - so I think you have to setup JDBC resource in your *J2EE server*. This depends on the server you're using - what is it? JRun? JBoss? WebSphere? Weblogic? - -- 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+QMa8Ze1f4n3990IRAiXKAJ4qHGq+b+BJVs6yXQ/s0zp0MzdRaACgl8F/ tNJaUdDbxQYmDcWv03mfPZ0= =MPk4 -----END PGP SIGNATURE----- |
|
From: Tomasz S. <Tom...@e-...> - 2003-02-05 08:05:25
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 John Walker wrote: | | I told ColdFusion we would only do SELECT statements, but when it | verifies the datasource, I guess it invokes that method. I love the | idea of ignorning the call. | <snip/> Jonathan Ackerman wrote: | | However instead of throwing an error for methods like | setTransactionIsolation() perhaps the driver should just ignore the | call. What do you think Tomasz ? | <snip/> I think it's not very clean to silently ignore *any* method invocation, especially in such sensitive piece of software as JDBC driver (even if it's such feature-poor one as ours). This breaks many things, and is against many programming principles (e.g. reliable failure, not surprising user, code consistency). I don't know ColdFusion at all, but I'd like John to try first using non-XA resource in it's app-server (FWIK at least JBoss is able to do such trick). OTOH many JDBC drivers I know do just that - ignore method invocations they don't implement, and simply put that in documentation. So it *may* be possible to do just that. However if we decide to do so, I'd rather make *whole* csvjdbc driver behave consistently - either throw UnsupportedOperationException everywhere, or ignore/return empty results everywhere. *Or* we could use some sort of preprocessor for Java (there are few such tools - free of course). Final message: John: Try to setup non-XA resource first. If it fails we'll make something out. Jonathan: If we make this move we'll spend more time maintaing/supporting csvjdbc in the future (I think it's worth it if project will, slowly but surely, evolve). Just my 2(euro)c. Cheers. - -- 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+QMWxZe1f4n3990IRAtyOAJ4jnqESUY+E6lcAm3mYab6rcH0EXgCfYGWc A8EpM9hhTIM0wroCJcxWemo= =qC4z -----END PGP SIGNATURE----- |
|
From: John W. <jw...@bl...> - 2003-01-16 11:45:15
|
Thanks much, yes I would love to try the driver again. 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/16/2003 06:01 AM To: csvjdbc-develop <csv...@li...> cc: Subject: [Csvjdbc-develop] New CVS version of CsvJdbc -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi. I've just commited some of my improvements to CsvJdbc. Those are quickly summarized in src/doc/releasenotes.html: - - some small improvements to implementation details - - added support for different input encodings of CSV files. - - made CsvJdbc interface compatible with JDBC 3.0 (e.g. it's now possible to compile project using JDK 1.4). That all for now. Jonathan, please make a release and publish it on sf.net so John can try it out (or give me rights to do it :)) Cheers. - -- 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+JpD5Ze1f4n3990IRAucQAJwOQND7ZtG081hDVSagnnQKUWY7+wCdHem6 e37c1CGIzTpju3cNVllMQ0Y= =/Vy9 -----END PGP SIGNATURE----- ------------------------------------------------------- This SF.NET email is sponsored by: Thawte.com Understand how to protect your customers personal information by implementing SSL on your Apache Web Server. Click here to get our FREE Thawte Apache Guide: http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0029en _______________________________________________ Csvjdbc-develop mailing list Csv...@li... https://lists.sourceforge.net/lists/listinfo/csvjdbc-develop |
|
From: Tomasz S. <Tom...@e-...> - 2003-01-16 11:01:15
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi. I've just commited some of my improvements to CsvJdbc. Those are quickly summarized in src/doc/releasenotes.html: - - some small improvements to implementation details - - added support for different input encodings of CSV files. - - made CsvJdbc interface compatible with JDBC 3.0 (e.g. it's now possible to compile project using JDK 1.4). That all for now. Jonathan, please make a release and publish it on sf.net so John can try it out (or give me rights to do it :)) Cheers. - -- 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+JpD5Ze1f4n3990IRAucQAJwOQND7ZtG081hDVSagnnQKUWY7+wCdHem6 e37c1CGIzTpju3cNVllMQ0Y= =/Vy9 -----END PGP SIGNATURE----- |
|
From: Tomasz S. <Tom...@e-...> - 2003-01-16 07:31:39
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Jonathan Ackerman wrote: | Oops. Forgot to do it. It's all done now. | Thx. - -- 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+Jl/iZe1f4n3990IRAhJWAKCvCNE3YgOCpjAZX686cmcTJvoJDQCgtDLy haS2mEfWP/s5rv6CF6jWt4s= =Oz+t -----END PGP SIGNATURE----- |
|
From: Tomasz S. <Tom...@e-...> - 2003-01-15 06:52:35
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Jonathan Ackerman wrote: | What's your sf.net id. I give you dev access to the project. | | Jonathan | It seem that you've missed my previous post. My sf.net id is: "tskutnik" (without quotes). Will you grant me dev access to csvjdbc ? See ya. - -- 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+JQUKZe1f4n3990IRAu+gAJ9FDln8TfJn4iFzXoSuCcvcz7mzcgCgs+09 NvjbMMaNYZdm2b4F98ldgic= =ssrR -----END PGP SIGNATURE----- |
|
From: John W. <jw...@bl...> - 2003-01-09 20:38:22
|
Note that I am not a Java developer. Just a web developer looking for a JDBC driver. 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/10/2003 03:19 AM To: 'Tomasz Skutnik' <Tom...@e-...>, csv...@li... cc: Jonathan Ackerman <jon...@op...> Subject: RE: [Csvjdbc-develop] JDBC driver for CSV What's your sf.net id. I give you dev access to the project. Jonathan -----Original Message----- From: Tomasz Skutnik [mailto:Tom...@e-...] Sent: Thursday, 9 January 2003 9:44 p.m. To: csv...@li... Cc: Jonathan Ackerman Subject: Re: [Csvjdbc-develop] JDBC driver for CSV -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 John Walker wrote: | | 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. | I can send you *my* up-to-date source, however... I've already submitted a patch that waits for check in (AFAIR since 29.09.2002 - see mailing list archive). I still have one more patch that allows passing input charater encoding of CSV file to driver on obtaining collection, but I wait patiently for Jonathan to push things forward. So *if* you want - I can send you my sources along with those patches and precompiled, unofficial JAR archive. But I'd rather wait for Jonathan to do his commiter/maintainer job - that's the way open source works. BTW. Jonathan - maybe you could give me full commit access - so I'll be able to commit all my changes by myself, and make next release. What do you say? - -- 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+HTZTZe1f4n3990IRAgQZAJ44fEPWOg5H3aYa0gw390ODHzs9bgCgt+4e NIocZWW2epBUpC1OVtqA610= =aBwU -----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 |
|
From: Jonathan A. <jon...@op...> - 2003-01-09 19:17:34
|
What's your sf.net id. I give you dev access to the project. Jonathan -----Original Message----- From: Tomasz Skutnik [mailto:Tom...@e-...] Sent: Thursday, 9 January 2003 9:44 p.m. To: csv...@li... Cc: Jonathan Ackerman Subject: Re: [Csvjdbc-develop] JDBC driver for CSV -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 John Walker wrote: | | 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. | I can send you *my* up-to-date source, however... I've already submitted a patch that waits for check in (AFAIR since 29.09.2002 - see mailing list archive). I still have one more patch that allows passing input charater encoding of CSV file to driver on obtaining collection, but I wait patiently for Jonathan to push things forward. So *if* you want - I can send you my sources along with those patches and precompiled, unofficial JAR archive. But I'd rather wait for Jonathan to do his commiter/maintainer job - that's the way open source works. BTW. Jonathan - maybe you could give me full commit access - so I'll be able to commit all my changes by myself, and make next release. What do you say? - -- 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+HTZTZe1f4n3990IRAgQZAJ44fEPWOg5H3aYa0gw390ODHzs9bgCgt+4e NIocZWW2epBUpC1OVtqA610= =aBwU -----END PGP SIGNATURE----- |
|
From: John W. <jw...@bl...> - 2003-01-09 12:39:36
|
Understood. I will wait. 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/09/2003 03:44 AM To: csv...@li... cc: Jonathan Ackerman <jon...@op...> Subject: Re: [Csvjdbc-develop] JDBC driver for CSV -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 John Walker wrote: | | 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. | I can send you *my* up-to-date source, however... I've already submitted a patch that waits for check in (AFAIR since 29.09.2002 - see mailing list archive). I still have one more patch that allows passing input charater encoding of CSV file to driver on obtaining collection, but I wait patiently for Jonathan to push things forward. So *if* you want - I can send you my sources along with those patches and precompiled, unofficial JAR archive. But I'd rather wait for Jonathan to do his commiter/maintainer job - that's the way open source works. BTW. Jonathan - maybe you could give me full commit access - so I'll be able to commit all my changes by myself, and make next release. What do you say? - -- 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+HTZTZe1f4n3990IRAgQZAJ44fEPWOg5H3aYa0gw390ODHzs9bgCgt+4e NIocZWW2epBUpC1OVtqA610= =aBwU -----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 |
|
From: Tomasz S. <Tom...@e-...> - 2003-01-09 08:45:38
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 John Walker wrote: | | 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. | I can send you *my* up-to-date source, however... I've already submitted a patch that waits for check in (AFAIR since 29.09.2002 - see mailing list archive). I still have one more patch that allows passing input charater encoding of CSV file to driver on obtaining collection, but I wait patiently for Jonathan to push things forward. So *if* you want - I can send you my sources along with those patches and precompiled, unofficial JAR archive. But I'd rather wait for Jonathan to do his commiter/maintainer job - that's the way open source works. BTW. Jonathan - maybe you could give me full commit access - so I'll be able to commit all my changes by myself, and make next release. What do you say? - -- 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+HTZTZe1f4n3990IRAgQZAJ44fEPWOg5H3aYa0gw390ODHzs9bgCgt+4e NIocZWW2epBUpC1OVtqA610= =aBwU -----END PGP SIGNATURE----- |
|
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 |
|
From: John W. <jw...@bl...> - 2003-01-08 19:33:47
|
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 |
|
From: Jonathan A. <jon...@op...> - 2003-01-08 19:17:09
|
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 |
|
From: John W. <jw...@bl...> - 2003-01-08 13:37:55
|
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 |
|
From: Tomasz S. <Tom...@e-...> - 2003-01-08 11:49:05
|
-----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----- |
|
From: Tomasz S. <Tom...@e-...> - 2003-01-03 09:32:55
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 John Walker wrote: | | a) On Windows, how do you secify the CSV directory on the server? I | did the following, which I am pretty sure is wrong and causing my grief: | | jdbc:relique:csv:*e:\cf\bocs\PFVMI\SAPData* Try jdbc:relique:csv:e:/cf/bocs/PFVMI/SAPData (use Un*x slashes instead of Windows' ones - you should always use them - no matter what platform, omit asterisks) | | b) When using ODBC drivers for CSV files, I am accustomed to select * | and have the rows returned as field_1, field_2, etc.. Appears this | driver will use whatever field name I give it? Or, is it expecting a | header row of field names in the 1st row that correspond to what I select? Sorry, ask someone else, or look into sources :) | | c) I am also accustomed to select * from csvfile.csv, but it appears I | the .csv is taken for granted and should not be specified, correct? | Yep. Read the manual. | | | 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... Cheers. - -- 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+FVhzZe1f4n3990IRAnYSAKCHa36+nuQDVaimSkExo0SCzFUU4wCeOLOG +Z16jDkD0lINhRZVyP89deo= =i6WB -----END PGP SIGNATURE----- |
|
From: John W. <jw...@bl...> - 2003-01-02 18:38:32
|
a) On Windows, how do you secify the CSV directory on the server? I did the following, which I am pretty sure is wrong and causing my grief: jdbc:relique:csv:e:\cf\bocs\PFVMI\SAPData b) When using ODBC drivers for CSV files, I am accustomed to select * and have the rows returned as field_1, field_2, etc.. Appears this driver will use whatever field name I give it? Or, is it expecting a header row of field names in the 1st row that correspond to what I select? c) I am also accustomed to select * from csvfile.csv, but it appears I the .csv is taken for granted and should not be specified, correct? 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... |
|
From: Tomasz S. <Tom...@e-...> - 2002-09-25 08:11:24
|
Hi everybody. I've made some fixes to current CVS, and I'm posting it for review and (probably) inclusion. What was done: 1. Added debug flag to compiler invocation in "compile" target. 2. Improved handling of negative and overflowed indexes in getColumn(int index) method of CsvResultSet class. 3. Fixed bug in wasNull() method of CsvResultSet class. AFAIK construct such as 'getString(lastIndexRead).equals(null)' never evaluates to true - it's always false or throws NPE :-) 4. Changed CsvReader to return 'null' for columns that are missing in a row - method getColumn(int columnIndex) of CsvReader class. Patch included. Apply in CVS working copy root using: $ zcat patch.gz | patch -p0 Comments? Questions? Cheers. Scooter. -- 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 |
|
From: Jonathan A. <jon...@op...> - 2002-05-30 21:08:47
|
Very nice. If you want I can make you a member of the team. In which case you can update CVS directly. There are now a number of new updates in the code base. Reckon it's time to do a new release. Jonathan -----Original Message----- From: Jason Bedell [mailto:jas...@di...] Sent: Friday, 24 May 2002 4:32 a.m. To: csv...@li... Subject: [Csvjdbc-develop] Updates I edited the CsvReader to accept fully qualified field names. I am new to this project and to SourceForge for that matter and am not sure what the next steps are to get this changed review, excepted, submitted,etc. I also made changes to CsvResultSet. I implemented the wasNull() method and added better descriptions to the "Not Supported" exceptions thrown for debugging purposes. <<CsvReader.java>> <<CsvResultSet.java>> Thanks, Jason W. Bedell Technology Specialist Direct: 816.512.9255 jas...@di... Digital Evergreen 423 West 8th Street Kansas City, MO 64105 Phone: 816.512.9399 www.digitalevergreen.com |
|
From: Jason B. <jas...@di...> - 2002-05-23 16:32:51
|
I edited the CsvReader to accept fully qualified field names. I am new = to this project and to SourceForge for that matter and am not sure what = the next steps are to get this changed review, excepted, submitted,etc. I also made changes to CsvResultSet. I implemented the wasNull() method = and added better descriptions to the "Not Supported" exceptions thrown = for debugging purposes. <<CsvReader.java>> <<CsvResultSet.java>>=20 Thanks, Jason W. Bedell Technology Specialist Direct: 816.512.9255 jas...@di...=20 Digital Evergreen 423 West 8th Street Kansas City, MO 64105 Phone: 816.512.9399 www.digitalevergreen.com |
|
From: Jonathan A. <jon...@op...> - 2002-02-28 19:10:48
|
One patch is to fix a bug that has been reported where the getXXX methods on the result set are index starting at 0 not at 1 as defined in the JDBC spec. The other is a fix to the build.xml so that it is ant 1.4 compatible. We also have a number of requested features/bugs namely: 1) Metadata object for the database not just the result set 2) Support for relative paths in the CSV file name specified in a SELECT 3) Support for SQL WHERE clause I'll check out the spec below. Later Jonathan -----Original Message----- From: Sander Brienen [mailto:san...@cg...] Sent: Thursday, 28 February 2002 10:07 p.m. To: jon...@op... Subject: Re: [Csvjdbc-develop] New Team Member Very good. I am curious what those patches are. What we also have to think about is what we should provide, and more important what not, around SQL. There are many statements that are not relevant within a CSV driver. Hughes Technologies offers a small relational database system which supports a subset of the sql spec. see http://www.hughes.com.au/library/msql/manual_20/spec.html for there spec's. From this spec we should not implement there addition with regular expressions, but the rest is a nice start for us I guess. What do you think? regards, Sander Brienen Cap Gemini Ernst & Young WARP11 Advanced Development email: san...@cg... web: http://www.nl.cgey.com >>> Jonathan Ackerman <jon...@op...> 02/27 8:23 pm >>> Hi all, Just to let you know we have a new team member: Michael Maraya. Michael has submitted a number of patches. As soon as these are applied I'll roll out a v0.8 release. 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/ _______________________________________________ Csvjdbc-develop mailing list Csv...@li... https://lists.sourceforge.net/lists/listinfo/csvjdbc-develop -- **************************************************************************** This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst & Young Group. It is only intended for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. **************************************************************************** |
|
From: Jonathan A. <jon...@op...> - 2002-02-28 02:57:26
|
Hi all, Just to let you know we have a new team member: Michael Maraya. Michael has submitted a number of patches. As soon as these are applied I'll roll out a v0.8 release. 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/ |
5 messages has been excluded from this view by a project administrator.
