Compare DM problem

[Jonathan Fuerth]

Hi Thomas & Joey,

I just tried comparing one of my local PostgreSQL databases to an empty playpen (the "older" side was the empty playpen). I expect this is fallout from the recent changes to the diff routine.

java.lang.IllegalStateException: Don't know what type of output to make
    at ca.sqlpower.architect.swingui.CompareDMPanel$StartCompareAction$1.cleanup(CompareDMPanel.java:1314)
    at ca.sqlpower.swingui.SPSwingWorker$1.run(SPSwingWorker.java:114)
    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
    at java.awt.EventQueue.dispatchEvent(EventQueue.java:633)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)
    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188)
    at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

If you'd like a copy of my PostgreSQL schema so you can reproduce the issue, I can send one along.

-Jonathan

[Joey Silva]

Sorry about that. Fixed it, though.

> --
> You received this message because you are subscribed to the Google Groups "Architect Developers" group.
> To post to this group, send email to architect-...@googlegroups.com.
> To unsubscribe from this group, send email to architect-develo...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/architect-developers?hl=en.

[Thomas Kellerer]

After updating the sources I cannot load my project anymore:

ca.sqlpower.sqlobject.SQLObjectException: There is an XML parsing error in project file at Line:2074 Column:309
at ca.sqlpower.architect.ProjectLoader.load(ProjectLoader.java:210)
at ca.sqlpower.architect.swingui.SwingUIProjectLoader.load(SwingUIProjectLoader.java:195)
at ca.sqlpower.architect.swingui.action.OpenProjectAction$LoadFileWorker.doStuff(OpenProjectAction.java:169)
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:104)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.IllegalStateException: An end transaction for object FK_T026_T025_ORDERTIMEID of type class ca.sqlpower.sqlobject.SQLRelationship was called while it was not in a transaction.
at org.apache.commons.digester.Digester.createSAXException(Digester.java:2540)
at org.apache.commons.digester.Digester.createSAXException(Digester.java:2566)
at org.apache.commons.digester.Digester.startElement(Digester.java:1276)
at ca.sqlpower.xml.UnescapingDefaultHandler.startElement(UnescapingDefaultHandler.java:235)
at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at ca.sqlpower.xml.UnescapingXMLReader.parse(UnescapingXMLReader.java:99)
at org.apache.commons.digester.Digester.parse(Digester.java:1567)
at ca.sqlpower.architect.ProjectLoader.load(ProjectLoader.java:199)
... 4 more

Any ideas?

Regards
Thomas

Joey Silva, 23.02.2010 19:00:

> Sorry about that. Fixed it, though.
>
> On 2010-02-23, at 12:26 PM, Jonathan Fuerth wrote:
>

>> Hi Thomas& Joey,

[Jonathan Fuerth]

On Wed, Feb 24, 2010 at 2:42 AM, Thomas Kellerer <google...@sql-workbench.net> wrote:

After updating the sources I cannot load my project anymore:

This is a problem with the events being emitted by the SQLObjects. We're getting Compound Edit end events that had no preceding start event. Previously, this error was being logged as a warning. I requested that it be upgraded to an exception, because it's not the type of thing we ought to be sweeping under the rug.

There are currently 13 test failures in the library due to this change, and several more in the Architect (including all the ones that try to load project files). I trust someone on our side is working on this right now. We'll send an update when it's fixed.

In the mean time, if you want to keep working, you can comment out the line that throws the IllegalStateException in your working copy (it should be the root cause of the stack trace you posted). But don't commit that, of course. We'll have a real fix ready soon.

-Jonathan