Hi ,
I am using Microsoft SQL Server 2005 JDBC Driver to connect to my SQL Database from my Java Midtier.
By Default JDBC Driver set the ANSI_PADDING to ON.
I know I can override this on per session level by doing something like this:
con.prepareStat ement("set ANSI_PADDING OFF exec RDB_WD2PerfGetI ncomeExpense ?,?,? ");
It works but means that I have to set it for every one of my sql statements, which are everywhere, around 1000 all ups.
My Question is, Is there a way to set it up on JDBC Driver level for the whole Java Apps. Any suggestion is appriciated. Please help.
Regards,
Lawardy
I am using Microsoft SQL Server 2005 JDBC Driver to connect to my SQL Database from my Java Midtier.
By Default JDBC Driver set the ANSI_PADDING to ON.
I know I can override this on per session level by doing something like this:
con.prepareStat ement("set ANSI_PADDING OFF exec RDB_WD2PerfGetI ncomeExpense ?,?,? ");
It works but means that I have to set it for every one of my sql statements, which are everywhere, around 1000 all ups.
My Question is, Is there a way to set it up on JDBC Driver level for the whole Java Apps. Any suggestion is appriciated. Please help.
Regards,
Lawardy