Re: macaddr data type and prepared statements

Dave,

Yes its of type macaddr, if I build the statement manually (with all the
quoting uglyness) then its fine, e.g.

create table test (a serial, b macaddr);

insert into test (b) values ('00:00:00:00:00:00');
insert into test (b) values ('00:00:00:00:00:01');
insert into test (b) values ('00:00:00:00:00:02');

Cheers

Steve

Dave Cramer wrote:
> Steve,
>
>
> What are the column types in the table. If it is macaddr type then
> this is expected behaviour.
>
> Dave
> On 4-Aug-08, at 9:28 AM, Steve Foster wrote:
>
>> 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
>>
>> --
>> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc
>
>

--
Steve Foster Email: s(dot)p(dot)foster(at)leeds(dot)ac(dot)uk
Unix team Phone: 0113 343 7225
Information Systems Services Fax: 0113 343 5411
University of Leeds
Leeds LS2 9JT