jdbc problem

From: Paweł Cesar Sanjuan Szklarz <paweld2(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: jdbc problem
Date: 2007-08-22 13:48:08
Message-ID: 1187790488.19687.15.camel@bishio.cc.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi.

I use ibatis and jdbc do connect to postgres. When I use a 8.2 database,
then all works ok, but for 7.4 databases I get this error:

15:42:46,936 INFO [STDOUT] 2007-08-22 15:42:46,932 B5A22F41 WARN
[org.springframework.ws.soap.server.SoapMessageDispatcher] - Endpoint
invocation resulted in exception - responding with SOAP Fault
org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation;
bad SQL grammar []; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in pl/com/cc/gwindws/dao/ibatis/map/PTP.xml.
--- The error occurred while applying a parameter map.
--- Check the checkLoanId-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: org.postgresql.util.PSQLException: ERROR: syntax error at end
of input
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at end
of input
Caused by:
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in pl/com/cc/gwindws/dao/ibatis/map/PTP.xml.
--- The error occurred while applying a parameter map.
--- Check the checkLoanId-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: org.postgresql.util.PSQLException: ERROR: syntax error at end
of input
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at end
of input
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:565)

When i check the servers logs i see this:
LOG: connection received: host=192.168.1.16 port=52557
LOG: connection authorized: user=postgres database=gwind
LOG: connection received: host=192.168.1.16 port=43021
LOG: connection authorized: user=postgres database=gwind
LOG: statement: BEGIN
LOG: statement: create
ERROR: syntax error at end of input at character 10
LOG: statement: ROLLBACK
LOG: statement: create
ERROR: syntax error at end of input at character 10
LOG: statement: create
ERROR: syntax error at end of input at character 10
LOG: statement: create
.....
this ERROR repeats every 3 seconds.

When i send a request to the servlet, i get this on the log:
LOG: statement: SET SESSI
ERROR: syntax error at end of input at character 10

I really try to :
----- Change the JDBC jar file for postgres 7.4 and 8.2
----- use additional options on the url connection

My database is in LATIN2.

Thanks.

Pawel Cesar Sanjuan Szklarz.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message rfrancis 2007-08-23 12:24:26 Re: User Defined Types -- Using inet/cdr from JDBC ?
Previous Message ttvvaa 2007-08-21 19:38:48 Re: JDBC COPY error encoding