on 06-01-2010 11:13 AM
Iam getting this error in message monitoring
my sender is idoc and receiver is jdbc.
Unable to execute statement for table or stored procedure. 'EPMFA_ORD_HST' (Structure 'EPMFA_ORD_HST_Insert') due to java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]String or binary data would be truncated.
JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'EPMFA_ORD_HST' (structure 'EPMFA_ORD_HST_Insert'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]String or binary data would be truncated....
java.sql.SQLException means u have a problem with sql statement, u have to check "action " is INSERT or not , and also check in receiver commucation channel , u check JDBC DRIVERS AND CONNECTION , and user name and pwd are mentioned correctly or not .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Check your test data,the problem with data,the error could be because of the length of filed defined in data base is less than your test data filed length.
your database table has a colum named 'EPMFA_ORD_HST' of type VARCHAR(30),Now if you will try to insert a string of length greater than 30, the program will throw this type of exception.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This is JDBC Drivers Problem, check once.
Thnx,
Siva.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.