User Activity

  • Posted a comment on discussion Help on CsvJdbc - CSV file JDBC driver

    Thank you, Simon, for your help! I am able to build using 1.0.34. Thank you also for your support fixing bugs. I have confirmed that bugs #127 and #128 are now fixed for me.

  • Posted a comment on discussion Help on CsvJdbc - CSV file JDBC driver

    When/How does CSVJDBC post latest versions to any public Maven repositories? For example, the Maven central repository has CSVJDBC, but only up to 1.0.31, not the latest 1.0.32: https://repo.maven.apache.org/maven2/net/sourceforge/csvjdbc/csvjdbc/ Thanks!

  • Modified a comment on discussion Help on CsvJdbc - CSV file JDBC driver

    I see from the documentation that timeZoneName defaults to UTC. So, if reading a timestamp that has no timezone specified, does it get read in assuming UTC? And upon writing it out, should it not also be written assuming the same UTC? Keeping the same time zone assumption for both reading and writing would preserve the value. But currently, it appears to be read in as UTC, but written out as local time zone, thus causing the value to change. Example file is "time_types.csv": colTimestamp 2017-08-04...

  • Posted a comment on discussion Help on CsvJdbc - CSV file JDBC driver

    I see from the documentation that timeZoneName defaults to UTC. So, if reading a timestamp that has no timezone specified, does it get read in assuming UTC? And upon writing it out, should it not also be written assuming the same UTC? Keeping the same time zone assumption for both reading and writing would preserve the value. But currently, it appears to be read in as UTC, but written out as local time zone, thus causing the value to change. Example file is "time_types.csv": colTimestamp 2017-08-04...

  • Modified a comment on discussion Help on CsvJdbc - CSV file JDBC driver

    How do I get DatabaseMetaData.getColumns() to work when I have an indexed file? Here is what I tried: Here is the content of the CSV files: id,name,date 1,apple,2017-01-01 2,banana,2017-02-02 3,cantaloupe,2017-03-03 With non-indexed files like "fruits.csv", I get back metadata as expected. Properties props; Connection conn; ResultSet results; boolean writeHeaderLine = true; props = new Properties(); props.put("columnTypes", "Integer,String,Date"); conn = DriverManager.getConnection("jdbc:relique:csv:.",...

  • Posted a comment on discussion Help on CsvJdbc - CSV file JDBC driver

    How do I get DatabaseMetaData.getColumns() to work when I have an indexed file? Here is what I tried: Here is the content of the CSV files: id,name,date 1,apple,2017-01-01 2,banana,2017-02-02 3,cantaloupe,2017-03-03 With non-indexed files like "fruits.csv", I get back metadata as expected. Properties props; Connection conn; ResultSet results; boolean writeHeaderLine = true; props = new Properties(); props.put("columnTypes", "Integer,String,Date"); conn = DriverManager.getConnection("jdbc:relique:csv:.",...

View All

Personal Data

Username:
richardsee
Joined:
2017-07-24 23:29:00

Projects

  • No projects to display.

Personal Tools

MongoDB Logo MongoDB