RE: [Hibernate] Mass Deletes
I got in on this thread late, but if I understand what people are talking about, the
select-then-delete model doesn't work well on large datasets. This is one of the
drawbacks to
Entity Beans for our organization. Trying doing that model for 10K rows and you
quickly see how
much that extra statement costs you when you can do it in less than a second with a
simple delete.
Patrick
--- Odd Moller <[EMAIL PROTECTED]> wrote:
> I don't understand the drawbacks with the select-then-delete alternative.
> Doesn't it just mean one additional statement to the database?
>
> ///Odd Moller
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: den 4 augusti 2003 05:36
> To: [EMAIL PROTECTED]
> Subject: [Hibernate] Mass Deletes
>
>
> Many users have asked for
>
> session.delete("from Foo foo where foo.count=0");
>
> to issue a single SQL DELETE. This is certainly not possible for objects
> with collections or cascades (though it might not matter if we ignore
> Lifecycle callback; not sure). For other classes it is conceptually
> possible.
>
> Now, this is really quite easy to implement - it would take me about 1-2
> hours to do it.
>
> But my big problem is: how do we know which _loaded_ objects were deleted?
> I don't think there is any good way to do this. All we get back from DELETE
> is a row count.
>
> * Do we issue a SELECT beforehand, to fetch the ids . and then issue
> the delete?
> * Do we just disable mass delete for classes which have loaded instances?
> * Is it simply not worth it?
>
> The select-then-delete option doesn't seem particularly better than the
> current situation when JDBC batch updates are enabled. The
> disable-when-instances-are-loaded option looks like it would work, but only
> for some very limited usecases (though it may work for the usecases we are
> most interested in).
>
>
> Thoughts?
>
>
> **
> Any personal or sensitive information contained in this email and
> attachments must be handled in accordance with the Victorian Information
> Privacy Act 2000, the Health Records Act 2001 or the Privacy Act 1988
> (Commonwealth), as applicable.
>
> This email, including all attachments, is confidential. If you are not the
> intended recipient, you must not disclose, distribute, copy or use the
> information contained in this email or attachments. Any confidentiality or
> privilege is not waived or lost because this email has been sent to you in
> error. If you have received it in error, please let us know by reply
> email, delete it from your system and destroy any copies.
> **
>
>
>
>
>
>
> ---
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa0013ave/direct;at.aspnet_072303_01/01
> ___
> hibernate-devel mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/hibernate-devel
>
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa0013ave/direct;at.aspnet_072303_01/01
___
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
RE: [Hibernate] Mass Deletes
So the select would be to get the just the IDs affected so Hibernate can figure out if
any
currently loaded objects need to be marked as deleted? And then a delete to blow the
rows away? I
like that, as it is more efficient than the Entity Bean model, but allows for object
caching in
memory.
Thanks,
Patrick
--- [EMAIL PROTECTED] wrote:
>
> No! That is NOT what we are suggesting. It would be just two SQL
> statements.
>
>
>
> |-+--->
> | | Patrick Burleson|
> | | <[EMAIL PROTECTED]>|
> | | Sent by:|
> | | [EMAIL PROTECTED]|
> | | ceforge.net |
> | | |
> | | |
> | | 04/08/03 11:44 PM |
> | | |
> |-+--->
>
>
>--|
> |
>
> |
> | To: [EMAIL PROTECTED]
> |
> | cc:
>
> |
> | Subject: RE: [Hibernate] Mass Deletes
>
> |
>
>
>--|
>
>
>
>
> I got in on this thread late, but if I understand what people are talking
> about, the
> select-then-delete model doesn't work well on large datasets. This is one
> of the drawbacks to
> Entity Beans for our organization. Trying doing that model for 10K rows and
> you quickly see how
> much that extra statement costs you when you can do it in less than a
> second with a simple delete.
>
>
> Patrick
>
> --- Odd Moller <[EMAIL PROTECTED]> wrote:
> > I don't understand the drawbacks with the select-then-delete alternative.
> > Doesn't it just mean one additional statement to the database?
> >
> > ///Odd Moller
> >
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Sent: den 4 augusti 2003 05:36
> > To: [EMAIL PROTECTED]
> > Subject: [Hibernate] Mass Deletes
> >
> >
> > Many users have asked for
> >
> > session.delete("from Foo foo where foo.count=0");
> >
> > to issue a single SQL DELETE. This is certainly not possible for objects
> > with collections or cascades (though it might not matter if we ignore
> > Lifecycle callback; not sure). For other classes it is conceptually
> > possible.
> >
> > Now, this is really quite easy to implement - it would take me about 1-2
> > hours to do it.
> >
> > But my big problem is: how do we know which _loaded_ objects were
> deleted?
> > I don't think there is any good way to do this. All we get back from
> DELETE
> > is a row count.
> >
> > * Do we issue a SELECT beforehand, to fetch the ids . and then
> issue
> > the delete?
> > * Do we just disable mass delete for classes which have loaded
> instances?
> > * Is it simply not worth it?
> >
> > The select-then-delete option doesn't seem particularly better than the
> > current situation when JDBC batch updates are enabled. The
> > disable-when-instances-are-loaded option looks like it would work, but
> only
> > for some very limited usecases (though it may work for the usecases we
> are
> > most interested in).
> >
> >
> > Thoughts?
> >
> >
> > **
> > Any personal or sensitive information contained in this email and
> > attachments must be handled in accordance with the Victorian Information
> > Privacy Act 2000, the Health Records Act 2001 or the Privacy Act 1988
> > (Commonwealth), as applicable.
> >
> > This email, including all attachments, is confidential. If you are not
> the
> > intended recipient, you must not disclose, distribute, copy or use the
> > information contained in this email or attachments. Any confidentialit
Re: [Hibernate] Recommended JDBC drivers for MS SQL?
The Hibernate page lists "date-handling" issues with the MS/DataDirect driver. What sort of date-handling issues? We use a rebranded DataDirect driver that comes with Jrun and have had virtually no issues with that driver. And we move a lot of data around. Thanks, Patrick --- Serge Knystautas <[EMAIL PROTECTED]> wrote: > We've been using the Inet Software's for years and have had great > success in a number of environments (including hibernate). Not too > expensive either. I similarly have never had much success with > Microsoft's JDBC driver. > > http://www.inetsoftware.de > > -- > Serge Knystautas > President > Lokitech >> software . strategy . design >> http://www.lokitech.com > p. 301.656.5501 > e. [EMAIL PROTECTED] > > Timothy Kettering wrote: > > I've always done development with Hibernate w/ MySQL, but this new > > contract I just received, they're requesting to have the database on a > > MS SQL server. I checked the hibernate site, and the only thing it says > > is NOT to use the Microsoft provided JDBC driver. > > > > So I'm asking for a bit more information.. is the afforementioned still > > true? Do any of you have positive experiences with a specific > > commercial JDBC driver that would be recommended for use with MS SQL? > > The client is willing to pay, but I don't want to make them pay any more > > money than they have to. Thanks. > > > > --- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa0013ave/direct;at.aspnet_072303_01/01 > ___ > hibernate-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hibernate-devel __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com --- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa0013ave/direct;at.aspnet_072303_01/01 ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] How to use Hibernate in WSAD5
It looks like the support Jars (in this case commons-lang.jar) aren't in your WEB-INF/lib directory or in the CLASSPATH of the server. They need to be in one of those places. Good luck, Patrick --- Yin Shi <[EMAIL PROTECTED]> wrote: > Hi friends, > > I am using WSAD5. > > I am new to Hibernate, and I tried to use it in a pure Java project, and ran it by a > Java Application (has main class), which was ok. > > But when I tried it in a Web Application, write a servlet to access the Hibernate, > every time it just failed, the error message is: "Failed to load servlet: > java.lang.NoClassDefFoundError: org/apache/commons/lang/exception/NestableException". > > By the way, I am trying the quick start example using Tomcat 4.1 and Hibernate2 > provided in the Hibernate home page, the difference is I want to use it in WSAD5. I > just could not get it working. I think "sessionFactory = new > Configuration().configure().buildSessionFactory();" caused the problem, but I am not > sure how to fix it. I did not have .properties file, I wander if I need it or not? > > Just wander does anyone have simple examples how to use Hibernate in a Web > Application > in WSAD5? > > Here is my cfg.xml > __ > > > DTD//EN" > > "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd";> > > > > > >name="hibernate.connection.driver_class">COM.ibm.db2.jdbc.net.DB2Driver > jdbc:db2:JDO > admin > admin > true > true > net.sf.hibernate.dialect.DB2Dialect > > > > > > > > --- > > Thanks for all you helps! > > > __ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > > > --- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa0013ave/direct;at.aspnet_072303_01/01 > ___ > hibernate-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hibernate-devel __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com --- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa0013ave/direct;at.aspnet_072303_01/01 ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] Log4J for debugging hibernate
Here is the log4j "Short Manual" from the Log4j site. It covers the .properties file in it. Log4j is quite easy to configure and after reading these docs you should be up and running in a few minutes. http://jakarta.apache.org/log4j/docs/manual.html Thanks, Patrick --- Prasad Iyer <[EMAIL PROTECTED]> wrote: > Hi, > Can anybody give me "log4j.properties" file for debugging Hibernate+tapestry > module plus any other required configuration if required please. > I am stuck. I don't know Log4J. > Help would be highly appreciated. > regards > prasad chandrasekaran > > > > --- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa0013ave/direct;at.aspnet_072303_01/01 > ___ > hibernate-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hibernate-devel __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com --- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa0013ave/direct;at.aspnet_072303_01/01 ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] Where to put hibernate.cfg.xml
It needs to be in the CLASSPATH somewhere. I put mine in WEB-INF/classes and it seems to work well. Thanks, Patrick --- Yin Shi <[EMAIL PROTECTED]> wrote: > Hi, I am using WSAD5 and Hibernate2, I do not know where to put the .cfg.xml file, > because I tried to put it in every directory, they are not working at all. Do you > know > where to put it? > > I just have a Web Project, inside the Java Source, I have a java class Cat.java > (setter/getter), and a servlet to get the Hibernate session, when I call > " > Configuration conf = new > Configuration().configure().addClass(net.sf.hibernate.examples.quickstart.Cat.class); > > ", > > it always gives me an error message saying that " > 3100cb4a Configuration I net.sf.hibernate.cfg.Configuration Configuration resource: > /hibernate.cfg.xml > 3100cb4a Configuration W net.sf.hibernate.cfg.Configuration /hibernate.cfg.xml not > found > 3100cb4a WebGroup E SRVE0026E: [Servlet Error]-[/hibernate.cfg.xml not found]: > net.sf.hibernate.HibernateException: /hibernate.cfg.xml not found > at > net.sf.hibernate.cfg.Configuration.getConfigurationInputStream(Configuration.java:708) > > " > > This is my cfg.xml > -- > > > DTD//EN" > > "C:\hibernate-configuration-2.0.dtd"> > > > > > > name="hibernate.connection.driver_class">COM.ibm.db2.jdbc.net.DB2Driver > jdbc:db2:JDO > admin > admin > true > true > net.sf.hibernate.dialect.DB2Dialect > > > > > > > > > > So could anyone help me? > > Thanks a lot! > > > __ > Do you Yahoo!? > The New Yahoo! Search - Faster. Easier. Bingo. > http://search.yahoo.com > > > --- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa0013ave/direct;at.aspnet_072303_01/01 > ___ > hibernate-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hibernate-devel __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com --- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa0013ave/direct;at.aspnet_072303_01/01 ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] CVS access
Les, I think the 2.1 stuff is on a branch in the CVS repository called v21branch. Set your working copy to point at that branch and I think you are good to go. Thanks, Patrick --- Les Hazlewood <[EMAIL PROTECTED]> wrote: > Hiya folks, > > I'd like to start participating in development. How can I get anonymous CVS > access to the 2.1 development tree? I didn't see a specific module name > listed on the Sourceforge CVS page... > > I'd like to be able to do my cvs update everytime I work on the tree to make > sure that I'm in sync with the developers... (then I could provide > up-to-date patches ;) ) > > Thanks, > > Les > > > --- > This SF.net email is sponsored by: VM Ware > With VMware you can run multiple operating systems on a single machine. > WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines > at the same time. Free trial click here:http://www.vmware.com/wl/offer/358/0 > ___ > hibernate-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/hibernate-devele.net > https://lists.sourceforge.net/lists/listinfo/hibernate-devel __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com --- This SF.net email is sponsored by: VM Ware With VMware you can run multiple operating systems on a single machine. WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the same time. Free trial click here:http://www.vmware.com/wl/offer/358/0 ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] MS SQL performance and Unicode
Even more fun info here, is that if your JDBC driver (like say the DataDirect driver) uses NVARCHAR parameters with maximum widths (4000), SQL Server 7.0 will take forever to give you results. In our case, from 1 second using a VARCHAR (or even a shorter NVARCHAR) to 18 seconds. This problem doesn't appear in SQL Server 2000. Now, the part about not using an index I have no idea about. Would be interesting to investigate. Thanks, Patrick __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com --- This SF.net email is sponsored by: VM Ware With VMware you can run multiple operating systems on a single machine. WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the same time. Free trial click here:http://www.vmware.com/wl/offer/358/0 ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] DBCP Connection Pooling (OT)
At 05:16 AM 8/29/2003 +1000, Gavin King wrote: I think its better to direct these questions to the dbcp guys; dbcp is, as is usual for Jakarta stuff, extremely undocumented - but _someone_ must know the answers to these questions. So you to have noticed how most Jakarta projects aren't documented well...funny, Torque's lack of good docs is what got me looking at Hibernate. :-) (Yes, I realize Torque is now apart of Apache DB, but it came from an even worse documented project in Jakarta, Turbine) And to those in those projects who say "If you don't like the docs, then write some yourself", I have this to say: It's hard to explain to my boss why I am staring at source code writing docs when I am supposed to be trying to evaluate a product for our usage. So in my case, bad docs get you dropped from contention pretty quickly. And the core developers (or people with the time) or the only ones that can write the documentation needed by normal people like me. Thanks, Patrick --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] DBCP Connection Pooling (OT)
At 08:40 AM 8/29/2003 -0400, Serge Knystautas wrote: Put the other shoe on... jakarta developers have the same set of bosses/wives/children who don't accept explanations of needing to write docs. Actually, my boss gets quite irate if I don't document things so that someone can come in and use our software. But I also see your point, as I have a wife who would rather have me spending time with her than my computer. :-) If anything, I think it's a tribute to how good of a job the Hibernate committers are for doing this. As having been one of those lothesome Jakarta committers, who has told so many people that if they want something fix/doc'd to fix/doc it, I really appreciate how much Max, Gavin, Christian, et al do. I think I my implicit idea was how much I appreciate how well Hibernate is documented. I have found only one place where the docs didn't live up to reality. (And I might even submit a patch to them to make it clearer) This implies you'd prefer people didn't donate source code unless they are prepared to doc it and meet other requirements. I would rather have the code in contention and then quickly dropped rather than never had that opportunity. I agree that value(docs) >= value(code), so you try to help when you can. I agree that having the opportunity to have access to code with no docs is much better than that code having never been available. I greatly appreciate the contributions of the Jakarta projects and use them a lot in my personal projects. I just get very frustrated when there aren't docs or the docs are wrong. Cause then convincing my boss that we should use it becomes that much harder. Patrick --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] Nested Transaction
At 08:19 PM 8/29/2003 +0530, Prasad Iyer wrote:
What can I say?
Thanks Sir for your valuable time.
regards
prasad chandrasekaran
I sense great sarcasm there, but Christian's response is pretty good. If
you start a transaction and create a parent, then create children, and one
of the children fails, you rollback the transaction and the parent object
won't be created either. And that's not a Hibernate thing. That's a RDBMS
thing. Hibernate just provides a nice interface into it.
An example would be (Please excuse any syntax or API errors, doing this one
from memory):
try
{
Session session = SessionFactory.getSession();
Transaction tx = session.startTransaction();
Parent parent = new Parent();
Child child = new Child();
parent.getChildren().add(child);
tx.commit();
}
catch(Exception e)
{
if( tx != null )
{
tx.rollback();
}
}
finally
{
session.close();
}
If you haven't already done so, I would look into a SQL book. I found the
following one quite helpful:
http://www.amazon.com/exec/obidos/tg/detail/-/0201703092/qid=1062203306/sr=8-3/ref=sr_8_3/103-7047765-0401466?v=glance&s=books&n=507846
Did that help you answer your question?
Thanks,
Patrick
---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
RE: [Hibernate] CVS Problems
At 01:51 PM 9/10/2003 -0700, Schnitzer, Jeff wrote: > From: Michael Gloegl [mailto:[EMAIL PROTECTED] > > when trying to connect to the CVS I constantly get "EOF from Server" and > "Connection Reset by Peer" errors. Is anyone else having such problems > in the moment? Yes. I was getting them yesterday too. (using anonymous cvs) Jeff Schnitzer [EMAIL PROTECTED] I think it has to do with SF.net throttling the amount of pserver connections to the non-developer access CVS Server. I got it for a long time, and then I go through finally. It just takes time, keep trying. Patrick --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] bad performance during flush and help is needed.
At 08:15 PM 9/12/2003 +1000, Gavin King wrote: Forget about the 500 transactions. The problem is this: with 300-500 objects in the session cache, a single transaction( with an single object inserted) takes about one second. It simply does *not* take a second to dirty check 500 objects, dude. Nowhere even close. If you think you can prove that it does, send my the code to demonstrate this. It would have to be some kind of bug. I certainly agree. I have had 100,000 objects in a Collection (I am assuming internally Hibernate is doing about the same), and looped over them doing all sorts of math and creating new objects and that code took less than a half a second. There must be something else going on. Patrick --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] some performnace metric for the dirty check during hibernate flush.
At 02:29 AM 9/16/2003 -0700, jiesheng zhang wrote:
---test logic
1. load some (n) number of objects in memory.
2. begin tranaction.
3. // do not do anything here.
4. commit.
Then calculate the time consumed from step 2 and 4.
test code -
List ps=new ArrayList(10010);
for (int i=1000; i<2100; i++)
{
Parent p1=(Parent)session.load(Parent.class, new
Long(i));
p1.getValues().size();
}
long startTime=System.currentTimeMillis();
Transaction tx=session.beginTransaction();
tx.commit();
long endTime=System.currentTimeMillis();
System.out.println("total time(in
ms):"+(endTime-startTime));
-The performance metics-
objects in memory time (in ms) for dirty check (3
experiments)
1 741, 751,821
2000200, 230, 230
1000201, 191, 190,
100 30, 30, 30
1 10, 10, 10
jason
This is a lot better than your original statements to the list. You were
originally quoting 1 second per object for transaction commit. Now you are
doing 1 in less than a second. Also, you would need to test to see how
long just the .beginTransaction() and .commit() methods are taking,
disregarding a dirty check. In other words, don't load any objects. Just do
the last part of your code and see what you get.
Patrick
---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] more cvs repository
The last I read on this a little while back was that SF is limiting access to anonymous logins...that you will get connection issues. I just keep trying and I eventually get through. Plus the SF anonymous CVS servers are a day behind the developer access servers. I don't know if that has changed, but if it hasn't, that could explain what you are seeing. Thanks, Patrick At 05:17 AM 10/13/2003, khote wrote: Any news on when the hibernate direcectory will be available on sourceforge? I've already downloaded the nightly tarball, that's not the issue. It's been at least a week. I filed a report on sourceforge as well. Anybody in particular I can contact about this, to find out when? I'm unfortunately being held up on my project because of a bug in it ... blah blah, you've all been there before. --- This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net hosts over 70,000 Open Source Projects. See the people who have HELPED US provide better services: Click here: http://sourceforge.net/supporters.php ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel --- This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net hosts over 70,000 Open Source Projects. See the people who have HELPED US provide better services: Click here: http://sourceforge.net/supporters.php ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] Hibernate and Oracle XML datatype
grendelAI wrote: Does Hibernate support Oracle's XML Data type? I have a table with a xml data type field that I need to query based on values in the xml document stored. Can Hibernate facilitate the sql? Probably more a question for the forums and not the dev list, but you might want to look at creating your own UserType. Thanks, Patrick --- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] Version Jars Update
Eric Pugh wrote: 1) Ant in CVS is recorded as being at 1.5.3. It is 721k file, so I renamed it ant-1.5.3.jar. Just as an FYI, on ibiblio at [1] there is a version called ant-1.5.3-1.jar that is 721k as well. If ant was a runtime requirement, I would suggest that we use that version, to simplify life for people who use Maven to download the hibernate dependencies, but since it is build time, I think it is fine to keep calling our version of ant 1.5.3. 3) optional.jar. I renamed optional.jar to ant-optional-1.5.3.jar to clarify that it is used by ant, and to match the ibiblio naming. [1] Eric, To help out, I downloaded the jars from ibiblio and compared them with the jars in Hibernate CVS, and they match exactly...or at least according to Beyond Compare. Patrick --- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] Version Jars Update
Eric Pugh wrote: Thanks.. The confirmation that they all match between IBiblio and the local repo is good! On to the HibernateExt updates! Eric To be more accurate, I should have said "The two ant jars in question match exactly". Although I could run the gauntlet and compare them all. Might make that tonight's project. :-) Patrick --- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] Proxy Code for MSSQL Driver for Hibernate
Christian Bauer wrote: On 09 Feb (11:57), Eric Pugh wrote: There have been at least two instances where the usage of Microsofts JDBC driver has conflicted with Hibernate. Thats why the driver should be fixed, not wrapped. Use a different driver or file a bug report at MS. They have 50B in cash, should be easy to get someone to fix it. I think the MS Driver is actually the Data-Direct driver. You could file a bug report with them and it might get fixed faster. --- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn ___ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
[Hibernate] Sequence query on Postgresql
I opened two JIRA requests regarding sequence selects (with provided patches) for the Postgresql Dialect. They have both been closed, with only Hibernate 3 getting the fix. Gavin closed the Hibernate 2 one after he added the sequence queries to a bunch of dialects. Then Michael Gloegl closed the Hibernate 3 one noticing Gavin had already done the fix. I just don't want the fix for Hibernate 2 to fall through the cracks. It would be really nice to see this in 2.1.8 as it will put to an end all the problems I have with SchemaUpdate on Postgresql. The issues in question are: http://opensource.atlassian.com/projects/hibernate/browse/HHH-95 and http://opensource.atlassian.com/projects/hibernate/browse/HB-1390 Thanks, Patrick --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel
[Hibernate] Re: Sequence query on Postgresql
On Fri, 28 Jan 2005 14:03:24 -0500, Patrick Burleson <[EMAIL PROTECTED]> wrote: > I opened two JIRA requests regarding sequence selects (with provided > patches) for the Postgresql Dialect. They have both been closed, with > only Hibernate 3 getting the fix. > > Gavin closed the Hibernate 2 one after he added the sequence queries > to a bunch of dialects. Then Michael Gloegl closed the Hibernate 3 one > noticing Gavin had already done the fix. > > I just don't want the fix for Hibernate 2 to fall through the cracks. > It would be really nice to see this in 2.1.8 as it will put to an end > all the problems I have with SchemaUpdate on Postgresql. > > The issues in question are: > > http://opensource.atlassian.com/projects/hibernate/browse/HHH-95 > > and > > http://opensource.atlassian.com/projects/hibernate/browse/HB-1390 > > Thanks, > Patrick > Well, since I see 2.1.8 it out, I'm guessing this didn't make it in. Are there more releases planned in the 2.1.x line? Thanks, Patrick --- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl ___ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel
[Hibernate] Could someone please reopen HB-1390?
I just wanted to bring to the developer's attention that HB-1390 has not actually been applied to Hibernate 2, just Hibernate 3. The issue is erroneously marked as a duplicate. I know Hibernate 3 is the focus, but this is fix goes a long way towards making SchemaUpdate that much better working with Postgresql. http://opensource.atlassian.com/projects/hibernate/browse/HB-1390 Thanks, Patrick --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] Can I post general questions here?
I would check the forum: http://forum.hibernate.org/ Patrick On Tue, 1 Mar 2005 13:24:40 -0800 (PST), J. Jeff Roberts <[EMAIL PROTECTED]> wrote: > I know that firebird-devel is only for people working on the code of > the project itself, but I don't see a more general list for Hibernate. > > Where should I post questions about problems I'm having getting > Hibernate 3.0 to work with Firebird 1.5.2 ? > > Thanks, > -Jeff > > __ > Do you Yahoo!? > Yahoo! Mail - now with 250MB free storage. Learn more. > http://info.mail.yahoo.com/mail_250 > > --- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > ___ > hibernate-devel mailing list > hibernate-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > --- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click ___ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel
Re: [Hibernate] org.hibernate.HibernateException: Not able to obtain connection
You should ask this question in the user forum: http://forum.hibernate.org/ On 9/13/05, 梁炳場 <[EMAIL PROTECTED]> wrote: > At 1st, Hibernate can retrieve records when "getUserProfileList" is run. > After addition of record and then "getUserProfileList" is run again. > The following error messages display. > > Why is it so?? Is the configuration not okay? > > > org.apache.jasper.JasperException: org.hibernate.HibernateException: > Not able to obtain connection > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:370) > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291) > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > > root cause > > java.lang.RuntimeException: org.hibernate.HibernateException: Not able > to obtain connection > com.erp.hibernate.UserProfileService.getUserProfileList(UserProfileService.java:182) > org.apache.jsp.user.addUserProfile_jsp._jspService(org.apache.jsp.user.addUserProfile_jsp:120) > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322) > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291) > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) > javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > > > --- > SF.Net email is sponsored by: > Tame your development challenges with Apache's Geronimo App Server. Download > it for free - -and be entered to win a 42" plasma tv or your very own > Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php > ___ > hibernate-devel mailing list > hibernate-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > --- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server. Download it for free - -and be entered to win a 42" plasma tv or your very own Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php ___ hibernate-devel mailing list hibernate-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hibernate-devel
