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

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-
_____________________________________________________