http://permalink.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://permalink.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://permalink.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://permalink.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://permalink.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://permalink.gmane.org/gmane.comp.db.mysql.java/5515 <pre>Mmmmmh. It looks like it works! Thanx! Pierre 2011/12/21 Celil Germeyan &lt;celilg&lt; at &gt;itg.com.tr&gt; </pre> Pierre Goupil 2011-12-29T16:05:48 http://permalink.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://permalink.gmane.org/gmane.comp.db.mysql.java/5513 <pre>Hey Ryan, On 12/12/2011 9:35 AM, Ryan Beckes wrote: You say that the same exact commands executed in the CLI work fine and produce different results than when executed from the JDBC client application. If that's the case, the most probably root cause is SQL Mode (for JDBC compliance, Connector/J sets SQL Mode to "strict_trans_tables"). The various SQL modes are described here: http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html The fastest way to see exactly what's happening is to turn on the MySQL Server general query log, and issue the same statements from both the CLI and the JDBC application. This will log the statements before they are executed - including statements to set the SQL Mode - and should help confirm exactly what the server is receiving from the JDBC application. Best regards, </pre> Todd Farmer 2011-12-12T19:05:24 http://permalink.gmane.org/gmane.comp.db.mysql.java/5512 <pre>Hello, I am trying to copy one table to another using jdbc (see code below). The table is copied fine, but the last column is NULL for all values. I am also having problems retrieving the value from that table (the value is always returned as null). If I run the same sql commands via the mysql client, the table is copied OK. Thanks, Ryan Connection conn = null; PreparedStatement ps1 = null; PreparedStatement ps2 = null; PreparedStatement ps3 = null; try { String userName = "user"; String password = "password"; String url = "jdbc:mysql://localhost:3306/plus"; Class.forName ("com.mysql.jdbc.Driver").newInstance (); conn = DriverManager.getConnection (url, userName, password); System.out.println ("Database connection established"); String dropQuery="DROP TABLE IF EXISTS CLASSMEMBERSHIPTMP"; ps1 = conn.prepareStatement(dropQuery); ps1.executeUpdate(); String createTmpQuery="CREATE TABLE IF NOT EXISTS CLASSMEMBERSHIPTMP (ID big</pre> Ryan Beckes 2011-12-12T17:35:10 http://permalink.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://permalink.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://permalink.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://permalink.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://permalink.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://permalink.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://permalink.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://permalink.gmane.org/gmane.comp.db.mysql.java/5504 <pre>...Friends always help you with your problems. Just rely on me. http://www.team-wdl.de/friends.page.php?ypupageid=98x6 </pre> Knaide 2011-06-12T00:09:09 http://permalink.gmane.org/gmane.comp.db.mysql.java/5503 <pre>Ok Todd, So I need to bind to the libraries of both v1.5 and v1.6. I now have the Ant build defined and getting the warning about the different compliers. I will play and sort this out. thanks for the assist. regards, Kevin -----Original Message----- From: Todd Farmer Sent: Tuesday, May 24, 2011 6:10 PM To: Kevin Hine Cc: java&lt; at &gt;lists.mysql.com Subject: Re: ConnectorJ 5.1.16 Source does not build on JDK 1.6.0_13 Hi Kevin, On 5/24/2011 2:47 AM, Kevin Hine wrote: ... Yes, unfortunately. You'll want to take a look at the ant build script - it has two different compile steps. The first handles the pre-JDBC4 code baseline (which, as noted by the error message above, does not implement the new-to-JDBC4 methods), and a second uses a Java 6.0+ compiler to handle the JDBC-specific classes. Within C/J itself, the driver does a check to see if we're running in a JDBC4-enabled JVM or not, and if so, uses the classes in the com.mysql.jdbc.JDBC4* classes. In short, use the ant build script to compile C/J (a</pre> Kevin Hine 2011-05-25T10:30:19 http://permalink.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://permalink.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://permalink.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://permalink.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 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.db.mysql.java