• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 772
  • Last Modified:

connecting JDBC-ODBC driver in glassfish admin panel

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!!!!

<jdbc-connection-pool driver-classname="" validation-table-name="viewallpayments" datasource-classname="sun.jdbc.odbc.ee.DataSource" res-type="javax.sql.ConnectionPoolDataSource" description="" name="jessieTest" is-connection-validation-required="true" ping="true">
      <property name="databaseName" value="jessieTest"></property>
      <property name="serverName" value="myServer"></property>
      <property name="user" value="myUser"></property>
      <property name="password" value="myPass"></property>
    </jdbc-connection-pool>
    <jdbc-resource pool-name="jessieTest" description="" jndi-name="jdbc/jessieTest"></jdbc-resource>
0
Tagom
Asked:
Tagom
1 Solution
 
TagomAuthor Commented:
This is the error that I get:

**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.<init>(ConnectionHolder40.java:85)
      at com.sun.gjc.spi.jdbc40.ConnectionWrapper40.<init>(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.<init>(ConnectionHolder40.java:85)
      at com.sun.gjc.spi.jdbc40.ConnectionWrapper40.<init>(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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now