Skip to content

Instantly share code, notes, and snippets.

@schani
Last active August 14, 2023 12:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save schani/4bd6e7dc4858592c72a3e85df83ce2e6 to your computer and use it in GitHub Desktop.
Save schani/4bd6e7dc4858592c72a3e85df83ce2e6 to your computer and use it in GitHub Desktop.
06:26:12.553 [JettyServerThreadPool-128] ERROR com.glideapps.jdbcgateway.Server - Uncaught exception when handling /query
org.jooq.exception.SQLDialectNotSupportedException: Type signed is not supported in dialect MYSQL
curl --location --request POST 'http://jdbc-gateway.staging.internal.glideapps.com/query' \
--header 'Content-Type: application/json' \
--data-raw '{
"connectionInfo": {
"uri": "jdbc:mysql://mysql-test-1.mysql.database.azure.com/test?sslMode=REQUIRED",
"props": {
"user": "adminuser",
"password": "nom1n-br0"
},
"dialect": "mysql"
},
"base": {
"kind": "query",
"query": "select * from test.numberid"
},
"query": {
"conditions": [],
"sort": [],
"limit": 1000
},
"defaultSortColumn": "id",
"schema": {
"id": {
"sqlDataType": "signed",
"glideDataType": "number",
"primaryKey": false,
"nullable": false,
"readOnly": true,
"hasDefaultValue": false
},
"name": {
"sqlDataType": "char",
"glideDataType": "string",
"primaryKey": false,
"nullable": false,
"readOnly": true,
"hasDefaultValue": false
},
"int": {
"sqlDataType": "signed",
"glideDataType": "number",
"primaryKey": false,
"nullable": false,
"readOnly": true,
"hasDefaultValue": false
}
}
}'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment