Problem while connectiong Teradata from Java

Connectivity

Problem while connectiong Teradata from Java

Hi,
I am trying to connect Teradata from java using Teradata JDBC Driver. I am using RAD 6.0 IDE.

I am getting following exception , can anyone help me please?

Exception :

[10/3/07 11:15:20:581 PDT] 0000003e FreePool E J2CA0046E: Method createManagedConnectionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/TDDataSource, throwing ResourceAllocationException. Original exception: com.ibm.ws.exception.WsException: DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: [NCR][Teradata JDBC Driver]:TeraConnection: getHoldability: function not supported in this version. with SQL State : HY000 SQL Code : 779
at com.ncr.teradata.ComUtil.ThrowExcp(ComUtil.java:1770)
at com.ncr.teradata.TeraConnection.getHoldability(TeraConnection.java:804)
at com.ncr.teradata.TeraLogicalConnection.getHoldability(TeraLogicalConnection.java:468)
at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getHoldability(InternalGenericDataStoreHelper.java:362)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.(WSRdbManagedConnectionImpl.java:646)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:941)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1502)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1294)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:2000)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:769)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:569)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:328)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:297)
at com.covansys.ebiz.ti.db.TeraDataConnectionPool.getConnection(TeraDataConnectionPool.java:59)
at com.covansys.ebiz.ti.db.DatabaseConnectionManager.getConnection(DatabaseConnectionManager.java:63)
at com.covansys.ebiz.ti.db.dao.DataAccessObject.getConnection(DataAccessObject.java:276)
at com.covansys.ebiz.ti.db.dao.DataAccessObject.prepareDynamicStatement(DataAccessObject.java:320)
at com.covansys.ebiz.ti.db.dao.DataAccessObject.readDynamic(DataAccessObject.java:395)
at com.gap.size.dao.StyleResultsTDDAO.getResultsForStyleColor(StyleResultsTDDAO.java:77)
at com.gap.size.dao.StyleResultsTDDAO.getStyleColorResults(StyleResultsTDDAO.java:46)
at com.gap.size.model.POListingController.getUpdatedTerraData(POListingController.java:2109)
at com.gap.size.model.POListingController.consolidatePOListing(POListingController.java:157)
at com.gap.size.formaction.POLoadAction.populatePOs(POLoadAction.java:1480)
at com.gap.size.formaction.POLoadAction.postProcess(POLoadAction.java:1085)
at com.covansys.ebiz.query.QueryAction.executeSecure(QueryAction.java:286)
at com.gap.size.formaction.POLoadAction.executeSecure(POLoadAction.java:1129)
at com.covansys.ebiz.struts.SecureAction.execute(SecureAction.java:55)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1212)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:629)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:2837)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:220)
at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:204)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1681)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:77)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:421)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:367)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:94)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))

Additional information :

IDE : RAD 6.0
Driver verson : Tera Data JDBC Driver 03.01.00

Any help appreciated.

-Ramesh
1 REPLY
Teradata Employee

Re: Problem while connectiong Teradata from Java

The Connection.getHoldability method is supported beginning with TTU 8.0 / Teradata JDBC Driver version 3.2.0.3.