Open G3NSVRV opened 4 years ago
What version of Oracle are you testing against?
@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.
According to @dlvcrk test, it works with org.rundeck.hibernate.RundeckOracleDialect
with com.rundeck.hibernate.RundeckOracleDialect
fails.
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
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
remove any extra space and restart rundeck
@fgutierrezz Using org.rundeck.hibernate works fine, is the com. that may not exist on the dialect as @sjrd218 mentioned.
service.log
config
fs