Your message dated Wed, 27 Dec 2006 20:32:03 +0000
with message-id <[EMAIL PROTECTED]>
and subject line Bug#369379: fixed in mysql-connector-java 5.0.4+dfsg-1
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
Package: libmysql-java
Version: 3.1.11-1
Severity: important
I have succesfully been using mysql 4.1 with libmysql-java with
jdk 1.4 downloaded from sun site.
Last week I tried to migrate to mysql 5, in fact I do not know if the
bug is mysl 5 or in libmysl-java. The problem is the following, if I make
a query as follows
sql="select vales.fecha,obras.nombre from vales left join obras on
vales.obra=obras.id ";
pstmt = con.prepareStatement(sql);
rs=pstmt.executeQuery();
rsmd = rs.getMetaData();
System.out.println(rsmd.getColumnName(2)+":"+rsmd.getTableName(2)+":");
rs.next();
System.out.println(rs.getString("obras.nombre"));
every thing is perfect, but if I try order the query by obras.nombre
sql="select vales.fecha,obras.nombre from vales left join obras on
vales.obra=obras.id order by obras.nombre";
pstmt = con.prepareStatement(sql);
rs=pstmt.executeQuery();
rsmd = rs.getMetaData();
System.out.println(rsmd.getColumnName(2)+":"+rsmd.getTableName(2)+":");
rs.next();
System.out.println(rs.getString("obras.nombre")); <--- line 961
I get an exception at the last line:
Exception in thread "main" java.sql.SQLException: Column 'obras.nombre' not
found.
at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:929)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:4977)
at valesRV.Vales.main(Vales.java:961)
in fact, if I print 'rsmd.getTableName(2)', that should be 'obras', it is the
empty string.
As I said previously, I don't if the error is in libmysql-java
or in mysql server since that query in the mysql console works perfectly
and with mysql-server-4.1 I do not have any problems.
The version if mysql I have is:
ii mysql-server-5.0 5.0.21-3 mysql database server
binaries
l
-- System Information:
Debian Release: 3.1
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.15-1-686-smp
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15)
Versions of packages libmysql-java depends on:
ii java1-runtime-dummy [java1-ru 1.0 Dummy package providing java1-runt
ii java2-runtime-dummy [java2-ru 1.0 Dummy package providing java2-runt
-- no debconf information
--- End Message ---
--- Begin Message ---
Source: mysql-connector-java
Source-Version: 5.0.4+dfsg-1
We believe that the bug you reported is fixed in the latest version of
mysql-connector-java, which is due to be installed in the Debian FTP archive:
libmysql-java_5.0.4+dfsg-1_all.deb
to pool/main/m/mysql-connector-java/libmysql-java_5.0.4+dfsg-1_all.deb
mysql-connector-java_5.0.4+dfsg-1.diff.gz
to pool/main/m/mysql-connector-java/mysql-connector-java_5.0.4+dfsg-1.diff.gz
mysql-connector-java_5.0.4+dfsg-1.dsc
to pool/main/m/mysql-connector-java/mysql-connector-java_5.0.4+dfsg-1.dsc
mysql-connector-java_5.0.4+dfsg.orig.tar.gz
to
pool/main/m/mysql-connector-java/mysql-connector-java_5.0.4+dfsg.orig.tar.gz
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [EMAIL PROTECTED],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Marcus Better <[EMAIL PROTECTED]> (supplier of updated mysql-connector-java
package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [EMAIL PROTECTED])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.7
Date: Fri, 22 Dec 2006 10:45:42 +0100
Source: mysql-connector-java
Binary: libmysql-java
Architecture: source all
Version: 5.0.4+dfsg-1
Distribution: unstable
Urgency: low
Maintainer: Debian Java Maintainers
<[email protected]>
Changed-By: Marcus Better <[EMAIL PROTECTED]>
Description:
libmysql-java - Java database (JDBC) driver for MySQL
Closes: 366808 369379 387382 394878 404153
Changes:
mysql-connector-java (5.0.4+dfsg-1) unstable; urgency=low
.
* New upstream release. (Closes: #404153, #366808, #394878)
- Supports MySQL 5. (Closes: #369379)
- Fixes a character set mapping problem. (Closes: #387382)
* debian/rules: Get rid of cdbs. Install `CHANGES' file in proper place.
* The jar file is now named `mysql-connector-java.jar' instead of
`mysql.jar'. Symlinks are provided for the old names for the time
being.
* debian/control:
- Replace Build-Depends-Indep by Build-Depends.
- Add missing dependency on ant-optional.
- Add XS-Vcs-* fields.
* debian/rules: Build with java-gcj-compat-dev instead of Kaffe.
* Removed README.Debian since the information on supported JDK versions
may be outdated.
Files:
752373ee094deb179914a9c2f2a2d13e 1016 libs optional
mysql-connector-java_5.0.4+dfsg-1.dsc
95c3173a47cc043dae24cb382ee2086f 1013067 libs optional
mysql-connector-java_5.0.4+dfsg.orig.tar.gz
cb5b426938747fef58acfddf22c65ccc 3724 libs optional
mysql-connector-java_5.0.4+dfsg-1.diff.gz
2dcc37d5b1d973f74ec18010d2fd176d 546738 libs optional
libmysql-java_5.0.4+dfsg-1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFFktAe+C5cwEsrK54RAtNVAKCaY0neFp8YIV75w8NtiEVMrSeOpgCfW+oD
5Ogka57rIXKVFENMujUILRo=
=bNsb
-----END PGP SIGNATURE-----
--- End Message ---
_______________________________________________
pkg-java-maintainers mailing list
[email protected]
http://lists.alioth.debian.org/mailman/listinfo/pkg-java-maintainers
