Teradata FastExport using Spring?

Tools
Enthusiast

Teradata FastExport using Spring?

Hello Forum,

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"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd ">

<!-- Initialization for data source -->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<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" />
</bean>

<!-- Definition for exportJDBCTemplate bean -->
<bean id="exportJDBCTemplate"
class="com.teradata.fexp.ExportJDBCTemplate">
<property name="dataSource" ref="dataSource" />
</bean>
</beans>
Tags (1)
1 REPLY
Enthusiast

Re: Teradata FastExport using Spring?

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