Sorry for the noise - please ignore the previous message. The test is now failing in 1.2.0 too rather spectacularly. MS-Excel ODBC seems to be a gross misfit for the JDBC-ODBC bridge driver, especially for "optional" features as per the JDBC spec.
Shantanu On Jan 4, 11:38 am, Shantanu Kumar <[email protected]> wrote: > Hi, > > I came across this when testing clojure.contrib.sql/insert-values with > JDBC-ODBC bridge driver for MS-Excel files. > > c.c.sql/insert-values implementation has changed from 1.2.0 to 1.3.0- > SNAPHOT wherein it uses a PreparedStatement (in 1.3.0- > SNAPSHOT, .prepareStatement) instead of Statement > (1.2.0, .createStatement). In my test this causes to break the use- > case of inserting a new row into an Excel sheet because apparently the > Excel ODBC driver does not support the JDBC PreparedStatement > semantics. > > While it has been decided to use PreparedStatement for insert-values, > it might be a good idea to introduce an alternative where the lesser > JDBC drivers can work as well. > > Regards, > Shantanu -- You received this message because you are subscribed to the Google Groups "Clojure" group. To post to this group, send email to [email protected] Note that posts from new members are moderated - please be patient with your first post. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/clojure?hl=en
