How can i connect radon with jdbc?

[duchaoqun]

As it said in title.

[BohuTANG]

Hi,

Using jdbc driver connect to Radon same as to MySQL.
If any problem, please let us know.

[duchaoqun]

Connect with jdbc , Why print the following log?

• MySQL version is 5.7
  @BohuTANG

MySQL
5.7-Radon-1.0
MySQL Connector Java
mysql-connector-java-5.1.42 ( Revision: 1f61b0b0270d9844b006572ba4e77f19c0f230d4 )

2018/05/18 13:47:01.955564 query.go:240: [WARNING] proxy.query.set.query:SET net_write_timeout=600
2018/05/18 13:47:01.982928 query.go:240: [WARNING] proxy.query.set.query:SET net_write_timeout=60
2018/05/18 13:47:01.984433 query.go:240: [WARNING] proxy.query.set.query:SET character_set_results = NULL
2018/05/18 13:47:01.985481 query.go:240: [WARNING] proxy.query.set.query:SET autocommit=1
2018/05/18 13:47:01.988369 query.go:240: [WARNING] proxy.query.set.query:SET autocommit=1
2018/05/18 13:47:02.133830 router.go:169: [ERROR] router.can.not.find.table[dual]
2018/05/18 13:47:02.133889 query.go:209: [ERROR] proxy.select[select database()].from.session[37].error:Table 'dual' doesn't exist (errno 1146) (sqlstate 42S02)
2018/05/18 13:47:02.133930 server.go:204: [ERROR] server.handle.query.from.session[37].error:Table 'dual' doesn't exist (errno 1146) (sqlstate 42S02).query[select database()]
2018/05/18 13:47:02.198666 query.go:149: [ERROR] proxy.show.unsupported[SHOW COLLATION].from.session[37]
2018/05/18 13:47:02.198734 server.go:204: [ERROR] server.handle.query.from.session[37].error:unsupported.query:SHOW COLLATION (errno 1105) (sqlstate HY000).query[SHOW COLLATION]

[BohuTANG]

Hello,

Please try the lastest version(Connector/J 8.0.11)(we will look up the issue on this version)

[hustjieke]

@duchaoqun
Hi~I had try to connect radon with JDBC, and didn't recurrent the problem you met, the connector I used is mysql-connector-java-8.0.11.tar, can you provide more details about the environment you tested?

[hustjieke]

@duchaoqun We confirmed this is a bug after debug, but it does not affect the use of radon connect with JDBC, we'll fix it as soon as possible.

[andyli029]

mysql> select @@version_comment limit 1;
ERROR 1046 (3D000): No database selected

log:
2018/05/30 17:52:57.504176 query.go:209: [ERROR] proxy.select[select @@version_comment limit 1].from.session[2].error:No database selected (errno 1046) (sqlstate 3D000)
2018/05/30 17:52:57.504238 server.go:204: [ERROR] server.handle.query.from.session[2].error:No database selected (errno 1046) (sqlstate 3D000).query[select @@version_comment limit 1]

is similar to cmd: select 1;

[hustjieke]

@duchaoqun
The error log has being fixed, thanks!