Error while Importing SQL Table's Metadata
Hi
I am creating an External defination of category "dbtab". when i try to import the table in 3rd step i get this error.
"Error occurred while attempting to connect to database".
I checked the JDBC channel, in the channel getting this error "Error processing request in sax parser: Error when executing statement for table/stored proc. 'metadataRequest' (structure 'statement'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode."
Please help
Ravi Kanth Talagana replied
Hi,
Check this discussion.
JDBC Channel : Connection reset
Also try setting AutoCommit = true (Check box in the JDBC adapter)
Regards,
Ravi Kanth Talagana
Edited by: Ravi Kanth Talagana on Oct 27, 2009 11:07 AM