By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,380 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

JDBC Properties setting for ANSI

P: 5
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
Share this question for a faster answer!
Share on Google+

Post your reply

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