SQL Power Software Forum

I got an SQL run-time error then I was running a cleanse job, although it tells me what the Oracle error code was, but still I have no clue why that happened. I need more information about the SQL like statement, values in the statement etc.

in my cleanse project, I found that the output table graph does not refresh (switch to other screen then switch back) properly if I have one and only one 'wire' connect to it.

actually, that's 2 minor bugs:
1. I have some views in a database, but not in the project, (btw, when can we have the view management in the architect?), when I run the compare DM, the architect generated code that tried to drop the views, but the syntax is 'dop table xxx'.
2. in my project, the column data type is integer (10), after created the table in oracle, the architect shows the column data type is number(10), which is correct in oracle, but every time I do compare DM, the architect tries to alter table and modify the data type to number(10), which is not necessary.

Just a quick test on the compare DM, the architect does not drop or create sequence, so it would NOT be a problem when running the script, but I wonder is it because the architect can't see sequence or it's smart enough not to touch the sequence? I think the architect just can't 'see' the sequence for now.
BTW, I have to post another bug of the compare DM function, just found it during the test.

you can double click on the execute button in the forward engineer dialog.

in my project, some columns use sequence for auto-increment, they have the sequence name in the text-field, when I do the foreword engineer, (in Oracle, not the first time), the architect did not drop the sequences that already exist, but tried to execute the create sequence statement directly, although it doesn't cause any functional problem, but the architect tells you some errors in the sql execution, you don't get 100% statements run successfully, and the sequence values are old.

can we have the build # and date-time in the about dialog? It hard to remember the detail version for us who use nightly build lot.

I found some bugs relate to the power*dashboard related data function:

1. the column name of the related data table sometime saved in lower case, that makes that line of related data setup invisible, unchangeable, undeletable, and it wouldn't show up in the dashboard view.
2. in the popup window of related data, most of the window size is taken by the mete-data, that's useless for the end-user, how about put the description in the window title and hide the mete-data.
3. the dashboard should support custom SQL instead of just database table in the setup of related data.

I have a project that need a larger display area than the playpen, when I open the project, the playpen does not adjust properly to show scrollbars, until I resize the window a bit, then the scrollbars show up. I think we need to refresh the playpen up on project file open.

If the engine did not return any error, then you should check your dashboard display settings.

that looks like you are missing the DASH_DEMO in your pl.ini, could you verify that by open the 'database connections' setup dialog in the front-end?

I had the same problem, but also solved it, here is how I did:

the cause is the JRE version, for example, if you have Oracle installed on your machine, oracle may change you file search path and put an old JRE(in Oracle folder) at the beginning of the path. you need to make sure the kettle software uses the newest version of JRE on your machine, what you need to do is open the spoon.bat file (or other bat file that you want to run), look for a line like this:
REM set PATH=C:\j2sdk1.4.2_01\bin;.;%PATH%
uncomment it by removing "rem", then replace "C:\j2sdk1.4.2_01\bin" with the real path of the JRE on your machine, something looks like this:
"C:\Program Files\Java\jre1.6.0_03\bin", then try to run it again.

Hi

I downloaded the matchmaker and installed it, everything looks good, but it won't run, the log file looks like this:
0 [main] INFO ca.sqlpower.architect.ArchitectUtils - Log4J configured successfully
93 [AWT-EventQueue-0] INFO ca.sqlpower.matchmaker.prefs.PreferencesManager - Create PreferencesManager singleton
109 [AWT-EventQueue-0] INFO ca.sqlpower.sql.PlDotIni - Beginning to read/merge new pl.ini data
156 [AWT-EventQueue-0] INFO ca.sqlpower.sql.PlDotIni - Finished reading file.
156 [AWT-EventQueue-0] INFO ca.sqlpower.sql.PlDotIni - Beginning to read/merge new pl.ini data
218 [AWT-EventQueue-0] INFO ca.sqlpower.sql.PlDotIni - Finished reading file.
656 [AWT-EventQueue-0] ERROR ca.sqlpower.matchmaker.dao.hibernate.MatchMakerHibernateSessionContext - HSQLDB Driver File missing: builtin:hsqldb-1.8.0.9.jar
671 [AWT-EventQueue-0] ERROR ca.sqlpower.swingui.SPSUtils - dialog parent component null is neither JFrame nor JDialog

what might be the problem? I have the hsdb jdbc jar file in the jdbc folder (installed by matchmaker),
thanks,

are you sure that is the ODBC engine? because the ODBC engine should have that fixed.

how did you change that (the file path)?