SQL Power Software Forum

When initially installing the DQ repository on a MS SQL Server 2008 database, the install fails with a foreign key error:

ca.sqlpower.matchmaker.dao.hibernate.RepositoryException: Failed to create repository. See nested cause for more details.
at ca.sqlpower.matchmaker.dao.hibernate.RepositoryUtil.createRepositorySchema(RepositoryUtil.java:307)
at ca.sqlpower.matchmaker.dao.hibernate.RepositoryUtil.createOrUpdateRepositorySchema(RepositoryUtil.java:226)
at ca.sqlpower.matchmaker.dao.hibernate.MatchMakerHibernateSessionImpl.<init>(MatchMakerHibernateSessionImpl.java:194)
at ca.sqlpower.matchmaker.dao.hibernate.MatchMakerHibernateSessionContext.createSession(MatchMakerHibernateSessionContext.java:147)
at ca.sqlpower.matchmaker.swingui.SwingSessionContextImpl.createSession(SwingSessionContextImpl.java:227)
at ca.sqlpower.matchmaker.swingui.LoginDialog$LoginAction.doStuff(LoginDialog.java:147)
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:104)
at java.lang.Thread.run(Unknown Source)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Introducing FOREIGN KEY constraint 'step_output_input_fk' on table 'MM_MUNGE_STEP_INPUT' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4874)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:649)
at ca.sqlpower.sql.jdbcwrapper.StatementDecorator.execute(StatementDecorator.java:89)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
at ca.sqlpower.matchmaker.dao.hibernate.RepositoryUtil.createRepositorySchema(RepositoryUtil.java:302)
... 7 more

Hi, any schedule on support for the new SQL Server 2008 datatypes: e.g., DATE, TIME, hierarchyid, etc? These aren't available in 2005 using the 2005 or 2008 JDBC drivers.