Re: Problem connecting to a pgsql database from Net Beans.

Flavio,

I am not NB expert, but I find it useful to setup my DB connections the
following way,

Before, Configuring Connection Pool to your application, I prefer
setting up the Database connection itself with the specific DB
driver/datasource. I am using NB 5.5 as of now.

1. go to 'Runtime' tab, Click on 'Database'. Expand 'Drivers'. If you do
not have your PG driver setup, set a new Driver by doing right click on
'Drivers' -> 'New Driver'. Here, you could specify the location of the
pgjdbc jar file and you need not worry about keeping that in specific
directory.

2. Now, to setup DB connection, right click on 'Database', 'New
Connection'. Follow the next screen and your connection should be ready,
if things go well, NB will also test your connection as it will report
if the connection has been established or not.

I found this to be pretty useful.
HTH

Mayuresh

Flavio Monteiro wrote:
> Hi,
>
> now I've copied "postgresql-8.2-506.jdbc3.jar" into
> "/opt/SUNWappserver/lib" and Im getting a less scaring log:
>
> RAR5038:Unexpected exception while creating resource
> RAR5117 : Failed to obtain/create connection. Reason : Connection
> could not be allocated because: FATAL: database "null" does not exist
> RAR5114 : Error allocating connection : [Error in allocating a
> connection. Cause: Connection could not be allocated because: FATAL:
> database "null" does not exist]
> java.sql.SQLException: Error in allocating a connection. Cause:
> Connection could not be allocated because: FATAL: database "null" does
> not exist
> StandardWrapperValve[ClientInfo]: Servlet.service() for servlet
> ClientInfo threw exception
> java.lang.NullPointerException
>         at org.ClientInfo.doGet(ClientInfo.java:38)
>         at javax.servlet.http.HttpServlet.service (HttpServlet.java:707)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
>         at
> org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:397)
>         at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:278)
>         at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
>         at org.apache.catalina.core.StandardPipeline.invoke
> (StandardPipeline.java:536)
>         at
> org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:240)
>         at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java
> :179)
>         at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
>         at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
>         at org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:182)
>         at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
>         at
> com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
>         at org.apache.catalina.core.StandardPipeline.doInvoke
> (StandardPipeline.java:566)
>         at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
>         at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
>         at org.apache.coyote.tomcat5.CoyoteAdapter.service
> (CoyoteAdapter.java:239)
>         at
> com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorTask.java:667)
>         at
> com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java
> :574)
>         at
> com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:844)
>         at
> com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
>         at
> com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
>         at
> com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)
>         at com.sun.enterprise.web.connector.grizzly.WorkerThread.run
> (WorkerThread.java:75)
>
>
>
> --
> Flavio Monteiro