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 4149
> 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(datadire ct.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(datadire ct.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************ **********@g47g 2000cwa.googleg roups.com>,
"Dai Wei" <da****@hxtt.co m> 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(datadire ct.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************ **********@g47g 2000cwa.googleg roups.com>,
"Dai Wei" <da****@hxtt.co m> 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(datadire ct.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 enough for that to matter.
Statement stmt = PoolDB.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet Picks = stmt.executeQuery("SELECT * FROM picks where
week="+week); // get all the cloums and...
|
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', 'password') FROM dual;
CHECK_PASSWD('USER','PASSWORD')
|
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 how to correct this problem? I can't
use the "generated" key anymore under J#, because the bytelenght differs
from the one in java. Or maybe anyone can traslate it into c#?
Here is the source :
import java.security.*;
|
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 SRVE0026E:
-: java.lang.UnsatisfiedLinkError:
SQLConnect
at COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Connection.java:514)
at COM.ibm.db2.jdbc.app.DB2Connection.<init>(DB2Connection.java:436)
|
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 10 threads are
trying to use the same stored procedure, once one of the thread
finishes up and returns connection back to the pool I'm getting
exception from all other 9 stored procedures :
com.ibm.db2.jdbc.app.DB2DBException: SC_PE00003 in...
| |
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 JDBC.
Assume we have a table named "test". Under PSQL, we can input "\d test"
to see the details about table "test" successufully. However, my main
purpose is trying to get column name, column name of a table through JDBC.
|
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, cmd, callback):
self.__cmd = cmd
self.__callback = callback
threading.Thread.__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 though SQL Server IS in mixed authentication mode.
Does mixed mode mean you can connect either way, but only using MS SQL
Server interfaces (like Mgmt Studio), and not something like JDBC?
Can we connect using JDBC w/ an AD login? If so, what form...
|
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 Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is...
|
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 classes12.jar there but when i search for jdbc version in classes12.jar
ie,
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |