[IBATIS-755] Ibatis add a lot of spce when lauching dynamic query

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.3.0
• Component/s: Core
• Labels: dynamic spaces sql
• Environment: Windows XP / Eclipse
• Assignee: Unassigned
• Reporter: Philippe Preville
• Created: 01/Mar/10 14:25
• Updated: 01/Mar/10 14:25

Description

When you execute large dynamic SQL ibatis add a lot a sapces to the query. This situation could create problem to debug queries and for some database provider it takes more memory when the query "string" is larger.

A simple fix could be used in com.ibatis.sqlmap.engine.execution :

Add : sql = sql.trim().replaceAll("\\s\\s*", " ");

In : could be inserted in all these function : executeUpdate, addBatch, executeQuery, executeUpdateProcedure, executeQueryProcedure, prepareStatement, prepareCall, prepareStatement, prepareCall, addBatch