<< Arrest that man! He had built workaround a technical limitaion! | Home | NHibernate Query Generator 1.9 is out! >>

NHibernate Query Analyzer for NHibernate 1.2 GA

I am a bit late with this one, but here is a new version for NHibernate 1.2 GA. This also supports Castle Active Record, hopefully in a version neutral way.

You can get it here, or admire the UI here:

image

As an aside, I am thinking about adding Criteria Query functionality, since this is something that I use a lot. I am not sure yet what form this would take, at any rate it would involve runtime code generation, so that is complex (and sort of fun/pain).

I am opened to ideas.

Have fun...

Print | posted on Saturday, June 02, 2007 10:55 PM

Feedback

Gravatar

# re: NHibernate Query Analyzer for NHibernate 1.2 GA 6/3/2007 1:10 AM Bob Grommes

Hi Ayende,

Just a note for your next release -- the status bar should read "Project was built successfully". ;-)

Looks like some great stuff!

Gravatar

# re: NHibernate Query Analyzer for NHibernate 1.2 GA 6/3/2007 1:20 AM Ayende Rahien

Thanks for noticing, I fixed it in the source, will be there for next release.

Gravatar

# re: NHibernate Query Analyzer for NHibernate 1.2 GA 6/3/2007 9:24 AM raul

Hello Ayende,

This seems like a very nice tool, but unfortunately I'm having problems with the documentation. The link in the app [Help->Online Doc] is broken. Can you give a link to the docs please?

Gravatar

# re: NHibernate Query Analyzer for NHibernate 1.2 GA 6/3/2007 10:21 AM Miki Watts

Hi Ayende,

I'm using ActiveRecord, and setting the base settings programmatically, like this:

Hashtable properties = new Hashtable();

properties.Add("hibernate.connection.driver_class", "NHibernate.Driver.SqlClientDriver");
properties.Add("hibernate.dialect", "NHibernate.Dialect.MsSql2000Dialect");
properties.Add("hibernate.connection.provider", "NHibernate.Connection.DriverConnectionProvider");
properties.Add("hibernate.connection.connection_string", connectionString);

ActiveRecordConfiguration source = new ActiveRecordConfiguration();
source.Add(typeof(ActiveRecordBase), properties);

ActiveRecordStarter.Initialize(typeof(Initializer).Assembly, source);

Would there be an option to specify at least those base settings in the project settings manually ?

Gravatar

# re: NHibernate Query Analyzer for NHibernate 1.2 GA 6/3/2007 10:51 AM Ayende Rahien

Miki,
No, there isn't any. You need to provide an app.config or a hibernate.cfg.xml file with the configuration

Gravatar

# re: NHibernate Query Analyzer for NHibernate 1.2 GA 6/3/2007 3:54 PM Steve

Sorry for my ignorance, but when I double click on the .exe a quick cmd box pops up and then nothing happens.

I don't get the nice UI I see above.

Thanks

Gravatar

# re: NHibernate Query Analyzer for NHibernate 1.2 GA 6/3/2007 4:28 PM Ayende Rahien

Steve,
Are you sure that you have no downloaded NHibernate query GENERATOR ?

Gravatar

# re: NHibernate Query Analyzer for NHibernate 1.2 GA 6/3/2007 7:57 PM Steve

That explains it - thanks

Gravatar

# re: NHibernate Query Analyzer for NHibernate 1.2 GA 6/4/2007 8:39 PM Mike

When I New>>Project>>AddFile and bring in my *.hbm.files then try to 'Build Project' I get an unhandled SQLite exception...when I debug it says 'no such table: hibernate_unique_key'.
I have seen this when settin gthe conn string to 'New=True' but your exe.config is using New=False so that isn't it.
Any idea what I'm doing wrong?

Gravatar

# re: NHibernate Query Analyzer for NHibernate 1.2 GA 6/8/2007 4:02 PM AsbjornM

I have the same error as Mike, but then again, this is my first try.
Could it be possible that you could provide an small easy mapping and configuration file so we could test it with?
I don't know what to put inside the configurationfile, and have been looking here: http://www.hibernate.org/362.html but it does not look like it's even close..
Some sort of easy getting started like that document, using this tool would be nice.
Maybe it already exsists, but I don't know where to look.

Gravatar

# re: NHibernate Query Analyzer for NHibernate 1.2 GA 7/8/2007 1:02 AM Oleg

I have the same issue as two guys above. Can it be related to the fact that I use MS SQL Express 2005?

Gravatar

# re: NHibernate Query Analyzer for NHibernate 1.2 GA 7/8/2007 9:06 AM Oleg

The following solution to avoid the exception "unhandled SQLite exception: 'no such table: hibernate_unique_key'" should be applied:
go to <%APPDATA%\NHibernate Query Analyzer> folder and delete Sqlite.db.

Gravatar

# re: NHibernate Query Analyzer for NHibernate 1.2 GA 7/10/2007 12:38 AM Yamini

Hello,

I do not find the file SQLite.db in the above mentioned path and still get the same error. Do I need to create the SQLite.db ?

Comments have been closed on this topic.