-----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