By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,505 Members | 1,511 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,505 IT Pros & Developers. It's quick & easy.

Troubles with Threads and Suns jdbc-odbc Bridge Driver?

P: n/a
Shocks. Today I came to learn that Suns jdbc-odbc bridge driver isn't
meant for serious purposes; it's experimental. I already knew it isn't
thread safe, but didn't think of this as problematic for the relatively
simple system I'm using it. However, I suspect there are other issues.

Currently I'm stuck with a query which takes less than one second if I
run it somewhere in my program's main thread, while it takes easily 40
seconds when I run it from the ActionListener of, say, a menu item. I
have isolated it in the sense that all database stuff is concentrated in
one single method, which connects, queries and closes. So, there cannot
be a conflict with database resources being consumed elsewhere.

Next thing to try is to further cut down the system to create a minimal
system which shows this behaviour. Also, I'll try a different driver for
this MS Access database. I'll let you know if I can locate the problem.

In the meantime, it would be helpful to have answers to the following:
1. Are there known specific issues with the jdbc-odbc bridge driver
which could be relevant for the above problem?
2. Are there reviews available of the commerically available JDBC-ODBC
drivers, or straight JDBC drivers if these exist for MS Access?
3. Are there free JDBC-ODBC available? (not just free trials)

--
Grinnikend door het leven...
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
> 1. Are there known specific issues with the jdbc-odbc bridge driver which could be relevant for the above problem?
Sun's jdbc-odbc bridge isn't thread safe.
2. Are there reviews available of the commerically available JDBC-ODBC drivers, or straight JDBC drivers if these exist for MS Access? SequeLink JDBC Driver(datadirect.com) provides such a commerical
jdbc-odbc driver, and HXTT Access(www.hxtt.net) provides a type 4
driver for MS Access.
3. Are there free JDBC-ODBC available? (not just free trials)

Sun's jdbc-odbc bridge driver is free, and can work normaly for simple
task on most occasions.

Nov 13 '05 #2

P: n/a
> 1. Are there known specific issues with the jdbc-odbc bridge driver which could be relevant for the above problem?
Sun's jdbc-odbc bridge isn't thread safe.
2. Are there reviews available of the commerically available JDBC-ODBC drivers, or straight JDBC drivers if these exist for MS Access? SequeLink JDBC Driver(datadirect.com) provides such a commerical
jdbc-odbc driver, and HXTT Access(www.hxtt.net) provides a type 4
driver for MS Access.
3. Are there free JDBC-ODBC available? (not just free trials)

Sun's jdbc-odbc bridge driver is free, and can work normaly for simple
task on most occasions.

Nov 13 '05 #3

P: n/a
In article <11**********************@g47g2000cwa.googlegroups .com>,
"Dai Wei" <da****@hxtt.com> wrote:
1. Are there known specific issues with the jdbc-odbc bridge driver which
could be relevant for the above problem?

Sun's jdbc-odbc bridge isn't thread safe.


I know, but it doesn't explain my problem.
2. Are there reviews available of the commerically available JDBC-ODBC
drivers, or straight JDBC drivers if these exist for MS Access?

SequeLink JDBC Driver(datadirect.com) provides such a commerical
jdbc-odbc driver, and HXTT Access(www.hxtt.net) provides a type 4
driver for MS Access.


Thanks, I'll give these a try, together with the drivers from
http://www.easysoft.com/ and http://uda.openlinksw.com
3. Are there free JDBC-ODBC available? (not just free trials)

Sun's jdbc-odbc bridge driver is free, and can work normaly for simple
task on most occasions.


Hmmm, here the magic words are 'normally', 'simple' and 'most'. Given
the huge number of bug reports files at Sun's, I would not recommend
Sun's bridge driver in situations where time is money...

--
Grinnikend door het leven...
Nov 13 '05 #4

P: n/a
In article <11**********************@g47g2000cwa.googlegroups .com>,
"Dai Wei" <da****@hxtt.com> wrote:
1. Are there known specific issues with the jdbc-odbc bridge driver which
could be relevant for the above problem?

Sun's jdbc-odbc bridge isn't thread safe.


I know, but it doesn't explain my problem.
2. Are there reviews available of the commerically available JDBC-ODBC
drivers, or straight JDBC drivers if these exist for MS Access?

SequeLink JDBC Driver(datadirect.com) provides such a commerical
jdbc-odbc driver, and HXTT Access(www.hxtt.net) provides a type 4
driver for MS Access.


Thanks, I'll give these a try, together with the drivers from
http://www.easysoft.com/ and http://uda.openlinksw.com
3. Are there free JDBC-ODBC available? (not just free trials)

Sun's jdbc-odbc bridge driver is free, and can work normaly for simple
task on most occasions.


Hmmm, here the magic words are 'normally', 'simple' and 'most'. Given
the huge number of bug reports files at Sun's, I would not recommend
Sun's bridge driver in situations where time is money...

--
Grinnikend door het leven...
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.