geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Petersson <pe...@pmb.mine.nu>
Subject Re: Error when deploying a SQL Server DBpool with jtds 1.2 driver
Date Tue, 27 Feb 2007 13:47:24 GMT
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 
> <mailto:peter@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>
>   


Mime
View raw message