SQL Power Software Forum - Latest forum topics

Multiple Play Pens in 1 Project file

mustanshir — GMT

Hi,

Can someone please tell me if there is any feature in Power Architect similar to that of multiple Subject Areas in Erwin or multiple Pages in Visio.

For example, I have a database/schema with 100 tables in it. When I reverse engineer the same in Power Architect, all 100 tables get loaded in the same Play Pen. But, I want to divide these 100 tables into lets say multiple logical groups of 10 tables each, with some tables being shared across these groups. So, how do I do that?

If I create multiple projects, then I will not be able to use the data model comparision feature, because 10 tables in one project file will never match with 100 tables in the database.

In Erwin or Visio, one can load all the 100 tables in the project file and then lay them out logically in multiple diagrams. How can I achieve this in Power Architect?

Thanks & regards,
Mustanshir Hussain

Data model diff as SQL to recreate changes should by built in order of dependencies added

bronius — GMT

I ran into this issue today:
- SQL diff, see ALTER fields to add a fistful of new fields
- Execute SQL, watch some statements fail due to dependent fields not present
- EITHER Execute SQL again, ignoring dup fields, repeating for each field dependency now allowed
- OR manually sort the ALTER statements to make sure that missing fields are inserted first

Ex:
[code]ALTER TABLE sfstaging_account ADD COLUMN field_payopt_creditcode VARCHAR(255) AFTER field_home_addresszip;
ALTER TABLE sfstaging_build ADD COLUMN company_rep_email VARCHAR(255) AFTER field_company_subpartnerno;
ALTER TABLE sfstaging_build ADD COLUMN field_installation_county VARCHAR(255) AFTER field_installation_addresszip;
ALTER TABLE sfstaging_build ADD COLUMN paymentoption_id INT AFTER account_id;
ALTER TABLE sfstaging_lease ADD COLUMN field_payopt_prepaytime VARCHAR(255) AFTER field_payopt_srecowner;
ALTER TABLE sfstaging_lease ADD COLUMN field_payopt_srecowner VARCHAR(255) AFTER field_quoted_leaserate;
ALTER TABLE sfstaging_lease ADD COLUMN qe_api_taxamount DECIMAL(10,2) AFTER qe_api_taxrate;
ALTER TABLE sfstaging_lease ADD COLUMN qe_api_taxrate DECIMAL(10,2) AFTER field_payopt_prepaytime;[/code]

should be:
[code]ALTER TABLE sfstaging_account ADD COLUMN field_payopt_creditcode VARCHAR(255) AFTER field_home_addresszip;
ALTER TABLE sfstaging_build ADD COLUMN company_rep_email VARCHAR(255) AFTER field_company_subpartnerno;
ALTER TABLE sfstaging_build ADD COLUMN field_installation_county VARCHAR(255) AFTER field_installation_addresszip;
ALTER TABLE sfstaging_build ADD COLUMN paymentoption_id INT AFTER account_id;
ALTER TABLE sfstaging_lease ADD COLUMN field_payopt_srecowner VARCHAR(255) AFTER field_quoted_leaserate;
ALTER TABLE sfstaging_lease ADD COLUMN field_payopt_prepaytime VARCHAR(255) AFTER field_payopt_srecowner;
ALTER TABLE sfstaging_lease ADD COLUMN qe_api_taxrate DECIMAL(10,2) AFTER field_payopt_prepaytime;ALTER TABLE sfstaging_lease ADD COLUMN qe_api_taxamount DECIMAL(10,2) AFTER qe_api_taxrate;[/code]

Notice in the above example that the order of the first four or so ALTERs didn't matter, because the "AFTER fields" already exist, but the last four items had to be rearranged because the AFTER fields were to be inserted by this same SQL diff script.

Cheers
-Bronius

Performance using JDBC, OSX 10.7 and Oracle 11g

TL009 — GMT

I have Wabit Community Edition

- running on OSX 10.7 (Lion)
- using JDBC for Oracle (tried both ojdbc14 and ojdbc5)
- have Oracle 11g

The JDBC test connect is fine, the DB is found, the tables show ... so all the setup and connections seem ok.

However, whenever trying to add a table to the QueryPen it can take 30 minutes before it has updated. If I run an SQL instead, same problem to view results.

Can anyone give me a pointer as to why this would be and how to fix it ?

Thanks in advance

Oracle 8i JDBC connect issue

bitdoger — GMT

Oracle 8i connect does NOT correctly to linked tables...not matter what
ODJDBC.jar driver i use....I am able to correctly connect to my
oracle 8i database...but any use off foriegn key linked tables
does not show up on the sql edit tab and when i manually put it in
DOES NOT run the SQL stmt...running with the latest/greatest wabbit
under windows XP....thanx dave

Power Architect format and GIT

rsilva4 — GMT

Hello,

I'm using Power Architect (PA) to design data models, however I'm not soing it by myself. So I use git, the VCS I use for many other stuff, to share the files and maintain history and editors. So far so good.

The issue is when there is a conflict, which, in the case of PA format, happens if a user touches the same file I'm about to edit. This other user does not have to had made any changes to the file, just opening the file alter a lot of the structure.

So I have to improvise a locking system to no other user edit the same file I'm working on. Seams a little ancient this technique and at the same time totally breaks the development workflow.

Anyone has any suggestion on how to achieve what I want?

Does SQL Power plans to do something in the future to avoid this situations? Like trying to make a cleaner file format, if possible?

Thanks in advance

Best regards,

RS

Connect to SQL Server named instance

Webern — GMT

Can SQL Power Architect be connected to a SQL Server *Named Instance*? If so, how do I fill this form out?

For the non windows folks, normally when you connect to a SQL Server named instance, you specify the SQL Server like this

