| 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: | |
| Category: | Connector / J | Severity: | S1 (Critical) |
| Version: | 4.1.1a-alpha | OS: | Windows (WinXP) |
| Assigned to: | Mark Matthews | CPU Architecture: | Any |
[2 Feb 2004 3:28]
Jaroslaw Szczepankiewicz
[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
