> On July 6, 2020, 3:56 a.m., Pradeep Agrawal wrote:
> > I would like you to test this patch in all other db flavors ranger is supported.
They are Mysql, oracle, postgres, sqlanywhere, microsoft sqlserver
>
> Bill Ricky wrote:
> It took me some time to install all other kinds of databases. All tests are ok. HikariCP
and EclipseLink work fine with all the databases above.
With MS-SQL I am facing below issue
ERROR:
[EL Warning]: 2020-07-15 09:36:45.141--ClientSession(1017793925)--Exception [EclipseLink-4002]
(Eclipse Persistence Services - 2.7.7.v20200504-69f2c2b80d): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'x_service_config_def_SEQ'.
Error Code: 208
Call: SELECT NEXT VALUE FOR x_service_config_def_SEQ
Query: ValueReadQuery(sql="SELECT NEXT VALUE FOR x_service_config_def_SEQ")
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'X_USER_SEQ'.
Error Code: 208
Call: SELECT NEXT VALUE FOR X_USER_SEQ
Query: ValueReadQuery(sql="SELECT NEXT VALUE FOR X_USER_SEQ")
[EL Warning]: 2020-07-15 09:37:03.071--ClientSession(1469107147)--Exception [EclipseLink-4002]
(Eclipse Persistence Services - 2.7.7.v20200504-69f2c2b80d): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'X_TRX_LOG_SEQ'.
Error Code: 208
Call: SELECT NEXT VALUE FOR X_TRX_LOG_SEQ
Query: ValueReadQuery(sql="SELECT NEXT VALUE FOR X_TRX_LOG_SEQ")
Seems that its due to eclipselink-2.7.7.jar
Thanks
- Dhaval
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72645/#review221128
-----------------------------------------------------------
On July 5, 2020, 7:15 p.m., Bill Ricky wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/72645/
> -----------------------------------------------------------
>
> (Updated July 5, 2020, 7:15 p.m.)
>
>
> Review request for ranger.
>
>
> Bugs: RANGER-2895
> https://issues.apache.org/jira/browse/RANGER-2895
>
>
> Repository: ranger
>
>
> Description
> -------
>
> We should replace c3p0 with [HikariCP|https://github.com/brettwooldridge/HikariCP]. HikariCP
is much faster and less error prone. HikariCP is more popular with 13.2k+ stars on its github.
There were no more new commits since Nov 18, 2019 in [c3p0|https://github.com/swaldman/c3p0/commits/master].
>
> [MySQL connector|https://github.com/mysql/mysql-connector-j] and [Eclipselink|https://github.com/eclipse-ee4j/eclipselink]
should be upgraded to the latest stable versions as well to include many essential bugfixes.
>
>
> Diffs
> -----
>
> pom.xml 5bfd08df2
> security-admin/pom.xml 745dbfe8c
> security-admin/scripts/ranger-admin-site-template.xml 72ff66eaf
> security-admin/scripts/setup.sh 949c24244
> security-admin/scripts/upgrade_admin.py 10fa485bd
> security-admin/src/main/resources/conf.dist/ranger-admin-default-site.xml fcd4bd0ee
> security-admin/src/main/webapp/META-INF/applicationContext.xml b24f4d4ac
>
>
> Diff: https://reviews.apache.org/r/72645/diff/1/
>
>
> Testing
> -------
>
> 1.Compilation OK
> 2.Already used in production environment
>
>
> Thanks,
>
> Bill Ricky
>
>
|