Not able to insert Data into Voltdb

[prakash.reddy]

Hi Guys,

I have a requirement to insert data into voltdb using Talend.

Im able to get data from Voltdb using tJDBCInput but when i try to insert records into Voltdb using tJDBCOutput , it throws an error.

 

[statistics] connecting to socket on port 3387

[statistics] connected

Exception in component tJDBCOutput_1

java.sql.SQLFeatureNotSupportedException

at org.voltdb.jdbc.SQLError.noSupport(SQLError.java:65)

at org.voltdb.jdbc.JDBC4Connection.setAutoCommit(JDBC4Connection.java:446)

at j4u_test.etl_volt_test_0_1.etl_volt_test.tFileInputDelimited_1Process(etl_volt_test.java:1580)

at j4u_test.etl_volt_test_0_1.etl_volt_test.tJDBCInput_1Process(etl_volt_test.java:1230)

at j4u_test.etl_volt_test_0_1.etl_volt_test.runJobInTOS(etl_volt_test.java:2248)

at j4u_test.etl_volt_test_0_1.etl_volt_test.main(etl_volt_test.java:2082)

[FATAL]: j4u_test.etl_volt_test_0_1.etl_volt_test - tJDBCOutput_1 null

[statistics] disconnected

 

thanks

prakash

[prakash.reddy]

can any one answer or help me here?

 

[benjaminballard]

Hi Prakash,

The VoltDB JDBC driver supports setAutoCommit(true) only, it will throw a SQLFeatureNotSupportedException for setAutoCommit(false).

Contact VoltDB support or the VoltDB forums for assistance with VoltDB.  I only saw this because I have a Google Alert.

Thanks,

Ben Ballard

(Customer Success Manager, VoltDB)

 

[prakash.reddy]

thanks Ben