SQL Power Software Forum

Hi Larry,

We actually did implement a refresh feature quite some time ago (maybe 4 or 5 releases ago). You right-click the source database in question, then select "Refresh" from the popup menu.

In regards to your question about community involvement, we do have active contributors. See the activity log on Google code for up-to-the-minute details on the activity in SQL Power Architect Community Edition.

More contributors are always welcome! Our policy is to quickly review and either commit or request changes on any patches that are posted on the architect-developers@googlegroups.com mailing list. (Please join that list if you have any interest in getting involved!)

Best regards,

Jonathan

Hi again,

It appears that one of three things is going wrong:

You've signed in as a non-administrative user who does not have access to anything in the workspace. If so, try logging in as admin, just to test the hypothesis

The workspace may be truly empty. Have you used the full-blown Wabit client to create any projects? If not, try starting via the full Wabit client, connecting to your Wabit server, and then visit the demo project. Once you've played with that in the full client, refresh your web browser, and all the demo project objects should appear.

Perhaps something has gone wrong with the client-side HTML/Javascript code. Try this: in Firefox, open the Javascript console (under the Tools menu), clear it, then refresh the Wabit thin client window. You should not see any errors appear in the javascript console.

Please let us know if any of the above solves your problem!

Jonathan

Hi Joe,

In SQL Power Wabit 1.3.2, you have to modify a file to include your server's hostname. Under open the file wabit-enterprise-1.3.2/server/webapps/wabit-enterprise/thin-client/index.html in a text editor.

In the index.html file, search for the following:

change the localhost part to the hostname or IP address of the server where you have installed the Wabit server. Make sure you save this file as plain text!

Starting with the next version of Wabit (1.3.3; not yet released), this configuration step will no longer be necessary. We apologize for the inconvenience!

All the best,

Jonathan

Hi Bapajan,

The HTML-based thin client included with SQL Power Wabit Enterprise Edition is based entirely on web standards. It works fine in Mobile Safari, the Android browser, and should also work properly on the new Webkit-based BlackBerry browser.

You can obtain a trial copy of SQL Power Wabit EE here: http://download.sqlpower.ca/wabit/current.html

If you have any trouble getting started, please feel free to ask on this forum.

Best regards,

Jonathan

Yes, that does sound like a good project and opportunity!

As you say, the project description for the force-metadata-jdbc-driver begins with: "This JDBC driver implements just enough of the java.sql.DatabaseMetaData interface to allow the wonderful SchemaSpy to output a set of ERDs for a Force.com data model."

The way to get this driver working with SQL Power Architect would be to iteratively:

* implement the "next" missing feature in the driver
* re-test

until the populate/reverse engineer feature works properly.

The job would be far, far easier if you replaced the current stub implementations that return 0, false, or null (which is everything after line 77 of http://code.google.com/p/force-metadata-jdbc-driver/source/browse/trunk/force-metadata-jdbc-driver/src/com/claimvantage/force/jdbc/ForceMetaData.java) with a "throw UnsupportedOperationException()". Otherwise, if you start working on enhancing the driver's API coverage as-is, you'll spend most of your time backtracking through the SQL Power Architect code trying to figure out why there was a NullPointerException or IndexOutOfBoundsException after a call into the JDBC driver.

Good luck with this! I'd be very interested to hear back with your results. If you get it working, we'd be happy to bundle your enhanced version of the driver and a built-in configuration for Force.com connections in a future release of SQL Power Architect.

-Jonathan

Just to clarify, have you tried dropping a whole table in the playpen, or just the individual columns? Wabit's query editor takes entire tables, then lets you select/deselect columns afterward.

Hope that helps!

-Jonathan

Hey, that's great!

When you get to the point that you'd like us to mention your project in the next SQL Power Architect release notes, just follow up here!

-Jonathan

Hi again,

There is a link to a recording of the presentation on the left-hand side of this page, under the heading "Previous User Group Meetings."

Good luck with this project!

-Jonathan

Hi Galen,

Benjamin is right: although SQL Power Architect and SQL Power Library run fine on Javas 5, 6, and 7, you still need to compile on JDK 5.

We'll be happy to answer additional software-developer-related questions on the -developers mailing list: http://groups.google.com/group/architect-developers

See you there,

-Jonathan

Great. "See" you at the meeting.

To answer your question, yes you will be able to map your data types to whatever you like. The process involves the use of either an XSLT stylesheet or a Velocity template (your choice). At the meeting, I will be demonstrating the XSLT approach, but when you get down to solving this problem, you might prefer to use Velocity.

-Jonathan

Interesting suggestion, and one you could easily implement and contribute back to the project!

If you aren't already signed up for next week's SQL Power Architect User Group meeting, I urge you to do so. I will be demonstrating the "Custom report template" feature, which, despite its name, could be used to save out your data model as YAML in whatever structure you wish.

-Jonathan

Also of note: MySQL's MYISAM storage engine does not support relations between tables at all. If you are using MYISAM, then you will have to create all joins manually in the SQL Power Wabit query builder (or any other query tool).

To specify a join manually:

1. click the "J" hook in the toolbar
2. click the key column in the parent table
3. click the related column in the child table

-Jonathan

Glad to hear you solved it. Thanks for the followup!

-Jonathan

The problem is the line

DDL Generator=ca.sqlpower.architect.ddl.SQLServerDDLGenerator

which points to the common base class for SQL Server DDL support. You'll need to choose either the SQL Server 2000 or 2005 DDL generators, which can be done from the Advanced tab of the JDBC drivers panel that I mentioned above.

It is a bug that the non-instantiable base class appears in the list, and I think that bug has already been filed in our bug tracker.

-Jonathan

Yes, it's apparently trying to create an instance of the "DDL Generator" class specified in your database type configuration.

Can you tell us what this is set to? The information should be under the "JDBC Drivers" panel, advanced tab. The field is called "DDL Generator."

If possible, it would be helpful to see the corresponding "[Database Types_#]" section for the database type in question from your pl.ini file.

-Jonathan