SQL Power Software Forum

I just committed a fix into the 0.9.8 development branch. I'll also backport it into the 0.9.7 branch so that you can test it with a more stable branch.

I've successfully tested it on a 64-bit Java Runtime on Windows 7 RC 64-bit, and on a 32-bit Java Runtime on Windows 7 32-bit.

-Jeff

Hi David,

I think I can help you out, but I'll need more detail on the nature of the new error that you're getting.

This may be wrong as the database is running and yet the listener is not finding a database with the SID of HR or ORCL.

Typically, you would've seen another error dialogue similar to the one that told you the JDBC driver was missing. If so, there should be a button on that dialogue that says something like 'Show more details'. Click on that button, and a detailed error message should appear.

You can try copying and pasting the contents of that error message into a reply to this thread. Also, the error message would usually have a corresponding Oracle error code. (ORA-#####)

Hi David,

The reason for the error is because the Oracle JDBC driver was not found.

We felt that Oracle's terms for redistributing their JDBC driver were too strong (my understanding is that we would be required to collect certain personal information from each downloader), so we decided not to include it. You can download the Oracle JDBC driver from their website.

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

You would then use the User Preferences, using the JDBC Drivers tab to point the Wabit to the location of the driver file. I believe all the details should be in the User Guide (which you can download as a PDF at http://wabit.googlecode.com/files/WabitUserGuide-0.9.7.pdf, or access 'Help' in the Wabit itself)

Hope that helps!

Hi there,

I'm not familiar with System Architect or what file format it uses to save projects. If it's just plain XML, we could probably use XSLT to convert it.

Another possibility is to take your System Architect data model and create it in a database, and then use Power*Architect's reverse engineering feature to extract the data model from the database.

You can also try some of the troubleshooting steps outlined here:

http://ora-12505.ora-code.com/

I believe your assessment is correct.

I've filed this issue in the project's issue tracker:
http://code.google.com/p/power-matchmaker/issues/detail?id=13

Unfortunately I haven't had a lot of time to work on DQguru lately, so I'm not sure when this issue would get fixed. It is possible though that if the real problem is code in the SQL Power library, which is shared amongst all our projects, our other projects may be affected as well, in which case, we may have to fix it sooner.

Thank you for reporting this issue!

I would not be surprised if this error is directly related to the previous error that occurred when deriving the merge rules. It's probable that the error resulted in the merge rules being in a bad state.

Hello there,

Unfortunately, we don't have anyone who speaks fluent Spanish, so I'm going to have to get by with Google Translate.

Here's what it gives me:

I have questions on the use of dqguru are used as tools soundex there another more complete manual, thank you and how to use the tool translational word that I use when I get an error:
java.lang.runtimeexception use and will not let me ever, your help will agradecere

From what I can gather, you seem to want better documentation on the different transformations available in DQguru. Unfortunately, existing documentation is a bit lacking right now. If it's the Soundex transformation that you want to know about, it is used to match two names that sound similar to each other as opposed to spelled. However, Soundex is based on English names and is unlikely to work well with Spanish names (or any non-English names), so I would not recommend using it.

As for the error you're running into, unfortunately we would require more information from you to determine the cause. One would be a step-by-step description of exactly what you did before the error occured. The other thing would be the detailed error information, which you can get by pressing the 'Show Details' button when the error occurs, copying the text that gets displayed, and posting it here.

Sorry that I don't speak Spanish, but I hope you can understand most of what I wrote.

The specific error you mentioned appears to be from executing an incorrectly generated SQL statement that the DQguru created.

I've never tried running DQguru in on a SQL Server 2005 instance in SQL Server 2000 mode, so I don't know if that has anything to do with the error.

Anyways, it's possible that the fix applied to the Wabit might have been applied to our common library code, so you could try one of the latest continuous build snapshots and see if it's fixed in there.

These are available at http://pag.sqlpower.ca:8080/hudson/job/power-matchmaker/

Here's a patch file version of eason's change.

This is the preferable way to submit code changes as opposed to sending us the .java files since this allows us to more easily see what has changed. IDEs like Eclipse and Netbeans provide ways of generating these patch files easily.

Hi eason,

Your code refers to a class called SQLSubmodel which is not in our code. Is this a new class that you created?

Hi Adam,

The error message says

The TCP/IP connection to the host has failed. java.net.UnknownHostException

This suggests to me that your machine cannot even connect the machine that's running the SQL Server instance you're trying to connect to.

You may want to make sure that you're specifying the correct hostname/IP address for the SQL Server machine.

Hi eason,

It's proving a bit difficult to find out what your code changes are in the files you posted. Even when I use diff on your source directory and mine, there seems to be some differences that are probably not related to your code change.

Rather than submitting your entire project, the ideal thing to do would be to create a patch file that only contains the differences between your code and the code we have in Subversion. It would be a much smaller file and it would be much easier to tell what changed between your version and the one we have in Subversion.

Java IDEs like Eclipse and Netbeans should have that functionality built in. If you need help with doing that, please let us know.

Did the error occur immediately after you pressed the 'Page Format' button?

Or did it happen after you opened it, changed some settings, and then tried to apply them? If so, do you recall which settings you changed?

I should note that I tested this to work with changing my page orientation and page size on Ubuntu 9.04 with the Power*Architect 0.9.13 release with Java 1.6 update 13.

You appear to be using Java 1.6 update 6, so I don't know if that could be the key factor?

Hi there,

Would you be able to provide us the following details?

What version of Power*Architect are you using?

What version of Java you are using?

What operating system you are using?

You can generally find this information by going to the Help Menu and then click on 'About' (or the Architect Menu and then 'About' if you're on a Mac)