What's the difference between  and  using hibernate and sessionFactory?
31852
Hibernate has a handful of methods that, one way or another, takes your object and puts it into the database. What are the differences between them, when to use which, and why isn't there just one intelligent method that knows when to use what?  The methods that I have identified thus far are:   save() update() saveOrUpdate() saveOrUpdateCopy() merge() persist()
51479
Having read the threads  and  I am wondering for classes such as SqlConnection or one of the several classes inheriting from the Stream class does it matter if I close Dispose rather than Close?
29674
Why do we need an init() method in servlet? Can't we use the constructor to initialization?
73695
I've used all three of these when making local programmatic connections to databases. Is there any real difference between them?
9337
Is there a way to get the (to-be-generated) SQL from a Hibernate Criteria?  Ideally, I would have something like:  Criteria criteria = session.createCriteria(Operator.class);  ... build up the criteria ... ... and then do something like ...  String sql = criteria.toSql()  (But this of course does not exist)   The idea would then be to use the SQL as part of a huge 'MINUS' query (I need to find the differences between 2 identical schemas - identical in structure, not in data - and the MINUS is not supported by Hibernate)  (BTW I know I can check the SQL from the log files)
24768
I really want to know more about the update, export and the values that could be given to hibernate.hbm2ddl.auto I need to know when to use the update and when not? And what is the alternative?  These are changes that could happen over DB:   new tables new columns in old tables columns deleted data type of a column changed a type of a column changed its attributes tables dropped values of a column changed    In each case what is the best solution?
29633
I intend to develop a small (Java) application for managing my finances. I believe I need to use an embedded database, but I have no experience regarding this issue. I tried to look at , but I can't decide which one would be more suitable for me. , ,  and  seem to be good candidates, but I still don't see how they compare to each other. I appreciate your help comparing them and helping me decide which one to use.  I intend to use Hibernate for my application (unless you would recommend using DBMS-provided API), but I also want to have the ability to edit the database easily using a SQL browsing tool (modifying schema and changing data).  Thank you.
123183
I have the following query that sort of works, but I find it to be kludgy and inefficient.  Is there a better way to write this query?  I know this is a bit of an odd query, else I would probably have found some advice when searching, but it is necessary for our business logic.  We've been doing this in Hibernate queries and using software to output the file but we're needing to improve performance drastically and that means using raw sql.  The output of this query is to be used to partially populate a helper table that we query to figure out which of our 40-odd product tables a particular item is contained in.  Could the following query be replicated using something like GROUP_CONCAT in reverse? Note that the second and third column must be repeated on each line.  The fields all contain the same type of data.  SELECT 'Pn', 'Mfg', 'TableId', 'SourceColumn', 'OtherData' SELECT PN1, Mfg, '26', 'PN1', OtherData FROM Table  UNION ALL SELECT PN2, Mfg, '26', 'PN2', OtherData FROM Table UNION ALL SELECT PN3, Mfg, '26', 'PN3', OtherData FROM Table UNION ALL SELECT PN4, Mfg, '26', 'PN4', OtherData  INTO OUTFILE 'XXX.dat' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM Table d;   Input looks like the following table:       |  PN1  |  PN2  |  PN3    |  PN4    |  MFG  |  TableId  |  OtherData  |     -----------------------------------------------------------------------     |  asdf |  abde |  12354  |  asdfc  |  2    |  26       |  0.2456     |     |  nupo |  1354 |  null   |  null   |  2    |  26       |  1.53       |     |  ...  |  ...  |  ...    |  ...    |  ...  |  ...      |  ...        |     |  ...  |  ...  |  ...    |  ...    |  ...  |  ...      |  ...        |     |  ...  |  ...  |  ...    |  ...    |  ...  |  ...      |  ...        |   I want the output .dat file to look like this:       "Pn","Mfg","TableId","SourceColumn","OtherData"     "asdf",2,26,"PN1",0.2456     "abde",2,26,"PN2",0.2456     "12354",2,26,"PN3",0.2456     "asdfc",2,26,"PN4",0.2456     "nupo",2,26,"PN1",1.53     "1354",2,26,"PN2",1.53     ...     ...     ...   If I take the INTO OUTFILE clause out, I get an output that looks like this:       |  Pn      |  Mfg     |  TableId    |  SourceColumn  | OtherData  |     -----------------------------------------------------------------     |  "Pn"    |  {blob}  |  "TableId"  |  "PN"          |  {blob}    |     |  "asdf"  |  {blob}  |  "PN1"      |  "PN1"         |  {blob}    |     |  "abde"  |  {blob}  |  "PN2"      |  "PN2"         |  {blob}    |     |  "12354" |  {blob}  |  "PN3"      |  "PN3"         |  {blob}    |     |  "asdfc" |  {blob}  |  "PN4"      |  "PN4"         |  {blob}    |     |  "nupo"  |  {blob}  |  "PN1"      |  "PN1"         |  {blob}    |     |  "1354"  |  {blob}  |  "PN2"      |  "PN2"         |  {blob}    |     |  ...     |  ...     |  ...        |   ...          |   ...      |     |  ...     |  ...     |  ...        |   ...          |   ...      |     |  ...     |  ...     |  ...        |   ...          |   ...      |
104627
What are the main differences between InnoDB and MyISAM?
98044
What is the difference between storing a datatable in Session vs Cache? What are the advantages and disadvantages?  So, if it is a simple search page which returns result in a datatable and binds it to a gridview. If user 'a' searches and user 'b' searches, is it better to store it in Session since each user would most likely have different results or can I still store each of their searches in Cache or does that not make sense since there is only one cache.  I guess basically what I am trying to say is that would the Cache be overwritten.
48923
When using JDBC, I often come across constructs like    ResultSet rs = ps.executeQuery(); while (rs.next()) {     int id = rs.getInt(1);     // Some other actions }   I asked myself (and authors of code too) why not to use labels for retrieving column values:    int id = rs.getInt("CUSTOMER_ID");   The best explanation I've heard is something concerning performance. But actually, does it make processing extremely fast? I don't believe so, though I have never performed measurements. Even if retrieving by label would be a bit slower, nevertheless, it provide better readability and flexibility, in my opinion. So could someone give me good explanation of avoiding to retrieve column values by column index instead of column label? What are pros and cons of both approaches (maybe, concerning certain DBMS)?
21803
Is there any real practical difference between "java -server" and "java -client"?    All I can find on Sun's site is a vague      "-server starts slower but should run faster".     What are the real differences?  (Using JDK 1.6.0_07 currently.)
106556
Java .class files can be decompiled fairly easily. How can I protect my database if I have to use the login data in the code?
18087
What is the difference between the User scope and Application scope in app.config?
39343
How to find out size of session in ASP.NET from web application?
63733
What are the pros and cons of using  or ? The Criteria API is a nice object-oriented way to express queries in Hibernate, but sometimes Criteria Queries are more difficult to understand/build than HQL.   When do you use Criteria and when HQL? What do you prefer in which use cases? Or is it just a matter of taste?
47611
I want to use a Java file SaveProp which is written in a package user. The class file has been placed in WEBINF/classes. Below are the two lines which cause the issue.  jsp:useBean id="user" class="user.SaveProp" scope="session"  jsp:setProperty name="user" property="*"   It throws:  The value for the useBean class attribute user.SaveProp is invalid   I'm using Tomcat 6.0.