Reading CSV file without header with CSV-JDBC driver

Question

I am using http://csvjdbc.sourceforge.net/doc.html to treat CSV files on disk (e.g. 'myFile' in 'myDir') as an SQL DB I can query with SQL syntax:

// create connection
Class.forName("org.relique.jdbc.csv.CsvDriver");
Properties props = new Properties();
props.put("separator", ";");
Connection conn = DriverManager.getConnection("jdbc:relique:csv:" + myDir, props);

// run query
Statement stmt = conn.createStatement();
ResultSet myData = stmt.executeQuery("SELECT * FROM \"" + myFile + "\"");

This works fine, but I run into trouble when the CSV file does not have a header. In that case, the first data line is considered as header and thus not read like the other data lines.

Is there any way to tell the query not to look for a header and treat the first line as data input?

props.put("suppressHeaders", "true");

Icewine
– Icewine

2017-05-09 07:57:45 +00:00
Commented May 9, 2017 at 7:57 — Icewine
– Icewine, Commented May 9, 2017 at 7:57
Thank you, that does it indeed! :)

Sofie VL
– Sofie VL

2017-05-09 08:03:23 +00:00
Commented May 9, 2017 at 8:03 — Sofie VL
– Sofie VL, Commented May 9, 2017 at 8:03

rjdkolb · Accepted Answer · 2017-05-09 08:18:16Z

3

Did you try setting the property suppressHeaders as listed in DemoDriver4

Properties props = new Properties();
// Define column names and column data types here.
props.put("suppressHeaders", "true");
props.put("headerline", "ID,ANGLE,MEASUREDATE");
props.put("columnTypes", "Int,Double,Date");

edited May 9, 2017 at 8:18

answered May 9, 2017 at 7:57

rjdkolb

12.1k13 gold badges79 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Reading CSV file without header with CSV-JDBC driver

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related