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

Tammy,

are you building the jar from source? if so can you try running ant test
?
also see my comments below

Dave

On Wed, 2003-12-24 at 09:32, Tammy Jones wrote:
>
> 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();"

you really should be getting something like
~/reiser/informix7.4/bin/psql isp -c "select version()"
version
------------------------------------------------------------------------------------------------------------------
PostgreSQL 7.4informix1.4 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5)
(1 row)

and

~/reiser/informix7.4/bin/psql -d isp -c "select pg_encoding_to_char(1)"
pg_encoding_to_char
---------------------
EUC_JP
(1 row)

not SELECT ??

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