Problem while connectiong Teradata from Java
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Problem while connectiong Teradata from Java Expand / Collapse
Author
Message
Posted 10/3/2007 2:29:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 10/4/2007 12:25:00 PM
Posts: 1, Visits: 1
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


Ramesh
Post #9101
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 10:32am

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.094. 9 queries. Compression Disabled.