tomcat postgresql connectivity error

Started by dsidsabout 20 years ago3 messagesgeneral
Jump to latest
#1dsids
me.linuxadmin@gmail.com

Hi,
Im trying to run a web application from tomcat which connects to a
database on postgresql 8.1.3....
But when it tries to connect to a database.....an E 101 Exception
occured while retrieving results. is shown

When I checked up the logs of tomcat.....I could see..
SQLException [ERROR: No parser with id 17555]; nested exception is
org.postgresql.util.PSQLException: ERROR: No parser with id 17555

Please advise
Danish

#2Richard Huxton
dev@archonet.com
In reply to: dsids (#1)
Re: tomcat postgresql connectivity error

Danish wrote:

Hi,
Im trying to run a web application from tomcat which connects to a
database on postgresql 8.1.3....
But when it tries to connect to a database.....an E 101 Exception
occured while retrieving results. is shown

When I checked up the logs of tomcat.....I could see..
SQLException [ERROR: No parser with id 17555]; nested exception is
org.postgresql.util.PSQLException: ERROR: No parser with id 17555

Google for "no parser with id" and read through the first few results.
Does this (tsearch2 + undefined locale) sound like it might apply to you?

--
Richard Huxton
Archonet Ltd

#3dsids
me.linuxadmin@gmail.com
In reply to: Richard Huxton (#2)
Re: tomcat postgresql connectivity error

Yes I did a search on Google but it didnt give me any clues..............
Although the database is now working fine.....
The only thing I did was to change the statement with which i created
postgresql logfile...
I would do./.../usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data >>
/usr/local/pgsql/logs/logfile.txt 2>&1 start

now I do /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile
start

the database started working fine.....

Thanks
Danish
--
View this message in context: http://www.nabble.com/-GENERAL-tomcat-postgresql-connectivity-error-t1478217.html#a4003642
Sent from the PostgreSQL - general forum at Nabble.com.