Latest topics for the forum "SQL Power Architect Bugs"

Wrong interpretation of PK in H2-table

forumsareforsissyboysandgirliemen — GMT

I have a hibernate generated H2 database. Two tables are connected via a third in a many-to-many relationship. The connection table has it's own primary key, which is not including any of the FK fields in the connection table. This is verified in the DDL generated by hibernate and by inspecting the connection table in a different database tool.

The connection table also has a value field called ROLE.

When the three tables are opened in Power Architect, ROLE and one of the FK fields are included in the PK.

Hibernate 3.6.1, Power Architect 1.0.6, java 1.6.0_26, Linux 2.6.38-12-generic (amd64) (Ubuntu 11.04), H2 database 1.3.153 (2011-03-14).

*Hibernate DDL:

create table T03INVESTMENT_ACCOUNT_ADDITIONAL_PARTY_ASSOCIATION (
ADDITIONAL_PARTY_ID bigint generated by default as identity,
ROLE varchar(25) not null,
INV_ACCOUNT_ID bigint not null,
INV_ACCOUNT_PARTY_ID bigint not null,
primary key (ADDITIONAL_PARTY_ID)
)

alter table T03INVESTMENT_ACCOUNT_ADDITIONAL_PARTY_ASSOCIATION
add constraint FKD34AAEF7B6A3C6C6
foreign key (INV_ACCOUNT_PARTY_ID)
references T03InvestmentAccountParty

alter table T03INVESTMENT_ACCOUNT_ADDITIONAL_PARTY_ASSOCIATION
add constraint FKD34AAEF7E45C1F6F
foreign key (INV_ACCOUNT_ID)
references T03InvestmentAccount

*SQL Power Architect DDL (for DB2) generated after reverse engineering the H2 database (And this is also what is shown in ER diagram and in the database explorer). Note definition of PK.

CREATE TABLE T03INVESTMENT_ACCOUNT_ADDITIONAL_PARTY_ASSOCIATION (
ADDITIONAL_PARTY_ID BIGINT DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_80D5D060_7F1A_44C1_82C0_CEFE74EE462E) NOT NULL,
INV_ACCOUNT_PARTY_ID BIGINT NOT NULL,
ROLE VARCHAR(25) NOT NULL,
INV_ACCOUNT_ID BIGINT NOT NULL,
CONSTRAINT T03INVESTMENT_ACCOUNT_ADDITIONAL_PARTY_ASSOCIATION_pk PRIMARY KEY (ADDITIONAL_PARTY_ID, INV_ACCOUNT_PARTY_ID, ROLE)
);

....

Power Architect hungs with Java 6-29

Lourence108 — GMT

I've just download the latest version of Java (6-29) on my machine.

PA now hungs when I connect to the DB. I cannot connect (or test the connection) as it hungs with no error codes: the application is completely hung.

I've tried to re-install PA and re-install Java to no avail.

++++UPDATE++++
I found JRE 6-27 in one of my systems. I've disinstalled 6-29 and installed 6-27 [u]and now PA is back to work[/u]!!!!

It begs the question why??

Many thanks in advance for any help

Lou

bug when using tables: java.lang.NullPointerException

aro — GMT

Hello,

We are discovering SQL Power Architect, it is version 1.0.5 PRO trial version, freshly downloaded.
We are under Windows XP SP3, Java JRE 1.6.0_26.

We have a project opened, connected to an existing PostgrSQL database with PostGis, and we are drawing a shema by drag-droping tables from the tree panel to the PlayPen area, an error message occurs for certain tables. The same error message occurs if we try to deploy the table item in the tree.

We are suspecting the error to happens only on table that have a column which type is "geometry". Geometry is a special but quite common type provided with the PostGis extension for PostgreSQL.

Do you think something can be done to solve the bug ?
Regards,

Here is the detail of the error message:

[code]java.lang.RuntimeException: java.lang.RuntimeException: java.lang.NullPointerException
at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.cleanup(PlayPen.java:1700)
at ca.sqlpower.swingui.SPSwingWorker$1.run(SPSwingWorker.java:114)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.lang.RuntimeException: java.lang.NullPointerException
at ca.sqlpower.sqlobject.SQLTable.populateRelationshipsWithList(SQLTable.java:820)
at ca.sqlpower.sqlobject.SQLTable$5.run(SQLTable.java:737)
at ca.sqlpower.architect.swingui.ArchitectSwingSessionImpl.runInForeground(ArchitectSwingSessionImpl.java:1166)
at ca.sqlpower.object.AbstractSPObject.runInForeground(AbstractSPObject.java:642)
at ca.sqlpower.sqlobject.SQLTable.populateRelationships(SQLTable.java:732)
at ca.sqlpower.sqlobject.SQLTable.createTableFromSource(SQLTable.java:300)
at ca.sqlpower.sqlobject.SQLTable.createInheritingInstance(SQLTable.java:287)
at ca.sqlpower.architect.swingui.PlayPen.importTableCopy(PlayPen.java:1258)
at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.cleanup(PlayPen.java:1621)
... 15 more
Caused by: java.lang.NullPointerException
at ca.sqlpower.sqlobject.SQLRelationship.attachRelationship(SQLRelationship.java:577)
at ca.sqlpower.sqlobject.SQLRelationship.attachRelationship(SQLRelationship.java:530)
at ca.sqlpower.sqlobject.SQLTable.populateRelationshipsWithList(SQLTable.java:796)
... 23 more
[/code]

