SQL Power Software Forum - Latest forum topics

ssh connection without external tunneling?

bronius — GMT

I have not seen it in a lot of places, but Sequel Pro for Mac handles tunneling over ssh to mysql very nicely:
http://www.sequelpro.com/docs/Set_up_an_SSH_Tunnel
http://www.sequelpro.com/docs/Connecting_to_a_MySQL_Server_on_a_Remote_Host
In most db GUIs, SQL*Power Architect included, I don't get this and have to first fire up an external ssh tunnel before using the app or I get connection failure.

Would it be possible to add in an ssh-key based mysql tunnel into the Connection Manager?

Cheers
-Bronius

Demo Files Location

Popcorn — GMT

I am trying to evaluate SQL Wabit using the Community Version. All of the demos/tutorials use a demo database of Movies & Actors. Each of these demos/tutorials state that the Databases come with the download of the product. However, we I downloaded it there is no databases with it that I can find. I asked the company (thinking that they would at least support their download operation) but they told me to ask my question here.
Can anybody tell me how to get the datebases mentioned in the demos/tutorials so I can evaluate the product using the demos/tutorials provided?

connnecting to remote XML/A Server

ctamietto — GMT

I need to configure a remote XML/A Server datasource in SQL Power Wabit .
In my case is jasper server .
The correct URL is http://jasper:8080/jasperserver4/xmla but i have to provide also the user credentials .
How can I specify in the configuration of the data source this information ?

Dyson Air Multiplier Follower

greenorange — GMT

With the use of by far the most up-to-date technological innovation nowadays we are able to truly view a lot of enhancements anyplace we seem from cellular phones, laptops, desktop personal computers and further household appliances, [url=http://www.chinabladelessfan.net/Product-Advantage.htm]air multiplier[/url]. :oops: :oops: :oops:

Dimension Views

cpeterson10 — GMT

Does power architect support the creation of dimension views?

Connecting to a remote postgresSQL instance

sglanger — GMT

I have postgreSQL 9.1 running on a Windows server. I have succeeded in using pgAdmin from a remote XP box to that Server/dbase. Installed SQL PA on the same XP box

I setup the server in SQL PA and hit the "TEstConnection" button and get "Connection Test Succesful". Then I try to actually open the connection and get
"FATAL pg_hba.conf no entry for host "a.b.c.d.", user "postgres", dbase "ddw", ssl off"

Clearly there are requirements above and beyond what it takes to get pgAdmin to work, but I can find no documents for them at sqlpower or postgreSQL

any help?

Bug while copying a Querie

elazaro — GMT

Hi all,

I have a strange bug while copying a querie...

I am on MAC OSX Lion with 1.3.4 the bug occured while copying a querie.

java.lang.RuntimeException: java.lang.NullPointerException
at ca.sqlpower.swingui.DataEntryPanelBuilder$2.actionPerformed(DataEntryPanelBuilder.java:160)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6373)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6138)
at java.awt.Container.processEvent(Container.java:2085)
at java.awt.Component.dispatchEventImpl(Component.java:4735)
at java.awt.Container.dispatchEventImpl(Container.java:2143)
at java.awt.Component.dispatchEvent(Component.java:4565)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4621)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4282)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4212)
at java.awt.Container.dispatchEventImpl(Container.java:2129)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4565)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:679)
at java.awt.EventQueue.access$000(EventQueue.java:85)
at java.awt.EventQueue$1.run(EventQueue.java:638)
at java.awt.EventQueue$1.run(EventQueue.java:636)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
at java.awt.EventQueue$2.run(EventQueue.java:652)
at java.awt.EventQueue$2.run(EventQueue.java:650)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:649)
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)
Caused by: java.lang.NullPointerException
at ca.sqlpower.query.TableContainer.createCopy(TableContainer.java:268)
at ca.sqlpower.query.QueryImpl.(QueryImpl.java:424)
at ca.sqlpower.query.QueryImpl.(QueryImpl.java:408)
at ca.sqlpower.wabit.rs.query.QueryCache.(QueryCache.java:396)
at ca.sqlpower.wabit.swingui.action.CopyQueryAction.copy(CopyQueryAction.java:52)
at ca.sqlpower.wabit.swingui.action.CopyAction$1.applyChanges(CopyAction.java:57)
at ca.sqlpower.swingui.DataEntryPanelBuilder$8.call(DataEntryPanelBuilder.java:378)
at ca.sqlpower.swingui.DataEntryPanelBuilder$8.call(DataEntryPanelBuilder.java:375)
at ca.sqlpower.swingui.DataEntryPanelBuilder$2.actionPerformed(DataEntryPanelBuilder.java:155)
... 36 more

What can i do ?

Seems my workbench is corrupted now oO

SQL Server 2008 data types

monstercop — GMT

I've been trialling Power Architect in using SQL Server 2008 and there are some inconsistencies which I am a little confused about. The connection area quite happily allows you to specify SQL Server 2008, and connects happily. When I start doing anything in anger, there appear to be many data type conversion issues. For example when I have a uniqueidentifier data type in SQL Server 2008, but when I connect, it converts as a CHAR(36) which serves no real purpose and I need to change it. Thoughts on this? Am I unreasonable in an expectation that if something connects, it carries the appropriate data types, or have I blatantly missed the point...?

Oil and Gas Monthly Deals Analysis

brent31976 — GMT

