Re: [BUGS] BUG #1026: org.apache.commons.dbcp.DbcpException: - Mailing list pgsql-jdbc

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