I am trying to use Teradata Fastexport using Spring framework. When I give "Type=FASTEXPORT" in my connection URL it looks me that this is not being considerd as fastexport/utility session.
Below is my Beans.xml file (Please let me know if I am doing someting wrong.
<?xml version="1.0" encoding="UTF-8"?>
<!-- Initialization for data source -->
<property name="driverClassName" value="com.teradata.jdbc.TeraDriver" />
<property name="url" value="jdbc:teradata://db-IP/TMODE=ANSI,CHARSET=UTF8,TYPE=FASTEXPORT" />
<property name="username" value="username" />
<property name="password" value="password" />
<!-- Definition for exportJDBCTemplate bean -->
<property name="dataSource" ref="dataSource" />
I got it what mistake I was doing.
I did not use Prepared Statement and because of same reason I faced the issue.
The issue is resolved.
Here are the rules I found from Teradata JDBC Fast Export Doc
To qualify for JDBC FastExport, the SQL SELECT statement must meet the following criteria:
JDBC FastExport must be used with a PreparedStatement
The Teradata session character set must be ASCII, UTF8, or UTF16. Beginning with Teradata JDBC Driver version 13.00.00.20, any Teradata session character set supported by the Teradata JDBC Driver may be used.
All Teradata data types declared in the source table or view must be supported by JDBC FastExport