We are encountering two issues when using MySQL with large tables (by large,
we're talking > 1 million rows). Our application is written in Java and we
are using the mm.mysql JDBC driver. We run our applications using both
Oracle and MySQL. Below are issues that we have experienced.
1. The mm.
We have also experienced the same exact behavior, also using the mm.mysql
driver, on Linux. However, our problem is intermittent. There are times
(though these times cannot be accurately predicted) where the data is
retrieved correctly, which implies that the data is stored correclty. We
have v
confidentiality of this message. If you have received this email in
error, please notify me immediately by reply and delete this message.
-Original Message-
From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 3:51 PM
To: Stephen Faustino
Cc: '[EMAIL PROT
y [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 3:29 PM
To: Stephen Faustino
Cc: '[EMAIL PROTECTED]'
Subject: Re: BDB tables on Linux
On Mon, Mar 05, 2001 at 11:27:54AM -0600, Stephen Faustino wrote:
>
> I've installed 3.23.33 on both Solaris and Linux RH 6.2 using th
I've installed 3.23.33 on both Solaris and Linux RH 6.2 using the tarball
for Solaris and the RPM for Linux. The BDB tables work as expected on
Solaris, but they did not not work under Linux. What I'm seeing is that I
can create a BDB just fine. However, attempting a rollback results in:
ERROR
1. Can temporary tables be of type BDB? Now before the question is asked
as to why I need transactional support on a temporary table, let me first
say that I really don't need it; this is just something we stumbled across
during development.
If we create a temporary table of type BDB and attem
A small correction: if you want "Jo" to match John or LittleJohn, you need
to do:
SELECT * FROM customers WHERE name LIKE "%Jo%"
Stephen L. Faustino
Senior Software Engineer
SecureLogix Corporation
-Original Message-
From: Craig Atkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January
SELECT * FROM customers WHERE name LIKE "Jo%"
String comparisons are not case sensitive unless the comparison involves a
binary string.
Stephen L. Faustino
Senior Software Engineer
SecureLogix Corporation
-Original Message-
From: Craig Atkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, J
