ExtendedAnsiSQL ODBC Flag resets

[Paolo Botta <pa...@cabril.it>]

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

[Christopher Schultz <ch...@christopherschultz.net>]

-----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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org