Re: Problem connecting to a pgsql database from Net Beans.
От | Mayuresh Nirhali |
---|---|
Тема | Re: Problem connecting to a pgsql database from Net Beans. |
Дата | |
Msg-id | 46D69C41.4020807@Sun.COM обсуждение исходный текст |
Ответ на | Problem connecting to a pgsql database from Net Beans. ("Flavio Monteiro" <flaviopinto.monteiro@gmail.com>) |
Список | pgsql-jdbc |
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
В списке pgsql-jdbc по дате отправления: