Hi all,
I have a Java webapp using a mysql database. It all used to run well, but I
now frequently get the following error:
2005-09-15 11:33:32,115 [Thread-23] ERROR rotation -
com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception:
** BEGIN NESTED
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan Kuhn wrote:
Hi all,
I have a Java webapp using a mysql database. It all used to run well, but I
now frequently get the following error:
2005-09-15 11:33:32,115 [Thread-23] ERROR rotation -
com.mysql.jdbc.CommunicationsException:
Hi Mark,
thanks for your answer. See comments.
Stefan,
Something is closing the network connection abrubtly between JDBC and
your MySQL server. Things to check are:
1) Connections don't sit longer than 'wait_timeout' on the server.
I am actually using connection pooling (the torque system,
space
Is LIMIT supported with the JDBC driver?
thank you everygody
Laurie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
: java.lang.OutOfMemoryError: Java heap space
java.lang.OutOfMemoryError: Java heap space
Is LIMIT supported with the JDBC driver?
thank you everygody
Laurie
Laurie,
Yes, the driver supports the 'LIMIT' keyword, because it relies on the
server to do it (the driver does not rewrite queries or really
Manish wrote:
We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers
in -
mysql-connector-java-2.0.14-bin.jar
Do these drivers work with MySQL 4.1.8? hey seem to be working fine with
4.0.14 version of MySQL.
Is there any compatibility data available for all these JDBC drivers
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Manish wrote:
We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers
in -
mysql-connector-java-2.0.14-bin.jar
Do these drivers work with MySQL 4.1.8? hey seem to be working fine with
4.0.14 version of MySQL.
Is there any
We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers
in -
mysql-connector-java-2.0.14-bin.jar
Do these drivers work with MySQL 4.1.8? hey seem to be working fine with
4.0.14 version of MySQL.
Is there any compatibility data available for all these JDBC drivers and
MySQL
mysql can't work with foreign keys, but I read, that
tables in the innodb-format can do this. But if I work with the jdbc-driver
and OOo, OOo doesn't support the foreignkeys-gui :-(( (the cause is the
jdbc-Driver)
Does anybody know, if a future version of the jdbc-Driver will support
all my jobs in schools with only _one_ database).
Till now, I thought mysql can't work with foreign keys, but I read, that
tables in the innodb-format can do this. But if I work with the
jdbc-driver
and OOo, OOo doesn't support the foreignkeys-gui :-(( (the cause is the
jdbc-Driver)
Does
for quite some time). What version of MySQL are you
using?
I installed yesterday mysql 4.0.15 (and if I start phpMyAdmin I see this
number in the Browser)
The most recent two releases (4.0.14 and 4.0.15) have changed the
output format for the metadata that the JDBC driver uses to parse
I have the query cache on MySQL 4.0.13-standard running and working fine, with a large
amount of memory allocated to it. But it doesn't appear to be working with the MySQL
JDBC driver access. I have used versions 2.0 and 3.0 of the JDBC driver. Although it
will cache a query from the JDBC
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Shu-Ping Lin wrote:
Hi, How are you?
I have a problem to jdbc driver. My paltform is win2000 professional and
MySQL Server's version is 3.23.55.
I use jdbc driver of mysql-connector-java-3.0.6-stable.jar and i find some
problems to this jdbc
Hi, How are you?
I have a problem to jdbc driver. My paltform is win2000 professional and
MySQL Server's version is 3.23.55.
I use jdbc driver of mysql-connector-java-3.0.6-stable.jar and i find some
problems to this jdbc driver version.
When i use some method about setting or getting String
to do
work-around such as not committing if a flag is set which should not be
necessary.
I have tried afew versions of you JDBC driver and it always performs the
same.
You should be able to make simple selects without having to commit, the
c api does exactly that!
Here is some example java code
select!
This presents awkwardness with multi-threading and I have to do
work-around such as not committing if a flag is set which should not be
necessary.
I have tried afew versions of you JDBC driver and it always performs the
same.
You should be able to make simple selects without having to commit
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mufaddal wrote:
PROBLEM with your JDBC driver - mysql connector.
I am developing using jdk1.4.1 on Mac OS X. I am using the mysql
driver - mysql connector java 2.0.14. I am creating a table in mysql
thru java ... the code to do
PROBLEM with your JDBC driver - mysql connector.
I am developing using jdk1.4.1 on Mac OS X. I am using the mysql
driver - mysql connector java 2.0.14. I am creating a table in
mysql
thru java ... the code to do this is below:
try
All,
The documention on the JDBC driver (v0.87) shows that ampersands are used to
delimit driver parameters.
JBoss (www.jboss.org) stores datasource definitions in XML files, and so
using seems a bit problematic.
Is there any way that the supported delimiters can be extended to use a
semi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg Matthews wrote:
All,
The documention on the JDBC driver (v0.87) shows that ampersands are used to
delimit driver parameters.
I'm curious as to where you get a version # of '0.87'. As far as I know
neither MM.MySQL or Connector/J has had
Message -
From: Mark Matthews [EMAIL PROTECTED]
To: Greg Matthews [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, December 29, 2002 11:27 AM
Subject: Re: JDBC driver / JBoss
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg Matthews wrote:
All,
The documention on the JDBC driver
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg Matthews wrote:
Mark,
Version was 3.51.05.
Hmmm, that looks like an ODBC driver version. MySQL Connector/J has two
branches right now 2.0.x and 3.0.x, seeing as how you're using named
pipes, you must be using 3.0.x something.
amp; works
At 11:57 29/12/2002 +1100, Greg Matthews wrote:
Hi,
If anyone has managed to get named pipes working under Windows XP with
JBoss, would they be nice enough to forward the URL used?
Only one note here: MySQL by default disables the named pipes.
If you want the named pipes you must use at
Hi !
Some times my application is hang-up. The stack trace contains the
following:
at java.net.SocketInputStream.socketRead(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:86)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:186)
Hi:
I am using Connector/J 3.0.2 against MySQL
3.23.52-max.
My default table type is set to InnoDB (since I
always use innodb).
The following methods are acting strangely:
- DatabaseMetaData.getImportedKeys()
- DatabaseMetaData.getExportedKeys()
Often these methods return partial information
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
j.random.programmer wrote:
Hi:
I am using Connector/J 3.0.2 against MySQL
3.23.52-max.
My default table type is set to InnoDB (since I
always use innodb).
The following methods are acting strangely:
- DatabaseMetaData.getImportedKeys()
-
of the API can not be
used in a threaded manner.
ie, can I open just one connection to the database for a multithreaded
servlet? Will the mysql JDBC driver serialize access or allow
concurrent statements? Or will I have to worry about synchronization?
The driver will serialize access, but you
On Monday, September 30, 2002, at 03:53 24h, Slava Imeshev wrote:
Hello All,
Could anyone help me with this issue? Is it
possible to create/drop database using mySQL
JDBC driver?
Yes.
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-7707Mobile: (602)326
Hi, All
I ported my gweMysql JDBC Driver(Type4) to C# Driver. :-)
If you are interested in C# Driver, please check it out!!
http://www.t3-jpn.com/work/jdbc/jdbcmysql.html
--
I love Borland.
TAKAHASHI, KEN, Tomohiro
Sorry, URL is wrong
Please check it out
http://www.t3-jpn.com/jdbc/jdbcmysql.html
"TAKAHASHI, Tomohiro" wrote:
Hi, All
I ported my gweMysql JDBC Driver(Type4) to C# Driver. :-)
If you are interested in C# Driver, please check it out!!
--
I love Borland.
TAKA
I have a problem with the installation of the JDBC driver for Mysql.
I have Windows XP and Java2 SDK 1.4.01
I tried to install the JDBC driver org.gjt.mm.mysql.Driver but every time
I
try to connect to my database, I get a ClassNotFoundException:
org.gjt.mm.mysql.Driver error, although I
\mm.mysql-2.0.4-bin.jar
or
- If you don't want to modify the CLASSPATH: java
-classpath
C:\pleasework\jdbc\mysql\mm.mysql-2.0.4-bin.jar
myapp.jar.
Good Luck!
--- Myrto Karyda [EMAIL PROTECTED] wrote:
I have a problem with the installation of the JDBC
driver for Mysql.
I have Windows XP and Java2
I'm trying to use the twz1 jdbc driver with dbvis.
I keep getting a java.lang.VerifyError error. Has anyone been able to get
dbvis to work with
mysql via twz1 driver?
thanks in advance
jennifer moter
-
Before posting, please
Hi, All
I updated JDBC Driver i maintained. :-)
http://www.t3-jpn.com/jdbc/jdbcmysql.html
[New Features for only JDK1.4 ]
Add New Property 'useNewIO' to use SocketChannel and DirectBuffer
with JDK1.4's New I/O API.
Please download gweMysqlJDBC_extra4.zip and set useNewIO
Hi, All
gweMysql JDBC Driver Update!!
$B!&(BSupport Borland Enterprise Server5.0 (EJB2.0)
$B!&(BSupport JBuilder6
$B!&(BConnectionPoolDataSource support maxPoolSize property
( 0 means no-limit )
[WebSite]
http://www.t3-
Hi!!!=0A=0AI am using the Mysql JDBC Driver 2.0.11. I am trying to use the =
methods getImportedKeys(), and getExportedKeys()=0A=0ABut it returns an emp=
ty result set.=0A=0AI am using Innodb tables.=0A=0AThanks =0AAmit =0A
Hi!!!
I am using the Mysql JDBC Driver 2.0.11. I am trying to use the methods
getImportedKeys(), and getExportedKeys()
But it returns an empty result set.
I am using Innodb tables.
Thanks
Amit
-
Before posting, please
I have installed and configured JDBC driver to work with MySql 3.23.47.
Does anyone know how to test to see that JDBC driver is working
properly? Is there a test file?
thanks
--rahad
-
Before posting, please check:
http
(url,username,password);
If that doesn't throw exception, you are in pretty good shape :-)
laszlo
Rahadul Kabir wrote:
I have installed and configured JDBC driver to work with MySql 3.23.47.
Does anyone know how to test to see that JDBC driver is working
properly? Is there a test file?
thanks
, password, etc. for connection.
Gurhan
-Original Message-
From: Billy Bob [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 29, 2002 11:06 AM
To: [EMAIL PROTECTED]
Subject: Help with setting up the JDBC driver
I am trying to install the jdbc driver to work with MySQL. I have added
Shankar Unni wrote:
That's right:
Do the following in a temp directory:
jar xvf mm.mysql-2.0.10-you-must-unjar-me.jar
This will create a directory called mm.mysql-2.0.10. Inside that, you'll
find a mm.mysql-2.0.10.jar file, which is what you need to put in your
classpath (you can move
[database,sql,query,table]
Mark Matthews wrote:
Or download version 2.0.11 released today which fixes that bug (as far as
I can tell):
Absolutely. Quick work, indeed. I've already switched over to 2.0.11 and
it's been smooth.
Thanks for the fantastic support!
--
Shankar.
Rahadul,
Thursday, January 24, 2002, 8:45:31 PM, you wrote:
RK hi,
RK I recently installed MySQL3.23.47 and now I need the JDBC drivers for
RK it. Does anyone know where can I find a Free JDBC driver that would work
RK with MySQL 3.23.47-1?
RK thanks so much
You can find JDBC drivers, look
mm.mysql-2.0.10-you-must-unjar-me.jar
this is the JDBC driver for Mysql3.23.47. Can someone tell me what is
the command to unjar this file as well as how to install this on
linux.
mysql is on /var/lib/mysql (by default) and JDK on /home/tomcat.
thanks so much
--rahad
Rahadul Kabir wrote:
mm.mysql-2.0.10-you-must-unjar-me.jar
this is the JDBC driver for Mysql3.23.47. Can someone tell me what is
the command to unjar this file as well as how to install this on
linux.
mysql is on /var/lib/mysql (by default) and JDK on /home/tomcat.
thanks so much
On Fri, 25 Jan 2002, Rahadul Kabir wrote:
Date: Fri, 25 Jan 2002 12:40:35 -0500
From: Rahadul Kabir [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: How to install JDBC driver!
mm.mysql-2.0.10-you-must-unjar-me.jar
this is the JDBC driver for Mysql3.23.47. Can someone tell me what
I'm a bit confused here. can some please tell me what is the difference
between this two files
-- mm.mysql.jdbc-1.2c.tar.gz ( Includes mysql_comp.jar and
mysql_uncomp.jar)
-- mm.mysql-2.0.10-you-must-unjar-me.jar
For JDBC driver to run with mysql which one do I need? I thought you
only need
At 16:59 -0500 1/25/02, Rahadul Kabir wrote:
I'm a bit confused here. can some please tell me what is the difference
between this two files
-- mm.mysql.jdbc-1.2c.tar.gz ( Includes mysql_comp.jar and
mysql_uncomp.jar)
-- mm.mysql-2.0.10-you-must-unjar-me.jar
For JDBC driver to run with mysql
-me.jar
For JDBC driver to run with mysql which one do I need? I thought you
only need .jar file. then whats the mm.mysql.jdbc-1.2c.tar.gz
file for. Are they the same files???
thanks so much.
I think that MM.MySQL used to be packaged as a tar file, but not is
Oops: should be ... but NOW
Paul DuBois wrote:
I think that MM.MySQL used to be packaged as a tar file, but not is
distributed
as a JAR. Use the newer one, you'll be better off. And do as the filename
indicates: un-jar it. You'll end up with a directory that contains the
actual driver file plus a bunch of other
hi,
I recently installed MySQL3.23.47 and now I need the JDBC drivers for
it. Does anyone know where can I find a Free JDBC driver that would work
with MySQL 3.23.47-1?
thanks so much
--rahad
-
Before posting, please check
http://mmmysql.sourceforge.net/
On Thu, 24 Jan 2002, Rahadul Kabir wrote:
hi,
I recently installed MySQL3.23.47 and now I need the JDBC drivers for
it. Does anyone know where can I find a Free JDBC driver that would work
with MySQL 3.23.47-1?
thanks so much
--rahad
Is it planned for this to be addressed in a future MySQL version?
Original Message
Subject: Re: No Data Truncation warning with MM JDBC driver
Date: Tue, 27 Nov 2001 12:15:08 -0600
From: Mark Matthews [EMAIL PROTECTED]
To: Steve Pellegrino [EMAIL PROTECTED]
References: [EMAIL
Anyone have a preferred JDBC for MySQL? I need a driver that will be
reliable under heavy load.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hi,
-Original Message-
From: Wally Flint [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 08, 2001 6:01 PM
To: Mysql mailing list
Subject: JDBC driver recommendatons
Anyone have a preferred JDBC for MySQL? I need a driver that will be
reliable under heavy load.
Yes
Hi,
Michael Widenius wrote:
Tomohiro, could you be kind and put a copy kind a put a link from the
MySQL software portal to your page ? This way it will be easier for
other MySQL users to find your software!
http://www.mysql.com/portal/software/html/index.html
Sure.
Thank you so
/index.html
It would also be nice if you could add some small documentation on
your site how your driver compares to the mm JDBC driver.
Regards,
Monty
PS: If anyone on this list really likes some MySQL utility they are
using and wants to recommend this to other MySQL users, please
add
TAKAHASHI, Tomohiro writes:
Hi, All
I Fixed two bugs.
1. If LoginUser has empty password, Driver can not connect to MySQL.
2. Connection Pool does not work correctly. ;-)
Check this URL out for new Driver. :-)
http://www.t3-jpn.com/jdbc/jdbcmysql.html
Thank you so
Hi, All
I Fixed two bugs.
1. If LoginUser has empty password, Driver can not connect to MySQL.
2. Connection Pool does not work correctly. ;-)
Check this URL out for new Driver. :-)
http://www.t3-jpn.com/jdbc/jdbcmysql.html
"TAKAHASHI, Tomohiro" wrote:
I updated J
I'm developing a Java application that uses a pool of JDBC connections
to store and retrieve data in a MySQL database. I'm using the 3.23.38
Win32 version of MySQL, on Windows 2000 Professional, and the
mm.mysql-2.0.4 JDBC driver.
I'm using a table with a MEDIUMTEXT field, which the MySQL
Hi,
I'm connecting to a MySQL server through the MM JDBC driver on under Red Hat
6.2 using the below code. I keep getting an error message returned that says
: Server configuration denies access to data .
I'm connecting as the root user and I am definitely passing the correct
password etc
CHANGELOG:
- Fixed ResultSet.getBlob() ArrayIndex out-of-bounds
- Fixed ResultSetMetaData.getColumnTypeName for TEXT/BLOB
- Fixed ArrayIndexOutOfBounds when sending large BLOB queries (Max size
packet was not being set)
- Added ISOLATION level support to Connection.setIsolationLevel()
- Fixed
Hi,
I'm using mm.mysql driver version 2.0.4 and jdk.1.3.
Actually I'm trying to us it because it keeps on giving me Not suitable
driver error.
For test I used the JDBCBench.java.
try {
Class.forName(org.gjt.mm.mysql.Driver);
I got very useful help. Thanks.
But now, I am facing another Java - JDBC problem.
I have successfully downloaded mm.mysql-2.0.4-bin.jar
driver, but I am not sure how to use this in my Java
application.
How should I register my application with the DB?
Class.forName("???");
Thanks,
Leon
read the docs that come with it. it is ALL explained in there.
RTFM... is the best thing.
On Wed, 11 Apr 2001 10:39:32 -0700 (PDT), Leon Zilber wrote:
I got very useful help. Thanks.
But now, I am facing another Java - JDBC problem.
I have successfully downloaded mm.mysql-2.0.4-bin.jar
Hey dudes
I'm having some troubles accessing a Mysql database with Java thru basic
JDBC Drivers. Looks like when the java code doesn't receive any replies to
its query, it stalls and I'm stuck with a dead process. Which basically
annoys me :)
Can anyone confirm or infirm the fact that JDBC
66 matches
Mail list logo