You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "Deepak Dixit (Jira)" <ji...@apache.org> on 2022/07/29 09:14:00 UTC
[jira] [Comment Edited] (OFBIZ-12675) jdbc-driver class com.mysql.jdbc.Driver is deprecated
[ https://issues.apache.org/jira/browse/OFBIZ-12675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17572874#comment-17572874 ]
Deepak Dixit edited comment on OFBIZ-12675 at 7/29/22 9:13 AM:
---------------------------------------------------------------
After upgrade mysql jdbc drive class to latest version, we may face issue `Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY` as default result size in TYPE_FORWARD_ONLY in EntityQuery class
Mysql updated scrollTolerantForwardOnly default value to false since 8.0.24 version. In this case need to set the scrollTolerantForwardOnly=true while making jdbc connection.
```
jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true&characterEncoding=UTF-8&scrollTolerantForwardOnly=true"
```
was (Author: deepak.dixit):
After upgrade mysql jdbc drive class to latest version, we may face issue `Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY` as default result size in TYPE_FORWARD_ONLY in EntityQuery class
Mysql updated scrollTolerantForwardOnly default value to false since 8.0.24 version. In this case need to set the scrollTolerantForwardOnly=true while making jdbc connection.
```
jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true&characterEncoding=UTF-8&scrollTolerantForwardOnly=true"``
> jdbc-driver class com.mysql.jdbc.Driver is deprecated
> -----------------------------------------------------
>
> Key: OFBIZ-12675
> URL: https://issues.apache.org/jira/browse/OFBIZ-12675
> Project: OFBiz
> Issue Type: Improvement
> Affects Versions: 18.12.06, 22.01.01
> Reporter: Deepak Dixit
> Assignee: Deepak Dixit
> Priority: Major
>
> MySQL Connector/J 8.0 is highly recommended for use with MySQL Server 8.0 and 5.7. Please upgrade to MySQL Connector/J 8.0 [1]
> Here are the guide to update connector j to 8.0
> [https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-upgrading-to-8.0.html]
>
> [1]https://dev.mysql.com/doc/connector-j/8.0/en/
--
This message was sent by Atlassian Jira
(v8.20.10#820010)