ExtendedAnsiSQL ODBC Flag resets

2013-03-07 Thread Paolo Botta
Hi everybody

I have a strange behavior but I don't know if it's a problem of Tomcat or
what else:

I have Tomcat 7.0.19 running on java 1.6.0_31 on Windows 7, but I tried on
different version of java, Tomcat (6 and 7) and Windows (xp and 7) and I
obtained the same behavior.

I create a system DSN to access an Access file (version 2003). I set in the
ODBC ExtendeAnsiSQL=1. I run my program that use Tomcat and create tables
with extendedAnsiSQL (in particulare DECIMAL fields in the database) all
work fine.

When I stop Tomcat and restart it the flag in the ODBC is set to 0.

I use a workaround setting the ExtendedAnsiSQL=1 in the connection string,
but why it reset in the ODBC every time I stop and restart Tomcat?

 

Thanks to everybody.

 

Bye

Paolo



Re: ExtendedAnsiSQL ODBC Flag resets

2013-03-07 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256

Paolo,

On 3/7/13 4:52 AM, Paolo Botta wrote:
 I have a strange behavior but I don't know if it's a problem of
 Tomcat or what else:
 
 I have Tomcat 7.0.19 running on java 1.6.0_31 on Windows 7, but I
 tried on different version of java, Tomcat (6 and 7) and Windows
 (xp and 7) and I obtained the same behavior.

Wow, you should really upgrade: we're on Tomcat 7.0.37, now. It's not
likely to be your problem, but you should really upgrade.

 I create a system DSN to access an Access file (version 2003).

Oh, wow: you are using Access as your data store? Ouch.

 I set in the ODBC ExtendeAnsiSQL=1.

What does that mean? It is in a file somewhere?

 I run my program that use Tomcat and create tables with
 extendedAnsiSQL (in particulare DECIMAL fields in the database)
 all work fine.
 
 When I stop Tomcat and restart it the flag in the ODBC is set to
 0.
 
 I use a workaround setting the ExtendedAnsiSQL=1 in the connection
 string, but why it reset in the ODBC every time I stop and restart
 Tomcat?

The connection string is the right place to do this. I don't know
where else you might be doing it, but it's likely to be a connection
property, and not a property of the database (and I use that term
with an enormous grain of salt).

- -chris
-BEGIN PGP SIGNATURE-
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEAREIAAYFAlE5MN0ACgkQ9CaO5/Lv0PA+8wCeNx2Q+jS5Pjebrk3F5DUxuzdL
lAIAn3nTyXp61NVGFp0fge6wYpBlJlf4
=ihUL
-END PGP SIGNATURE-

-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org