Bug #2605 Error while connecting to 4.1.1a-alpha from JDBC
Submitted: 2 Feb 2004 3:28 Modified: 2 Feb 2004 6:48
Reporter: Jaroslaw Szczepankiewicz Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / J Severity:S1 (Critical)
Version:4.1.1a-alpha OS:Microsoft Windows (WinXP)
Assigned to: Mark Matthews CPU Architecture:Any

[2 Feb 2004 3:28] Jaroslaw Szczepankiewicz
Description:
error while connecting to mysqld-opt from JDBC (tested on 2.0.14 and 3.0.x)
in method com.mysql.jdbc.Connection.connectionInit()
while reading variables from server, sql_mode variable returned as "" or null, and converting to Integer throws Exception

How to repeat:
Connect from Java program using 2.0.14 or 3.0.x JDBC

Suggested fix:
not known, I Use bootstrap ignoring this parameter when connecting to 4.1.1
[2 Feb 2004 6:48] Mark Matthews
I'm not able to repeat this bug with the current version of Connector/J (3.0.10 or 3.1.1 nightly snapshot).

Do you have any more details surrounding the server variable 'sql_mode' being NULL? What does a 'show variables' from the MySQL client show for the value?
[3 Feb 2004 2:44] Jaroslaw Szczepankiewicz
I've downloaded version 3.1.0 JDBC alpha from your site and now have this error

java.sql.SQLException: Communication link failure: Bad handshake
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:815)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:1585)
	at com.mysql.jdbc.Connection.<init>(Connection.java:524)
	at com.mysql.jdbc.Driver.connect(Driver.java:359)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	

I started mysqld-opt with options --no-defaults --port=9903 --default-character-set=cp1250

show variables outputs from mysql.exe (take a look on sql_mode):
Variable_name        Value
back_log        50
basedir        c:\\setup_net\\Data\\mysql\\
binlog_cache_size        32768
bulk_insert_buffer_size        8388608
character_set_server        cp1250
character_set_system        utf8
character_set_database        cp1250
character_set_client        cp1250
character_set_connection        cp1250
character-sets-dir        c:\\setup_net\\Data\\mysql\\share\\charsets/
character_set_results        cp1250
collation_connection        cp1250_general_ci
collation_database        cp1250_general_ci
collation_server        cp1250_general_ci
concurrent_insert        ON
connect_timeout        5
datadir        c:\\setup_net\\Data\\mysql\\data\\
date_format        %Y-%m-%d
datetime_format        %Y-%m-%d %H:%i:%s
default_week_format        0
delay_key_write        ON
delayed_insert_limit        100
delayed_insert_timeout        300
delayed_queue_size        1000
expire_logs_days        0
flush        OFF
flush_time        1800
ft_boolean_syntax        + -><()~*:""&|
ft_min_word_len        4
ft_max_word_len        84
ft_query_expansion_limit        20
ft_stopword_file        (built-in)
have_bdb        NO
have_crypt        NO
have_compress        YES
have_innodb        YES
have_isam        NO
have_raid        NO
have_symlink        YES
have_openssl        NO
have_query_cache        YES
init_file        
init_connect        
init_slave        
innodb_additional_mem_pool_size        1048576
innodb_buffer_pool_size        8388608
innodb_buffer_pool_awe_mem_mb        0
innodb_data_file_path        ibdata1:10M:autoextend
innodb_data_home_dir        
innodb_file_io_threads        4
innodb_open_files        300
innodb_force_recovery        0
innodb_thread_concurrency        8
innodb_flush_log_at_trx_commit        1
innodb_fast_shutdown        ON
innodb_file_per_table        OFF
innodb_flush_method        
innodb_lock_wait_timeout        50
innodb_log_arch_dir        .\\
innodb_log_archive        OFF
innodb_log_buffer_size        1048576
innodb_log_file_size        5242880
innodb_log_files_in_group        2
innodb_log_group_home_dir        .\\
innodb_mirrored_log_groups        1
innodb_max_dirty_pages_pct        90
interactive_timeout        28800
join_buffer_size        131072
key_buffer_size        8388600
key_cache_block_size        1024
key_cache_division_limit        100
key_cache_age_threshold        300
language        c:\\setup_net\\Data\\mysql\\share\\english\\
large_files_support        ON
local_infile        ON
log        OFF
log_update        OFF
log_bin        OFF
log_slave_updates        OFF
log_slow_queries        OFF
log_warnings        OFF
long_query_time        10
low_priority_updates        OFF
lower_case_table_names        ON
max_allowed_packet        1048576
max_binlog_cache_size        4294967295
max_binlog_size        1073741824
max_connections        100
max_connect_errors        10
max_error_count        64
max_delayed_threads        20
max_heap_table_size        16777216
max_join_size        4294967295
max_relay_log_size        0
max_seeks_for_key        4294967295
max_length_for_sort_data        1024
max_sort_length        1024
max_user_connections        0
max_tmp_tables        32
max_write_lock_count        4294967295
myisam_max_extra_sort_file_size        268435456
myisam_max_sort_file_size        2147483647
myisam_repair_threads        1
myisam_recover_options        OFF
myisam_sort_buffer_size        8388608
net_buffer_length        16384
net_read_timeout        30
net_retry_count        10
net_write_timeout        60
new        OFF
old_passwords        OFF
open_files_limit        0
pid_file        c:\\setup_net\\Data\\mysql\\data\\hessus.pid
log_error        .\\hessus.err
port        9903
protocol_version        10
preload_buffer_size        32768
pseudo_thread_id        3
query_alloc_block_size        8192
query_cache_limit        1048576
query_cache_min_res_unit        4096
query_cache_size        0
query_cache_type        ON
secure_auth        OFF
query_prealloc_size        8192
range_alloc_block_size        2048
read_buffer_size        131072
read_only        OFF
read_rnd_buffer_size        262144
relay_log_purge        ON
rpl_recovery_rank        0
shared_memory        OFF
shared_memory_base_name        MYSQL
server_id        0
slave_net_timeout        3600
read_only        OFF
skip_external_locking        ON
skip_networking        OFF
skip_show_database        OFF
slow_launch_time        2
sort_buffer_size        2097144
sql_mode        
storage_engine        MyISAM
table_cache        64
table_type        MyISAM
thread_cache_size        0
thread_stack        196608
tx_isolation        REPEATABLE-READ
time_format        %H:%i:%s
timezone        ?rodkowoeuropejski czas stand.
tmp_table_size        33554432
tmpdir        
transaction_alloc_block_size        8192
transaction_prealloc_size        4096
version        4.1.1a-alpha
version_comment        Source distribution
version_compile_machine        i32
version_compile_os        Win95/Win98
wait_timeout        28800