connecting JDBC-ODBC driver in glassfish admin panel
Posted on 2012-09-13
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-resource pool-name="jessieTest" description="" jndi-name="jdbc/jessieTest"></jdbc-resource>