469,625 Members | 1,089 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

JDBC Properties setting for ANSI

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.prepareStatement("set ANSI_PADDING OFF exec RDB_WD2PerfGetIncomeExpense ?,?,? ");

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.


Mar 19 '08 #1
0 815

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by BARTKO, Zoltán | last post: by
6 posts views Thread by c_piliotis | last post: by
1 post views Thread by lawardy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.