Hi! In general it should work to inserting/updating etc. more than one long column in one table. But we found and fixed several bugs in the database kernel (version <= 7.4.3.23) concerning long columns. Maybe you run into one of these bugs.
To find out more about the reason I need some more details: - complete version of your databse kernel - version of your jdbc-driver (java -jar sapdbc.jar -V) - a jdbc trace (http://sapdb.2scale.net/moin.cgi/JdbcTrace) - a vtrace (http://sapdb.2scale.net/moin.cgi/VTrace) Thanks, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: Hai Pham [mailto:[EMAIL PROTECTED] > Sent: Montag, 16. Juni 2003 03:46 > To: SAP-DB > Subject: JDBC insert with multiple Long Byte columns (not persisted) > > > Hi all, > > I am using JDBC (7.4.3) with kernel version 7.4.3 on > Windows XP. > > I have a table with two long byte fields. If I insert > data with the total size of those two columns greater > than roughly 50KB, the data of the second column WON'T > be persisted. The first column's data is always saved > no matter how big the data is. I don't know exactly > the total size that would start causing problem. > > In the case I tested, it works if the size of first > column is ~17KB and the 2nd's ~4KB. > > I found one reference about a similar problem in here: > http://www.mail-archive.com/[EMAIL PROTECTED]/msg > 04976.html > > However, I didn't get any exception at all. > > Does anyone has a similar problem? > > Thanks. > > ===== > ------------------- > Hai Pham Quang > ------------------- > > __________________________________________________________ > L�che-vitrine ou l�che-�cran ? > magasinage.yahoo.ca > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
