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 <[EMAIL PROTECTED]>:
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>
