Skip site navigation (1) Skip section navigation (2)

Re: Help with JSP connection with postgreSQL

From: Eduardo V(dot) Rodríguez <evazquez(at)insys-corp(dot)com(dot)mx>
To: 'Edgar Saenz' <edgarsaenz(at)programmer(dot)net>,pgsql-novice(at)postgresql(dot)org
Subject: Re: Help with JSP connection with postgreSQL
Date: 2004-06-10 17:15:37
Message-ID: 59B41C14544D314889E6FA384A307A921C909F@osiris.insys-corp.com.mx (view raw or flat)
Thread:
Lists: pgsql-novice
If you use the correct path from installation postgres should be found in
path

 /usr/local/pgsql/

where resides a directory called "data"

Inside that directory there is a file called pg_hba.conf which contains
whose hosts permissions are granted.

Check if local connections are allowed, or if you are not connecting from
the same host in which the database resides, check the permissions for the
range of ip adress you are connecting of.

I have the same problem with Perl modules, I dont know if Postgres need a
module for Java, but if it needs a module for Java check the installation
process, specially if you have to register an environment variable. like
POSTGRES_INCLUDE or POSTGRES_LIB, that works for me.

Hope can help you

Eduardo Vazquez


-----Original Message-----
From: Edgar Saenz [mailto:edgarsaenz(at)programmer(dot)net]
Sent: Thursday, June 10, 2004 8:36 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Help with JSP connection with postgreSQL


Hello, I am having problems connecting to postgreSQL from my JSP page.
I have followed the instructions from other mailing lists and have 
started the DB with postmaster with the -i option. Also, the 
postgresql.conf, I have set the parameter

tcpip_socket = true
and
port=5432

When I try to connect, I just dont get a connection object.
My working environment is:

-Red Hat Linux
-postgreSQL 7.3
-Java 1.4
-Tomcat 4.1.27

I have runned out of options, any suggestions will be greatly appreciated.

Thanks in advance!!

Rene


-- 
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

pgsql-novice by date

Next:From: Markus BertheauDate: 2004-06-10 17:51:21
Subject: Re: Character encoding in database dumps
Previous:From: Tom LaneDate: 2004-06-10 15:53:20
Subject: Re: query planner woes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group