You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/11/25 05:40:43 UTC
[GitHub] [shardingsphere] iamif3000 opened a new issue #8332: What is the compatible mysql jdbc version of 5.0.0 ?
iamif3000 opened a new issue #8332:
URL: https://github.com/apache/shardingsphere/issues/8332
Hi,
I made a performance test on sharding-proxy(4.1.1). And I found out that mysql-jdbc-5.1.48 is not compatible with sharding-proxy while 5.1.12 works OK.
So I'd like to know the compatible jdbc version of sharding-proxy 5.0.0.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #8332: What is the compatible mysql jdbc version of 5.0.0 ?
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #8332:
URL: https://github.com/apache/shardingsphere/issues/8332#issuecomment-733576351
I am not testing for all MySQL versions, but I think they are similar.
Could you provide the error message or use wireshark to catch the packet?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] iamif3000 edited a comment on issue #8332: What is the compatible mysql jdbc version of 5.0.0 ?
Posted by GitBox <gi...@apache.org>.
iamif3000 edited a comment on issue #8332:
URL: https://github.com/apache/shardingsphere/issues/8332#issuecomment-733621142
@terrymanu
With mysql-connector-java-5.1.48, jmeter reports
------------------------
java.sql.SQLException: Cannot create PoolableConnectionFactory (Unknown system variable 'transaction_isolation')
------------------------
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking commented on issue #8332: What is the compatible mysql jdbc version of 5.0.0 ?
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #8332:
URL: https://github.com/apache/shardingsphere/issues/8332#issuecomment-733725945
transaction_isolation means mysql server is 8.0.
You should ensure your jdbc version compatible with your mysql server version, not ShardingSphere-proxy.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] iamif3000 commented on issue #8332: What is the compatible mysql jdbc version of 5.0.0 ?
Posted by GitBox <gi...@apache.org>.
iamif3000 commented on issue #8332:
URL: https://github.com/apache/shardingsphere/issues/8332#issuecomment-733621142
@terrymanu
The error message
------------------------
java.sql.SQLException: Cannot create PoolableConnectionFactory (Unknown system variable 'transaction_isolation')
------------------------
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking closed issue #8332: What is the compatible mysql jdbc version of 5.0.0 ?
Posted by GitBox <gi...@apache.org>.
kimmking closed issue #8332:
URL: https://github.com/apache/shardingsphere/issues/8332
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] kimmking edited a comment on issue #8332: What is the compatible mysql jdbc version of 5.0.0 ?
Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #8332:
URL: https://github.com/apache/shardingsphere/issues/8332#issuecomment-733725945
transaction_isolation means mysql server is 8.0.
(mysql 5.x this parameter is tx_isolation)
You should ensure your jdbc version compatible with your mysql server version, not ShardingSphere-proxy.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org