469,331 Members | 1,721 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

Troubles with Threads and Suns jdbc-odbc Bridge Driver?

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
4 3900
> 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
> 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
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
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.

Similar topics

1 post views Thread by Ron | last post: by
5 posts views Thread by Maxim | last post: by
reply views Thread by toxxi | last post: by
reply views Thread by Roman Prigozhin | last post: by
9 posts views Thread by sreekant | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.