DevHeads.net

Java

Mysql: desc table -> JDBC rs.getString("COLUMN_SIZE")

Hello,
I have the following table in MySQL:

mysql> desc VEREIN;
+---------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+----------------+
| V_ID | int(11) | NO | PRI | NULL | auto_increment |
| Name | varchar(50) | NO | | NULL | |
| Strasse | varchar(50) | YES | | NULL | |
| O_ID | int(11) | YES | MUL | NULL | |
+---------+-------------+------+-----+---------+----------------+
4 rows

Storing default value for incorrect timestamps

Hi,

Below is my current mysql setup:
Version: 5.7
sql_mode=''
time_zone=SYSTEM
system_time_zone=PDT
Table 'test' with 2 columns:
+-------------+-----------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-----------+------+-----+---------------------+-------+
| Roles | int(11) | NO | PRI | NULL | |
| DateUpdated | timestamp | NO | | 0000-00-00 00:00:00 | |
+-------------+-----------+------+-----+---------------------+-------+

When I use mysql command line client to ins

Potential memory leak in java driver

Hi,

I was debugging a OOM isssue with our application server using MySQL
community driver version *5.1.41*, 1G heap which was running for approx 5
days. When heap dump was analyzed it was found that almost all the space
was consumed by mysql NonRegisteringDriver class and specifically a field
named connectionPhantomRefs.

We are using maxLifeTime of 7 Mins (Default is 30 mins), and min
connections at anypoint is 40 on single server instance. My guess is since
we are killing connection every 7 minutes so 24*60*60/7 = 12342 connections
per day.

MySQL Connector/J 5.1.41 has been released

Dear MySQL Users,

MySQL Connector/J 5.1.41, 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.41 is suitable for use with many MySQL server versions,
including 4.1, 5.0, 5.1, 5.4 and 5.5.

MySQL Connector Java is available in source and binary form from the
Connector/J download pages at
<a href="http://dev.mysql.com/downloads/connector/j/5.1.html" title="http://dev.mysql.com/downloads/connector/j/5.1.html">http://dev.mysql.com/downloads/connector/j/5.1.html</a>
and mirror sites as well as Maven-2 repositories.

MySQL Connector Java (Commercial) is already available for download on the
My Oracle Support (MOS) website.

Data type mapping in mysql

Hi,

I am new to Mysql datatype.I have created table with FLOAT data type.
I saw in MysqlDefs class that Float is map to FIELD_TYPE_FLOAT in " mysqlToJavaType(String mysqlType)" method and then again FIELD_TYPE_FLOAT is map to Types.REAL in "mysqlToJavaType(int mysqlType)" method

I have below question:
Why FIELD_TYPE_FLOAT is mapped to Types.REAL, can it be mapped to Types.FLOAT instead of Types.REAL?

I am using mysql-connector-java-5.1.34.jar to connect mysql to java.

Thanks
Santlal J.

Escaping Strings

Hello,

I'm trying to build a query builder, similar to the one implemented in
PHP in the Drupal project.

Inefficient use of Inflaters increases GC time when using mysql protocol compression

Inflaters are not used efficiently in the CompressedInputStreams class
and this leads to lots of finalize calls to Inflater objects which
drives up the garbage collection time for application using mysql
protocol compression feature.

Details:
The issue is that the MySQL driver seems to allocate a very high
number of Inflaters and Inflaters need to be finalized irrespective of
whether they have been shut down properly or not.

connector/j client certificate

I am trying to use SSL in my application.

Connector/j and Android

Since Android uses an stripped down version of java with fewer
stuff... and pretty much everyone seems to be using JSON.

Is the connector/j supposed to work in Android?

Regards

Business Intelligence Software User - Cognos,tibco,Qliktech,Telerik

Hi,

Would you be interested in acquiring the list of "Business Intelligence
Software Users" which includes VAR's, Partners, and Vendors etc.?

Some of the software user list available: IBM Cognos, Microsoft BI,
MicroStrategy BI, Oracle BI, QlikTech, SAP, SAS, Sybase, Telerik, Tibco
spotfire and many more,

