Janssen, Roger
Mon, 03 Mar 2008 03:24:58 -0800
Hi, Just a general question about sql statement execution. Is it possible to force OJB not to execute a prepared statement, but to execute the sql as a regular sql statement? The reason behind this is that we hit some kind of upperbound limit with MSSQL regarding the maximum allowed number of parameters in a prepared statement. Some of the statements that are being generated by OJB are rejected (SQL exceptions are thrown) by MSSQL, because this upperbound is crossed. One solution would be to not use a prepared statement in these cases. Greetings, Roger Janssen ************************************************************************* The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed.You should not copy, disclose or distribute this communication without the authority of iBanx bv. iBanx bv is neither liable for the proper and complete transmission of the information has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies.