Cocatenating strings, How with prepared statements? (JBDC)

[john doed]

How can I cocatenate a varchar in an UPDATE sql prepared Statement?

This SQL was working with SAPDB:
UPDATE atable SET msg_field=msg_field & 'my new string' WHERE id=1"

but now with prepared statements I get an error:

UPDATE atable SET msg_field=msg_field & ? WHERE id=1"
pstmt.setString(1,"my new string");

Gives this error:
SQLException error "Value too large"

I am using 7.4.3.10

Thanks.

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general