Let me know your interest and I can send you count & sample to review.

Await your response.

Thanks,

Mark FreeMan

Mark Freeman| Leadgen

M-World Data

If you do not wish to receive, any more email please reply to this email
with "Unsubscribe" in subject line

Oracle Users 2015

Hi,

Would you like to procure the contact list of Oracle Users to accelerate
sales/marketing activities at your firm?

ü JD Edwards Enterprise One users

ü Oracle Human Resource Management Systems users

ü PeopleSoft users etc..

Reach: C level, Directors, President and VP, IT decision makers, Analysts,
Marketing Managers and many more. Samples can be provided based on request.

List can be modified as per your requirement.

Is there Mysql cluster MGM API for Java?

Hi,
I know there is a Mysql cluster MGM API for C, so I want to know if there is Mysql cluster MGM API for Java?
The MGM api exampls are:
ndb_init / ndb_mgm_set_connectstring / ndb_mgm_connect / ndb_mgm_get_status /ndb_mgm_get_status2

Thanks,

Hobby

How to improve JDBC performance

hi all

My program insert some data to MySQL Server,becasue some reason ,can't
batch insert.
In my benchmarks,the bottleneck is jdbc,how to improve performance?
see the jstack

"recvMsgWorkTPConfig-11-thread-20" prio=10 tid=0x00002aaac0445000
nid=0x399b runnable [0x000000004af94000]
java.lang.Thread.State: RUNNABLE
at java.util.zip.CRC32.updateBytes(Native Method)
at java.util.zip.CRC32.update(CRC32.java:74)
//omission ...
"recvMsgWorkTPConfig-11-thread-6" prio=10 tid=0x000000000bcc4000 nid=0x3987
runnable [0x0000000049b7f000]
java.lang.Thread.State: RUNNABLE
at java.net.S

JDBC lint

JDBC lint helps Java programmers write correct and efficient code when
using the JDBC API. This includes resource management, e.g., missing
Connection.close, incorrect use of JDBC, e.g., Statement.addBatch
without Statement.executeBatch, and potential optimizations, e.g.,
unread ResultSet columns. JDBC lint wraps DataSource and Connection and
via dynamic proxy classes and thus has compatibility with all
applications using JDBC. I tested against H2 and MySQL and hope users
find this helpful:

<a href="https://github.com/maginatics/jdbclint" title="https://github.com/maginatics/jdbclint">https://github.com/maginatics/jdbclint</a>

I appreciate any feedback!

<PROMOTION> Spending A Lot For Your Business Software? We Are Giving You a Full Version With No Cost At All.

Your email client cannot read this email.
To view it online, please go here:
<a href="http://emailmarketing.netiquette.asia/display.php?M=1070518&amp;C=5cfdb1799b5fb752257298f50fcf8c6b&amp;S=167&amp;L=6&amp;N=78" title="http://emailmarketing.netiquette.asia/display.php?M=1070518&amp;C=5cfdb1799b5fb752257298f50fcf8c6b&amp;S=167&amp;L=6&amp;N=78">http://emailmarketing.netiquette.asia/display.php?M=1070518&amp;C=5cfdb1799b...</a>

To stop receiving these
emails:http://emailmarketing.netiquette.asia/unsubscribe.php?M=1070518&C=5cfdb1799b5fb752257298f50fcf8c6b&L=6&N=167

MySQL Connector/J 5.1.26 has been released

Hello all,

MySQL Connector/J 5.1.26, a maintenance release of the production
5.1 branch has been released.

MySQL Connector/J 5.1.25 has been released

Hello all,

MySQL Connector/J 5.1.25, a maintenance release of the production
5.1 branch has been released.

Hi!!! ...

Single Mom Makes $89,844/Yr in Her Spare Time on The Computer Without Selling Anything

<a href="http://howtozeek.com/hwork55.html" title="http://howtozeek.com/hwork55.html">http://howtozeek.com/hwork55.html</a>

