Bug #26064 Connections fail when using the 5.0 JDBC driver
Submitted: 4 Feb 2007 16:09
Reporter: Mark Leith Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Workbench Preview Severity:S2 (Serious)
Version:1.2.9alpha OS:MacOS (OSX, Linux)
Assigned to: CPU Architecture:Any
Tags: Connections, reverse engineer, workbench

[4 Feb 2007 16:09] Mark Leith
Description:
When trying to use the "MySQL 5.0 JDBC Driver" connection for reverse engineering a MySQL schema, all connections "fail", leading to an error such as:

Fetching schemata...
Invalid function calling ReverseEngineeringMysqlJdbc.getSchemataThe list of schema names could not be retrieved (error: 10003)
(null)

In fact, it seems as if connections are not even attempted, nothing is logged in to the general query log:

[markleith@medusa:/usr/local/mysql-csc6439/var] $ more medusa.log 
/usr/local/mysql-csc6439/libexec/mysqld, Version: 5.1.15-beta-debug-log (Source distribution). started with:
Tcp port: 6439  Unix socket: /Users/markleith/mysql/mysql-csc6439.sock
Time                 Id Command    Argument
[markleith@medusa:/usr/local/mysql-csc6439/var] $ 

And using a modified binary that also dumps "access denied" errors, just in case, there are no failed connections:

[markleith@medusa:/usr/local/mysql-csc6439/var] $ tail -n 5 error.log 
070204 16:00:37  InnoDB: Started; log sequence number 0 105985795
070204 16:00:37 [Note] /usr/local/mysql-csc6439/libexec/mysqld: ready for connections.
Version: '5.1.15-beta-debug-log'  socket: '/Users/markleith/mysql/mysql-csc6439.sock'  port: 6439  Source distribution
070204 16:00:37 [Note] SCHEDULER: Loaded 0 events
070204 16:06:46 [Warning] Got signal 1 from thread 1
[markleith@medusa:/usr/local/mysql-csc6439/var] $ 

How to repeat:
Try to reverse engineer a schema using the 5.0 JDBC Driver connection
[4 Feb 2007 16:15] David Shrewsbury
Same error occurs for version 1.1.9alpha on Ubuntu Linux against MySQL 5.1.14-beta. Native driver works fine.

> uname -a
Linux kodiak 2.6.17-10-generic #2 SMP Tue Dec 5 21:16:35 UTC 2006 x86_64 GNU/Linux