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

[Mayuresh Nirhali <Mayuresh(dot)Nirhali(at)Sun(dot)COM>]

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