On Dec 14, 2010, at 7:21 PM, Feris Thia wrote:
> Hi Mark,
>
> On Wed, Dec 15, 2010 at 8:10 AM, Mark Matthews
> wrote:
> Feris,
>
> *How* are you writing, via batch statements with rewriting, or directly, or
> via LOAD DATA INFILE? It seems you're off by about a
re you writing, via batch statements with rewriting, or directly, or via
LOAD DATA INFILE? It seems you're off by about a factor of 10-20x from what
I've seen performance-wise for writes.
-Mark
--
Mark Matthews
Principal Software Developer - MySQL Enterprise Tools
Oracle
http://
be
>>> used.
>>> You must also specify the --ssl-ca option, and possibly the --ssl-cert and
>>> --ssl-key options.
>>> ##
>> This documentation appears to be wrong.
>> Anders
>
> Excellent logic.
>
> I have updated bug #3138 with a private comment
gt; Well thats disappointing.
>
> sigh
> So what are we supposed to use for loadbalancing mysql.
>
> Thank you for your reply.
>
> Kind Regards
> Brent Clark
Brent,
Some clients (namely the JDBC driver, and the R-O-R adapter) have load
balancing built in.
-Mark
--
tocol.java:583)
>at
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
>at java.lang.Thread.run(Thread.java:636)
>
> Also, the MySQL instance I'm connecting to is hosted by dreamhost. I don't
> have any control over their networking c
ing (most
debian-based distributions do this by default), and "mysql" is using unix
domain sockets (which Java can't) to speak to mysqld. If that's the case,
you'll have to reconfigure mysqld to listen at least on the loopback
(127.0.0.1) by removing --skip-networking from m
better idea if it's going
to work for your situation in it's current (and always changing)
state, and also to provide input into the direction of the developers.
Best regards,
-Mark
--
Mark Matthews, Architect - Enterprise Tools
MySQL @ Sun Microsystems, Inc., http://www.sun.co
verState() and changeUser(), which operate on all connections
held by the replication connection.
- Connections created with jdbc:mysql:replication:// URLs now force
roundRobinLoadBalance=true on the slaves, and round-robin load
balancing now uses a "random" choice to more even
er now attempts
connections to the next "best" (depending on the load balance strategy
in use) server, and continues to attempt connecting to the next "best"
server every 250 milliseconds until one is found that is up and running
or 5 minutes has passed.
If the driver giv
ySQL server that was down. The driver now attempts
connections to the next "best" (depending on the load balance strategy
in use) server, and continues to attempt connecting to the next "best"
server every 250 milliseconds until one is found that is up and running
or 5 minutes h
values when "padCharsWithSpace" is set
to "true".
* Specifying a "validation query" in your connection pool that starts with "/*
ping */" _exactly_ will cause the driver to instead send a ping to the server
and return a fake result set (much lighter
he-middle from asking the client for data that the client is not
expecting. Thanks to Jan Kneschke for discovering the exploit and Andrey
"Poohie" Hristov, Konstantin Osipov and Sergei Golubchik for discussions about
implications and possible fixes. (Bug#29605)
Enjoy!
on", which sets
useDynamicCharsetInfo to "false" (see previous entry), and sets
useLocalSessionState and autoReconnect to "true".
* Fixed BUG#28851 - parser in client-side prepared statements silently
consumes character following '/' if it'
ut of MysqlIO (how many
bytes the driver expected to read, how many it actually read, say that
communications with the server were unexpectedly lost).
* Setting "useDynamicCharsetInfo" to "false" now causes driver to use static
lookups for collations as well (makes R
where calling getGeneratedKeys() on a prepared statement after
calling execute() didn't always return the generated keys (executeUpdate()
worked fine however).
- - Fixed issue where a failed-over connection would let an application call
setReadOnly(false), when that call shou
ytes, rather than 16K), and initial packets used during handshake are
now sized appropriately as to not require reallocation.
* Fixed issue where calling getGeneratedKeys() on a prepared statement
after calling execute() didn't always return the generated keys
(executeUpdate() worked
rom SHOW CREATE TABLE in
DatabaseMetaData, ignore exceptions relating to tables being missing (which
could happen for cross-reference or imported-key requests, as the list of
tables is generated first, then iterated).
Regards,
-Mark
- -
ause
NullPointerExceptions when it's required to check this property.
- Fixed BUG#21814 - time values outside valid range silently wrap.
- Fixed bug when calling stored functions, where parameters weren't
numbered correctly (first parameter is now the retu
14 - time values outside valid range silently wrap.
- Fixed bug when calling stored functions, where parameters weren't
numbered correctly (first parameter is now the return value, subsequent
parameters if specified start at index "2").
- Fixed BUG#21
d BUG#19615, PreparedStatement.setObject(int, Object, int)
doesn't respect scale of BigDecimals.
- Fixed BUG#19282 - ResultSet.wasNull() returns incorrect value
when extracting native string from server-side prepared statement
generated result set.
- Fixed BUG#19568 -
scale of BigDecimals.
- Fixed BUG#19282 - ResultSet.wasNull() returns incorrect value
when extracting native string from server-side prepared statement
generated result set.
- Fixed BUG#19568 - ResultSet.getSomeNumeric() didn't work for the
BIT type.
- Fixed BUG
ixed BUG#19568 - ResultSet.getSomeNumeric() didn't work for the
BIT type.
- Fixed BUG#19724 - Updatable result set fails when server is in
ANSI sql_mode.
- --
Mark Matthews
MySQL AB, Software Development Manager - Client Connectivity
www.mysql.com
-BEGIN
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dyego Souza Dantas Leal said the following on 5/2/2006 2:58 PM:
> I have a problem using the latest version of Connector/J
>
>
> the DESC of table shows:
>
> mysql> desc tiposelo;
> ++-+--+-+-+
Manuel Schmitt (manitu) wrote:
Hi,
I'am searching for a way to have mysqld log all passwords which clients
are using ("trying") while connecting.
As to the documentation and to my trials neither the error log nor the
general query log contain passwords, only the usernames.
I already tried to g
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Patrick Duda wrote:
> I guess I don't understand this locking stuff. I have a InnoDB table
> that has one thing in it, a counter. All I want to do is have multiple
> instances of the code read this counter and increment it. I want to
> make sure tha
Michael Lai wrote:
David Logan wrote:
Michael Lai wrote:
I am currently using MySQL 5.0.15 with mysql-connector-java-3.1.11.
I can access the database from my JSPs with no problem except for one
small issue. After a long delay (usually overnight), when someone
first tries to access the da
c value (and is thus not
complementary to .getObject() on an UNSIGNED LONG type).
- - Fixed BUG#11874 - ResultSet.getShort() for UNSIGNED TINYINT returned
wrong values.
- - Fixed BUG#15676 - lib-nodist directory missing from package breaks
out-of-box build
- - Fixed BUG#15854 -
a parameters), the
> driver will automatically [behind the scenes] escape the percent sign?
> If so, wow!
> Thanks;
> -nat
>
Nat,
No, it does not escape "%", it only escapes quotes and binary data, just
as any other prepared statement implementation from any vendor does
ase session as
> part of the connection pool recycling?
Depends on the connection pool and how it's configured. Generally the
logical session is terminated by the container, eventually the
connection pool will terminate the physical session if some idle timeout
value is reached, or if the physi
a dump file on the remote server runing a script with crontab. i
> gzip that file just to make the file transfer faster . the local server
> then fetches the file (wget) and gunzips it and then i load the file.
> works pretty good.
>
The JDBC driver, and the "mysqli" interfac
automatically.
If you can use MysqlConnectionPoolDataSource with JBoss' connection
pool, the MySQL JDBC driver will reset connection state when the
"logical" connection is closed. If you don't use our
ConnectionPoolDataSource, your application is responsible for setting
C driver for MySQL and put the aspects
in there ;)
JDBC in general doesn't use aspects, but JDBC is just a bunch of
interfaces to be implemented by driver vendors.
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com
-BEGIN PGP SIGNATURE---
they are related? I wasn´t
> aware of this.
>
> Thanks, Fernando.
Fernando,
The JDBC driver uses Aspect/J to weave in tracing aspects, if that's
what they're referring to. I'm not sure the server uses any technology
that could be considered "aspects".
ff by adding "useServerPrepStmts=false" to your URL
configuration properties for Connector/J 3.1.x, and MySQL should be able
to utilize the query cache again.
It's planned that in the future the query cache will work with
server-side prepared statements, but for now the above is
the server.
2) If the mysql server is on a different machine than your application:
2a) There are no network hardware issues
2b) There isn't a firewall between the server and your application
that times-out connections
3) MySQL isn't crashing in between queries (see your mysql serve
other poster's example just ends up setting the error
variable, _not_ creating a custom error.
MySQL does not yet have a RAISERROR implementation, so to create an
exception, you usually have to do something that is erroneous, but that
has no side effects and then parsing the error message f
ut the NetAPP filesystem generating more UDP traffic, then look
for DNS issues. Did your "OS boys" look at the destination for these
packets (port # and host), as that would tell you a _lot_ about why
they're being sent.
-Mark
- --
Mark Matthews
MySQL AB, Software Development
java.sun.com/docs/books/tutorial/jdbc/basics/transactions.html
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8D
And @endDate);
Kent,
If you prefix things with @, they are session variables. You want
something like the following, I believe:
Create procedure `mit_logs`.`spUsingDateRange`(begDate datetime, endDate
datetime)
BEGIN
SELECT *
FROM mitlog
WHERE (mitlog.StartDateTime between begDate And endDa
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark Matthews wrote:
[snip]
> For example, besides containing regulations concerning techology for
> software that deals with artifacts that fall under HIPPA (but does not
> mandate _which_ technology to use), there are regulations about
>
amiliar with this that could provide a reference or a simple
> summary. It seems an interesting and important topic that I thought the list
> might be interested.
Try Health and Human Service's Website
http://aspe.hhs.gov/admnsimp/bannertx.htm
-Mark
- --
Mark Matthews
MySQL
[SUSPEND] XID (suspended tx can only be resumed on same physical
connection)
XA START XID [JOIN|RESUME]
XA COMMIT XID [ONE PHASE]
You (well, really, your transaction mananger) issue these commands as
you would any other SQL query.
-Mark
- --
Mark Matthews
MySQL AB, Software Development Man
x27;ve chosen to configure the server. It can't be
avoided. Once again, if you're using version 3.1.x of the driver, you
can put "cacheServerConfiguration=true" in your JDBC URL, and the values
from this query will be cached, however if you reconfigure your database
server, you&
buffers for it, so essentially you're allocating _400_ megs or so _per_
client.
(not to mention that many of your web sessions are sending 200 megs of
data around your network between your appserver(s) and your database,
which is a performance issue as well)
-Mark
- --
Mark Matthews
specified raised an exception in
MysqlIO.changeDatabaseTo().
We apologize to those of you that make connections without specifying a
database, as this would've caused problems for you :(
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Client Connectivity
www.mysq
le-byte
charsets including 'aliases' Windows-31J, CP934, MS932.
- Added support for the "EUC_JP_Solaris" character encoding, which
maps to a MySQL encoding of "eucjpms" (backported from 3.1 branch). This
only works on servers that support eucjpms, na
xed BUG#11259, autoReconnect ping causes exception on connection
startup.
- Fixed BUG#11360 Connector/J dumping query into SQLException twice
- Fixed PreparedStatement.setClob() not accepting null as a parameter.
- Fixed BUG#11411 - Production package doesn
ut in place (like writing seminars in flash and rolling
out our own call-in numbers, remember we're a database company, not a
multimedia production house), why not recommend it?
Regards,
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com
-
some situations, but other users are going to want/need
partitioning and load distribution at the _application_ level, which I
think is the problem Kevin's talking about.
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com
-BEGIN PGP SIGN
d to how the RPMs were
packaged and/or post-processed.
Regards,
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http
nt languages. This may be the case
> where what Java calls "timestamp", MySQL calls "datetime". Same data,
> different name.
Shawn,
You are correct. The MySQL JDBC drivers maps MySQL's "DATETIME" to
java.sql.Timestamp.
Lieven, you might've found this
to C/J 3.0 if you wanted to stick some code in
Connection.execSQL().
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird
hed by the same MySQL.
>
> I'm using JBoss 3.2.5 with JDBC 3.0.16 and MySQL 4.0.23a.
>
> Any idea why?
>
>
> Regards,
> Rafal
>
>
Rafal,
Define what you mean by "not cached by MySQL"Do you mean the query
cache? If so, what do your query cache
an ISV/OEM that wants to include MySQL in your product, you
should contact [EMAIL PROTECTED], because the is dramatically different,
but is negotiated per-situation based on the pricing model and revenue
you'd be generating with your software.
-Mark
- --
Mark Matthews
MySQL AB, Soft
sultSets).
If the driver is reading 100's of megabytes of rows, it's because the
server is sending them. What happens if you run the _exact_ same query
in the MySQL commandline client?
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.
,
Maybe you missed this section in the manual?
http://dev.mysql.com/doc/connector/j/en/cj-upgrading-3-0-to-3-1.html
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com
MySQL User Conference (Santa Clara CA, 18-21 April 2005)
Early registration unti
ME NULL
) TYPE=InnoDB;
And then in your INSERT statement, use NOW() for your create_date.
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com
MySQL User Conference (Santa Clara CA, 18-21 April 2005)
Early registration until February 28: http://www.mysqluc.com/
-+
> | AMFTPF |
> ++
> | 15.00 |
> ++
>
> 1 row in set (0,01 sec)
Julien,
I went ahead and reported this as a bug, you can track it via
http://bugs.mysql.com/bug.php?id=8794
(You might want to comment on it, that way you will get e-mails as its
x27;t actually have configurable locale, and doesn't
expose this information in any status variable, you will have to set
your client to the same locale as your server to get these numbers to
parse, see:
http://java.sun.com/j2se/1.5.0/docs/guide/intl/locale.doc.html
and
http://java.sun.com/j
will treat
BIT(1-8) as the JDBC standard BIT type (which maps to
java.lang.Boolean), as the server does not currently send enough
information to determine the size of a bitfield when < 9 bits are
declared. BIT(>9) will be treated as VARBINARY, and will return
byte[] when
ning
> under Win2K and clients connect via the JDBC driver.
>
>
Dan,
JDBC doesn't enable multi-statements by default, you have to pass it as
a configuration parameter.
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Client Connectivity
www.mysql.com
MySQL Us
ys create
a new connection.
The only other obvious thing I can think of since you're using
short-lived connections is to make sure you've not running reverse-DNS
lookups inside the MySQL server (--skip-name-resolve), although that's
usually one of the first things a really high-volume in
e the feature, so you should've gotten a 'syntax
error' when you tried it ;)
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Client Connectivity
Office: +1 408 213 6557
www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG
his feature to be enabled.
- - Refactoring of where logic for prepared statement, server-prepared
statement lives.
- --
Mark Matthews
MySQL AB, Software Development Manager - Client Connectivity
www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - h
7026 - DBMD.getProcedures() doesn't respect catalog
parameter.
- --
Mark Matthews
MySQL AB, Software Development Manager - Client Connectivity
www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbir
er including the newer, more secure authentication
scheme.
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Client Connectivity
Office: +1 408 213 6557
www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - ht
d server-side prepared statements.
While Connector/J version 3.0 will connect to MySQL server, version 4.1
or newer, and implements Unicode characters and the new authorization
mechanism, Connector/J 3.0 will not be updated to support new features
in current and future server versions."
27;Monty' code mentioned in Util.java?
>
> Ta,
>
Mike,
MySQL-4.1.7 uses SHA-1. The code you're looking at is for MySQL-4.0 and
older. See MysqlIO.secureAuth411(), which also happens to have the
entire algorithm in a comment block ;)
-Mark
- --
Mark Matthews
MySQ
DBC driver.
Try upgrading to something more recent, like 3.0.16 at
http://dev.mysql.com/downloads/connector/j/3.0.html and see if the
problem goes away.
(This is especially true if you are trying to connect to MySQL 4.1 or
newer).
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager
the slowdown with the 3.0.15 driver so I upgraded to the
> 3.0.16 driver and have the same problem.
>
> Any insight?
Frank,
What character set are you using in the JDBC driver? Does it happen to
be utf-8?
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - C
D_ROWS() is scoped by _connection_, are you sure you don't do
anything with the connection between issuing the two queries (for
example, calling commit(), or using the connection via a pool, and not
having the same connection twice in a row?)
-Mark
- --
Mark Matthews
MySQL AB, So
1.x from
http://downloads.mysql.com/snapshots.php ... It has a change to it where
it will use the smaller of 1MB or max_allowed_packet for LOAD DATA LOCAL
INFILE operations (this still works, it's just not the 'normal' way the
client library works).
-Mark
- --
Mark Matthews
r version >= 4.1.1.
- Fixed regression where useUnbufferedInput was defaulting to
'false'.
- Fixed BUG#6231, ResultSet.getTimestamp() on a column with TIME in
it fails.
- --
Mark Matthews
MySQL AB, Software Development Manager - Client Connectivity
Office: +1 70
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William R. Mussatto wrote:
> Mark Matthews said:
>
>>-BEGIN PGP SIGNED MESSAGE-
>>Hash: SHA1
>>
>>William R. Mussatto wrote:
>>
>>
>>>>Tried it and now I get connection timed out aft
xReconnects + " times. Giving up.",
SQLError.SQL_STATE_UNABLE_TO_CONNECT_TO_DATASOURCE);
)
That 'underlying exception' bit will be important for anyone who is
trying to figure out why you're having problems!
-Mark
- --
Mark Matthews
working' (check /etc/mysql/my.cnf or /etc/my.cnf, debian
often ships their binaries with a my.cnf with --skip-networking in it).
-Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Client Connectivity
Office: +1 708 332 0507
www.mysql.com
-BEGIN PGP SIGNATURE
en
released yet as a binary by the DBD::MySQL maintainer (DBD::MySQL
version 2.9015)
> Thanks that worked, now to see what happends when I try w/connector/J
As long as you're using a recent version of Connector/J (3.0.15 or
3.1.4), it'll work fine.
Regards,
-M
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John McCaskey wrote:
| The problem is not the memory on the database server, but on the client
| running the JDBC connection. Seems that when you retrieve the result it
| is trying to store everything in memory at once.
|
| Here is some info from the m
ava can
>>actually see and what is hidden. But I do know that it can see the
>>descriptions of the columns.
>>
>>I had assumed that Mark Matthews, the guy who develops the JDBC drivers, had
>>persuaded the other MySQL developers that the JDBC drivers *had* to be able
>&g
se at
http://bugs.mysql.com/ ? This issue would get the proper attention it
needs if you use that 'channel'.
Thanks!
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 332 0507
www.mysql.com
MySQL Guide to Lower TCO
ht
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.1.4, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.1.4 is the second (and last planned before GAMMA) BETA release
of the 3.1 series that is suitable for use with either MySQL-4.1 or
M
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.15, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.0.15 is a bugfix release for the stable tree that is
suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0.
It
null.
|
What is the _full_ stacktrace here? This doesn't look like it's coming
from the JDBC driver (we don't have a message like this that I can see).
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 332 0507
www.
.
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 332 0507
www.mysql.com
MySQL Guide to Lower TCO
http://www.mysql.com/it-resources/white-papers/tco.php
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.3 (MingW32)
Comment: U
> Hi everyone,
>
> Is there a standard way to specify a default user name and password for
> the java driver? For example, will it recognize .my.cnf like most mysql
> clinets do?
>
> Thanks,
>
> Sergei
>
Sergei,
No there is not. It must be passed in on the command line. Of course your
application
> Hi,
>
> I have following code to insert a row into a table - schema follows:
> :
> PreparedStatement insertData = targetConnection.prepareStatement("insert
> into CompanyParticipationLevel
> (siteId,nodeId,companyId,editionId,participation
> LevelId,participationText,participationLogo) values
ld be pretty
straightforward to automatically update your Lucene index and query it
inside MySQL queries:
http://freshmeat.net/projects/judf/?topic_id=66
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 332 0507
www.mysql.co
rdSQL.
[snip]
Sorry, just fell into 'vernacular', mostly because their website is
'www.firebirdsql.org' :p
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 332 0507
www.mysql.com
MySQL Guide to Lower TCO
http
.
-Mark
- --
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
| -
| This mail sent through IMP: http://horde.org/imp/
- --
Mr. Mark Matthews
MySQL AB, Soft
. as MySQL AB does with the MySQL product line.
You are also much more likely to find people and third-party products
that know, understand and work with MySQL than those that can work with
FirebirdSQL out there in the marketplace.
Regards,
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Dev
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.1.3, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.1.3 is the first BETA release of the 3.1 series that is
suitable for use with either MySQL-4.1 or MySQL-5.0 (and is required
when using
e, you could turn off server-side prepared statements
with 'useServerPrepStmts=false' in your URL).
Sorry for any hassle this has caused.
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 332 0507
www.mysql.com
MySQ
;m not sure the problem is on the client...
Leonardo,
Earlier you said that a statement without a parameter ('?') works, but
one with a parameter doesn't.
In both cases, are you still using a PreparedStatement?
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manag
reating the PreparedStatement each time
gives me
> the error
> above when I call ResultSet rs = ps1.executeQuery().
>
> I'm using connectorJ 3.1.2, mysql 4.1.2
What happens if you use a nightly snapshot of Connector/J from
http://downloads.mysql.com/snapshots.php?
-
your friend here):
http://dev.mysql.com/doc/connector/j/en/index.html#id2800874
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 332 0507
www.mysql.com
MySQL Guide to Lower TCO
http://www.mysql.com/it-resources/white-papers/tco.php
--
ould know where to go from there, but I am
>> not sure that I am telling my app where to go to find
>> the drivers.
>>
> I think you're probably right. I've always found that first programs were
> extremely crucial for developing the confidence that it takes to
pro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.1.2, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.1.2 is a new feature release for the ALPHA tree that is
suitable for use with either MySQL-4.1 or MySQL-5.0 (and is required
when us
erializing his four connections, or he might not be
actually producing enough load to actually be able to measure any
difference between his two approaches. If he could post his DDL, the
relative size(s) of his data set(s) and the queries, that would be
somewhere to start.
-Mark
- --
Mr. Mark Matthews
n. This facilitates having a
common URL, but the ability to test cases when various properties
(characterEncoding, autoReconnect, etc) affect how the driver behaves.
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 332 0507
www.mysql.c
d from database as (int)chars: ");
for (int i = 0; i < utf8String.length(); i++) {
System.out.println(Integer.toHexString((int)utf8String.charAt(i)));
}
}
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 7
1 - 100 of 429 matches
Mail list logo
