Re: Connecting to a Windows database from Z/OS
Posted by:
D Hughes
Date: February 02, 2022 05:19PM
When connecting from a Windows system the line in question starts:
" /* mysql-conn" hex: "032f2a206d7973716c2d636f6e6e"
when connecting from z/os I get:
hex: "03615c4094a8a298936083969595" which is " /* mysql-conn" in EBCIDIC and which throws an error.
This is the full query from the Windows client:
/* mysql-connector-java-8.0.27 (Revision: e920b979015ae7117d60d72bcc8f077a839cd791) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@collation_connection AS collation_connection, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_write_timeout AS net_write_timeout, @@performance_schema AS performance_schema, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout