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