macaddr data type and prepared statements
От | Steve Foster |
---|---|
Тема | macaddr data type and prepared statements |
Дата | |
Msg-id | 48970402.9080808@leeds.ac.uk обсуждение исходный текст |
Ответы |
Re: macaddr data type and prepared statements
Re: macaddr data type and prepared statements Re: macaddr data type and prepared statements |
Список | pgsql-jdbc |
Hi All, I'm trying to bulk load some MAC addresses using a prepared statement. But I keep on getting an error about incorrect datatype (complains that I'm trying to insert "character varying"). Bellow is an example of the code that I'm using: try { Class.forName("org.postgresql.Driver"); conn = DriverManager.getConnection(jdbc_url, jdbc_user, jdbc_pass); PreparedStatement stmt = conn.prepareStatement("insert into log (date, time, mac, network) values (?,?,?,?)"); while (inputLineIterator.hasNext()) { String[] line = inputLineIterator.next(); if (line == null) { continue; } stmt.setDate(1, new java.sql.Date( dfmt.parse(line[0]).getTime()) ); stmt.setDate(2, new java.sql.Date( tfmt.parse(line[1]).getTime()) ); stmt.setString(3, line[2]); stmt.setString(4, line[3]); stmt.execute(); } stmt.close(); } Any recommendations? Cheers Steve
В списке pgsql-jdbc по дате отправления: