Thanks for the quick response.
I tried with the following values in openfire.xml
<className>org.jivesoftware.database.DefaultConnectionProvider</className>
<defaultProvider>
<driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver>
<serverURL>jdbc:sqlserver://MSSQL02Server.C.com;databaseName=QXXX</serverURL>
<testSQL>select 1</testSQL>
<testBeforeUse>true</testBeforeUse>
<testAfterUse>true</testAfterUse>
<minConnections>5</minConnections>
<maxConnections>25</maxConnections>
<connectionTimeout>1.0</connectionTimeout>
<username encrypted="true">8028fb0ac86f45c189795d94e72662d043d6cdff31cc77a6</username>
<password encrypted="true">c723830706265ac41b65dcc9b12fe2c139336ff56bf5e419</password>
</defaultProvider>
false
<enabled>false</enabled>
But when I click continue, following error shows up.
2016.10.12 14:44:22 WARN [Jetty-QTP-AdminConsole-15]: org.eclipse.jetty.servlet.ServletHandler -
javax.servlet.ServletException: java.lang.ExceptionInInitializerError
at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl .java:905)
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.j ava:834)
at org.jivesoftware.openfire.admin.setup.setup_002ddatasource_002dstandard_jsp._js pService(setup_002ddatasource_002dstandard_jsp.java:446)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:812)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1669)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1652)
at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:76)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1652)
at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:53)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1652)
at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:80)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1652)
at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:162)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1652)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:22 3)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:11 27)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185 )
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:106 1)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandler Collection.java:215)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.jav a:110)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:499)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635 )
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.ExceptionInInitializerError
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.logicalcobwebs.cglib.proxy.Enhancer.setCallbacksHelper(Enhancer.java:616)
at org.logicalcobwebs.cglib.proxy.Enhancer.setThreadCallbacks(Enhancer.java:609)
at org.logicalcobwebs.cglib.proxy.Enhancer.createUsingReflection(Enhancer.java:631 )
at org.logicalcobwebs.cglib.proxy.Enhancer.firstInstance(Enhancer.java:538)
at org.logicalcobwebs.cglib.core.AbstractClassGenerator.create(AbstractClassGenera tor.java:225)
at org.logicalcobwebs.cglib.proxy.Enhancer.createHelper(Enhancer.java:377)
at org.logicalcobwebs.cglib.proxy.Enhancer.create(Enhancer.java:285)
at org.logicalcobwebs.proxool.ProxyFactory.getProxy(ProxyFactory.java:116)
at org.logicalcobwebs.proxool.ProxyFactory.getWrappedConnection(ProxyFactory.java: 85)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:261 )
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnec tionProvider.java:88)
at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:602)
at org.jivesoftware.openfire.admin.setup.setup_002ddatasource_002dstandard_jsp._js pService(setup_002ddatasource_002dstandard_jsp.java:220)
… 34 more
Caused by: org.logicalcobwebs.cglib.core.CodeGenerationException: java.lang.reflect.InvocationTargetException–>null
at org.logicalcobwebs.cglib.core.AbstractClassGenerator.create(AbstractClassGenera tor.java:237)
at org.logicalcobwebs.cglib.reflect.FastClass$Generator.create(FastClass.java:64)
at org.logicalcobwebs.cglib.proxy.MethodProxy.helper(MethodProxy.java:81)
at org.logicalcobwebs.cglib.proxy.MethodProxy.create(MethodProxy.java:46)
at $java.sql.Connection$$EnhancerByProxool$$700d1a6f.CGLIB$STATICHOOK1( )
at $java.sql.Connection$$EnhancerByProxool$$700d1a6f.()
… 54 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.logicalcobwebs.cglib.core.ReflectUtils.defineClass(ReflectUtils.java:384)
at org.logicalcobwebs.cglib.core.AbstractClassGenerator.create(AbstractClassGenera tor.java:219)
… 59 more
Caused by: java.lang.SecurityException: class “com.microsoft.sqlserver.jdbc.ISQLServerConnection$$FastClassByProxool$$2b8cf6a f”'s signer information does not match signer information of other classes in the same package
at java.lang.ClassLoader.checkCerts(ClassLoader.java:895)
at java.lang.ClassLoader.preDefineClass(ClassLoader.java:665)
at java.lang.ClassLoader.defineClass(ClassLoader.java:758)
… 65 more