GlobalData's "Oil and Gas Monthly Deals Analysis - M&A and Investment Trends, December 2011" report is an essential source of data and trend analysis on the mergers and acquisitions (M&As) and financings in the oil and gas industry. The report provides detailed information on M&As, equity/debt offerings, private equity, venture financing and partnership transactions registered in the oil and gas industry in Novmeber 2011. The report portrays detailed comparative data on the number of deals and their value in the last six months, subdivided by deal types, segments and geographies. Additionally, the report provides information on the top financial advisory firms in the oil and gas industry.

http://www.fastmr.com/prod/290797_oil_and_gas_monthly_deals_analysis_ma_and.aspx

Error while evaluating SQL power Architect with PostgreSQL - data modeling

arise2 — GMT

Hi All,

We're trying to check your software but on the beginning we receive such error while trying to drag scheme (PostgreSQL database 9.0.4) to PlayPen. This problem accures everytime with every single table from the scheme.

Could you pls advice what can be done with this?

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(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:641)
at java.awt.EventQueue.access$000(EventQueue.java:84)
at java.awt.EventQueue$1.run(EventQueue.java:602)
at java.awt.EventQueue$1.run(EventQueue.java:600)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:611)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: java.lang.NullPointerException
at ca.sqlpower.architect.enterprise.SPObjectSnapshotHierarchyListener.cleanupSnapshot(SPObjectSnapshotHierarchyListener.java:222)
at ca.sqlpower.architect.enterprise.SPObjectSnapshotHierarchyListener.transactionEnded(SPObjectSnapshotHierarchyListener.java:523)
at ca.sqlpower.object.AbstractSPObject.fireTransactionEnded(AbstractSPObject.java:557)
at ca.sqlpower.object.AbstractSPObject.fireTransactionEnded(AbstractSPObject.java:534)
at ca.sqlpower.object.AbstractSPObject.commit(AbstractSPObject.java:597)
at ca.sqlpower.sqlobject.UserDefinedSQLType.setMyNullability(UserDefinedSQLType.java:689)
at ca.sqlpower.sqlobject.SQLColumn.assignTypes(SQLColumn.java:674)
at ca.sqlpower.architect.swingui.PlayPen$AddObjectsTask.cleanup(PlayPen.java:1690)
... 15 more

error when adding a table to a query

JohnS50 — GMT

Any help with this would be greatly appreciated.

SQL Power Wabit 1.3.4
Copyright 2003-2010 SQL Power Group Inc.

Operating System:
Windows 7 6.1 (amd64)

Runtime Environment:
Java(TM) SE Runtime Environment
1.7.0_02-b13

VM info:
Java HotSpot(TM) 64-Bit Server VM
22.0-b10
Oracle Corporation

I connected to MS SQL 2008 R2

I dragged a table from the list under my connection to the query workspace and got this error:

java.lang.RuntimeException: ca.sqlpower.sqlobject.SQLObjectException: Failed to populate columns of tables
at ca.sqlpower.query.TableContainer.loadColumnsFromTable(TableContainer.java:171)
at ca.sqlpower.query.TableContainer.(TableContainer.java:80)
at ca.sqlpower.swingui.querypen.QueryPen$QueryPenDropTargetListener.drop(QueryPen.java:222)
at java.awt.dnd.DropTarget.drop(Unknown Source)
at sun.awt.dnd.SunDropTargetContextPeer.processDropMessage(Unknown Source)
at sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchDropEvent(Unknown Source)
at sun.awt.dnd.SunDropTargetContextPeer$EventDispatcher.dispatchEvent(Unknown Source)
at sun.awt.dnd.SunDropTargetEvent.dispatch(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.processDropTargetEvent(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$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$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: ca.sqlpower.sqlobject.SQLObjectException: Failed to populate columns of tables
at ca.sqlpower.sqlobject.SQLTable.populateAllColumns(SQLTable.java:442)
at ca.sqlpower.sqlobject.SQLTable.populateColumns(SQLTable.java:365)
at ca.sqlpower.sqlobject.SQLTable.getColumns(SQLTable.java:1566)
at ca.sqlpower.query.TableContainer.loadColumnsFromTable(TableContainer.java:153)
... 34 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from char to SMALLINT is unsupported.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
at com.microsoft.sqlserver.jdbc.DataTypes.throwConversionError(DataTypes.java:1117)
at com.microsoft.sqlserver.jdbc.IntColumnIdentityFilter.apply(SQLServerDatabaseMetaData.java:2320)
at com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:114)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1981)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1966)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getObject(SQLServerResultSet.java:2255)
at ca.sqlpower.sql.jdbcwrapper.ResultSetDecorator.getObject(ResultSetDecorator.java:502)
at ca.sqlpower.sql.CachedRowSet.populate(CachedRowSet.java:255)
at ca.sqlpower.sql.CachedRowSet.populate(CachedRowSet.java:214)
at ca.sqlpower.sql.CachedRowSet.populate(CachedRowSet.java:202)
at ca.sqlpower.sql.jdbcwrapper.SQLServerDatabaseMetaDataDecorator.getColumns(SQLServerDatabaseMetaDataDecorator.java:56)
at ca.sqlpower.sql.jdbcwrapper.SQLServer2008DatabaseMetaDataDecorator.getColumns(SQLServer2008DatabaseMetaDataDecorator.java:87)
at ca.sqlpower.sqlobject.SQLColumn.fetchColumnsForTable(SQLColumn.java:481)
at ca.sqlpower.sqlobject.SQLTable.populateAllColumns(SQLTable.java:407)
... 37 more

SQL Server 2008 Connection

cpeterson10 — GMT

Newbie question here.

I am running SQL Server 2008 local on my machine and I am having a hard time creating a DB connection. The URL generated is jdbc:sqlserver://cpeterson-HP:1433

I'm curious where the actual database name should be referenced.

Thanks!

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