472,096 Members | 2,239 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,096 software developers and data experts.

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 844

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 Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.