Thread: [Squirrel-sql-users] Hibernate plugin configuration
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Manu_ <man...@li...> - 2007-12-18 07:34:54
|
Hello, I have a problem with the Hibernate plugin : I have a web application that works with Hibernate and I want to use my configuration files (hibernate.cfg.xml and xxx.hbm.xml) with the plugin. How can I configure the plugin to use this files ? Or if not possible, how can I bypass this to use the plugin on my database ? Thanks in advance, Manu -- View this message in context: http://www.nabble.com/Hibernate-plugin-configuration-tp14384514p14384514.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
From: Gerd W. <bir...@t-...> - 2007-12-19 23:49:02
|
Manu_ wrote: > Hello, > > I have a problem with the Hibernate plugin : I have a web application that > works with Hibernate and I want to use my configuration files > (hibernate.cfg.xml and xxx.hbm.xml) with the plugin. > > How can I configure the plugin to use this files ? > Or if not possible, how can I bypass this to use the plugin on my database ? This sounds like you could define your Hibernate configuration inside SQuirreL as follows: 1. On the Hibernate configuration tab add the directory that contains your hibernate.cfg.xml to the additional class path. 2. Do the same for all the library directories, jars, zips ... your applications uses. 3. Choose the topmost option to obtain a SessionFactorImpl. For more information about SQuirreL's Hibernate configurations, please have a look at the Hibernate Plugin's help. When your Hibernate configuration is done you should be able to connect to this configuration from inside your Session. Feel free to ask me if you have any further problems. Gerd |
From: Manu_ <man...@li...> - 2007-12-20 08:00:16
|
OK I found yesterday how to see the stack trace when an error occurs and then I could get the error cause. The problem was that my hibernate configuration file name was not exactly 'hibernate.cfg.xml', and the plugin search this name precisely. I changed the name and now all is working well. Thanks a lot for your help. Manu Gerd Wagner wrote: > > Manu_ wrote: >> Hello, >> >> I have a problem with the Hibernate plugin : I have a web application >> that >> works with Hibernate and I want to use my configuration files >> (hibernate.cfg.xml and xxx.hbm.xml) with the plugin. >> >> How can I configure the plugin to use this files ? >> Or if not possible, how can I bypass this to use the plugin on my >> database ? > > This sounds like you could define your Hibernate configuration inside > SQuirreL > as follows: > > 1. On the Hibernate configuration tab add the directory that contains your > hibernate.cfg.xml to the additional class path. > > 2. Do the same for all the library directories, jars, zips ... your > applications > uses. > > 3. Choose the topmost option to obtain a SessionFactorImpl. > > For more information about SQuirreL's Hibernate configurations, please > have a > look at the Hibernate Plugin's help. > > > When your Hibernate configuration is done you should be able to connect to > this > configuration from inside your Session. > > Feel free to ask me if you have any further problems. > > Gerd > > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services > for just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > -- View this message in context: http://www.nabble.com/Hibernate-plugin-configuration-tp14384514p14432227.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
From: Kreig, V. <Vivian.Kreig@Staples.com> - 2007-12-20 18:09:12
|
Hi, I must be overlooking something obvious here. I am using Squirrel 2.5 and would like to search through a package body for a particular stored procedure. The find option is disabled in the Sql query window. We have multiple stored procedures in one package. Does anyone know how to do this? I am scrolling through and it is tedious. Thank you, Vivian |
From: Robert M. <rob...@gm...> - 2007-12-20 19:58:46
|
On Dec 20, 2007 1:08 PM, Kreig, Vivian <Viv...@st...> wrote: > > Hi, > I must be overlooking something obvious here. > I am using Squirrel 2.5 and would like to search through a package body > for a particular stored procedure. The find option is disabled in the > Sql query window. We have multiple stored procedures in one package. > Does anyone know how to do this? I am scrolling through and it is > tedious. > So, Ctrl-F doesn't bring up the find dialog? (Are you using the netbeans editor configuration)? Also, how about the object tree - when you expand package, do you see your package and if so, how about the procedures beneath? If you click on a procedure there should be a source tab (assuming you have the Oracle plugin installed). Rob |
From: bdubb <bri...@gm...> - 2008-02-19 19:00:14
|
I am having difficulty as well setting up the Hibernate plugin. I've got a Mac OSX (10.4.11)... not sure if this matters. I believe I've got everything setup but am getting a Hibernate Exception: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException Caused by: org.hibernate.HibernateException: Hibernate Dialect must be explicitly set I do have the "hibernate.cfg.xml" file (project/hibernate.cfg.xml)... Is there a specific place I need to save it? In the root, in the src, in the classpath? thanks, brian Gerd Wagner wrote: > > Manu_ wrote: >> Hello, >> >> I have a problem with the Hibernate plugin : I have a web application >> that >> works with Hibernate and I want to use my configuration files >> (hibernate.cfg.xml and xxx.hbm.xml) with the plugin. >> >> How can I configure the plugin to use this files ? >> Or if not possible, how can I bypass this to use the plugin on my >> database ? > > This sounds like you could define your Hibernate configuration inside > SQuirreL > as follows: > > 1. On the Hibernate configuration tab add the directory that contains your > hibernate.cfg.xml to the additional class path. > > 2. Do the same for all the library directories, jars, zips ... your > applications > uses. > > 3. Choose the topmost option to obtain a SessionFactorImpl. > > For more information about SQuirreL's Hibernate configurations, please > have a > look at the Hibernate Plugin's help. > > > When your Hibernate configuration is done you should be able to connect to > this > configuration from inside your Session. > > Feel free to ask me if you have any further problems. > > Gerd > > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services > for just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > -- View this message in context: http://www.nabble.com/Hibernate-plugin-configuration-tp14384514p15562400.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
From: Gerd W. <bir...@t-...> - 2008-02-20 05:42:50
|
Hi Brian, this looks as if Hibernate can't automatically detect a dialect for your datatbase In you hibnernate.cfg.xml you can manually set a dialect in the following way: <property name="dialect">org.hibernate.dialect.HSQLDialect</property> You may need to Google for the right dialect of your database system. You may also try out a dialect that you think comes close to your databases SQL dialect. Hope this helps Gerd bdubb wrote: > I am having difficulty as well setting up the Hibernate plugin. I've got a > Mac OSX (10.4.11)... not sure if this matters. I believe I've got > everything setup but am getting a Hibernate Exception: > > java.lang.RuntimeException: java.lang.reflect.InvocationTargetException > Caused by: org.hibernate.HibernateException: Hibernate Dialect must be > explicitly set > > I do have the "hibernate.cfg.xml" file (project/hibernate.cfg.xml)... Is > there a specific place I need to save it? In the root, in the src, in the > classpath? > > thanks, brian > > > > Gerd Wagner wrote: >> Manu_ wrote: >>> Hello, >>> >>> I have a problem with the Hibernate plugin : I have a web application >>> that >>> works with Hibernate and I want to use my configuration files >>> (hibernate.cfg.xml and xxx.hbm.xml) with the plugin. >>> >>> How can I configure the plugin to use this files ? >>> Or if not possible, how can I bypass this to use the plugin on my >>> database ? >> This sounds like you could define your Hibernate configuration inside >> SQuirreL >> as follows: >> >> 1. On the Hibernate configuration tab add the directory that contains your >> hibernate.cfg.xml to the additional class path. >> >> 2. Do the same for all the library directories, jars, zips ... your >> applications >> uses. >> >> 3. Choose the topmost option to obtain a SessionFactorImpl. >> >> For more information about SQuirreL's Hibernate configurations, please >> have a >> look at the Hibernate Plugin's help. >> >> >> When your Hibernate configuration is done you should be able to connect to >> this >> configuration from inside your Session. >> >> Feel free to ask me if you have any further problems. >> >> Gerd >> >> >> ------------------------------------------------------------------------- >> SF.Net email is sponsored by: >> Check out the new SourceForge.net Marketplace. >> It's the best place to buy or sell services >> for just about anything Open Source. >> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> >> > |