MySQL Connector/J 5.1.23 has been released

Hello all,

MySQL Connector/J 5.1.23, a maintenance release of the production 5.1
branch has been released.

DrizzleJDBC 1,2

Hi

I just released DrizzleJDBC 1.2

DrizzleJDBC is a BSD licensed JDBC driver for MySQL/MariaDB/Drizzle

It is in maven central:
<dependency>
<groupId>org.drizzle.jdbc</groupId>
<artifactId>drizzle-jdbc</artifactId>
<version>1.2</version>
</dependency>

Changelog;
- IPv6 support, enclose the IP in brackets, [::1] (
<a href="https://github.com/krummas/DrizzleJDBC/issues/10" title="https://github.com/krummas/DrizzleJDBC/issues/10">https://github.com/krummas/DrizzleJDBC/issues/10</a>)
- Correct behavior if getInt on larger than MAXINT values (
<a href="https://github.com/krummas/DrizzleJDBC/issues/9" title="https://github.com/krummas/DrizzleJDBC/issues/9">https://github.com/krummas/DrizzleJDBC/issues/9</a>)
- Fix ssl support, was not possible to close connection (
<a href="https://github.com/krummas/DrizzleJDBC/issues/8" title="https://github.com/krummas/DrizzleJDBC/issues/8">https://github.com/krummas/DrizzleJDBC/issues/8</a>)
- Su

MySQL Connector/J 5.1.22 has been released

Hello all,

MySQL Connector/J 5.1.22, a maintenance release of the production 5.1
branch has been released.

Access denied for user 'sa'@'localhost'

Good evening

I'm trying to install a webapp: sakai, on a remote server; but I'm getting
that error:

Caused by: java.sql.SQLException: Access denied for user 'sa'@'localhost'
(using password: NO)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4578)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296)
at com.m

Re: MySQL Connector/MXJ 5.0.12 has been released

I am in need of a 5.5.x embedded MySQL instance.

In your release notes you mentioned that the binaries can be found here:
<a href="http://dev.mysql.com/downloads/connector/mxj/5.0.html" title="http://dev.mysql.com/downloads/connector/mxj/5.0.html">http://dev.mysql.com/downloads/connector/mxj/5.0.html</a>

Unfortunately I am seeing an empty page there. Has this artifact ever
been uploaded somewhere?

BTW: I am able to download version 5.0.11 from a couple of mirrors,
but that version and others don't even show up on the main site.

Thanks,
Sebastian

MySQL Connector/J 5.1.21 has been released

Hello all,

MySQL Connector/J 5.1.21, a maintenance release of the production 5.1
branch has been released.

jdbc connection failing on password

Hi,

I have a linux client able to connect successfully to a remote mysql
database running on a Windows server, via the standard mysql prompt CLI.
However I also have a program using the jdbc drivers on the same client that
keeps getting 'Access Denied.' errors and I don't understand why. This same
program works fine on other clients and to other mysql servers.

Any ideas anyone?

Cheers

Colin

Timeout

Hi,

In my application, i have a timeout by mysql server after few days.

I would like that application is always connected to the server.

I try the option autoreconnect in java, but it didn't match.

How-to make this ?

MySQL Connector/J 5.1.20 has been released

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
<a href="http://dev.mysql.com/downloads/connector/j/5.1.html" title="http://dev.mysql.com/downloads/connector/j/5.1.html">http://dev.mysql.com/downloads/connector/j/5.1.html</a>
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 affe

MySQL Connector/J 5.1.19 has been released

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
<a href="http://dev.mysql.com/downloads/connector/j/5.1.html" title="http://dev.mysql.com/downloads/connector/j/5.1.html">http://dev.mysql.com/downloads/connector/j/5.1.html</a>
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 affe

NullPointerException in GregorianCalendar.java:2026 when upgrading to debian squeeze

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.s

How disable innodb support.

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.

Problem with in-memory connector MXJ

Good afternoon,

I'm currently trying and configure MySQL in order to have an in-memory
database in my unit tests.

escaping in a non-prepared query

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.

MySQL Connector/J 5.1.18 has been released

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

<a href="http://dev.mysql.com/downloads/connector/j/5.1.html" title="http://dev.mysql.com/downloads/connector/j/5.1.html">http://dev.mysql.com/downloads/connector/j/5.1.html</a>

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 applica

executing Java code from database trigger.

Hi,

I wanted to run java method from trigger. for that i need to write java db
procedure..

MySQL Connector/MXJ 5.0.12 has been released

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 exi

MySQL Connector/J 5.1.17 Has Been Released

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

<a href="http://dev.mysql.com/downloads/connector/j/5.1.html" title="http://dev.mysql.com/downloads/connector/j/5.1.html">http://dev.mysql.com/downloads/connector/j/5.1.html</a>

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

Re:5

...Friends always help you with your problems. Just rely on me. <a href="http://www.team-wdl.de/friends.page.php?ypupageid=98x6" title="http://www.team-wdl.de/friends.page.php?ypupageid=98x6">http://www.team-wdl.de/friends.page.php?ypupageid=98x6</a>

ConnectorJ 5.1.16 Source does not build on JDK 1.6.0_13

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

Calling resultSet.getString after resultSet.updateString

Hello,

While testing my application with MySQL I noticed a difference with
Oracle's JDBC implementation.

DBCP error

Hi All,

We are frequently getting DBCP error. We have seen this error in
catalina.log & 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.

aglet using mysql-connector-java-5.1.14

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.

Connector/MXJ in Maven repository

Hi,

would it be possible to upload Connector/MXJ to the maven repository ?
I'd be happy to help with this (via
<a href="https://docs.sonatype.org/display/Repository/Uploading+3rd-party+Artifacts+to+Maven+Central" title="https://docs.sonatype.org/display/Repository/Uploading+3rd-party+Artifacts+to+Maven+Central">https://docs.sonatype.org/display/Repository/Uploading+3rd-party+Artifac...</a>)
if you need a volunteer ?

cheers,
Thomas Dudziak

MySQL Connector/J 5.1.15 Has Been Released

Hi,

MySQL Connector/J 5.1.15, a maintenance release of the production 5.1 branch has been released.

FW: java code to validate column content of 2 different tables in 2 different databases(both mysql).

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.

java code to validate column content of 2 different tables in 2 different databases(both mysql).

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.

Connector/MXJ

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.

Connecting to mysql 4.0.x using mysql-j-connector 5.1.14

Hello MySQL Java Connector users and developers,

I know that mysql-j-connector doesn't list mysql 4.0.x as supported, anyway
I was able to connect to mysql 4.0.x with previous versions of
mysql-j-connector (<=5.1.13) but not with latest one, 5.1.14. Here is the
relevant exception stack trace:

WARN org.hibernate.cfg.SettingsFactory - Could not obtain connection to
query metadata
java.sql.SQLException: ResultSet is from UPDATE.

MySQL Connector/J 5.1.14 Has Been Released!

Hi,

MySQL Connector/J 5.1.14, a maintenance release of the production 5.1 branch has been released.

Hej dude

Hi key!

Bella, intelligente, socievole donna per l'uomo in cerca di un incontro in Italia
ad avviare una relazione seria.
Il mio indirizzo e-mail: <a href="mailto: ... at yahoo dot com"> ... at yahoo dot com</a>
Scrivi a me e io ti invier

Retrieving of large ResultSets

Hi,

I need to retrieve several large (>300 k rows) results from 100 tables.
Each of these tables has 101 columns.

Does any of you have an idea about the best strategy ?

I am currently planning to test the two following ones.

1) Retrieving by block (500 rows at a time for instance)
2) Line by line with
stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
java.sql.ResultSet.CONCUR_READ_ONLY);
stmt.setFetchSize(Integer.MIN_VALUE);

As indicated in the documentation.

Any thought ?

Regards

Syndicate content