Latest topics for the forum "SQL Power Architect Technical Support"

Can't forward engineer without a connection starting 9.16?

irisheyes — GMT

Sometimes I work on a design of a database when I don't have a connection to the database server. In previous version of Power Architect, I could leave the connection set to "No connection" in the forward engineering dialog and still be able to forward engineer. I could save the SQL script and then log into one of my remote to run my scripts. Now I am unable to do this. Event though I still have the first dropdown set to "No connection", I get this error:

ca.sqlpower.sqlobject.SQLObjectException: Couldn't connect to database: The TCP/IP connection to the host has failed. java.net.UnknownHostException:
at ca.sqlpower.sqlobject.SQLDatabase.getConnection(SQLDatabase.java:603)
at ca.sqlpower.architect.ddl.GenericDDLGenerator.generateDDLStatements(GenericDDLGenerator.java:219)
at ca.sqlpower.architect.ddl.GenericDDLGenerator.generateDDLScript(GenericDDLGenerator.java:173)
at ca.sqlpower.architect.swingui.action.ExportDDLAction$1.call(ExportDDLAction.java:91)
at ca.sqlpower.architect.swingui.action.ExportDDLAction$1.call(ExportDDLAction.java:81)
at ca.sqlpower.swingui.DataEntryPanelBuilder$2.actionPerformed(DataEntryPanelBuilder.java:153)
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)
etc...

Locally, we use SQL Server in Windows Authentication mode which I gave up on trying to make work even after reading the forums. Just using the scripts generated was a great workaround but now I don't even have that. However, even if I could get the network SQL Servers to connect, I would still have this problem with the remote databases.

So... IS there a way to use forward engineering without specifying a connection?

Forward engineer causes NullPointerException

dorr67 — GMT

When I try to forward engineer to a MySQL db, I get a NullPointerException. Has anyone else experienced this?

java.lang.NullPointerException
at ca.sqlpower.architect.ddl.GenericDDLGenerator.addRelationship(GenericDDLGenerator.java:366)
at ca.sqlpower.architect.ddl.GenericDDLGenerator.writeExportedRelationships(GenericDDLGenerator.java:927)
at ca.sqlpower.architect.ddl.GenericDDLGenerator.generateDDLStatements(GenericDDLGenerator.java:237)

PA 9.16 - javaw.exe grabs 90+ percent of CPU

HankWalters — GMT

I recently updated PA to version 0.9.16 so that I could connect to a MS SQL Server 2008 non-default instance. I am on a Win XP SP 3 computer with 2 GB RAM and a 1.70GHz processor.

The problem is that anything that I do in the diagram window (move tables, zoom in/out, etc.) is very laggy and slow. When I run Task Manager, I see that the javaw.exe jumps up to 90+ percent of CPU anytime I do anything in the diagram window.

Any ideas what may be causing this? I have used PA for many versions and this is the first time I have had this problem with it.

Thanks,
Hank

timestamps with timezone possible for postgres?

schodnicki — GMT

Hi there,

I was wondering if there is a way in power architect to specify a column to be of type TIMESTAMP WITH TIMEZONE, which is a type supported by postgres.

Reverse engineering shows a timestamptz type in the treeview. It is converted to a normal timestamp when dragging it to a diagram though.

Thanks

Any easier way to deal with larger size diagram?

scottb108 — GMT

Is there any easier way to deal with a larger diagram, i.e. when you reach the natural "edges" of the screen?

As far as I can tell, the only way to extend the border is to drag a table there. Also, you then have to constantly click on the scroll bar to move, as the arrow keys apparently are non-functional.

Are there any fixes to thes inconviences, or possible future enhancements to address this?

Thanks,
Scott

Issues with SQL Server 2008 R2 and jtds sql server driver

Lourence108 — GMT

Hi

