Hello Cedric, _PACKET_SIZE is a database parameter, which can be set by DBM GUI or with dbmcli command param_startsession param_put _PACKET_SIZE <new value> param_checkall param_commitsession BTW, you should look into your application where the large statement comes from. Possibly a prepared statement, or an 'executeBatch' may suit your need more. Alexander Schr�der SAP DB, SAP Labs Berlin
-----Original Message----- From: Cedric Cuche [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 1:18 PM To: [EMAIL PROTECTED] Subject: PACKET_SIZE and jdbc Hi, I have a JSP page that create a Tab separted value file using the datas from a db instance. I got an error with big datasets (pair of DOUBLE PRECISION and VARCHAR(255)): javax.servlet.jsp.JspException: SQL statement is too long. Increase the DB parameter PACKET_SIZE. How do I set the PACKET_SIZE: 1. In the installation script (like the create_demo_db.cmd) 2. On a production instance Is there any special settings to apply on the Jdbc driver? Thanks for any help Cedric Cuche
