mycat oracle java_mycat后端oracle的问题

mycat 后端使用 oracle数据库， 发现jdbc连接的sql没单独处理，直接丢给oracle，所以报错了。

具体配置及如下：

/* mysql-connector-java-8.0.21 (Revision: 33f65445a1bcc544eb0120491926484da168f199) */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

server.xml

0

0

1

1

0

0

300

1

(?:(\s*next\s+value\s+for\s*MYCATSEQ_(\w+))(,|\)|\s)*)+

false

io.mycat.route.sequence.handler.HttpIncrSequenceHandler

0

0

0

64k

1k

0

384m

false

false

0

123456

zeus2

zeus2

user

TESTDB

true

TESTDB

schema.xml

select 1 FROM dual

不知道哪里可以关闭