mywindowsserver\mysqlservernamedinstance

This is not a firewall or sql server issue, all other windows-friendly client applications can connect to the sql server instance both locally and remotely.

Thanks

[img]
http://matthewjamesbriggs.com/imghost/SqlServerNamedInstance.PNG
[\img]

Problem with foreign keys

riffmaker — GMT

Hi

I have a problem with foreign keys. I tried to search, but couldn't find any solutions.

Maybe I'm doing something wrong, but sometimes when I add a relationship SQL power architect adds all foreign keys from referenced table.

Let's say I have comment_rating table and comment table. In comment_rating table I have cmnt_id which is foreign key of column cmnt_id in comment table. But when I want to make FK of the cmnt_id, I end up with usr_id FK, st_id FK and ent_id FK which are foreign keys from comment table...

Is this some kind of bug, or am I doing something wrong? Please help me, 'cos otherwise SQL Power Architect rocks

Newbie connecting Power Architect to PostgreSQL on Mac OSX Lion Server

askoog66 — GMT

I have spent several days trying to access the embedded PostgeSQL database on my Mac OSX Lion Server without success. The server is static ip at 192.168.1.20.

I have tried following https://discussions.apple.com/thread/3199015?start=15&tstart=0
as much as possible, but the solutions seem to vary wildly.

What I have done is:
1. edit file/system/library/LaunchDaemons/org.postgresql.postgres.plist

deteted lines
-c
listen_addresses=
2. edit file /var/pgsql/pg_hba.conf

add lines
host all all 192.168.1.0/24 trust
have also tried instead
host all all samenet trust
3. edit file /var/pgsql/postgresql.conf

edit lines
#listen_addresses = 'localhost'
listen_addresses = '*'

#port = 5432
port = 5432
4. restart mac os x server

I am able to access the server via terminal locally -
sudo -u _postgres psql template 1

When I type in terminal locally -
sudo serveradmin fullstatus postgres
I get the following
postgres:dataDirHasBeenInitialized = yes
postgres:PG_VERSION = "9.0.4"
postgres:dataDir = "/var/pgsql"
postgres:postgresIsResponding = yes
postgres:dataDirIsDirectory = yes
postgres:PGserverVersion = 90004
postgres:dataDirExists = yes
postgres:setStateVersion = 1
postgres:state = "RUNNING"

When I try to connect from my laptop on the same network with SQL Power Architect, I setup a new connection with the following:
Database Type - PostgreSQL
Hostname - 192.168.1.20 (also tried my hostname (mini-server))
Port - 5432
Database - template1
JDBC URL is auto assembled as - jdbc:postgresql://192.168.1.20:5432/template1
Username - _postgres (also tried postgres)
password - (also tried not password)

When I test the connection I get a connection refused error.

When I start up Network Utility on my laptop and scan open ports, it finds nothing at 192.168.1.20:5432

It seems like I am close, but not cigar. Unfortunately, I come from a Microsoft Access background and have no familiarity with these client/server type of databases.

Thanks.......

Export Excel & Interactive Reporting

haydarcavus — GMT

Hi,

a) Is it possible to export reports to excel?

b) Is it possible to master-detail reporting (interactive reporting)?

university

brent31976 — GMT

I found a report as what you’re looking http://www.fastmr.com/prod/284058_pulmonary_edema_global_clinical_trials_review_h2.aspx
. But I’m not sure about the publisher and other details. But it’s worth to read

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)
);

....

Installation error

wshazlett — GMT

When running the installation for version 1.3.4 on Windows 7 Enterprise 64bit I get the following error at the installation directory step.

"This directory cannot be written! Please choose another directory!."

Any clues? I am an administrator on my machine.

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

Cannot forward engineer or compare data models

Ken Clark — GMT

I am unable to generate any SQL for my data model. Any time I do, I get a null pointer exception, as in the trace below.

Note I also had an anomaly with a column -- I created a new (non-PK) column on a table, and later noticed that it was in several tables, including in the original table as both a PK and a non-PK column. It took me a while to clear this bad column out -- it would not let me delete. Instead, I found I could create a dummy table, move the column to that table, and then delete the dummy table. I repeated that until it was gone everywhere, and then recreated the column in the table where it should have been.

Is my data model corrupt now? Any way to fix it if so?

Thanks,
ken

Error stack trace for compare:

[code]java.lang.NullPointerException
at ca.sqlpower.architect.ddl.GenericDDLGenerator.addRelationship(GenericDDLGenerator.java:341)
at ca.sqlpower.architect.swingui.CompareDMFormatter.sqlScriptGenerator(CompareDMFormatter.java:276)
at ca.sqlpower.architect.swingui.CompareDMFormatter.formatForSQLOutput(CompareDMFormatter.java:190)
at ca.sqlpower.architect.swingui.CompareDMPanel$StartCompareAction$1.cleanup(CompareDMPanel.java:1373)
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)[/code]

Cannot connect to SQL Server 2005 database

msaleh — GMT

hi
it's my first use of power architect
and i am trying to connect to sql server 2005 (Express) db on a remote machine (i can connect to it successfully from Microsoft sql server management studio express)

here's what i tried:

Database Type: SQL Server 2005
Hostname: 192.168.1.56
Port:1433
JDBC URL:jdbc:sqlserver://192.168.1.56:1433
Username:***
Password:***

when i try to test the connection, i get following exception:

[code]com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 192.168.1.56, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1049)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841)
at ca.sqlpower.sql.JDBCDataSource.createConnection(JDBCDataSource.java:296)
at ca.sqlpower.swingui.JDBCDataSourcePanel$1.actionPerformed(JDBCDataSourcePanel.java:168)
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.plaf.basic.BasicButtonListener.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.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.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.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)[/code]

please advise.