jdbc problem

Поиск
Список
Период
Сортировка
От Paweł Cesar Sanjuan Szklarz
Тема jdbc problem
Дата
Msg-id 1187790488.19687.15.camel@bishio.cc.com.pl
обсуждение исходный текст
Ответы Re: jdbc problem
Список 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.



В списке pgsql-jdbc по дате отправления:

Предыдущее
От: ttvvaa
Дата:
Сообщение: Re: JDBC COPY error encoding
Следующее
От: rfrancis@ev.net
Дата:
Сообщение: Re: User Defined Types -- Using inet/cdr from JDBC ?