All Forums Connectivity
madhuramesh 1 post Joined 10/07
03 Oct 2007
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(TeraCon nection.java:804) at com.ncr.teradata.TeraLogicalConnection.getHoldability( TeraLogicalConnection.java:468) at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelpe r.getHoldability(InternalGenericDataStoreHelper.java: 362) at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.(W SRdbManagedConnectionImpl.java:646) at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImp l.createManagedConnection(WSManagedConnectionFactoryIm pl.java:941) at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConn ectionWithMCWrapper(FreePool.java:1502) at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForCo nnection(FreePool.java:1294) at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolMa nager.java:2000) at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(Co nnectionManager.java:769) at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(C onnectionManager.java:569) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnecti on(WSJdbcDataSource.java:328) at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnecti on(WSJdbcDataSource.java:297) at com.covansys.ebiz.ti.db.TeraDataConnectionPool.getConn ection(TeraDataConnectionPool.java:59) at com.covansys.ebiz.ti.db.DatabaseConnectionManager.getC onnection(DatabaseConnectionManager.java:63) at com.covansys.ebiz.ti.db.dao.DataAccessObject.getConnec tion(DataAccessObject.java:276) at com.covansys.ebiz.ti.db.dao.DataAccessObject.prepareDy namicStatement(DataAccessObject.java:320) at com.covansys.ebiz.ti.db.dao.DataAccessObject.readDynam ic(DataAccessObject.java:395) at com.gap.size.dao.StyleResultsTDDAO.getResultsForStyleC olor(StyleResultsTDDAO.java:77) at com.gap.size.dao.StyleResultsTDDAO.getStyleColorResult s(StyleResultsTDDAO.java:46) at com.gap.size.model.POListingController.getUpdatedTerra Data(POListingController.java:2109) at com.gap.size.model.POListingController.consolidatePOLi sting(POListingController.java:157) at com.gap.size.formaction.POLoadAction.populatePOs(POLoa dAction.java:1480) at com.gap.size.formaction.POLoadAction.postProcess(POLoa dAction.java:1085) at com.covansys.ebiz.query.QueryAction.executeSecure(Quer yAction.java:286) at com.gap.size.formaction.POLoadAction.executeSecure(POL oadAction.java:1129) at com.covansys.ebiz.struts.SecureAction.execute(SecureAc tion.java:55) at org.apache.struts.action.RequestProcessor.processActio nPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(Requ estProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionS ervlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionSe rvlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.jav a:763) at javax.servlet.http.HttpServlet.service(HttpServlet.jav a:856) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service (ServletWrapper.java:1212) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleR equest(ServletWrapper.java:629) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(We bApp.java:2837) at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest( WebGroup.java:220) at com.ibm.ws.webcontainer.VirtualHost.handleRequest(Virt ualHost.java:204) at com.ibm.ws.webcontainer.WebContainer.handleRequest(Web Container.java:1681) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WC ChannelLink.java:77) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.h andleDiscrimination(HttpInboundLink.java:421) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.h andleNewInformation(HttpInboundLink.java:367) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallba ck.complete(HttpICLReadCallback.java:94) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestCo mplete(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.ru n(WorkQueueManager.java(Compiled Code)) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java( Compiled Code))Additional information :IDE : RAD 6.0Driver verson : Tera Data JDBC Driver 03.01.00Any help appreciated.-Ramesh

tomnolan 594 posts Joined 01/08
05 Jul 2012

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

You must sign in to leave a comment.