You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by Rajiv M <rm...@gmail.com> on 2007/02/24 18:28:58 UTC
Error when deploying a SQL Server DBpool with jtds 1.2 driver
Hello,
While creating a SQL Server database pool with the below settings:
Driver: net.sourceforge.jtds.jdbc.Driver
JAR: jtds/jtds/1.2/jar
Database: <database name>
Host: <server name>
Connect String: jdbc:jtds:sqlserver://<server name>;DatabaseName=<database name>
Test connection was successful. But "deploy" or "show plan" ended in
the below error:
21:30:27,044 DEBUG [ApplicationDispatcher] servletPath=/DBWizard,
pathInfo=/*, queryString=null, name=null
21:30:27,044 DEBUG [ApplicationDispatcher] Path Based Include
21:30:27,064 ERROR [DatabasePoolPortlet] Unable to save connection pool
java.lang.NullPointerException
at org.apache.geronimo.kernel.repository.Artifact.create(Artifact.java:47)
at org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.getRAR(DatabasePoolPortlet.java:1059)
at org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.save(DatabasePoolPortlet.java:894)
at org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.processAction(DatabasePoolPortlet.java:344)
at org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229)
at org.apache.pluto.core.PortletServlet.doPost(PortletServlet.java:163)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
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(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
at org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvokerImpl.java:120)
at org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvokerImpl.java:68)
at org.apache.pluto.PortletContainerImpl.processPortletAction(PortletContainerImpl.java:164)
at org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processPortletAction(PortletContainerWrapperImpl.java:82)
at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
at org.apache.pluto.portalImpl.Servlet.doPost(Servlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:56)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
at org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:342)
at org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:31)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:419)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:869)
at java.lang.Thread.run(Thread.java:797)
How to solve this problem
Thanks
Rajiv
Re: Error when deploying a SQL Server DBpool with jtds 1.2 driver
Posted by Peter Petersson <pe...@pmb.mine.nu>.
That line should be perfectly right, I am not sure but I think that you
may have missed editing the line below it
<dep:artifactId>MSSqlDB_Name</dep:artifactId>
MSSqlDB_Name <<== should be what ever name you use in your
geronimo-web.xml sys:resource-link
Also the <connectiondefinition-instance> data have to match your naming
pw user and so on.
/Peter
grimba e skrev:
> you must create a file xml and to do deploy manual, wizard this bad
> one, you must arnar them you yourself…. I send an example to you
>
> */<dep:groupId>console.dbpool</dep:groupId>/*
> line bad
>
>
> Rodrigo Baeza.
>
> 2007/2/25, Peter Petersson <peter@pmb.mine.nu
> <ma...@pmb.mine.nu>>:
>
> If I remember right the is (has been) some problem creating/deploying
> mysql database plans from the Geronimo ( 1.1/1.1.1) console.
> Deploying using the command line tools should solve your problem, see
> example below for command and plan template:
>
> Command (on a Unix/linux system):
> cd GERONIMO_HOME
> java -jar bin/deployer.jar deploy /path_to/mssqldb_pool_plan.xml
> repository/tranql/tranql-connector/1.2/tranql-connector-1.2.rar
>
> Using the following plan (mssqldb_pool_plan.xml edit where
> appropriate):
>
> <?xml version="1.0" encoding="UTF-8"?>
> <connector
> xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.1">
> <dep:environment
> xmlns:dep=" http://geronimo.apache.org/xml/ns/deployment-1.1">
> <dep:moduleId>
> <dep:groupId>console.dbpool</dep:groupId>
> <dep:artifactId>MSSqlDB_Name</dep:artifactId>
> <dep:version>1.0</dep:version>
> <dep:type>rar</dep:type>
> </dep:moduleId>
> <dep:dependencies>
> <dep:dependency>
> <dep:groupId>jtds</dep:groupId>
> <dep:artifactId>jtds</dep:artifactId>
> <dep:version>1.2</dep:version>
> <dep:type>jar</dep:type>
> </dep:dependency>
> </dep:dependencies>
> </dep:environment>
> <resourceadapter>
> <outbound-resourceadapter>
> <connection-definition>
>
> <connectionfactory-interface>
> javax.sql.DataSource</connectionfactory-interface>
> <connectiondefinition-instance>
> <name>MSSqlDB_Tois</name>
> <config-property-setting
> name="Password">the_pw</config-property-setting>
> <config-property-setting
> name="Driver">net.sourceforge.jtds.jdbc.Driver</config-property-setting>
> <config-property-setting
> name="UserName">the_user</config-property-setting>
> <config-property-setting
> name="ConnectionURL">jdbc:jtds:sqlserver://db_server:1433/db_name</config-property-setting>
>
> <connectionmanager>
> <local-transaction/>
> <single-pool>
> <max-size>10</max-size>
> <min-size>0</min-size>
>
> <blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>
>
> <idle-timeout-minutes>30</idle-timeout-minutes>
> <match-one/>
> </single-pool>
> </connectionmanager>
> </connectiondefinition-instance>
> </connection-definition>
> </outbound-resourceadapter>
> </resourceadapter>
> </connector>
>
> Thats it I hope it helps.
> /Peter
>
> Rajiv M skrev:
> > Hello,
> >
> > While creating a SQL Server database pool with the below settings:
> > Driver: net.sourceforge.jtds.jdbc.Driver
> > JAR: jtds/jtds/1.2/jar
> > Database: <database name>
> > Host: <server name>
> > Connect String: jdbc:jtds:sqlserver://<server
> > name>;DatabaseName=<database name>
> >
> > Test connection was successful. But "deploy" or "show plan" ended in
> > the below error:
> >
> > 21:30:27,044 DEBUG [ApplicationDispatcher] servletPath=/DBWizard,
> > pathInfo=/*, queryString=null, name=null
> > 21:30:27,044 DEBUG [ApplicationDispatcher] Path Based Include
> > 21:30:27,064 ERROR [DatabasePoolPortlet] Unable to save
> connection pool
> > java.lang.NullPointerException
> > at
> > org.apache.geronimo.kernel.repository.Artifact.create
> (Artifact.java:47)
> > at
> >
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.getRAR(DatabasePoolPortlet.java:1059)
> >
> > at
> >
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.save
> (DatabasePoolPortlet.java:894)
> >
> > at
> >
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.processAction(DatabasePoolPortlet.java:344)
> >
> > at
> > org.apache.pluto.core.PortletServlet.dispatch
> (PortletServlet.java:229)
> > at
> > org.apache.pluto.core.PortletServlet.doPost(PortletServlet.java:163)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
> > 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(ApplicationFilterChain.java
> :252)
> >
> > at
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> >
> > at
> >
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java
> :672)
> >
> > at
> >
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)
> >
> > at
> >
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java
> :499)
> >
> > at
> >
> org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvokerImpl.java:120)
> >
> > at
> >
> org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvokerImpl.java
> :68)
> >
> > at
> >
> org.apache.pluto.PortletContainerImpl.processPortletAction(PortletContainerImpl.java:164)
> >
> > at
> >
> org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processPortletAction
> (PortletContainerWrapperImpl.java:82)
> >
> > at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
> > at org.apache.pluto.portalImpl.Servlet.doPost(Servlet.java:267)
> > at javax.servlet.http.HttpServlet.service (HttpServlet.java:615)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> > at
> >
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> >
> > at
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> >
> > at
> >
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java
> :213)
> >
> > at
> >
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
> >
> > at
> >
> org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java
> :56)
> >
> > at
> >
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
> >
> > at
> >
> org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke
> (GeronimoStandardContext.java:342)
> >
> > at
> >
> org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:31)
> >
> > at
> > org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:126)
> >
> > at
> >
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> >
> > at
> > org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:107)
> >
> > at
> >
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
> > at
> >
> org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java
> :419)
> >
> > at
> >
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> >
> > at
> >
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
> >
> > at
> >
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
> >
> > at
> > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.java:527)
> >
> > at
> >
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
> >
> > at
> > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPool.java:869)
> >
> > at java.lang.Thread.run(Thread.java:797)
> >
> > How to solve this problem
> > Thanks
> > Rajiv
>
>
> ------------------------------------------------------------------------
>
> <?xml version="1.0" encoding="UTF-8"?>
> <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.1">
> <dep:environment xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.1">
> <dep:moduleId>
> <dep:groupId>jdbc</dep:groupId>
> <dep:artifactId>caratula</dep:artifactId>
> <dep:version>1.0</dep:version>
> <dep:type>rar</dep:type>
> </dep:moduleId>
> <dep:dependencies>
> <dep:dependency>
> <dep:groupId>jtds</dep:groupId>
> <dep:artifactId>jtds</dep:artifactId>
> <dep:version>1.2</dep:version>
> <dep:type>jar</dep:type>
> </dep:dependency>
> </dep:dependencies>
> </dep:environment>
> <resourceadapter>
> <outbound-resourceadapter>
> <connection-definition>
> <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
> <connectiondefinition-instance>
> <name>jdbc/caratula</name>
> <config-property-setting name="Password">danna</config-property-setting>
> <config-property-setting name="Driver">net.sourceforge.jtds.jdbc.Driver</config-property-setting>
> <config-property-setting name="UserName">lstrumme</config-property-setting>
> <config-property-setting name="ConnectionURL">jdbc:jtds:sqlserver://192.168.10.9:1433/dbcaratulas</config-property-setting>
> <connectionmanager>
> <local-transaction/>
> <single-pool>
> <max-size>8</max-size>
> <min-size>3</min-size>
> <blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>
> <idle-timeout-minutes>15</idle-timeout-minutes>
> <match-one/>
> </single-pool>
> </connectionmanager>
> </connectiondefinition-instance>
> </connection-definition>
> </outbound-resourceadapter>
> </resourceadapter>
> </connector>
>
Re: Error when deploying a SQL Server DBpool with jtds 1.2 driver
Posted by grimba e <mr...@gmail.com>.
you must create a file xml and to do deploy manual, wizard this bad one, you
must arnar them you yourself…. I send an example to you
*<dep:groupId>console.dbpool</dep:groupId>*
line bad
Rodrigo Baeza.
2007/2/25, Peter Petersson <pe...@pmb.mine.nu>:
>
> If I remember right the is (has been) some problem creating/deploying
> mysql database plans from the Geronimo (1.1/1.1.1) console.
> Deploying using the command line tools should solve your problem, see
> example below for command and plan template:
>
> Command (on a Unix/linux system):
> cd GERONIMO_HOME
> java -jar bin/deployer.jar deploy /path_to/mssqldb_pool_plan.xml
> repository/tranql/tranql-connector/1.2/tranql-connector-1.2.rar
>
> Using the following plan (mssqldb_pool_plan.xml edit where appropriate):
>
> <?xml version="1.0" encoding="UTF-8"?>
> <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.1">
> <dep:environment
> xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.1">
> <dep:moduleId>
> <dep:groupId>console.dbpool</dep:groupId>
> <dep:artifactId>MSSqlDB_Name</dep:artifactId>
> <dep:version>1.0</dep:version>
> <dep:type>rar</dep:type>
> </dep:moduleId>
> <dep:dependencies>
> <dep:dependency>
> <dep:groupId>jtds</dep:groupId>
> <dep:artifactId>jtds</dep:artifactId>
> <dep:version>1.2</dep:version>
> <dep:type>jar</dep:type>
> </dep:dependency>
> </dep:dependencies>
> </dep:environment>
> <resourceadapter>
> <outbound-resourceadapter>
> <connection-definition>
>
> <connectionfactory-interface>javax.sql.DataSource
> </connectionfactory-interface>
> <connectiondefinition-instance>
> <name>MSSqlDB_Tois</name>
> <config-property-setting
> name="Password">the_pw</config-property-setting>
> <config-property-setting
> name="Driver">net.sourceforge.jtds.jdbc.Driver</config-property-setting>
> <config-property-setting
> name="UserName">the_user</config-property-setting>
> <config-property-setting
>
> name="ConnectionURL">jdbc:jtds:sqlserver://db_server:1433/db_name</config-property-setting>
> <connectionmanager>
> <local-transaction/>
> <single-pool>
> <max-size>10</max-size>
> <min-size>0</min-size>
>
> <blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>
> <idle-timeout-minutes>30</idle-timeout-minutes>
> <match-one/>
> </single-pool>
> </connectionmanager>
> </connectiondefinition-instance>
> </connection-definition>
> </outbound-resourceadapter>
> </resourceadapter>
> </connector>
>
> Thats it I hope it helps.
> /Peter
>
> Rajiv M skrev:
> > Hello,
> >
> > While creating a SQL Server database pool with the below settings:
> > Driver: net.sourceforge.jtds.jdbc.Driver
> > JAR: jtds/jtds/1.2/jar
> > Database: <database name>
> > Host: <server name>
> > Connect String: jdbc:jtds:sqlserver://<server
> > name>;DatabaseName=<database name>
> >
> > Test connection was successful. But "deploy" or "show plan" ended in
> > the below error:
> >
> > 21:30:27,044 DEBUG [ApplicationDispatcher] servletPath=/DBWizard,
> > pathInfo=/*, queryString=null, name=null
> > 21:30:27,044 DEBUG [ApplicationDispatcher] Path Based Include
> > 21:30:27,064 ERROR [DatabasePoolPortlet] Unable to save connection pool
> > java.lang.NullPointerException
> > at
> > org.apache.geronimo.kernel.repository.Artifact.create(Artifact.java:47)
> > at
> >
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.getRAR
> (DatabasePoolPortlet.java:1059)
> >
> > at
> >
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.save
> (DatabasePoolPortlet.java:894)
> >
> > at
> >
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.processAction
> (DatabasePoolPortlet.java:344)
> >
> > at
> > org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229)
> > at
> > org.apache.pluto.core.PortletServlet.doPost(PortletServlet.java:163)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
> > 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(
> ApplicationFilterChain.java:252)
> >
> > at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:173)
> >
> > at
> > org.apache.catalina.core.ApplicationDispatcher.invoke(
> ApplicationDispatcher.java:672)
> >
> > at
> > org.apache.catalina.core.ApplicationDispatcher.doInclude(
> ApplicationDispatcher.java:574)
> >
> > at
> > org.apache.catalina.core.ApplicationDispatcher.include(
> ApplicationDispatcher.java:499)
> >
> > at
> > org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(
> PortletInvokerImpl.java:120)
> >
> > at
> > org.apache.pluto.invoker.impl.PortletInvokerImpl.action(
> PortletInvokerImpl.java:68)
> >
> > at
> > org.apache.pluto.PortletContainerImpl.processPortletAction(
> PortletContainerImpl.java:164)
> >
> > at
> >
> org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processPortletAction
> (PortletContainerWrapperImpl.java:82)
> >
> > at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
> > at org.apache.pluto.portalImpl.Servlet.doPost(Servlet.java:267)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> > at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:252)
> >
> > at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:173)
> >
> > at
> > org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:213)
> >
> > at
> > org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:178)
> >
> > at
> > org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(
> DefaultSubjectValve.java:56)
> >
> > at
> > org.apache.catalina.authenticator.AuthenticatorBase.invoke(
> AuthenticatorBase.java:524)
> >
> > at
> >
> org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke
> (GeronimoStandardContext.java:342)
> >
> > at
> > org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(
> GeronimoBeforeAfterValve.java:31)
> >
> > at
> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
> :126)
> >
> > at
> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :105)
> >
> > at
> > org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:107)
> >
> > at
> > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java
> :541)
> > at
> > org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java
> :419)
> >
> > at
> > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java
> :148)
> >
> > at
> > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
> :869)
> >
> > at
> >
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> (Http11BaseProtocol.java:667)
> >
> > at
> > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> PoolTcpEndpoint.java:527)
> >
> > at
> > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> LeaderFollowerWorkerThread.java:80)
> >
> > at
> > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:869)
> >
> > at java.lang.Thread.run(Thread.java:797)
> >
> > How to solve this problem
> > Thanks
> > Rajiv
>
>
Re: Error when deploying a SQL Server DBpool with jtds 1.2 driver
Posted by Peter Petersson <pe...@pmb.mine.nu>.
If I remember right the is (has been) some problem creating/deploying
mysql database plans from the Geronimo (1.1/1.1.1) console.
Deploying using the command line tools should solve your problem, see
example below for command and plan template:
Command (on a Unix/linux system):
cd GERONIMO_HOME
java -jar bin/deployer.jar deploy /path_to/mssqldb_pool_plan.xml
repository/tranql/tranql-connector/1.2/tranql-connector-1.2.rar
Using the following plan (mssqldb_pool_plan.xml edit where appropriate):
<?xml version="1.0" encoding="UTF-8"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.1">
<dep:environment
xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.1">
<dep:moduleId>
<dep:groupId>console.dbpool</dep:groupId>
<dep:artifactId>MSSqlDB_Name</dep:artifactId>
<dep:version>1.0</dep:version>
<dep:type>rar</dep:type>
</dep:moduleId>
<dep:dependencies>
<dep:dependency>
<dep:groupId>jtds</dep:groupId>
<dep:artifactId>jtds</dep:artifactId>
<dep:version>1.2</dep:version>
<dep:type>jar</dep:type>
</dep:dependency>
</dep:dependencies>
</dep:environment>
<resourceadapter>
<outbound-resourceadapter>
<connection-definition>
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
<connectiondefinition-instance>
<name>MSSqlDB_Tois</name>
<config-property-setting
name="Password">the_pw</config-property-setting>
<config-property-setting
name="Driver">net.sourceforge.jtds.jdbc.Driver</config-property-setting>
<config-property-setting
name="UserName">the_user</config-property-setting>
<config-property-setting
name="ConnectionURL">jdbc:jtds:sqlserver://db_server:1433/db_name</config-property-setting>
<connectionmanager>
<local-transaction/>
<single-pool>
<max-size>10</max-size>
<min-size>0</min-size>
<blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>
<idle-timeout-minutes>30</idle-timeout-minutes>
<match-one/>
</single-pool>
</connectionmanager>
</connectiondefinition-instance>
</connection-definition>
</outbound-resourceadapter>
</resourceadapter>
</connector>
Thats it I hope it helps.
/Peter
Rajiv M skrev:
> Hello,
>
> While creating a SQL Server database pool with the below settings:
> Driver: net.sourceforge.jtds.jdbc.Driver
> JAR: jtds/jtds/1.2/jar
> Database: <database name>
> Host: <server name>
> Connect String: jdbc:jtds:sqlserver://<server
> name>;DatabaseName=<database name>
>
> Test connection was successful. But "deploy" or "show plan" ended in
> the below error:
>
> 21:30:27,044 DEBUG [ApplicationDispatcher] servletPath=/DBWizard,
> pathInfo=/*, queryString=null, name=null
> 21:30:27,044 DEBUG [ApplicationDispatcher] Path Based Include
> 21:30:27,064 ERROR [DatabasePoolPortlet] Unable to save connection pool
> java.lang.NullPointerException
> at
> org.apache.geronimo.kernel.repository.Artifact.create(Artifact.java:47)
> at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.getRAR(DatabasePoolPortlet.java:1059)
>
> at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.save(DatabasePoolPortlet.java:894)
>
> at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.processAction(DatabasePoolPortlet.java:344)
>
> at
> org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229)
> at
> org.apache.pluto.core.PortletServlet.doPost(PortletServlet.java:163)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
> 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(ApplicationFilterChain.java:252)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
>
> at
> org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvokerImpl.java:120)
>
> at
> org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvokerImpl.java:68)
>
> at
> org.apache.pluto.PortletContainerImpl.processPortletAction(PortletContainerImpl.java:164)
>
> at
> org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processPortletAction(PortletContainerWrapperImpl.java:82)
>
> at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
> at org.apache.pluto.portalImpl.Servlet.doPost(Servlet.java:267)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>
> at
> org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:56)
>
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
>
> at
> org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:342)
>
> at
> org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(GeronimoBeforeAfterValve.java:31)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
>
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
> at
> org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:419)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
>
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
>
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
>
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:869)
>
> at java.lang.Thread.run(Thread.java:797)
>
> How to solve this problem
> Thanks
> Rajiv