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... 4 4123
> 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.
> 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.
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...
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... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Ron |
last post by:
this code is giving me an excption and I cannot tell why could someone who
is familiar with jdbc help me out, I am using mysql with jdbc, although the
exception does not look like it is getting far...
|
by: Maxim |
last post by:
Hi all!
My problem is very, very silly and stupid, I know, don't blame me for
that please...
When I call my query from SQL*Plus, I get the correct result:
SELECT check_passwd('user',...
|
by: toxxi |
last post by:
If I use this little Prg under Sun's Java, the outputbytearray (byte1) is ~46
bytes long! If I use it under J# the outputbytearray (byte 1) is all the time
only 40 bytes long! Can anyone show me...
|
by: global |
last post by:
Hi, can anyone help me
I'm on Linux with UDB Runtime-Client 8.1.4 and try to connect to
a windows udb-server 8.1.4 via Websphere and jdbc , and get this
error:
3e1a29e5 WebGroup E...
|
by: Roman Prigozhin |
last post by:
HI All,
I have a problem with calling stored procedure in
multithreaded environment.
This procedure utilizes session table to collect data and
cursor to return it back to java application . When...
|
by: Ying Lu |
last post by:
Hello,
Under mysql, we have "desc tablename" to get the detail information
about a table. My question is about to get column name, and column type
for a specific table under PostgreSQL through...
|
by: sreekant |
last post by:
Hi folks
What am I doing wrong in the following? I just want to run fluidsynth in
the background.
#########################################
class MyThread(threading.Thread):
def __init__(self,...
|
by: aj |
last post by:
I'm a newbie w/ SQL Server 2005.
We will be connecting to SQL Server 2005 via JDBC. We have made this
work by using an SQL Server account, rather than an Active Directory
(AD) account, even...
|
by: neuraljay |
last post by:
hi everyone. I am trying to build a jsp using webwork, hibernate and mysql. And right now I am doing its unit testing. Everytime I run the test I am getting this error:
Error JDBC exception on...
|
by: vijayarl |
last post by:
hi Everyone,
I need to know how to check the jdbc version using classes12.jar
am getting into this path :/../../../../oui/jlib/
then listed all files under this directory
i did found...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |