You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by David Kerber <dc...@verizon.net> on 2011/12/20 02:28:42 UTC
Re: Access dbf files outside context/docbase - fixed
Just to close out this thread, it's now fixed. I found a native Java
dBase (.dbf) file driver, and it works great in both 32- and 64-bit
environments, without having to mess with ODBC or the screwy Microsoft
database file drivers.
D
On 12/16/2011 10:09 PM, David Kerber wrote:
> On 12/16/2011 5:54 PM, Christopher Schultz wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> David,
>>
>> Thanks for posting back.
>>
>> On 12/16/11 2:50 PM, David kerber wrote:
>>> Figured out the cause, though I don't have it fixed yet: I'm
>>> running under a 64-bit JRE, and there is no 64-bit dBAse driver
>>> installed, just 32-bit. So I have to either find a 64-bit dbase
>>> ODBC driver (Hah!), or switch to a 32-bit TC and JRE.
>> Unless you need a huge heap, running a 32-bit process might be a
>> better idea, anyway. You can probably improve performance a bit, too.
>>
>> Another good idea is probably to "upgrade" from Access (or are you
>> really using dBase?) to Microsoft SQL Server (or any actual RDBMS for
>> that matter). :)
> Yes, using real .dbf files. They're much more reliable than Access
> .mdbs are, IME. We're actually using them in parallel with a real SQL
> backend, for different purposes. It's kind of an awkward architecture
> the way it's being used in this particular case, but it worked great
> when it was first implemented, and still does for 98% of our needs.
> This is the first time we've had to mix the two.
>
> The real answer, as I did a bit more digging, is to switch to a java
> native dbase driver, rather than going through MS's ODBC kludge.
> Since my app is fairly well modularized, that shouldn't be too tough
> (famous last words!!!!)
>
>
>>
>>> To answer various other issues and possibilities that had been
>>> mentioned: I verfied that the driver works fine on my dev machine
>>> with UNC names, and I changed the user under which the TC is
>>> running to the domain administrator, and that didn't help.
>> I believe Sun's Java started supporting UNC path names somewhere
>> around the late 1.5 or initial 1.6 releases, so it might not have
>> anything to do with the driver itself.
> Ok, thanks for that tidbit; I didn't realize they came to the UNC
> table that late in the game.
>
> D
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Access dbf files outside context/docbase - fixed
Posted by David kerber <dc...@verizon.net>.
On 12/20/2011 1:09 PM, Christopher Schultz wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> David,
>
> On 12/19/11 8:28 PM, David Kerber wrote:
>> Just to close out this thread, it's now fixed. I found a native
>> Java dBase (.dbf) file driver, and it works great in both 32- and
>> 64-bit environments, without having to mess with ODBC or the screwy
>> Microsoft database file drivers.
>
> Cool. Plus, now you can move to *NIX since you aren't dependent upon ODBC.
>
> - -chris
That thought has crossed my mind more than once!
D
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Access dbf files outside context/docbase - fixed
Posted by Christopher Schultz <ch...@christopherschultz.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
David,
On 12/19/11 8:28 PM, David Kerber wrote:
> Just to close out this thread, it's now fixed. I found a native
> Java dBase (.dbf) file driver, and it works great in both 32- and
> 64-bit environments, without having to mess with ODBC or the screwy
> Microsoft database file drivers.
Cool. Plus, now you can move to *NIX since you aren't dependent upon ODBC.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAk7wz3cACgkQ9CaO5/Lv0PAwWQCfQ4t94Fb78T5hIERfge0H/RZP
WlwAnj2lTorjjbS7k3SRVfaKUyiPmgNV
=bdrl
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org