Re: [Coursework-help] Database Access Error

[Sam O. <sa...@lo...>]

Are you able to access the remote database through psql? 

I turned full logging on in Postgres to better debug Coursework.  This 
shows me all queries, query errors, etc.

I uncommented these 3 lines in Postgres:
------------------------
log_statement = true
log_duration = true
log_timestamp = true
------------------------

The only other line I uncommented in postgresql.conf was:
tcpip_socket = true

Sam

Leonardo Hernandez wrote:

> Hello,
>
> I'm getting an error when trying to connect to database. For example, 
> when I try to access "User Registration" or "User Login" I get this 
> error:
>
> -- WARN [Thread 9] (UserRegistration.java) - DB Error: connection was 
> null
>
> I can't find any other log to help me solve this problem. Any ideas?
> Here is my oracle.properties:
>
> ---------------------------------
> dbDriver=org.postgresql.Driver
> minConns=5
> maxConns=25
> maxConnTime=1.0
>
>
> # mode can be FAILOVER or ORACLE_CONNECTION_POOL(default)
> #mode=FAILOVER
> dbDriver=org.postgresql.Driver
> dbServer=jdbc\:postgresql\://archie/cw
> dbLogin=hernandez
> dbPassword=
>
>
> # add the following properties for DUAL (FAILOVER) mode
> dbServer_failover=jdbc\:postgresql\://archie/cw
> dbLogin_failover=hernandez
> dbPassword_failover=
> ----------------------------------
>
> I access a remote database without password, maybe this is the problem.
>
> Any Ideas?
>
> -Leonardo
>