You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by Edson Carlos Ericksson Richter <ed...@brinformatica.srv.br> on 2006/01/22 01:42:50 UTC
Problems configuring DB pool 1.0
Steps to reproduce
1) Give name (jdbc/TestPool)
2) Select driver (MS SQL Server)
3) Driver is not listed on list. So, I got to folder and deployed in
GERONIMO/repository a mssql folder with 3 jars.
4) Got back to browser and click "Refresh".
Now wizard does'nt work anymore. I need to stop Geronimo and start again.
After restart, the problem stay, with the following error log:
22:40:38,000 ERROR [DatabasePoolPortlet] Unable to render portlet
java.lang.NullPointerException
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
t.loadDriverJARList(DatabasePoolPortlet.java:750)
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
t.renderBasicParams(DatabasePoolPortlet.java:721)
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
t.doView(DatabasePoolPortlet.java:625)
at javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:250)
at javax.portlet.GenericPortlet.render(GenericPortlet.java:178)
at
org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:218
)
at
org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:672)
at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
ispatcher.java:574)
at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
patcher.java:499)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
rImpl.java:120)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.render(PortletInvoke
rImpl.java:73)
at
org.apache.pluto.PortletContainerImpl.renderPortlet(PortletContainerI
mpl.java:119)
at
org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.renderPo
rtlet(PortletContainerWrapperImpl.java:70)
at
org.apache.pluto.portalImpl.aggregation.PortletFragment.service(Portl
etFragment.java:168)
at
org.apache.jsp.WEB_002dINF.aggregation.ColumnFragment_jsp._jspService
(org.apache.jsp.WEB_002dINF.aggregation.ColumnFragment_jsp:65)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:322)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
91)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:672)
at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
ispatcher.java:574)
at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
patcher.java:499)
at
org.apache.pluto.portalImpl.aggregation.AbstractFragment.service(Abst
ractFragment.java:112)
at
org.apache.jsp.WEB_002dINF.aggregation.RowFragment_jsp._jspService(or
g.apache.jsp.WEB_002dINF.aggregation.RowFragment_jsp:64)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:322)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
91)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:672)
at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
ispatcher.java:574)
at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
patcher.java:499)
Richter
Re: Problems configuring DB pool 1.0
Posted by Edson Carlos Ericksson Richter <ed...@brinformatica.srv.br>.
Looking at log with more attention, I realized that I could select only
one JAR for the driver. So I'll extract all MS jars and put everything
in one JAR so it could be usable.
May be I should make a RFE to allow more than one JAR to create DB Pool?
Richter
Edson Carlos Ericksson Richter escreveu:
> Ok, I realized I can't just "drop in" the jars into a mssql folder (as
> suggested at db pool portlet page!!!). So, I used web console to
> deploy jars, and now I have following structure:
>
> C:\pgm\geronimo-1.0\repository\mssql\jars\msbase-2000.jar
> C:\pgm\geronimo-1.0\repository\mssql\jars\driver-2000.jar
> C:\pgm\geronimo-1.0\repository\mssql\jars\util-2000.jar
>
> But now, when I complete DB Pool connection configuration, nothing
> happens (and connection pool ins't added).
>
>
> I'll appreciate any help.
>
> Richter
>
>
> Edson Carlos Ericksson Richter escreveu:
>
>> Steps to reproduce
>>
>> 1) Give name (jdbc/TestPool)
>> 2) Select driver (MS SQL Server)
>> 3) Driver is not listed on list. So, I got to folder and deployed in
>> GERONIMO/repository a mssql folder with 3 jars.
>> 4) Got back to browser and click "Refresh".
>>
>> Now wizard does'nt work anymore. I need to stop Geronimo and start
>> again.
>> After restart, the problem stay, with the following error log:
>>
>> 22:40:38,000 ERROR [DatabasePoolPortlet] Unable to render portlet
>> java.lang.NullPointerException
>> at
>> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
>> t.loadDriverJARList(DatabasePoolPortlet.java:750)
>> at
>> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
>> t.renderBasicParams(DatabasePoolPortlet.java:721)
>> at
>> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
>> t.doView(DatabasePoolPortlet.java:625)
>> at
>> javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:250)
>> at javax.portlet.GenericPortlet.render(GenericPortlet.java:178)
>> at
>> org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:218
>> )
>> at
>> org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>> at
>> org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
>>
>> at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>> icationFilterChain.java:252)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>> ilterChain.java:173)
>> at
>> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
>> atcher.java:672)
>> at
>> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
>> ispatcher.java:574)
>> at
>> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
>> patcher.java:499)
>> at
>> org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
>> rImpl.java:120)
>> at
>> org.apache.pluto.invoker.impl.PortletInvokerImpl.render(PortletInvoke
>> rImpl.java:73)
>> at
>> org.apache.pluto.PortletContainerImpl.renderPortlet(PortletContainerI
>> mpl.java:119)
>> at
>> org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.renderPo
>> rtlet(PortletContainerWrapperImpl.java:70)
>> at
>> org.apache.pluto.portalImpl.aggregation.PortletFragment.service(Portl
>> etFragment.java:168)
>> at
>> org.apache.jsp.WEB_002dINF.aggregation.ColumnFragment_jsp._jspService
>> (org.apache.jsp.WEB_002dINF.aggregation.ColumnFragment_jsp:65)
>> at
>> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>> at
>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>> .java:322)
>> at
>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
>> 91)
>> at
>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>> icationFilterChain.java:252)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>> ilterChain.java:173)
>> at
>> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
>> atcher.java:672)
>> at
>> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
>> ispatcher.java:574)
>> at
>> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
>> patcher.java:499)
>> at
>> org.apache.pluto.portalImpl.aggregation.AbstractFragment.service(Abst
>> ractFragment.java:112)
>> at
>> org.apache.jsp.WEB_002dINF.aggregation.RowFragment_jsp._jspService(or
>> g.apache.jsp.WEB_002dINF.aggregation.RowFragment_jsp:64)
>> at
>> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>> at
>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>> .java:322)
>> at
>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
>> 91)
>> at
>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>> icationFilterChain.java:252)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>> ilterChain.java:173)
>> at
>> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
>> atcher.java:672)
>> at
>> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
>> ispatcher.java:574)
>> at
>> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
>> patcher.java:499)
>>
>> Richter
>>
>>
>
>
Re: Problems configuring DB pool 1.0
Posted by Edson Carlos Ericksson Richter <ed...@brinformatica.srv.br>.
Ok, I realized I can't just "drop in" the jars into a mssql folder (as
suggested at db pool portlet page!!!). So, I used web console to deploy
jars, and now I have following structure:
C:\pgm\geronimo-1.0\repository\mssql\jars\msbase-2000.jar
C:\pgm\geronimo-1.0\repository\mssql\jars\driver-2000.jar
C:\pgm\geronimo-1.0\repository\mssql\jars\util-2000.jar
But now, when I complete DB Pool connection configuration, nothing
happens (and connection pool ins't added).
I'll appreciate any help.
Richter
Edson Carlos Ericksson Richter escreveu:
> Steps to reproduce
>
> 1) Give name (jdbc/TestPool)
> 2) Select driver (MS SQL Server)
> 3) Driver is not listed on list. So, I got to folder and deployed in
> GERONIMO/repository a mssql folder with 3 jars.
> 4) Got back to browser and click "Refresh".
>
> Now wizard does'nt work anymore. I need to stop Geronimo and start again.
> After restart, the problem stay, with the following error log:
>
> 22:40:38,000 ERROR [DatabasePoolPortlet] Unable to render portlet
> java.lang.NullPointerException
> at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
> t.loadDriverJARList(DatabasePoolPortlet.java:750)
> at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
> t.renderBasicParams(DatabasePoolPortlet.java:721)
> at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
> t.doView(DatabasePoolPortlet.java:625)
> at
> javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:250)
> at javax.portlet.GenericPortlet.render(GenericPortlet.java:178)
> at
> org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:218
> )
> at
> org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:173)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
> atcher.java:672)
> at
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
> ispatcher.java:574)
> at
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
> patcher.java:499)
> at
> org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
> rImpl.java:120)
> at
> org.apache.pluto.invoker.impl.PortletInvokerImpl.render(PortletInvoke
> rImpl.java:73)
> at
> org.apache.pluto.PortletContainerImpl.renderPortlet(PortletContainerI
> mpl.java:119)
> at
> org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.renderPo
> rtlet(PortletContainerWrapperImpl.java:70)
> at
> org.apache.pluto.portalImpl.aggregation.PortletFragment.service(Portl
> etFragment.java:168)
> at
> org.apache.jsp.WEB_002dINF.aggregation.ColumnFragment_jsp._jspService
> (org.apache.jsp.WEB_002dINF.aggregation.ColumnFragment_jsp:65)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
> .java:322)
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
> 91)
> at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:173)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
> atcher.java:672)
> at
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
> ispatcher.java:574)
> at
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
> patcher.java:499)
> at
> org.apache.pluto.portalImpl.aggregation.AbstractFragment.service(Abst
> ractFragment.java:112)
> at
> org.apache.jsp.WEB_002dINF.aggregation.RowFragment_jsp._jspService(or
> g.apache.jsp.WEB_002dINF.aggregation.RowFragment_jsp:64)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
> .java:322)
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
> 91)
> at
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:173)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
> atcher.java:672)
> at
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
> ispatcher.java:574)
> at
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
> patcher.java:499)
>
> Richter
>
>
Re: Problems configuring DB pool 1.0 - SOLVED (partially)
Posted by Edson Carlos Ericksson Richter <ed...@brinformatica.srv.br>.
Ok, downloaded Geronimo+Jetty and everthing works.
Using Geronimo+Tomcat I was able to test deployment, but not show plan
neither deploy.
Richter
Re: Problems configuring DB pool 1.0 - SOLVED (partially)
Posted by Edson Carlos Ericksson Richter <ed...@brinformatica.srv.br>.
Solved (it's a real Geronimo BUG)!!!
The problem is Geronimo-1421: I can't type ; in url using
Geronimo-Tomcat. I didn't tested with Jetty.
So I created a user which default database is database I want, and
didn't touch url neither fill in "database name" field.
Best regards,
Richter
Edson Carlos Ericksson Richter escreveu:
> Advance (but still not works)!
>
> I didn't fill "Database" field (keep it empty).
>
> Now, I beign sent to "*Create Database Pool* -- Step 3: Final Pool
> Configuration".
>
> I fill in:
>
> url =
> "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Biblio;SelectMethod=Cursor;"
>
> Driver Status = /Loaded Successfully/
> Pool min size = 2
> Pool max size = 10
> Blocking timeout (millis) = 5000
> Idle timeout (min) = 10
>
>
> click "Skip test and deploy". Nothing happens, pool is not created. On
> server window I got following stack trace:
>
>
> 23:50:24,343 ERROR [[DBWizard]] Servlet.service() for servlet DBWizard
> threw exc
> eption
> java.lang.NullPointerException
> at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
> t.save(DatabasePoolPortlet.java:809)
> at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
> t.processAction(DatabasePoolPortlet.java:334)
> at
> org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229
> )
> at
> org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:173)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
> atcher.java:672)
> at
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
> ispatcher.java:574)
> at
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
> patcher.java:499)
> at
> org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
> rImpl.java:120)
> at
> org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvoke
> rImpl.java:68)
> at
> org.apache.pluto.PortletContainerImpl.processPortletAction(PortletCon
> tainerImpl.java:164)
> at
> org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processP
> ortletAction(PortletContainerWrapperImpl.java:82)
> at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
> alve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
> alve.java:178)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
> torBase.java:482)
> at
> org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.
> invoke(GeronimoStandardContext.java:272)
> at
> org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSu
> bjectValve.java:46)
> at
> org.apache.geronimo.tomcat.valve.PolicyContextValve.invoke(PolicyCont
> extValve.java:50)
> at
> org.apache.geronimo.tomcat.valve.TransactionContextValve.invoke(Trans
> actionContextValve.java:53)
> at
> org.apache.geronimo.tomcat.valve.ComponentContextValve.invoke(Compone
> ntContextValve.java:47)
> at
> org.apache.geronimo.tomcat.valve.InstanceContextValve.invoke(Instance
> ContextValve.java:60)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
> ava:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
> ava:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
> ve.java:107)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
> 526)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
> a:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
> :856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
> ssConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
> int.java:527)
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
> lowerWorkerThread.java:80)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
> ool.java:684)
> at java.lang.Thread.run(Thread.java:595)
> 23:50:24,343 ERROR [Servlet] Exception caught:
> java.lang.NullPointerException
> at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
> t.save(DatabasePoolPortlet.java:809)
> at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
> t.processAction(DatabasePoolPortlet.java:334)
> at
> org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229
> )
> at
> org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:173)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
> atcher.java:672)
> at
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
> ispatcher.java:574)
> at
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
> patcher.java:499)
> at
> org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
> rImpl.java:120)
> at
> org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvoke
> rImpl.java:68)
> at
> org.apache.pluto.PortletContainerImpl.processPortletAction(PortletCon
> tainerImpl.java:164)
> at
> org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processP
> ortletAction(PortletContainerWrapperImpl.java:82)
> at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
> alve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
> alve.java:178)
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
> torBase.java:482)
> at
> org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.
> invoke(GeronimoStandardContext.java:272)
> at
> org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSu
> bjectValve.java:46)
> at
> org.apache.geronimo.tomcat.valve.PolicyContextValve.invoke(PolicyCont
> extValve.java:50)
> at
> org.apache.geronimo.tomcat.valve.TransactionContextValve.invoke(Trans
> actionContextValve.java:53)
> at
> org.apache.geronimo.tomcat.valve.ComponentContextValve.invoke(Compone
> ntContextValve.java:47)
> at
> org.apache.geronimo.tomcat.valve.InstanceContextValve.invoke(Instance
> ContextValve.java:60)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
> ava:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
> ava:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
> ve.java:107)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
> 526)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
> a:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
> :856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
> ssConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
> int.java:527)
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
> lowerWorkerThread.java:80)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
> ool.java:684)
> at java.lang.Thread.run(Thread.java:595)
>
Re: Problems configuring DB pool 1.0
Posted by Stanley Bradbury <St...@gmail.com>.
Maurice wrote:
>Were you able to get a db pool created in Geronimo for Sql Server? I have not
>been able to get a connection yet.
>
>Thanks for any information
>Maurice
>
>
>
>
>
I don't know about SQL Server but don't think it could be too different
from other DBs. Take a look at this paper that describes setting up a
pool using Derby to see if it helps:
http://db.apache.org/derby/integrate/JPetStoreGeronimo.html
RE: Problems configuring DB pool 1.0
Posted by Lin Sun <li...@gmail.com>.
My understanding is that the generic Tranql resource adapter doesn't support
MS SQL server but I haven't tried verifying this myself. I had to use a
proprietary vendor resource adapter for MS SQL server.
Thanks,
Lin
-----Original Message-----
From: news [mailto:news@sea.gmane.org] On Behalf Of Maurice
Sent: Wednesday, March 01, 2006 7:51 PM
To: user@geronimo.apache.org
Subject: Re: Problems configuring DB pool 1.0
Were you able to get a db pool created in Geronimo for Sql Server? I have
not
been able to get a connection yet.
Thanks for any information
Maurice
Re: Problems configuring DB pool 1.0
Posted by Maurice <mo...@yahoo.com>.
Were you able to get a db pool created in Geronimo for Sql Server? I have not
been able to get a connection yet.
Thanks for any information
Maurice
Re: Problems configuring DB pool 1.0
Posted by Edson Carlos Ericksson Richter <ed...@brinformatica.srv.br>.
Advance (but still not works)!
I didn't fill "Database" field (keep it empty).
Now, I beign sent to "*Create Database Pool* -- Step 3: Final Pool
Configuration".
I fill in:
url =
"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Biblio;SelectMethod=Cursor;"
Driver Status = /Loaded Successfully/
Pool min size = 2
Pool max size = 10
Blocking timeout (millis) = 5000
Idle timeout (min) = 10
click "Skip test and deploy". Nothing happens, pool is not created. On
server window I got following stack trace:
23:50:24,343 ERROR [[DBWizard]] Servlet.service() for servlet DBWizard
threw exc
eption
java.lang.NullPointerException
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
t.save(DatabasePoolPortlet.java:809)
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
t.processAction(DatabasePoolPortlet.java:334)
at
org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229
)
at
org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:672)
at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
ispatcher.java:574)
at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
patcher.java:499)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
rImpl.java:120)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvoke
rImpl.java:68)
at
org.apache.pluto.PortletContainerImpl.processPortletAction(PortletCon
tainerImpl.java:164)
at
org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processP
ortletAction(PortletContainerWrapperImpl.java:82)
at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:482)
at
org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.
invoke(GeronimoStandardContext.java:272)
at
org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSu
bjectValve.java:46)
at
org.apache.geronimo.tomcat.valve.PolicyContextValve.invoke(PolicyCont
extValve.java:50)
at
org.apache.geronimo.tomcat.valve.TransactionContextValve.invoke(Trans
actionContextValve.java:53)
at
org.apache.geronimo.tomcat.valve.ComponentContextValve.invoke(Compone
ntContextValve.java:47)
at
org.apache.geronimo.tomcat.valve.InstanceContextValve.invoke(Instance
ContextValve.java:60)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
526)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ssConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:684)
at java.lang.Thread.run(Thread.java:595)
23:50:24,343 ERROR [Servlet] Exception caught:
java.lang.NullPointerException
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
t.save(DatabasePoolPortlet.java:809)
at
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
t.processAction(DatabasePoolPortlet.java:334)
at
org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229
)
at
org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:672)
at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
ispatcher.java:574)
at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
patcher.java:499)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
rImpl.java:120)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvoke
rImpl.java:68)
at
org.apache.pluto.PortletContainerImpl.processPortletAction(PortletCon
tainerImpl.java:164)
at
org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processP
ortletAction(PortletContainerWrapperImpl.java:82)
at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:482)
at
org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.
invoke(GeronimoStandardContext.java:272)
at
org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSu
bjectValve.java:46)
at
org.apache.geronimo.tomcat.valve.PolicyContextValve.invoke(PolicyCont
extValve.java:50)
at
org.apache.geronimo.tomcat.valve.TransactionContextValve.invoke(Trans
actionContextValve.java:53)
at
org.apache.geronimo.tomcat.valve.ComponentContextValve.invoke(Compone
ntContextValve.java:47)
at
org.apache.geronimo.tomcat.valve.InstanceContextValve.invoke(Instance
ContextValve.java:60)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
526)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ssConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:684)
at java.lang.Thread.run(Thread.java:595)
Re: Problems configuring DB pool 1.0
Posted by Edson Carlos Ericksson Richter <ed...@brinformatica.srv.br>.
I tryied to import a jboss datasource (that works actually). On log appear:
23:31:24,656 WARN [DatabasePoolPortlet] Import Results:
23:31:24,656 WARN [DatabasePoolPortlet] 0 ignored
23:31:24,656 WARN [DatabasePoolPortlet] 1 reviewed but not deployed
23:31:24,656 WARN [DatabasePoolPortlet] 0 not reviewed
23:31:24,656 WARN [DatabasePoolPortlet] 0 deployed
And in portlet, the import never got out of "Started" status... May be a
"ajax" issue?
Richter
Edson Carlos Ericksson Richter escreveu:
> Ok, still not work. Now, I have no log message explain why didn't work.
>
> I've created a all-in-one JAR with contents from 3 ms jars, but not
> worked. I could run all steps to create the pool, and no error message
> appear in log. But the pool ins't created.
>
> I'll try jTds 1.1...
>
> Richter
>
>
> Edson Carlos Ericksson Richter escreveu:
>
>> The jTds 1.2 driver didn't worked too. I'll make more investigation.
>> In meanwhile, I'm testing a "all-in-one-mssql2000-driver.jar" I
>> created myself.
>>
>> I'll let you know if this worked.
>>
>> Thanks,
>>
>> Richter
>>
>>
>>
>> Aaron Mulder escreveu:
>>
>>> This is mentioned in the following JIRA issue:
>>>
>>> http://issues.apache.org/jira/browse/GERONIMO-1467
>>>
>>> It seems like the problem is that the SQL Server drivers need to have
>>> a version in the file name. Such as:
>>> repository/mssql/jars/foo-1.0.jar
>>>
>>> However, you'll probably run into another problem afterward which is
>>> that we don't currently let you select more than 1 JAR for the driver.
>>> What you'll need to do to work around that is to select one of the
>>> JARs and have the console generate a plan for you (without trying to
>>> test the connection), then copy the dependency element in the plan for
>>> the 2 other JARs and deploy the pool at the command line.
>>>
>>> If you just want to get up and running quickly you can have Geronimo
>>> download the jTDS driver to connect to SQL Server, and use that driver
>>> instead.
>>>
>>> Thanks,
>>> Aaron
>>>
>>> On 1/21/06, Edson Carlos Ericksson Richter
>>> <ed...@brinformatica.srv.br> wrote:
>>>
>>>
>>>> Steps to reproduce
>>>>
>>>> 1) Give name (jdbc/TestPool)
>>>> 2) Select driver (MS SQL Server)
>>>> 3) Driver is not listed on list. So, I got to folder and deployed in
>>>> GERONIMO/repository a mssql folder with 3 jars.
>>>> 4) Got back to browser and click "Refresh".
>>>>
>>>> Now wizard does'nt work anymore. I need to stop Geronimo and start
>>>> again.
>>>> After restart, the problem stay, with the following error log:
>>>>
>>>> 22:40:38,000 ERROR [DatabasePoolPortlet] Unable to render portlet
>>>> java.lang.NullPointerException
>>>> at
>>>> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
>>>> t.loadDriverJARList(DatabasePoolPortlet.java:750)
>>>> at
>>>> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
>>>> t.renderBasicParams(DatabasePoolPortlet.java:721)
>>>> at
>>>> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
>>>> t.doView(DatabasePoolPortlet.java:625)
>>>> at
>>>> javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:250)
>>>> at javax.portlet.GenericPortlet.render(GenericPortlet.java:178)
>>>> at
>>>> org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:218
>>>> )
>>>> at
>>>> org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>>> at
>>>> org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
>>>>
>>>> at
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>>>> icationFilterChain.java:252)
>>>> at
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>>>> ilterChain.java:173)
>>>> at
>>>> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
>>>> atcher.java:672)
>>>> at
>>>> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
>>>> ispatcher.java:574)
>>>> at
>>>> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
>>>> patcher.java:499)
>>>> at
>>>> org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
>>>> rImpl.java:120)
>>>> at
>>>> org.apache.pluto.invoker.impl.PortletInvokerImpl.render(PortletInvoke
>>>> rImpl.java:73)
>>>> at
>>>> org.apache.pluto.PortletContainerImpl.renderPortlet(PortletContainerI
>>>> mpl.java:119)
>>>> at
>>>> org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.renderPo
>>>> rtlet(PortletContainerWrapperImpl.java:70)
>>>> at
>>>> org.apache.pluto.portalImpl.aggregation.PortletFragment.service(Portl
>>>> etFragment.java:168)
>>>> at
>>>> org.apache.jsp.WEB_002dINF.aggregation.ColumnFragment_jsp._jspService
>>>> (org.apache.jsp.WEB_002dINF.aggregation.ColumnFragment_jsp:65)
>>>> at
>>>> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>>> at
>>>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>>>> .java:322)
>>>> at
>>>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
>>>> 91)
>>>> at
>>>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>>> at
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>>>> icationFilterChain.java:252)
>>>> at
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>>>> ilterChain.java:173)
>>>> at
>>>> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
>>>> atcher.java:672)
>>>> at
>>>> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
>>>> ispatcher.java:574)
>>>> at
>>>> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
>>>> patcher.java:499)
>>>> at
>>>> org.apache.pluto.portalImpl.aggregation.AbstractFragment.service(Abst
>>>> ractFragment.java:112)
>>>> at
>>>> org.apache.jsp.WEB_002dINF.aggregation.RowFragment_jsp._jspService(or
>>>> g.apache.jsp.WEB_002dINF.aggregation.RowFragment_jsp:64)
>>>> at
>>>> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>>> at
>>>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>>>> .java:322)
>>>> at
>>>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
>>>> 91)
>>>> at
>>>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
>>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>>> at
>>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>>>> icationFilterChain.java:252)
>>>> at
>>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>>>> ilterChain.java:173)
>>>> at
>>>> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
>>>> atcher.java:672)
>>>> at
>>>> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
>>>> ispatcher.java:574)
>>>> at
>>>> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
>>>> patcher.java:499)
>>>>
>>>> Richter
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>
>
Re: Problems configuring DB pool 1.0
Posted by Edson Carlos Ericksson Richter <ed...@brinformatica.srv.br>.
Ok, still not work. Now, I have no log message explain why didn't work.
I've created a all-in-one JAR with contents from 3 ms jars, but not
worked. I could run all steps to create the pool, and no error message
appear in log. But the pool ins't created.
I'll try jTds 1.1...
Richter
Edson Carlos Ericksson Richter escreveu:
> The jTds 1.2 driver didn't worked too. I'll make more investigation.
> In meanwhile, I'm testing a "all-in-one-mssql2000-driver.jar" I
> created myself.
>
> I'll let you know if this worked.
>
> Thanks,
>
> Richter
>
>
>
> Aaron Mulder escreveu:
>
>> This is mentioned in the following JIRA issue:
>>
>> http://issues.apache.org/jira/browse/GERONIMO-1467
>>
>> It seems like the problem is that the SQL Server drivers need to have
>> a version in the file name. Such as:
>> repository/mssql/jars/foo-1.0.jar
>>
>> However, you'll probably run into another problem afterward which is
>> that we don't currently let you select more than 1 JAR for the driver.
>> What you'll need to do to work around that is to select one of the
>> JARs and have the console generate a plan for you (without trying to
>> test the connection), then copy the dependency element in the plan for
>> the 2 other JARs and deploy the pool at the command line.
>>
>> If you just want to get up and running quickly you can have Geronimo
>> download the jTDS driver to connect to SQL Server, and use that driver
>> instead.
>>
>> Thanks,
>> Aaron
>>
>> On 1/21/06, Edson Carlos Ericksson Richter
>> <ed...@brinformatica.srv.br> wrote:
>>
>>
>>> Steps to reproduce
>>>
>>> 1) Give name (jdbc/TestPool)
>>> 2) Select driver (MS SQL Server)
>>> 3) Driver is not listed on list. So, I got to folder and deployed in
>>> GERONIMO/repository a mssql folder with 3 jars.
>>> 4) Got back to browser and click "Refresh".
>>>
>>> Now wizard does'nt work anymore. I need to stop Geronimo and start
>>> again.
>>> After restart, the problem stay, with the following error log:
>>>
>>> 22:40:38,000 ERROR [DatabasePoolPortlet] Unable to render portlet
>>> java.lang.NullPointerException
>>> at
>>> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
>>> t.loadDriverJARList(DatabasePoolPortlet.java:750)
>>> at
>>> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
>>> t.renderBasicParams(DatabasePoolPortlet.java:721)
>>> at
>>> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
>>> t.doView(DatabasePoolPortlet.java:625)
>>> at
>>> javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:250)
>>> at javax.portlet.GenericPortlet.render(GenericPortlet.java:178)
>>> at
>>> org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:218
>>> )
>>> at
>>> org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>> at
>>> org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
>>>
>>> at
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>>> icationFilterChain.java:252)
>>> at
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>>> ilterChain.java:173)
>>> at
>>> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
>>> atcher.java:672)
>>> at
>>> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
>>> ispatcher.java:574)
>>> at
>>> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
>>> patcher.java:499)
>>> at
>>> org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
>>> rImpl.java:120)
>>> at
>>> org.apache.pluto.invoker.impl.PortletInvokerImpl.render(PortletInvoke
>>> rImpl.java:73)
>>> at
>>> org.apache.pluto.PortletContainerImpl.renderPortlet(PortletContainerI
>>> mpl.java:119)
>>> at
>>> org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.renderPo
>>> rtlet(PortletContainerWrapperImpl.java:70)
>>> at
>>> org.apache.pluto.portalImpl.aggregation.PortletFragment.service(Portl
>>> etFragment.java:168)
>>> at
>>> org.apache.jsp.WEB_002dINF.aggregation.ColumnFragment_jsp._jspService
>>> (org.apache.jsp.WEB_002dINF.aggregation.ColumnFragment_jsp:65)
>>> at
>>> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>> at
>>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>>> .java:322)
>>> at
>>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
>>> 91)
>>> at
>>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>> at
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>>> icationFilterChain.java:252)
>>> at
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>>> ilterChain.java:173)
>>> at
>>> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
>>> atcher.java:672)
>>> at
>>> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
>>> ispatcher.java:574)
>>> at
>>> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
>>> patcher.java:499)
>>> at
>>> org.apache.pluto.portalImpl.aggregation.AbstractFragment.service(Abst
>>> ractFragment.java:112)
>>> at
>>> org.apache.jsp.WEB_002dINF.aggregation.RowFragment_jsp._jspService(or
>>> g.apache.jsp.WEB_002dINF.aggregation.RowFragment_jsp:64)
>>> at
>>> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>> at
>>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>>> .java:322)
>>> at
>>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
>>> 91)
>>> at
>>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>> at
>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>>> icationFilterChain.java:252)
>>> at
>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>>> ilterChain.java:173)
>>> at
>>> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
>>> atcher.java:672)
>>> at
>>> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
>>> ispatcher.java:574)
>>> at
>>> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
>>> patcher.java:499)
>>>
>>> Richter
>>>
>>>
>>>
>>
>>
>>
>>
>
>
Re: Problems configuring DB pool 1.0
Posted by Edson Carlos Ericksson Richter <ed...@brinformatica.srv.br>.
The jTds 1.2 driver didn't worked too. I'll make more investigation.
In meanwhile, I'm testing a "all-in-one-mssql2000-driver.jar" I created
myself.
I'll let you know if this worked.
Thanks,
Richter
Aaron Mulder escreveu:
>This is mentioned in the following JIRA issue:
>
>http://issues.apache.org/jira/browse/GERONIMO-1467
>
>It seems like the problem is that the SQL Server drivers need to have
>a version in the file name. Such as:
>repository/mssql/jars/foo-1.0.jar
>
>However, you'll probably run into another problem afterward which is
>that we don't currently let you select more than 1 JAR for the driver.
> What you'll need to do to work around that is to select one of the
>JARs and have the console generate a plan for you (without trying to
>test the connection), then copy the dependency element in the plan for
>the 2 other JARs and deploy the pool at the command line.
>
>If you just want to get up and running quickly you can have Geronimo
>download the jTDS driver to connect to SQL Server, and use that driver
>instead.
>
>Thanks,
> Aaron
>
>On 1/21/06, Edson Carlos Ericksson Richter
><ed...@brinformatica.srv.br> wrote:
>
>
>>Steps to reproduce
>>
>>1) Give name (jdbc/TestPool)
>>2) Select driver (MS SQL Server)
>>3) Driver is not listed on list. So, I got to folder and deployed in
>>GERONIMO/repository a mssql folder with 3 jars.
>>4) Got back to browser and click "Refresh".
>>
>>Now wizard does'nt work anymore. I need to stop Geronimo and start again.
>>After restart, the problem stay, with the following error log:
>>
>>22:40:38,000 ERROR [DatabasePoolPortlet] Unable to render portlet
>>java.lang.NullPointerException
>> at
>>org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
>>t.loadDriverJARList(DatabasePoolPortlet.java:750)
>> at
>>org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
>>t.renderBasicParams(DatabasePoolPortlet.java:721)
>> at
>>org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
>>t.doView(DatabasePoolPortlet.java:625)
>> at javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:250)
>> at javax.portlet.GenericPortlet.render(GenericPortlet.java:178)
>> at
>>org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:218
>>)
>> at
>>org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>> at
>>org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
>>
>> at
>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>>icationFilterChain.java:252)
>> at
>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>>ilterChain.java:173)
>> at
>>org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
>>atcher.java:672)
>> at
>>org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
>>ispatcher.java:574)
>> at
>>org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
>>patcher.java:499)
>> at
>>org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
>>rImpl.java:120)
>> at
>>org.apache.pluto.invoker.impl.PortletInvokerImpl.render(PortletInvoke
>>rImpl.java:73)
>> at
>>org.apache.pluto.PortletContainerImpl.renderPortlet(PortletContainerI
>>mpl.java:119)
>> at
>>org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.renderPo
>>rtlet(PortletContainerWrapperImpl.java:70)
>> at
>>org.apache.pluto.portalImpl.aggregation.PortletFragment.service(Portl
>>etFragment.java:168)
>> at
>>org.apache.jsp.WEB_002dINF.aggregation.ColumnFragment_jsp._jspService
>>(org.apache.jsp.WEB_002dINF.aggregation.ColumnFragment_jsp:65)
>> at
>>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>> at
>>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>>.java:322)
>> at
>>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
>>91)
>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>> at
>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>>icationFilterChain.java:252)
>> at
>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>>ilterChain.java:173)
>> at
>>org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
>>atcher.java:672)
>> at
>>org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
>>ispatcher.java:574)
>> at
>>org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
>>patcher.java:499)
>> at
>>org.apache.pluto.portalImpl.aggregation.AbstractFragment.service(Abst
>>ractFragment.java:112)
>> at
>>org.apache.jsp.WEB_002dINF.aggregation.RowFragment_jsp._jspService(or
>>g.apache.jsp.WEB_002dINF.aggregation.RowFragment_jsp:64)
>> at
>>org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>> at
>>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
>>.java:322)
>> at
>>org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
>>91)
>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>> at
>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
>>icationFilterChain.java:252)
>> at
>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
>>ilterChain.java:173)
>> at
>>org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
>>atcher.java:672)
>> at
>>org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
>>ispatcher.java:574)
>> at
>>org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
>>patcher.java:499)
>>
>>Richter
>>
>>
>>
>>
>
>
>
Re: Problems configuring DB pool 1.0
Posted by Aaron Mulder <am...@alumni.princeton.edu>.
This is mentioned in the following JIRA issue:
http://issues.apache.org/jira/browse/GERONIMO-1467
It seems like the problem is that the SQL Server drivers need to have
a version in the file name. Such as:
repository/mssql/jars/foo-1.0.jar
However, you'll probably run into another problem afterward which is
that we don't currently let you select more than 1 JAR for the driver.
What you'll need to do to work around that is to select one of the
JARs and have the console generate a plan for you (without trying to
test the connection), then copy the dependency element in the plan for
the 2 other JARs and deploy the pool at the command line.
If you just want to get up and running quickly you can have Geronimo
download the jTDS driver to connect to SQL Server, and use that driver
instead.
Thanks,
Aaron
On 1/21/06, Edson Carlos Ericksson Richter
<ed...@brinformatica.srv.br> wrote:
> Steps to reproduce
>
> 1) Give name (jdbc/TestPool)
> 2) Select driver (MS SQL Server)
> 3) Driver is not listed on list. So, I got to folder and deployed in
> GERONIMO/repository a mssql folder with 3 jars.
> 4) Got back to browser and click "Refresh".
>
> Now wizard does'nt work anymore. I need to stop Geronimo and start again.
> After restart, the problem stay, with the following error log:
>
> 22:40:38,000 ERROR [DatabasePoolPortlet] Unable to render portlet
> java.lang.NullPointerException
> at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
> t.loadDriverJARList(DatabasePoolPortlet.java:750)
> at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
> t.renderBasicParams(DatabasePoolPortlet.java:721)
> at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortle
> t.doView(DatabasePoolPortlet.java:625)
> at javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:250)
> at javax.portlet.GenericPortlet.render(GenericPortlet.java:178)
> at
> org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:218
> )
> at
> org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:173)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
> atcher.java:672)
> at
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
> ispatcher.java:574)
> at
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
> patcher.java:499)
> at
> org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
> rImpl.java:120)
> at
> org.apache.pluto.invoker.impl.PortletInvokerImpl.render(PortletInvoke
> rImpl.java:73)
> at
> org.apache.pluto.PortletContainerImpl.renderPortlet(PortletContainerI
> mpl.java:119)
> at
> org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.renderPo
> rtlet(PortletContainerWrapperImpl.java:70)
> at
> org.apache.pluto.portalImpl.aggregation.PortletFragment.service(Portl
> etFragment.java:168)
> at
> org.apache.jsp.WEB_002dINF.aggregation.ColumnFragment_jsp._jspService
> (org.apache.jsp.WEB_002dINF.aggregation.ColumnFragment_jsp:65)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
> .java:322)
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
> 91)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:173)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
> atcher.java:672)
> at
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
> ispatcher.java:574)
> at
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
> patcher.java:499)
> at
> org.apache.pluto.portalImpl.aggregation.AbstractFragment.service(Abst
> ractFragment.java:112)
> at
> org.apache.jsp.WEB_002dINF.aggregation.RowFragment_jsp._jspService(or
> g.apache.jsp.WEB_002dINF.aggregation.RowFragment_jsp:64)
> at
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
> .java:322)
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:2
> 91)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:173)
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
> atcher.java:672)
> at
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
> ispatcher.java:574)
> at
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
> patcher.java:499)
>
> Richter
>
>