After few months of absence, having had problems recenty with PA and SQL Server 2008 (R2 this time!), I thought to test the various drivers and report the errors.
This post is about using jtds jtds-1.2.5 and SQL Server R2.
With this driver I manage to drag and drop the table AWBuildVersion successfully (better than jdbc4-3.0).
Issues:
1. the drver does not recognise the NVarchar data type and convert it to Varchar.
2. PA is representing for each DB as schemas objects that are not schemas, like db_accessadmin etc. Please see a discussion on this subject between me and Jonathan last year (SQL Server 2008 no schema), where we discussed the type of query PA needs to use to select the schema(s) and nothing else.
3. When I try to export to pdf the content of the playpen I get the following error:
java.lang.IllegalStateException: Event for a transaction rollback must fired on the foreground thread.
at ca.sqlpower.object.AbstractSPObject.fireTransactionRollback(AbstractSPObject.java:494)
at ca.sqlpower.sqlobject.SQLDatabase.setPlayPenDatabase(SQLDatabase.java:535)
at ca.sqlpower.architect.swingui.PlayPen.setDatabase(PlayPen.java:783)
at ca.sqlpower.architect.swingui.PlayPen.(PlayPen.java:626)
at ca.sqlpower.architect.swingui.PlayPen.(PlayPen.java:609)
at ca.sqlpower.architect.swingui.PlayPen.(PlayPen.java:605)
at ca.sqlpower.architect.swingui.PlayPen.(PlayPen.java:669)
at ca.sqlpower.architect.swingui.action.ExportPlaypenToPDFAction.doStuff(ExportPlaypenToPDFAction.java:122)
at ca.sqlpower.architect.swingui.action.ProgressAction$2.doStuff(ProgressAction.java:118)
at ca.sqlpower.swingui.SPSwingWorker.run(SPSwingWorker.java:104)
at java.lang.Thread.run(Unknown Source)

The tests are done using Windows 2008 R2 64 bits and SQL Server R2 (Nov. CTP).

SQL Server 2008 is not working... again!

Lourence108 — GMT

Hi guys

I've been on other sort of projects for a while and I've not used PA since September 2009.
Last version I've used successfully (just minor bugs) was 0.9.13.
JDBC driver was Microsoft sqljdbc4.jar.

Today I've installed the 0.9.16 version (downloading Architect-Setup-Windows-jdbc-0.9.16.exe from Hudson website).
Disaster!!
I try to srag and drop on the playpen the table HumanResources.Employee and I get a series of errors (see below), including errors referring to other tables in other schemas!

Considering that my installation hasn't changed but the only thing that has changed is the version of Power Architect, what is exactly going on?

Incidentally, I keep on seeing messages of guys having SQL Server 2008 / 05 problems and the PA guys saying that all is fine "in SQL Server 2000"!!!
Please note that the two versions are different (e.g. one has schemas the other not), and from previous messages I understand that your treatment of the two is very different.

Any light you can shed is useful.