java.lang.IllegalArugmentException when doing a Database Comparison

Erasmus — GMT

I am comparing my existing model with a SQL Server 2008 R2 Express Edition database and I get the following error message:

java.lang.IllegalArgumentException: -150 is not a sql datatype

I have run this comparison a number of times previously without a problem. I have done a visual comparison on the tables that have been modified since the last comparison, and the only data types used are integers and varchars.

The only thing that's possibly causing this is a new replicated view (a subscription) that contains nvarchar(max), decimal() and uniqueidentifier types.

Here's the info from the About SQL Power Architect:

SQL Power Architect 1.0.6
Copyright 2003-2010 SQL Power Group Inc.

Operating System:
Windows 7 6.1 (x86)

Runtime Environment:
Java(TM) SE Runtime Environment
1.6.0_26-b03

VM info:
Java HotSpot(TM) Client VM
20.1-b02
Sun Microsystems Inc.

Memory:
42MiB allocated (580MiB max); 14MiB free

Column Comments and Generate Data Dictionary in MS Word Format

unowhoiam123 — GMT

I am using

SQL Power Architect - 0.9.16
OS - Windows XP 5.1 (X86)
Runtime Environment - JRE 1.6.0_17-b04
Database: Oracle10gXE

I have two questions..

I generated the data dictionary in HTML format but it did not bring in the table and column comments as part of the report so any idea on how to get them would be helpful.

Also, I generated data dictionary in HTML (Export to HTML) and converted it into MS Word format manually. I would like know if there is a easier way to generate data dictionary in MS Word format directly.

Thanks in advance!

could not launch the sql power architect

nievous — GMT

nor in debian squeeze or ubuntu 10.04.

log:

[code]0 [AWT-EventQueue-2] INFO ca.sqlpower.architect.ArchitectUtils - Log4J configured successfully
1024 [AWT-EventQueue-2] INFO ca.sqlpower.sql.PlDotIni - Beginning to read/merge new pl.ini data
1467 [AWT-EventQueue-2] INFO ca.sqlpower.sql.PlDotIni - Finished reading file.
1469 [AWT-EventQueue-2] INFO ca.sqlpower.sql.PlDotIni - Beginning to read/merge new pl.ini data
1470 [AWT-EventQueue-2] INFO ca.sqlpower.sql.PlDotIni - Finished reading file.
1837 [AWT-EventQueue-2] ERROR ca.sqlpower.architect.swingui.ASUtils - got a null session in showExceptionDialog()
1843 [AWT-EventQueue-2] ERROR ca.sqlpower.swingui.SPSUtils - dialog parent component null is neither JFrame nor JDialog
1 [AWT-EventQueue-2] INFO ca.sqlpower.architect.ArchitectUtils - Log4J configured successfully
775 [AWT-EventQueue-2] INFO ca.sqlpower.sql.PlDotIni - Beginning to read/merge new pl.ini data
1288 [AWT-EventQueue-2] INFO ca.sqlpower.sql.PlDotIni - Finished reading file.
1290 [AWT-EventQueue-2] INFO ca.sqlpower.sql.PlDotIni - Beginning to read/merge new pl.ini data
1290 [AWT-EventQueue-2] INFO ca.sqlpower.sql.PlDotIni - Finished reading file.
2578 [AWT-EventQueue-2] ERROR ca.sqlpower.architect.swingui.ASUtils - got a null session in showExceptionDialog()
2604 [AWT-EventQueue-2] ERROR ca.sqlpower.swingui.SPSUtils - dialog parent component null is neither JFrame nor JDialog[/code]

Can not open saved project

Maestro — GMT

When trying to open saved file!

ca.sqlpower.sqlobject.SQLObjectException: SAX Exception in project file olap schemas parse!
at ca.sqlpower.architect.swingui.SwingUIProjectLoader.load(SwingUIProjectLoader.java:208)
at ca.sqlpower.architect.swingui.action.OpenProjectAction$LoadFileWorker.doStuff(OpenProjectAction.java:218)
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:104)
at ca.sqlpower.architect.swingui.action.OpenProjectAction$1.open(OpenProjectAction.java:87)
at ca.sqlpower.architect.swingui.ArchitectFrame$18.loadFile(ArchitectFrame.java:912)
at ca.sqlpower.swingui.RecentMenu.openFile(RecentMenu.java:129)
at ca.sqlpower.swingui.RecentMenu$1.actionPerformed(RecentMenu.java:148)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: org.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup.
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at ca.sqlpower.architect.olap.MondrianXMLReader.parse(MondrianXMLReader.java:103)
at ca.sqlpower.architect.swingui.SwingUIProjectLoader.load(SwingUIProjectLoader.java:205)
... 33 more

SAX Exception in project file olap schemas parse

MikeAKnox — GMT

I've been cutting and pasting comments into remarks on table and columns. This all worked beautifully over the holiday period until I came in this morning when I was unable to open my project with the above error.

I managed to edit the architect file and correct the issues which were

text in the comments attrribute 'Product ampersand Description' which caused an error expecting an entity name to follow the ampersand.

text in the comment referring to 'Dropdown