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
>