Re: odbc vs jdbc for database access in Mathematica
- To: mathgroup at smc.vnet.net
- Subject: [mg38219] Re: odbc vs jdbc for database access in Mathematica
- From: alexander.vorobiev at usa.net (Alexander Vorobiev)
- Date: Thu, 5 Dec 2002 03:33:02 -0500 (EST)
- References: <ashveh$em5$1@smc.vnet.net>
- Sender: owner-wri-mathgroup at wolfram.com
Todd,
The getRow method needed a small fix:
///
for (int i = 1; i <= types.length; i++) {
switch (types[i - 1]) {
///
because Java array indices start with 0 whrereas column inidices in
ResultSet start with 1. Other than that this simple class made a huge
difference - queries that used to take minutes to complete now take
less than a minute! My mistake was I was too reluctant to write any
Java code ;)
Thanks a lot!
Alexander