[
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:15 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.
{code:java}
jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true&characterEncoding=UTF-8&scrollTolerantForwardOnly=true"
{code}
https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-connp-props-result-sets.html
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.
{code:java}
jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz?autoReconnect=true&characterEncoding=UTF-8&scrollTolerantForwardOnly=true"
{code}
> 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)
