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 Sun, 25 Feb 2007 20:08:20 GMT
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


Mime
View raw message