Re: macaddr data type and prepared statements

might work for you:

prepstatement.setObject( index, macaddressString, Types.OTHER);

I use that for inet data type, never tried macaddr.

regards
gustav trede

Steve Foster skrev:
> 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
>