Not working properly using Rundeck 3.3.1

[G3NSVRV]

service.log

config

dataSource.dbCreate = update
dataSource.url = jdbc:oracle:thin:@oracle.rundeck.local/XE
dataSource.driverClassName = oracle.jdbc.driver.OracleDriver
dataSource.username = rundeckuser
dataSource.password = rundeckpassword
dataSource.dialect = com.rundeck.hibernate.RundeckOracleDialect
dataSource.properties.validationQuery = SELECT 1 FROM DUAL

fs

[root@node01 rundeck-3.3.1-SNAPSHOT]# md5sum server/lib/*
319c8013976ca6744f128d6eb78942c0  server/lib/ojdbc8.jar
67071c3123a0def25502bc51f8897692  server/lib/rundeck-oracle-dialect-1.0.0.jar

[sjrd218]

What version of Oracle are you testing against?

[sjrd218]

@G3NSVRV can you try dataSource.dialect = org.rundeck.hibernate.RundeckOracleDialect instead of what you used. I think the documentation may be using the wrong class name.

[jtobard]

According to @dlvcrk test, it works with org.rundeck.hibernate.RundeckOracleDialect with com.rundeck.hibernate.RundeckOracleDialect fails.

[dldrk]

Yes, using Oracle-XE-11G, ojdbc7.jar and this config:

dataSource.dbCreate = update
dataSource.username=rundeck
dataSource.password=rundeck
dataSource.url = jdbc:oracle:thin:@localhost:1521:xe
dataSource.driverClassName = oracle.jdbc.driver.OracleDriver
dataSource.dialect = org.rundeck.hibernate.RundeckOracleDialect
dataSource.properties.validationQuery = SELECT 1 FROM DUAL

[fgutierrezz]

Could you double check for any "extra space character" at the end of every line in rundeck-config file, this sometimes cause issues.

Example
...
dataSource.url = jdbc:oracle:thin:@localhost:1521:xe
dataSource.dialect = org.rundeck.hibernate.RundeckOracleDialect
....

remove any extra space and restart rundeck

[G3NSVRV]

@fgutierrezz Using org.rundeck.hibernate works fine, is the com. that may not exist on the dialect as @sjrd218 mentioned.