Since you mentioned BEA... I ran into an issue a few months back with BEA's JDBC driver for mssqlserver in regards to VARCHAR fields > 255 characters. It seems that the newer ms sql database (e.g. sql server 2000) can handle this but the driver can't. The driver simply truncates incoming or outgoing data to 255 chars. Switching to the new driver solved this problem but unfortunately created several others having to do with different licensing algorithms (destination connections vs source connections).
Charles -----Original Message----- From: Scott Thompson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 11:51 PM To: [EMAIL PROTECTED] Subject: 540 character limit in sql task Can anyone confirm/deny of the sql task has a 540 character limit on the SQL statements? I'm hitting such a limit, though I'm not sure if it's Ant or my JDBC driver doing this. (I'm sending mail to BEA as well) -ScottT -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
