Chat2DB icon indicating copy to clipboard operation
Chat2DB copied to clipboard

Bug: Error message when saving mysql&sqlserver under docker in web client

Open wuyaoqing opened this issue 1 year ago • 6 comments

Chat2DB Version

1.2.0

Describe the bug

Required request parameter 'id' for method parameter type Long is present but converted to null

wuyaoqing avatar May 30 '24 14:05 wuyaoqing

Hello, what is the error message when executing? Can you take a screenshot to show the specific operation?

tmlx1990 avatar May 30 '24 14:05 tmlx1990

Not only mysql8, but also connecting to SqlServer is the same. The test connection is successful, but an error is reported when saving image

wuyaoqing avatar May 30 '24 14:05 wuyaoqing

Hello, what is the error message when executing? Can you take a screenshot to show the specific operation?

I just replied with a screenshot. I am using the web version. When connecting to mysql8 and SqlServer, the same error message is reported.

wuyaoqing avatar May 30 '24 14:05 wuyaoqing

Hello, what is the error message when executing? Can you take a screenshot to show the specific operation?

I just replied with a screenshot. I am using the web version. When connecting to mysql8 and SqlServer, the same error message is reported.

I just tried it and it works fine. It can be saved normally. image image

tmlx1990 avatar May 30 '24 15:05 tmlx1990

That's a bit confusing. I used mysql8.0.35 and sqlserver2017 of docker and both reported an error when clicking save, but clicked test connection prompt success. Using other tools to connect such as dbeaver is normal.

wuyaoqing avatar May 31 '24 01:05 wuyaoqing

{ "getApplicationMessage": { "env": "prod", "versions": "1.2.0", "buildTime": 1717043800085, "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36" }, "errorCode": "common.paramError", "errorMessage": "Required request parameter 'id' for method parameter type Long is present but converted to null", "errorDetail": null, "solutionLink": "https://github.com/chat2db/Chat2DB/wiki/Chat2DB", "requestUrl": "/api/connection/datasource/create", "requestParams": "{"ssh":{"use":false,"hostName":"","port":"22","userName":"wyq","localPort":"","authenticationType":"password","password":"XXXXX"},"driverConfig":{"jdbcDriverClass":"com.mysql.cj.jdbc.Driver","jdbcDriver":"mysql-connector-java-8.0.30.jar"},"alias":"@XXXXX","environmentId":2,"storageType":"LOCAL","host":"XXXXX","port":"3308","authenticationType":"1","user":"root","password":"XXXXX","database":"mytest","url":"jdbc:mysql://XXXXX:3308/mytest","extendInfo":[{"key":"zeroDateTimeBehavior","value":"convertToNull"}],"connectionEnvType":"DAILY","type":"MYSQL"}" }

wuyaoqing avatar May 31 '24 01:05 wuyaoqing