Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id CFFD8633957
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 18 Feb 2010 09:06:36 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 98761-02-3 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 18 Feb 2010 13:06:17 +0000 (UTC)
X-Greylist: delayed 00:08:49.446744 by SQLgrey-1.7.6
Received: from smtp-out.abv.bg (smtp-out.abv.bg [194.153.145.99])
	by mail.postgresql.org (Postfix) with ESMTP id 817036335DE
	for <pgsql-sql@postgresql.org>; Thu, 18 Feb 2010 09:01:59 -0400 (AST)
Received: from smtp.abv.bg (m2.ni.bg [192.168.151.127])
	by smtp-out.abv.bg (Postfix) with ESMTP id 058CC14EBD3
	for <pgsql-sql@postgresql.org>; Thu, 18 Feb 2010 14:50:57 +0200 (EET)
DomainKey-Signature: a=rsa-sha1; s=smtp-out; d=abv.bg; c=simple; q=dns;
	b=aCkbCsda2XMa6HNmfzGl3QhS1Eeo/LF1pxAtNrQ3giXbK7qMlbR7G+Ker//GVlaMw
	dHZXYDioMNBF58MM/ynqDS1U2RqoshNLcpgob0cXpj0PVB6Scb4RMrU6Z3y+Ca2rIl9
	V29tckatWNgrNo8wGTxwkT7okWmpBPKHRdGr2fQ=
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=abv.bg; s=smtp-out;
	t=1266497457; bh=olNjoL/IozIPzWhYFczd44IOLlwOv4Xg3qifTOr2Idc=;
	h=From:Content-Type:Content-Transfer-Encoding:Subject:Date:
	Message-Id:To:Mime-Version:DKIM; b=ucZJ0vgBqALqKQTcjPDKiTsRt3Or0tJ
	gJkW7MXPSriWHQepvhna/RZUvPwIy+1irZvyfuCeSoiofk9cXVJDJN3s3cIdSoumIxT
	NvlyY51EVKwZsMuCSq2WPHppXEPPK9p1E1IhIfsFMbF0wnfIkYsG+jBsQLwBkDo+6x+
	MsLXqQ=
Received: from Unknown (HELO [192.168.180.4]) (78.90.12.216)
	(smtp-auth username iuzkan@abv.bg, mechanism plain)
	by smtp.abv.bg (qpsmtpd/0.82) with ESMTPA;
	Thu, 18 Feb 2010 14:53:08 +0200
From: zkn <zkn@abv.bg>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Subject: Problem with batch insert
Date: Thu, 18 Feb 2010 14:53:07 +0200
Message-Id: <1077F011-859B-4AE5-AE95-65B45F775DE6@abv.bg>
To: pgsql-sql@postgresql.org
Mime-Version: 1.0 (Apple Message framework v1077)
X-Mailer: Apple Mail (2.1077)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 201002/71
X-Sequence-Number: 33670

Hi,

First I'm sorry if this message shouldn't be posted in this mailing list =
but I wasn't sure if it should be here or in jdbc mailing list.

I have a weird problem with batch insert. It works fine on my =
development machine but when I upload to the server it fails. Here is =
the log:

DEBUG [http-8443-2] - {conn-100123} Preparing Statement: insert into =
target_filters_sections (filter_id, section_id) values (?, ?) , (?, ?)=20=

DEBUG [http-8443-2] - {pstm-100124} Executing Statement: insert into =
target_filters_sections (filter_id, section_id) values (?, ?) , (?, ?)=20=

DEBUG [http-8443-2] - {pstm-100124} Parameters: [23, 229, 23, 141]
DEBUG [http-8443-2] - {pstm-100124} Types: [java.lang.Integer, =
java.lang.Integer, java.lang.Integer, java.lang.Integer]
DEBUG [http-8443-2] - Unable to translate SQLException with SQL state =
'42601', error code '0, will now try the fallback translator
DEBUG [http-8443-2] - Returning JDBC Connection to DataSource
org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; =
bad SQL grammar []; nested exception is =
com.ibatis.common.jdbc.exception.NestedSQLException:=20
--- The error occurred while applying a parameter map.=20
--- Check the addSectionsToTargetsFilter-InlineParameterMap.=20
--- Check the statement (update failed).=20
--- Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or =
near ","
Position: 113


And here is the log for the same operation on my development machine:

DEBUG [http-8080-1] - {conn-100006} Preparing Statement: insert into =
target_filters_sections (filter_id, section_id) values (?, ?) , (?, ?) , =
(?, ?)=20
DEBUG [http-8080-1] - {pstm-100007} Executing Statement: insert into =
target_filters_sections (filter_id, section_id) values (?, ?) , (?, ?) , =
(?, ?)=20
DEBUG [http-8080-1] - {pstm-100007} Parameters: [28, 1603, 28, 1605, 28, =
1604]
DEBUG [http-8080-1] - {pstm-100007} Types: [java.lang.Integer, =
java.lang.Integer, java.lang.Integer, java.lang.Integer, =
java.lang.Integer, java.lang.Integer]
DEBUG [http-8080-1] - Returning JDBC Connection to DataSource

Postgre version on the server 8.1 on development 8.3
Any clues?=