Re: [JDBC] [BUGS] BUG #1026: org.apache.commons.dbcp.DbcpException:

[Tammy Jones]

Kris Jurka wrote: PostgreSQL version: 7.3.4 Description: org.apache.commons.dbcp.DbcpException: The connection attempt failed because failed getting backend We are trying to install DSPACE with POSTGRES. When we run the ant fresh_install command we get the following error. What could be causing a org.apache.commons.dbcp.DbcpException: The connection attempt failed because failed getting backend encoding? Have you been able to establish a JDBC connection at all or is this error only with dspace? I really haven't tried postgres with anything other than dspace. Could you enable logging on the server and see if that comes up with anything interesting? (Enable log_statement in postgresql.conf and restart the server making sure the output is going somewhere other than /dev/null) I enabled logging.  The logging results are below with the query results. What do you get from the results of the following queries when run in psql? I assume that I am running the queries appropriately.  The database service had to be started because of copy paste problems, not because of the queries below.   Here are the results: SELECT version(); $psql -d dspace -c "SELECT version();" SELECT $ more logfile 2003-12-24 09:21:12 LOG:  database system was shut down at 2003-12-24 09:20:46 E ST 2003-12-24 09:21:12 LOG:  checkpoint record is at 0/84FAA8 2003-12-24 09:21:12 LOG:  redo record is at 0/84FAA8; undo record is at 0/0; shu tdown TRUE 2003-12-24 09:21:12 LOG:  next transaction id: 587; next oid: 25169 2003-12-24 09:21:12 LOG:  database system is ready 2003-12-24 09:21:44 LOG:  query: begin; select getdatabaseencoding(); commit 2003-12-24 09:21:44 LOG:  query: SELECT version(); RESULT :c=0.00..0.01 :r=1 :w=0 RESULT :c=0.00..0.01 :r=1 :w=0 2003-12-24 09:22:49 LOG:  query: begin; select getdatabaseencoding(); commit 2003-12-24 09:22:49 LOG:  query: SELECT version(); RESULT :c=0.00..0.01 :r=1 :w=0 RESULT :c=0.00..0.01 :r=1 :w=0 SELECT pg_encoding_to_char(1); $ psql -d dspace -c "SELECT pg_encoding_to_char(1);" SELECT $ more logfile 2003-12-24 09:25:28 LOG:  database system was shut down at 2003-12-24 09:25:01 E ST 2003-12-24 09:25:28 LOG:  checkpoint record is at 0/84FAE8 2003-12-24 09:25:28 LOG:  redo record is at 0/84FAE8; undo record is at 0/0; shu tdown TRUE 2003-12-24 09:25:28 LOG:  next transaction id: 593; next oid: 25169 2003-12-24 09:25:28 LOG:  database system is ready 2003-12-24 09:25:33 LOG:  query: begin; select getdatabaseencoding(); commit 2003-12-24 09:25:33 LOG:  query: SELECT pg_encoding_to_char(1); RESULT :c=0.00..0.01 :r=1 :w=0 RESULT :c=0.00..0.01 :r=1 :w=0 SELECT getdatabaseencoding(); $ psql -d dspace -c "SELECT getdatabaseencoding();" SELECT $ more logfile 2003-12-24 09:26:46 LOG:  database system was shut down at 2003-12-24 09:26:26 E ST 2003-12-24 09:26:46 LOG:  checkpoint record is at 0/84FB28 2003-12-24 09:26:46 LOG:  redo record is at 0/84FB28; undo record is at 0/0; shu tdown TRUE 2003-12-24 09:26:46 LOG:  next transaction id: 596; next oid: 25169 2003-12-24 09:26:46 LOG:  database system is ready 2003-12-24 09:26:55 LOG:  query: begin; select getdatabaseencoding(); commit 2003-12-24 09:26:55 LOG:  query: SELECT getdatabaseencoding(); RESULT :c=0.00..0.01 :r=1 :w=0 RESULT :c=0.00..0.01 :r=1 :w=0 Kris Jurka ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend -- Tammy Jones ANALYTICAL SERVICES & MATERIALS NASA LaRC 2 West Durand Street Hampton, VA 23681 Mail Stop 185 Building 1194, Room 106 Phone: 4-8003 Fax: 4-8869 _____________________________________________________ "When your values are clear your decisions are easy" -Walt Disney- _____________________________________________________