X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6BD919F9316 for ; Thu, 18 May 2006 13:43:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 40667-03 for ; Thu, 18 May 2006 13:43:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 6BBB89F9C18 for ; Thu, 18 May 2006 13:43:50 -0300 (ADT) Received: from hotmail.com (bay112-f2.bay112.hotmail.com [64.4.26.12]) by svr4.postgresql.org (Postfix) with ESMTP id EE61B5B3ED8 for ; Thu, 18 May 2006 16:43:49 +0000 (GMT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 18 May 2006 09:43:44 -0700 Message-ID: Received: from 64.4.26.200 by by112fd.bay112.hotmail.msn.com with HTTP; Thu, 18 May 2006 16:43:39 GMT X-Originating-IP: [86.217.98.127] X-Originating-Email: [e1lauren@hotmail.com] X-Sender: e1lauren@hotmail.com In-Reply-To: <20060518131029.GD32278@surnet.cl> From: "Mathias Laurent" To: pgsql-admin@postgresql.org Subject: [JDBC] InsertRow problem with Serial Date: Thu, 18 May 2006 16:43:39 +0000 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed X-OriginalArrivalTime: 18 May 2006 16:43:44.0415 (UTC) FILETIME=[3A0D72F0:01C67A9A] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.693 tagged_above=0 required=5 tests=BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_SOFTFAIL X-Spam-Level: X-Archive-Number: 200605/266 X-Sequence-Number: 21798 Hello, I have a problem with the driver JDBC3, MyTable(col1(SERIAL), col2(VARCHAR), Col3(VARCHAR)) When i do >rs.moveToInsertRow(); >rs.updateString("col2",col2); >rs.updateString("col3",col3); >rs.insertRow(); >con.commit(); >rs.next(); >rs.refreshRow(); The ResulSet is not refreshed for the first column, the value for col1 is 0. Although insertion in the base worked and the serial have the good value !!! And this code works perfectly for MySql :( If somebody knows when that can come from ? Thank you, Mathias Laurent _________________________________________________________________ Retrouvez tout en un clin d'oeil avec la barre d'outil MSN Search ! http://desktop.msn.fr/