Error messages are:
java.lang.RuntimeException: java.lang.IllegalStateException: FK table Production.Document (TABLE) is missing columns, cannot populate relationships.
at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.cleanup(PlayPen.java:1652)
at ca.sqlpower.swingui.SPSwingWorker$1.run(SPSwingWorker.java:114)
at java.awt.event.InvocationEvent.dispatch(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.IllegalStateException: FK table Production.Document (TABLE) is missing columns, cannot populate relationships.
at ca.sqlpower.sqlobject.SQLRelationship$2.run(SQLRelationship.java:704)
at ca.sqlpower.architect.swingui.ArchitectSwingSessionImpl.runInForeground(ArchitectSwingSessionImpl.java:1106)
at ca.sqlpower.sqlobject.SQLRelationship.fetchExportedKeys(SQLRelationship.java:747)
at ca.sqlpower.sqlobject.SQLTable.populateRelationships(SQLTable.java:603)
at ca.sqlpower.sqlobject.SQLTable.populateRelationships(SQLTable.java:583)
at ca.sqlpower.sqlobject.SQLTable.createTableFromSource(SQLTable.java:285)
at ca.sqlpower.sqlobject.SQLTable.createInheritingInstance(SQLTable.java:272)
at ca.sqlpower.architect.swingui.PlayPen.importTableCopy(PlayPen.java:1260)
at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.cleanup(PlayPen.java:1600)
... 9 more

java.lang.NullPointerException
at ca.sqlpower.sqlobject.SQLRelationship$2.run(SQLRelationship.java:703)
at java.awt.event.InvocationEvent.dispatch(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)

java.lang.RuntimeException: java.lang.NullPointerException
at ca.sqlpower.sqlobject.SQLTable$4.run(SQLTable.java:650)
at java.awt.event.InvocationEvent.dispatch(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.NullPointerException
at ca.sqlpower.sqlobject.SQLTable$4.run(SQLTable.java:629)
... 8 more
java.lang.NullPointerException
at ca.sqlpower.sqlobject.SQLRelationship$2.run(SQLRelationship.java:703)
at java.awt.event.InvocationEvent.dispatch(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)

java.lang.IllegalStateException: Transaction ended outside of a transaction.
at ca.sqlpower.architect.swingui.dbtree.DBTreeModel$DBTreeSPListener.transactionEnded(DBTreeModel.java:321)
at ca.sqlpower.object.AbstractSPObject.fireTransactionEnded(AbstractSPObject.java:463)
at ca.sqlpower.object.AbstractSPObject.commit(AbstractSPObject.java:500)
at ca.sqlpower.sqlobject.SQLTable$7.run(SQLTable.java:1191)
at java.awt.event.InvocationEvent.dispatch(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)

Can't see SQL Server datatypes when create new column

scottb108 — GMT

I'm trying to create a new column using the uniqueidentifier datatype, for SQL Server 2008. However, this datatye does not appear in the Type list.

I tried connecting to the SQL Server 2008 DB to make sure it knew I was using this DB, that didn't seem to change anything.

Is there a trick to get this and/or other SQL Server datatypes to show up in the type list?

This is a great tool by the way, I've used it successfully on a few small projects.

DB2 ca.sqlpower.sqlobject.SQLObjectException

scandora — GMT

Hello -

I have SQLPA installed on an OpenSuse 11.2 box and I am trying to get a DB2 connection up against the DB2 SAMPLE database. I am using the universal driver db2jcc.jar, class com.ibm.db2.jcc.DB2Driver to connect to jdbc:db2://localhost:50001/SAMPLE. "Test Connection" works fine, but when I try to open the connection to view tables I get a ca.sqlpower.sqlobject.SQLObjectException: failed to get catalog names from database.

java -version
java version "1.6.0_18"
Java(TM) SE Runtime Environment (build 1.6.0_18-b07)
Java HotSpot(TM) Server VM (build 16.0-b13, mixed mode)

Any assistance appreciated...

-js

Cannot open my project

JavedYousafzai — GMT

Hello,
I have recently installed the free version of SQL Power architect ver 0.9.16 and I created some table and then linked them with the available relationship tool. Now when I try to open my project I get the error message
Exception type: ca.sqlpower.sqlobject.SQLObjectException
Detail String: There is an XML parsing error in project file at line xxxx column:xxx.

Please help or I have to redo the whole work in some other tool.
thanks

Load error

Madsen — GMT

Hi,

I'm trying to load a project with PA 0.9.16 created in PA 0.9.15. I've just updated the version and is getting the following error when loading the project:

ca.sqlpower.sqlobject.SQLObjectException: There is an XML parsing error in project file at Line:637 Column:201
at ca.sqlpower.architect.ProjectLoader.load(ProjectLoader.java:231)
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(Unknown Source)
Caused by: java.lang.IllegalArgumentException: Column RES_DRIVER_ID already exists in this index.
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.endElement(Digester.java:1061)
at ca.sqlpower.xml.UnescapingDefaultHandler.endElement(UnescapingDefaultHandler.java:151)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.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:215)
... 4 more
Caused by: java.lang.IllegalArgumentException: Column RES_DRIVER_ID already exists in this index.
at ca.sqlpower.sqlobject.SQLIndex.addIndexColumn(SQLIndex.java:963)
at ca.sqlpower.sqlobject.SQLIndex.addChildImpl(SQLIndex.java:687)
at ca.sqlpower.object.AbstractSPObject.addChild(AbstractSPObject.java:104)
at ca.sqlpower.sqlobject.SQLObject.addChild(SQLObject.java:353)
at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.commons.beanutils.MethodUtils.invokeMethod(MethodUtils.java:216)
at org.apache.commons.digester.SetNextRule.end(SetNextRule.java:256)
at org.apache.commons.digester.Rule.end(Rule.java:276)
at org.apache.commons.digester.Digester.endElement(Digester.java:1058)
... 19 more

All my other projects is working just fine in 0.9.16 so I'm a little baffled at this error.

Transformation error

du80 — GMT

Hello everybody,

i have a problem with "HTML export".
i run this option, and i have an error message "transformation error - java.lang.NullPointException".

I had succeeded to run this functionality before.
I reinstall this program. Always the same problem.

Have you an idea ?

Thanks in advance.

Displaying tables in existing db

DavidAraSmith — GMT

I just downloaded PA and have set up a connection to my db. It is listed on the left pane, but I can't figure out how get the tables display. I tried to Expand All Children but that took quite awhile and showed everything. Any ideas on how to get just the tables created to display would be great. Thanks.

We can't navigate to different disk volumes?

Wisebord — GMT

Hi all.

I went to save my project, and found that there was no way to navigate beyond the default disk volume chosen by PA.

This is under Mac OS 10.6.2. The same problem applies to the File/Open dialog. I guess this is a known problem, right? I'm using version 0.9.16.

Why are key columns not shown?

Wisebord — GMT

Hi all.

Just started using SQLPA. After creating a new table and specifying the name of the primary key, I find that it isn't shown in the diagram. Why? I looked for a preference for this behavior, and didn't find one.

I did eventually find the "project settings" dialog, but the default is "show all columns." So no answers there...

I'm using version 0.9.16.

Thanks!