> 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 > >