SQL Power Software Forum

os: vista
version: 0.9.6-alpha
db: oracle

In the merge rules section, clicking on the Derive Related Rules, it seems like some if not all of the rules are generated. Then an error window appears.
FAILED TO DERIVE RELATED TABLE INFORMATION
java.sql.SQLException: ORA-00936: missing expression

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:28

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)
at ca.sqlpower.sql.jdbcwrapper.OracleDatabaseMetaDataDecorator.getColumns(OracleDatabaseMetaDataDecorator.java:582)
at ca.sqlpower.matchmaker.swingui.DeriveRelatedRulesPanel$DeriveAction.deriveMergeRulesByColumnNames(DeriveRelatedRulesPanel.java:32

at ca.sqlpower.matchmaker.swingui.DeriveRelatedRulesPanel$DeriveAction.doStuff(DeriveRelatedRulesPanel.java:182)
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:99)
at java.lang.Thread.run(Unknown Source)

As a user I'm unsure what this error message is saying, I'm not sure if all of the related rules were generated. It seems like the merge rules were generated and I can be saved.

The Oracle error message (java.sql.SQLException: ORA-00936: missing expression) would suggest the our driver wrapper executed an incomplete SQL statement.

Unfortunately, the error log doesn't indicate what exactly was wrong with the statement, so we will have to do some digging around.