In the application we use, I set the connection pools inside of glassfish. I
need to be able to set the connections inside of glassfish each time for the
jdbc:odbc. As opposed to creating a .jar file for each database connection
pool? I have been able to ping the dataconnection pool, however when I go to
set up a grid via the application I get an error that i can not figure out
how to resolve. This is a high priority setup for me! I am attaching the xml
for glassfish so you can see the setup. I thought I had accomplished this
before but it now eludes me!!!! **ERROR** | 2012-09-13 12:32:27,109 | T53 |
!IMPORTANT! Database [jessieTest:jdbc/jessieTest] test query
failed.~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [Milsoft Filtered Stack Trace]
UnsupportedOperationException: null at
com.milsoft.ivr.database.DataSourceManager.initialize()L107 at
com.milsoft.ivr.database.DataSourceManager.getConnection()L51 at
com.milsoft.ivr.database.DbConnection.getConnection()L88 at
com.milsoft.ivr.database.ConnectionManager.execute()L314 at
com.milsoft.ivr.database.ConnectionManager.executeSQL()L206 at
com.milsoft.ivr.database.SimpleQuery.getGridResultSet()L29 at
com.milsoft.ivr.gui.GridConfigurator.testFrom()L70 at
com.milsoft.ivr.gui.GridConfigurator.findColumns()L102
java.lang.UnsupportedOperationException at
sun.jdbc.odbc.JdbcOdbcConnection.getClientInfo(JdbcOdbcConnection.java:1981)
at
com.sun.gjc.spi.jdbc40.ConnectionHolder40.getClientInfo(ConnectionHolder40.java:369)
at com.sun.gjc.spi.jdbc40.ConnectionHolder40.init(ConnectionHolder40.java:94)
at com.sun.gjc.spi.jdbc40.ConnectionHolder40.(ConnectionHolder40.java:85) at
com.sun.gjc.spi.jdbc40.ConnectionWrapper40.(ConnectionWrapper40.java:64) at
com.sun.gjc.spi.jdbc40.Jdbc40ObjectsFactory.getConnection(Jdbc40ObjectsFactory.java:90)
at
com.sun.gjc.spi.ManagedConnection.getConnection(ManagedConnection.java:460)
at
com.sun.enterprise.resource.allocator.LocalTxConnectorAllocator.fillInResourceObjects(LocalTxConnectorAllocator.java:119)
at
com.sun.enterprise.resource.pool.ConnectionPool.getResource(ConnectionPool.java:488)
at
com.sun.enterprise.resource.pool.PoolManagerImpl.getResourceFromPool(PoolManagerImpl.java:242)
at
com.sun.enterprise.resource.pool.PoolManagerImpl.getResource(PoolManagerImpl.java:167)
at
com.sun.enterprise.connectors.ConnectionManagerImpl.getResource(ConnectionManagerImpl.java:341)
at
com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection(ConnectionManagerImpl.java:304)
at
com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:190)
at
com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:165)
at
com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:160)
at com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:110) at
com.milsoft.ivr.database.DataSourceManager.initialize(DataSourceManager.java:107)
at
com.milsoft.ivr.database.DataSourceManager.getConnection(DataSourceManager.java:51)
at com.milsoft.ivr.database.DbConnection.getConnection(DbConnection.java:88)
at
com.milsoft.ivr.database.ConnectionManager.execute(ConnectionManager.java:314)
at
com.milsoft.ivr.database.ConnectionManager.executeSQL(ConnectionManager.java:206)
at com.milsoft.ivr.database.SimpleQuery.getGridResultSet(SimpleQuery.java:29)
at com.milsoft.ivr.gui.GridConfigurator.testFrom(GridConfigurator.java:70) at
com.milsoft.ivr.gui.GridConfigurator.findColumns(GridConfigurator.java:102)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597) at
com.sun.el.parser.AstValue.invoke(AstValue.java:234) at
com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297) at
com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
at javax.faces.component.UICommand.broadcast(UICommand.java:315) at
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794) at
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259) at
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) at
com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) at
javax.faces.webapp.FacesServlet.service(FacesServlet.java:409) at
org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1534)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:215)
at
org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:349)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:98) at
com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:91)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:162)
at
org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:326)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:227)
at
com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:170)
at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:822)
at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:719) at
com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1013) at
com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:225)
at
com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
at
com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
at
com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
at
com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
at com.sun.grizzly.ContextTask.run(ContextTask.java:71) at
com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
at
com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
at java.lang.Thread.run(Thread.java:662) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
**ERROR** | 2012-09-13 12:32:27,156 | T53 | query = SELECT TOP 1 * FROM
viewallpayments~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [Milsoft Filtered Stack
Trace] UnsupportedOperationException: null at
com.milsoft.ivr.database.DataSourceManager.getConnection()L57 at
com.milsoft.ivr.database.DbConnection.getConnection()L88 at
com.milsoft.ivr.database.ConnectionManager.execute()L314 at
com.milsoft.ivr.database.ConnectionManager.executeSQL()L206 at
com.milsoft.ivr.database.SimpleQuery.getGridResultSet()L29 at
com.milsoft.ivr.gui.GridConfigurator.testFrom()L70 at
com.milsoft.ivr.gui.GridConfigurator.findColumns()L102
java.lang.UnsupportedOperationException at
sun.jdbc.odbc.JdbcOdbcConnection.getClientInfo(JdbcOdbcConnection.java:1981)
at
com.sun.gjc.spi.jdbc40.ConnectionHolder40.getClientInfo(ConnectionHolder40.java:369)
at com.sun.gjc.spi.jdbc40.ConnectionHolder40.init(ConnectionHolder40.java:94)
at com.sun.gjc.spi.jdbc40.ConnectionHolder40.(ConnectionHolder40.java:85) at
com.sun.gjc.spi.jdbc40.ConnectionWrapper40.(ConnectionWrapper40.java:64) at
com.sun.gjc.spi.jdbc40.Jdbc40ObjectsFactory.getConnection(Jdbc40ObjectsFactory.java:90)
at
com.sun.gjc.spi.ManagedConnection.getConnection(ManagedConnection.java:460)
at
com.sun.enterprise.resource.allocator.LocalTxConnectorAllocator.fillInResourceObjects(LocalTxConnectorAllocator.java:119)
at
com.sun.enterprise.resource.pool.ConnectionPool.getResource(ConnectionPool.java:488)
at
com.sun.enterprise.resource.pool.PoolManagerImpl.getResourceFromPool(PoolManagerImpl.java:242)
at
com.sun.enterprise.resource.pool.PoolManagerImpl.getResource(PoolManagerImpl.java:167)
at
com.sun.enterprise.connectors.ConnectionManagerImpl.getResource(ConnectionManagerImpl.java:341)
at
com.sun.enterprise.connectors.ConnectionManagerImpl.internalGetConnection(ConnectionManagerImpl.java:304)
at
com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:190)
at
com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:165)
at
com.sun.enterprise.connectors.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:160)
at com.sun.gjc.spi.base.DataSource.getConnection(DataSource.java:110) at
com.milsoft.ivr.database.DataSourceManager.getConnection(DataSourceManager.java:57)
at com.milsoft.ivr.database.DbConnection.getConnection(DbConnection.java:88)
at
com.milsoft.ivr.database.ConnectionManager.execute(ConnectionManager.java:314)
at
com.milsoft.ivr.database.ConnectionManager.executeSQL(ConnectionManager.java:206)
at com.milsoft.ivr.database.SimpleQuery.getGridResultSet(SimpleQuery.java:29)
at com.milsoft.ivr.gui.GridConfigurator.testFrom(GridConfigurator.java:70) at
com.milsoft.ivr.gui.GridConfigurator.findColumns(GridConfigurator.java:102)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597) at
com.sun.el.parser.AstValue.invoke(AstValue.java:234) at
com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297) at
com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
at javax.faces.component.UICommand.broadcast(UICommand.java:315) at
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794) at
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259) at
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101) at
com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118) at
javax.faces.webapp.FacesServlet.service(FacesServlet.java:409) at
org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1534)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:215)
at
org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:349)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at
org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:98) at
com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:91)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:162)
at
org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:326)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:227)
at
com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:170)
at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:822)
at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:719) at
com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1013) at
com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:225)
at
com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
at
com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
at
com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
at
com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
at com.sun.grizzly.ContextTask.run(ContextTask.java:71) at
com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
at
com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
at java.lang.Thread.run(Thread.java:662) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
**ERROR** | 2012-09-13 12:32:27,156 | T53 | Grid's From-Clause SQL Syntax
Validation Failed Error: [null] Test SQL: SELECT TOP 1 * FROM viewallpayments
--
[Message sent by forum member 'knottysuki']
View Post: http://forums.java.net/node/890220