Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group