http://blog.gmane.org/gmane.comp.db.mysql.java hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.db.mysql.java/5519 <pre>Hello all, MySQL Connector/J 5.1.20, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.20 is suitable for use with many MySQL server versions, including 4.1, 5.0, 5.1, 5.4 and 5.5. It is now available in source and binary form from the Connector/J download pages at http://dev.mysql.com/downloads/connector/j/5.1.html and mirror sites as well as Maven-2 repositories. As always, we recommend that you check the "CHANGES" file in the download archive to be aware of changes in behavior that might affect your application. We welcome and appreciate your feedback, bug reports, bug fixes, patches etc: http://forge.mysql.com/wiki/Contributing MySQL Connector/J 5.1.20 includes the following general bug fixes and improvements also listed in more detail on http://dev.mysql.com/doc/connector-j/en/cj-news-5-1-20.html: - Fix for Bug#64983, 5.1.19 not working with JBoss AS 4.2.3.GA. - Fix for Bug#13960556, java.lang</pre> Tonci Grgin 2012-05-02T06:05:11 http://comments.gmane.org/gmane.comp.db.mysql.java/5518 <pre>Hello all, MySQL Connector/J 5.1.19, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.19 is suitable for use with many MySQL server versions, including 4.1, 5.0, 5.1, 5.4 and 5.5. It is now available in source and binary form from the Connector/J download pages at http://dev.mysql.com/downloads/connector/j/5.1.html and mirror sites as well as Maven-2 repositories. As always, we recommend that you check the "CHANGES" file in the download archive to be aware of changes in behavior that might affect your application. We welcome and appreciate your feedback, bug reports, bug fixes, patches etc: http://forge.mysql.com/wiki/Contributing MySQL Connector/J 5.1.19 includes the following general bug fixes and improvements: - Fix for Bug#64621, setMaxRows was not correctly processed during CS PS metadata collection causing entire resultset to be fetched and possibly leading to OOM. - Fix for Bug#6345</pre> Tonci Grgin 2012-04-04T07:22:24 http://comments.gmane.org/gmane.comp.db.mysql.java/5517 <pre>From mysqld Ver 5.0.51a-24+lenny2-log for debian-linux-gnu on i486 To mysqld Ver 5.1.49-3-log for debian-linux-gnu on i486 java.lang.NullPointerException at java.util.GregorianCalendar.computeFields(GregorianCalendar.java:2026) at java.util.GregorianCalendar.computeFields(GregorianCalendar.java:1996) at java.util.Calendar.setTimeInMillis(Calendar.java:1109) at java.util.Calendar.setTime(Calendar.java:1075) at java.text.SimpleDateFormat.format(SimpleDateFormat.java:876) It appears that in mysql-connector-java-5.1.10-bin.jar: com.mysql.jdbc.PreparedStatement line: 4728 this.tsdf.setTimeZone(this.connection.getServerTimezoneTZ()); is null. The combination " useGmtMillisForDatetimes=true&amp;amp;serverTimezone=Europe/Zurich&amp;amp;" in my tomcat's server.xml appears to fix it. Any better hints? Thanks in advance Ralf </pre> gmx 2012-01-15T08:21:25 http://comments.gmane.org/gmane.comp.db.mysql.java/5516 <pre>Hi! Can any body tell me how disable innodb support in mysql embedded connector/MXJ? I know that exist a skip-innodb option for my.cnf file and --skip-innodb as parameter for mysqld, but when i try use it into the server options map this does not disable innodb, i don't know why. I don't need innodb support and it make very slow the mysqld startup. I am using mysql-connector-mxj-gpl-5-0-12.jar and mysql-connector-java-5.1.18-bin.jar Thanks, any help is important to me. </pre> Victor Cifuentes 2012-01-15T05:48:56 http://comments.gmane.org/gmane.comp.db.mysql.java/5514 <pre>Good afternoon, I'm currently trying and configure MySQL in order to have an in-memory database in my unit tests. My environment is: Linux 3.0.0, Java 6 openJDK, MySQL connector 5.0.7 and MXJ 5.0.12. Here's my code: ------------------ String driver = System.getProperty("SQL_DRIVER", "com.mysql.jdbc.Driver"); String defaultUrl = "jdbc:mysql:///test?propertiesTransform=com.mysql.management.jmx.ConnectorMXJPropertiesTransform"; String url = System.getProperty("SQL_URL", defaultUrl); String user = System.getProperty("SQL_USER", "root"); String password = System.getProperty("SQL_PW", ""); Class.forName(driver); Connection conn = DriverManager.getConnection(url, user, password); ------------------ I get an exception at the last line: ------------------ Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 at java.util.ArrayList.rangeCheck(ArrayList.java:571) at java.util.ArrayList.get(ArrayList.java:349) at com.mysql.management.jmx.ConnectorMXJPropertiesTransform.&lt;init&gt;(Connecto</pre> Pierre Goupil 2011-12-21T14:24:02 http://comments.gmane.org/gmane.comp.db.mysql.java/5511 <pre>Hello, In my application I have a query which is very hard to rewrite to a preparedstatement for legacy reasons. Is there some method so I can do the right escaping by hand? query = "SELECT * FROM foo WHERE bar = '" + MySQLUtils.escapeString("bla") + "'"; Something like that. Thanks in advance, Ronald.</pre> Ronald Klop (Mailing List 2011-11-04T12:22:19 http://comments.gmane.org/gmane.comp.db.mysql.java/5510 <pre>Hello all, MySQL Connector/J 5.1.18, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.18 is suitable for use with any MySQL version including MySQL-5.1 or MySQL-5.5. It is now available in source and binary form from the Connector/J download pages at http://dev.mysql.com/downloads/connector/j/5.1.html and mirror sites as well as Maven-2 repositories. As always, we recommend that you check the "CHANGES" file in the download archive to be aware of changes in behavior that might affect your application. We welcome and appreciate your feedback, bug reports, bug fixes, patches etc.: http://forge.mysql.com/wiki/Contributing MySQL Connector/J 5.1.18 includes the following general bug fixes and improvements: - Fix for Bug#12565726, not putting the space between VALUES() and ON DUPLICATE KEY UPDATE causes C/J a) enter rewriting the query although it has ON UPDATE and b) to generate the wrong query with multi</pre> Tonci Grgin 2011-10-04T08:36:03 http://comments.gmane.org/gmane.comp.db.mysql.java/5509 <pre>Hi, I wanted to run java method from trigger. for that i need to write java db procedure.. as mention in http://download.oracle.com/javase/tutorial/jdbc/basics/storedprocedures.html#creating_stored_procedures_java_db but i am getting sql syntax error at 'AS LANGUAGE' please let me know if you have th solution for the same.. my create procedure statement is = "CREATE PROCEDURE log_sal(IN idsal float, IN old_sal float, IN new_sal float) " + //"PARAMETER STYLE JAVA " + "AS "+ "LANGUAGE JAVA " + //"DYNAMIC RESULT SETS 1 " + "EXTERNAL NAME 'com.trigger.DBTrigger.logSal'"; </pre> pravin kalbhor 2011-10-04T05:31:26 http://comments.gmane.org/gmane.comp.db.mysql.java/5508 <pre>To confirm that you would like gcdmj-java&lt; at &gt;m.gmane.org removed from the java mailing list, please click on the following link: http://lists.mysql.com/u/java/4e4f2360d44b612a/gcdmj-java=m.gmane.org This confirmation serves two purposes. First, it verifies that we are able to get mail through to you. Second, it protects you in case someone forges a subscription request in your name. We haven't checked whether your address is currently on the mailing list. To see what address you used to subscribe, look at the messages you are receiving from the mailing list. Each message has your address hidden inside its return path; for example, john&lt; at &gt;example.com receives messages with return path: java-return-&lt;number&gt;-john=example.com&lt; at &gt;lists.mysql.com. --- Administrative commands for the java list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: &lt;java-subscr</pre> java-help< at >lists.mysql.com 2011-08-20T03:00:48 http://comments.gmane.org/gmane.comp.db.mysql.java/5507 <pre>To confirm that you would like gcdmj-java&lt; at &gt;m.gmane.org removed from the java mailing list, please click on the following link: http://lists.mysql.com/u/java/4e4f2343ed93b80b/gcdmj-java=m.gmane.org This confirmation serves two purposes. First, it verifies that we are able to get mail through to you. Second, it protects you in case someone forges a subscription request in your name. We haven't checked whether your address is currently on the mailing list. To see what address you used to subscribe, look at the messages you are receiving from the mailing list. Each message has your address hidden inside its return path; for example, john&lt; at &gt;example.com receives messages with return path: java-return-&lt;number&gt;-john=example.com&lt; at &gt;lists.mysql.com. --- Administrative commands for the java list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: &lt;java-subscr</pre> java-help< at >lists.mysql.com 2011-08-20T03:00:19 http://comments.gmane.org/gmane.comp.db.mysql.java/5506 <pre>Hello all. MySQL Connector/MXJ 5.0.12 is now available for download. MySQL Connector/MXJ 5.0.12 is a Java utility package for deploying and managing a MySQL RDBMS. The 5.0.12 version includes MySQL 5.5.9 server community binaries and related resources for the following platforms: * Linux x86, x86_64 * Mac OS X x86, x86_64 * Windows XP/2K/NT/Vista/2003/2008/7 x86, x86_64 * SunOS sparc, x86, x86_64 * FreeBSD x86, x86_64 Platforms can easily be added or removed from: mysql-connector-mxj-gpl-5-0-12-db-files.jar MySQL Connector/MXJ may be bundled into an existing Java application and managed as a POJO (Plain Old Java Object) or launched by creating a Connector/J connection. This makes it easy for Java developers creating an application that uses JDBC through MySQL Connector/J to deploy applications which require a database by reducing installation barriers for their end-users. Adding a MySQL database to a Java application can be as easy as: 1) configuring the CLASSPATH t</pre> Tonci Grgin 2011-07-07T17:22:12 http://comments.gmane.org/gmane.comp.db.mysql.java/5505 <pre>Hello all, MySQL Connector/J 5.1.17, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.17 is suitable for use with any MySQL version including MySQL-5.1 or MySQL-5.5. It is now available in source and binary form from the Connector/J download pages at http://dev.mysql.com/downloads/connector/j/5.1.html and mirror sites as well as Maven-2 repositories and MOS. As always, we recommend that you check the "CHANGES" file in the download archive to be aware of changes in behavior that might affect your application. We welcome and appreciate your feedback, bug reports, bug fixes, patches etc.: http://forge.mysql.com/wiki/Contributing MySQL Connector/J 5.1.17 includes the following general bug fixes and improvements: - Fix for Bug#61332 - LIKE not optimized in server when run against I__S tables and no wildcards used. Databases/tables with "_" and/or "%" in their names (escaped or not) will be handled by </pre> Tonci Grgin 2011-07-07T17:07:30 http://comments.gmane.org/gmane.comp.db.mysql.java/5502 <pre>Folks, I am compiling within the Eclipse IDE. Within com.mysql.jdbc.CallableStatement the implented java.sql.CallableStatement results in the following error “The type CallableStatement must implement the inherited abstract method CallableStatement.getNString(int)” Is there something that I am missing? regards, Kevin</pre> Kevin Hine 2011-05-24T09:47:41 http://comments.gmane.org/gmane.comp.db.mysql.java/5501 <pre>Hello, While testing my application with MySQL I noticed a difference with Oracle's JDBC implementation. In the following excerpt, I expect the call to getString to return the "new-value" /* Sometimes the application calls moveToInsertRow() to insert a new row or next() to update an existing row in the database */ ... resultSet.updateString(2,"new-value"); resultSet.getString(2).equals("new-value"); ... /* Sometimes the database does not need to be updated and the changes are canceled */ It works as expected when inserting a new row (calling resultSet.moveToInsertRow() before the two lines above). However, it does not work when updating a row (calling resultSet.next() before the the two lines above). In this case the call to getString still returns the value in the database. Is there a way to make getString after updateString to work consistently for both uses case? Thank You, Dmitry Sample Code: import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java</pre> Dmitry Isakbayev 2011-05-10T19:26:49 http://comments.gmane.org/gmane.comp.db.mysql.java/5500 <pre>Hi All, We are frequently getting DBCP error. We have seen this error in catalina.log &amp; apps log. This issue has started since last 2 -3 days. We have checked the application code when this error has occured and assure that there is no connection leakage in code. Mysql server is also running fine. We have tune memory parameters in mysql, however effectless. Still we are getting the same error. Any suggestion/solution would be appreciated. Mysql server version: 5.0.45 JDBC version: mysql-connector-java-5.1.5-bin.jar apache Tomcat version: 6.0.16 server.xml parameters are as follows:: url="jdbc:mysql://hostname:3306/dbname" username="user" password="pass" maxActive="40" maxIdle="20" maxWait="5000" ERROR: 2011-05-05 16:32:57,666 [ajp-8009-177] ERROR TrainSearchResultCache.java - Error retrieving Train Search from DB: s- org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object at org.apache.tomcat.dbcp.dbcp.PoolingDataSour</pre> Dhaval Jaiswal 2011-05-06T07:56:13 http://comments.gmane.org/gmane.comp.db.mysql.java/5499 <pre>hi all, iam developing mobile agent using aglet 2.0.2 and mysql-connector-java-5.1.14 to connect database mysql. i was create simple code to insert some data to database. then i compile it and its work, but when i running with tahiti server there is error and no data insert to my database. anyone know the problem?? regards, scifo *this is error message in console:* database failure: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driv er has not received any packets from the server. *this is source code :* public void run() { System.out.println("Tampil no pencarian"); String mysqldriver = "com.mysql.jdbc.Driver"; Connection conn = null; Statement st = null; ResultSet rset = null; String sqlQuery = "INSERT INTO `cobadb`.`customer` (`nama` ,`alamat` ,`umur` ,`email` ,`telepon`) VALUES ( 'dudul', 'tegal', '21', ' dudul&lt; at &gt;yahoo.com', '12234567')"; try { Class.forName(mysqldriver); // koneksi driver database </pre> scifo anggy yudianto 2011-04-28T10:01:07 http://comments.gmane.org/gmane.comp.db.mysql.java/5497 <pre>Hi, would it be possible to upload Connector/MXJ to the maven repository ? I'd be happy to help with this (via https://docs.sonatype.org/display/Repository/Uploading+3rd-party+Artifacts+to+Maven+Central) if you need a volunteer ? cheers, Thomas Dudziak </pre> Thomas Dudziak 2011-02-12T01:18:15 http://comments.gmane.org/gmane.comp.db.mysql.java/5496 <pre>Hi, MySQL Connector/J 5.1.15, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.15 is suitable for use with any MySQL version including MySQL-5.1 or MySQL-5.5. It is now available in source and binary form from the Connector/J download pages at http://dev.mysql.com/downloads/connector/j/5.1.html and mirror sites as well as Maven-2 repositories (note that not all mirror sites or repositories may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site.) As always, we recommend that you check the change log http://dev.mysql.com/doc/refman/5.1/en/cj-news.html and "Upgrading" sections http://dev.mysql.com/doc/refman/5.1/en/cj-upgrading.html in the manual before upgrading as well as the "CHANGES" file in the download archive to be aware of changes in behavior that might affect your application. We welcome and appreciate your feedb</pre> Mark Matthews 2011-02-10T14:55:14 http://comments.gmane.org/gmane.comp.db.mysql.java/5495 <pre> Hi, Production Database have been migrated from old to new one as per application requirement with additional columns and tables. And hence has to be validated that the migrated data is correct by creating a script to run written in java. how to compare 2 columns(different col_name) in 2 different databases placed at different server and display output( in excel format) using JAVA. If matched, return TRUE else display unmatched with column id,column_name, table name. Any help will be greatly appreciated. "Legal Disclaimer: This electronic message and all contents contain information from Cybage Software Private Limited which may be privileged, confidential, or otherwise protected from disclosure. The information is intended to be for the addressee(s) only. If you are not an addressee, any disclosure, copy, distribution, or use of the contents of this message is strictly prohibited. If you have received this electronic message in error please notify the sender by reply e-mail to and destroy the</pre> Reshma Parveen 2010-12-22T08:12:05 http://comments.gmane.org/gmane.comp.db.mysql.java/5494 <pre>Hi, Production Database have been migrated from old to new one as per application requirement with additional columns and tables. And hence has to be validated that the migrated data is correct by creating a script to run written in java. how to compare 2 columns(different col_name) in 2 different databases placed at different server and display output( in excel format) using JAVA. If matched, return TRUE else display unmatched with column id,column_name, table name. Any help will be greatly appreciated. "Legal Disclaimer: This electronic message and all contents contain information from Cybage Software Private Limited which may be privileged, confidential, or otherwise protected from disclosure. The information is intended to be for the addressee(s) only. If you are not an addressee, any disclosure, copy, distribution, or use of the contents of this message is strictly prohibited. If you have received this electronic message in error please notify the sender by reply e-mail to and destroy the or</pre> Reshma Parveen 2010-12-22T07:58:53 http://comments.gmane.org/gmane.comp.db.mysql.java/5493 <pre>Hi everybody, I'm developping a Java application which uses data stored in a MySQL Community Server running on my computer. Now I want to use the Connector/MXJ to have an embedded database in my application. To do this I follow this procedure http://dev.mysql.com/doc/refman/5.0/en/connector-mxj-usagenotes-customdb.html. The following Jar files are in the classpath - mysql-connector-java-5.1.13-bin.jar - mysql-connector-mxj-db-gpl-5.0.11.jar - mycustom-mysql-connector-mxj-db-gpl-5.0.11-files.jar - aspectjrt.jar The problem is when I when I run my Java application I'have got the following error messages : [C:\Users\sebastien\AppData\Local\Temp\mysql-c.mxj\bin\mysqld.exe][--no-defaults][--console][--port=3336][--socket=mysql.sock][--basedir=C:\Users\sebastien\AppData\Local\Temp\mysql-c.mxj][--datadir=C:\Users\sebastien\AppData\Local\Temp\mysql-c.mxj\data][--pid-file=C:\Users\sebastien\AppData\Local\Temp\mysql-c.mxj\data\MysqldResource.pid] [MysqldResource] launching mysqld (driver_launched_mysqld_1) [Mys</pre> Sébastien Grognuz 2010-12-13T09:31:56 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.db.mysql.java