Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

connecting JDBC-ODBC driver in glassfish admin panel

Posted on 2012-09-13
2
Medium Priority
?
760 Views
Last Modified: 2012-11-28
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
Comment
Question by:Tagom
1 Comment
 

Accepted Solution

by:
Tagom earned 0 total points
ID: 38396033
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you've heard about htaccess and it sounds like it does what you want, but you're not sure how it works... well, you're in the right place. Read on. Some Basics #1. It's a file and its filename is .htaccess (yes, with a dot in the front). #…
If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
Integration Management Part 2
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month10 days, 23 hours left to enroll

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question