LGServices: src/main/java/de/mpiwg/gazetteer/utils/DBService.java annotate

annotate src/main/java/de/mpiwg/gazetteer/utils/DBService.java @ 88:f4242db6206b

Refactoring : replace getCurrentSession with openSession for nested transaction exception

author	Calvin Yeh <cyeh@mpipw-berlin.mpg.com>
date	Wed, 21 Jun 2017 05:56:02 +0200
parents	110be241ff54
children	090035f79373

rev	line source
6 0378dbd683b8 Loggin an exception "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 1 diff changeset	1 package de.mpiwg.gazetteer.utils;
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	2
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	3 import java.io.IOException;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	4 import java.sql.Connection;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	5 import java.sql.DriverManager;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	6 import java.sql.ResultSet;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	7 import java.sql.SQLException;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	8 import java.sql.Statement;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	9 import java.util.ArrayList;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	10 import java.util.Date;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	11 import java.util.HashMap;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	12 import java.util.List;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	13 import java.util.Map;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	14
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	15 import org.apache.log4j.Logger;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	16 import org.hibernate.Query;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	17 import org.hibernate.Session;
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	18 import org.hibernate.Transaction;
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	19
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	20 import de.mpiwg.gazetteer.bo.DBEntry;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	21 import de.mpiwg.gazetteer.bo.LGBranch;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	22 import de.mpiwg.gazetteer.bo.LGFile;
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	23 import de.mpiwg.gazetteer.bo.LGFullTextSearchFile;
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	24 import de.mpiwg.gazetteer.bo.LGTopic;
ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	25 import de.mpiwg.gazetteer.bo.LGTopicSectionRelation;
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	26 import de.mpiwg.gazetteer.db.DBBook;
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	27 import de.mpiwg.gazetteer.db.DBContents;
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	28 import de.mpiwg.gazetteer.db.DBCoordinatesBook;
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	29 import de.mpiwg.gazetteer.db.DBSection;
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	30 import de.mpiwg.gazetteer.db.DBSectionVersion;
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	31
67 0a9937b06cc3 save full text search table (filtered) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	32
0a9937b06cc3 save full text search table (filtered) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	33
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	34 public class DBService {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	35
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	36 private static Logger logger = Logger.getLogger(DBService.class);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	37
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	38 // JDBC driver name and database URL
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	39 static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	40
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	41
63 fc5116de601f config to SBB server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 60 diff changeset	42 //static final String DB_URL = "jdbc:mysql://localhost/";
fc5116de601f config to SBB server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 60 diff changeset	43 static final String DB_URL = "jdbc:mysql://194.94.134.66/"; // TODO: when move Gazetteer database to SBB, need to re-config this
fc5116de601f config to SBB server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 60 diff changeset	44 // replace the IP with SBB's host IP: 194.94.134.66
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	45
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	46 private static String SECTIONS_TABLE = "sections_index";
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	47
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	48
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	49 // TODO: for all connection to mysql, we need to new a connection once (don't close it) and check everytime is the connection is still available.
67 0a9937b06cc3 save full text search table (filtered) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	50 // It probably will timeout. If that then new a new connection.
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	51
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	52
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	53 private static DBService instance = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	54
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	55 public static DBService getInstance(){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	56 if(instance == null){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	57 instance = new DBService();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	58 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	59 return instance;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	60 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	61
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	62 private Map<String, DBBook> bookMap;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	63
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	64 private List<String> dynastyList;
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	65
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	66 private Map<String, DBCoordinatesBook> coordinatesBookMap;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	67
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	68 public List<String> getDynastyList() throws SQLException{
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	69 if(this.dynastyList == null){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	70 this.loadDynastyList();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	71 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	72 return dynastyList;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	73 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	74
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	75 private void loadDynastyList() throws SQLException{
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	76 Long start = System.currentTimeMillis();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	77 Connection conn = null;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	78 Statement stmt = null;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	79 this.dynastyList = new ArrayList<String>();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	80
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	81 try {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	82 String query = "SELECT DISTINCT dynasty FROM books";
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	83 logger.debug(query);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	84 conn = getNewConnection();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	85 stmt = conn.createStatement();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	86 ResultSet rs = stmt.executeQuery(query);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	87
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	88 while(rs.next()){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	89 this.dynastyList.add(rs.getString("dynasty"));
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	90 }
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	91 rs.close();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	92
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	93 } catch (Exception e) {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	94 e.printStackTrace();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	95 }finally{
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	96 conn.close();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	97 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	98
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	99 long end = System.currentTimeMillis();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	100 logger.debug("Time execution loading Book Map [ms]: " + (end - start));
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	101 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	102
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	103 public List<DBBook> getBooks(){
14 3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	104 try {
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	105 this.loadBookMap();
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	106 } catch (SQLException e) {
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	107
14 3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	108 e.printStackTrace();
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	109 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	110
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	111 // getBookMap().values() returns a Collection. In this way, we can use List.
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	112 return new ArrayList<DBBook>(getBookMap().values());
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	113 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	114
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	115
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	116 public DBCoordinatesBook getCoordinatesBook(String bookId) {
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	117 return getCoordinatesBookMap().get(bookId);
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	118 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	119
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	120 private Map<String, DBCoordinatesBook> getCoordinatesBookMap() {
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	121 if (coordinatesBookMap == null) {
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	122 try {
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	123 this.loadCoordinatesBookMap();
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	124 } catch (Exception e) {
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	125 e.printStackTrace();
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	126 }
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	127 }
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	128 return this.coordinatesBookMap;
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	129 }
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	130
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	131 private void loadCoordinatesBookMap() throws SQLException{
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	132 Long start = System.currentTimeMillis();
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	133 Connection conn = null;
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	134 Statement stmt = null;
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	135 this.coordinatesBookMap = new HashMap<String, DBCoordinatesBook>();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	136
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	137 try {
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	138 String query = "SELECT * FROM coordinates_books";
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	139 logger.debug(query);
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	140 conn = getNewConnection();
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	141 stmt = conn.createStatement();
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	142 ResultSet rs = stmt.executeQuery(query);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	143
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	144 while(rs.next()){
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	145 DBCoordinatesBook book = new DBCoordinatesBook(rs);
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	146 this.coordinatesBookMap.put(book.getBooks_id(), book);
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	147 }
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	148 rs.close();
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	149 } catch (Exception e) {
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	150 e.printStackTrace();
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	151 }finally{
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	152 conn.close();
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	153 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	154
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	155 long end = System.currentTimeMillis();
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	156 logger.debug("Time execution loading Coordinates Book Map [ms]: " + (end - start));
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	157 }
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	158
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	159 public DBBook getBook(String id){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	160 return getBookMap().get(id);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	161 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	162
43 9dbbbfd474f4 new: 1.existing topic in search result. 2.difference-set of book for topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 41 diff changeset	163 public Map<String, DBBook> getBookMap(){
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	164 if(bookMap == null){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	165 try {
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	166 this.loadBookMap();
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	167 } catch (Exception e) {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	168 e.printStackTrace();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	169 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	170 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	171 return this.bookMap;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	172 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	173
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	174 private void loadBookMap() throws SQLException{
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	175 Long start = System.currentTimeMillis();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	176 Connection conn = null;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	177 Statement stmt = null;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	178 this.bookMap = new HashMap<String, DBBook>();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	179
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	180 try {
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	181 String query = "SELECT * FROM books";
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	182 logger.debug(query);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	183 conn = getNewConnection();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	184 stmt = conn.createStatement();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	185 ResultSet rs = stmt.executeQuery(query);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	186
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	187 while(rs.next()){
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	188 DBBook book = new DBBook(rs);
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	189
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	190 this.bookMap.put(book.getId(), book);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	191 }
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	192 rs.close();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	193
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	194 } catch (Exception e) {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	195 e.printStackTrace();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	196 }finally{
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	197 conn.close();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	198 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	199
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	200 long end = System.currentTimeMillis();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	201 logger.debug("Time execution loading Book Map [ms]: " + (end - start));
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	202 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	203
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	204 public static List<DBSection> searchBook(List<String> termList, String field) throws SQLException{
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	205 Long start = System.currentTimeMillis();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	206
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	207 List<DBSection> list = new ArrayList<DBSection>();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	208
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	209 Connection conn = null;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	210 Statement stmt = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	211
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	212 //TODO this query should join the section table
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	213 String query = "SELECT * FROM books WHERE ";
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	214 for(int i=0; i<termList.size() ; i++){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	215 String term = termList.get(i);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	216 if(i>0){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	217 query += " OR ";
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	218 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	219 query += field + " like '%" + term + "%' ";
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	220 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	221
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	222 try {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	223 conn = getNewConnection();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	224 stmt = conn.createStatement();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	225
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	226 ResultSet rs = stmt.executeQuery(query);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	227 while (rs.next()) {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	228 DBBook book = new DBBook(rs);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	229
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	230 String sql = "SELECT * FROM "+ SECTIONS_TABLE +" WHERE " + "books_id = '" + book.getId() + "'";
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	231 logger.debug(sql);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	232 stmt = conn.createStatement();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	233 ResultSet rs0 = stmt.executeQuery(sql);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	234 while(rs0.next()){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	235 DBSection section = new DBSection(rs0);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	236 section.setBook(book);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	237 list.add(section);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	238 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	239 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	240 rs.close();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	241 } catch (Exception e) {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	242 e.printStackTrace();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	243 } finally {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	244 conn.close();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	245 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	246
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	247 long end = System.currentTimeMillis();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	248 logger.debug("Time execution serching Books [ms]: " + (end - start));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	249
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	250 return list;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	251 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	252
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	253 /*
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	254 public static List<DBBook> searchFullText0(List<String> termList) throws SQLException{
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	255 Long start = System.currentTimeMillis();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	256
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	257 String condition = "";
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	258 for(int i=0; i<termList.size() ; i++){
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	259 String term = termList.get(i);
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	260 if(i>0){
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	261 condition += " OR ";
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	262 }
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	263 condition += " contents.content like '%" + term + "%' ";
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	264 }
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	265
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	266
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	267 String sql =
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	268 "SELECT books.level1 AS level1, books.level2 AS level2, " +
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	269 "books.name AS name, books.line AS line,books.period AS period, books.dynasty AS dynasty, " +
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	270 "books.admin_type as admin_type, books.in_jibengujiku AS in_jibengujiku, " +
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	271 "books.start_year AS start_year, books.end_year AS end_year, " +
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	272 "books.id AS id, contents.line AS PAGE, contents.content AS CONTENT, " +
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	273 "books.volume AS volume, books.author AS author, books.edition AS edition " +
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	274 "FROM contents " +
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	275 "JOIN books ON contents.books_id = books.id " +
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	276 "WHERE " + condition + " " +
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	277 "ORDER BY contents.books_id, contents.line";
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	278
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	279
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	280 Connection conn = null;
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	281 Statement stmt = null;
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	282 List<DBBook> resultSet = new ArrayList<DBBook>();
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	283 // TODO new structure for the result of full text search?
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	284 try {
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	285 conn = getNewConnection();
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	286 stmt = conn.createStatement();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	287
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	288 int count = 0;
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	289 ResultSet rs = stmt.executeQuery(sql);
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	290 while (rs.next()) {
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	291 count++;
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	292 DBBook book = new DBBook(rs);
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	293 resultSet.add(book);
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	294 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	295
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	296 System.out.println("*********************** Count " + count + " ********************************");
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	297
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	298 rs.close();
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	299 } catch (Exception e) {
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	300 e.printStackTrace();
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	301 } finally {
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	302 conn.close();
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	303 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	304
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	305 long end = System.currentTimeMillis();
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	306 logger.debug("Time execution serching Books [ms]: " + (end - start));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	307
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	308 return resultSet;
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	309 }
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	310 */
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	311
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	312
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	313 public DBSection getSectionByBookIdAndPage(String bookId, int page) throws SQLException {
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	314
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	315 Connection conn = null;
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	316 Statement stmt = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	317
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	318 DBSection section = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	319
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	320 String query = "SELECT * FROM "+ SECTIONS_TABLE +" WHERE books_id='" + bookId + "' " +
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	321 "and start_page<=" + page + " and end_page>=" + page;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	322
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	323 try {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	324 Class.forName(JDBC_DRIVER);
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	325 conn = getNewConnection();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	326 stmt = conn.createStatement();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	327
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	328 ResultSet rs = stmt.executeQuery(query);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	329
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	330 while (rs.next()) {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	331 section = new DBSection(rs);
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	332 DBBook book = getInstance().getBook(bookId);
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	333 section.setBook(book);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	334
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	335 }
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	336 rs.close();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	337
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	338 } catch (Exception e) {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	339 e.printStackTrace();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	340 } finally {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	341 conn.close();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	342 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	343
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	344 if (section == null) {
40 35ed4e650a53 bug fixed: full text search when section not found in section_index table. add paginator Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 39 diff changeset	345 // section_index table is not completely correct by TOC_edit task (done by human), so query finds null in section
35ed4e650a53 bug fixed: full text search when section not found in section_index table. add paginator Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 39 diff changeset	346
35ed4e650a53 bug fixed: full text search when section not found in section_index table. add paginator Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 39 diff changeset	347 section = new DBSection();
35ed4e650a53 bug fixed: full text search when section not found in section_index table. add paginator Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 39 diff changeset	348 section.setBookId(bookId);
35ed4e650a53 bug fixed: full text search when section not found in section_index table. add paginator Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 39 diff changeset	349 DBBook book = getInstance().getBook(bookId);
35ed4e650a53 bug fixed: full text search when section not found in section_index table. add paginator Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 39 diff changeset	350 section.setBook(book);
35ed4e650a53 bug fixed: full text search when section not found in section_index table. add paginator Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 39 diff changeset	351 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	352
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	353 return section;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	354
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	355 }
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	356
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	357
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	358 public static List<DBContents> searchFullText_X(List<String> termList) throws SQLException{
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	359 //Trying subquery to get both contents and sections in one large mysql query, but it performed worse here...
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	360
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	361 Long start = System.currentTimeMillis();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	362
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	363 String condition = "(";
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	364 for(int i=0; i<termList.size() ; i++){
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	365 String term = termList.get(i);
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	366 if(i>0){
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	367 condition += " OR ";
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	368 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	369
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	370 condition += " content like '%" + term + "%' ";
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	371 }
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	372 condition += ")";
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	373
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	374
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	375 String condition_content_in_book = " WHERE books_id=contents.books_id and start_page <= contents.line and end_page >=contents.line LIMIT 0,1";
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	376
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	377 String sql = "SELECT contents.id, contents.books_id AS books_id, contents.line AS line, contents.content AS content, " +
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	378 "books.name, books.dynasty, " +
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	379 "(SELECT sections_index.id FROM "+ SECTIONS_TABLE + condition_content_in_book + ") AS section_id, " +
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	380 "(SELECT sections_index.name FROM "+ SECTIONS_TABLE + condition_content_in_book + ") AS section_name, " +
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	381 "(SELECT sections_index.start_page FROM "+ SECTIONS_TABLE + condition_content_in_book + ") AS start_page, " +
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	382 "(SELECT sections_index.end_page FROM "+ SECTIONS_TABLE + condition_content_in_book + ") AS end_page " +
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	383
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	384 "FROM contents JOIN books ON contents.books_id=books.id " +
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	385 "WHERE " + condition;//+ "and (books_id='00204' or books_id='00219')"; // remove the books_id condition after debug
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	386
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	387 //logger.debug("sql: " + sql);
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	388
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	389 Connection conn = null;
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	390 Statement stmt = null;
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	391 List<DBContents> resultSet = new ArrayList<DBContents>();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	392 try {
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	393 conn = getNewConnection();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	394 stmt = conn.createStatement();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	395
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	396 Integer count = 0;
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	397 ResultSet rs = stmt.executeQuery(sql);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	398
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	399 // log execution time
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	400 long tmp = System.currentTimeMillis();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	401 logger.debug("Time execution mysql query [ms]: " + (tmp - start));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	402
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	403
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	404 while (rs.next()) {
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	405
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	406 count++;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	407 DBContents content = new DBContents(rs);
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	408 content.setInx(count); // local index for row
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	409
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	410 String books_id = rs.getString("books_id");
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	411
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	412 // set this.section by bookId and page
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	413 DBSection section = new DBSection(); // some info are not correctly initial, since we update the sql query by query two table at once.
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	414
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	415 section.setId(rs.getLong("section_id"));
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	416 section.setName(rs.getString("section_name"));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	417
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	418 section.setBookId(books_id);
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	419 section.setStart_page(rs.getInt("start_page"));
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	420 section.setEnd_page(rs.getInt("end_page"));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	421
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	422
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	423 content.setSection(section);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	424
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	425 // set this.coordinatesBook by bookId
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	426 /*
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	427 DBCoordinatesBook coordinatesBook = new DBCoordinatesBook();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	428
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	429 coordinatesBook.setId(rs.getInt("cb_id"));
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	430 coordinatesBook.setBooks_id(books_id);
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	431 coordinatesBook.setPlace_name(rs.getString("place_name"));
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	432 coordinatesBook.setX(rs.getString("x"));
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	433 coordinatesBook.setY(rs.getString("y"));
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	434 */
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	435
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	436 // set this.coordinatesBook by bookId
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	437 content.setCoordinatesBook(DBService.getInstance().getCoordinatesBook(content.getBookId()));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	438
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	439 resultSet.add(content);
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	440
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	441
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	442 }
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	443 logger.debug("*********************** Count " + count + " ********************************");
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	444 // log execution time
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	445 long tmp2 = System.currentTimeMillis();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	446 logger.debug("Time execution parsing to objects [ms]: " + (tmp2 - tmp));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	447
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	448
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	449 rs.close();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	450 } catch (Exception e) {
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	451 e.printStackTrace();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	452 } finally {
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	453 conn.close();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	454 }
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	455 /*
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	456 // setting section in each DBContents content
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	457 for (DBContents content : resultSet) {
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	458 // set this.section by bookId and page
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	459 content.setSection(DBService.getInstance().getSectionByBookIdAndPage(content.getBookId(), content.getPage()));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	460
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	461 // set this.coordinatesBook by bookId
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	462 content.setCoordinatesBook(DBService.getInstance().getCoordinatesBook(content.getBookId()));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	463 }
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	464 */
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	465
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	466
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	467 long end = System.currentTimeMillis();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	468 logger.debug("Total Time execution full text search [ms]: " + (end - start));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	469
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	470 return resultSet;
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	471 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	472
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	473 public static List<DBContents> searchFullText(List<String> termList) throws SQLException{
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	474
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	475 Long start = System.currentTimeMillis();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	476
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	477 String condition = "(";
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	478 for(int i=0; i<termList.size() ; i++){
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	479 String term = termList.get(i);
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	480 if(i>0){
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	481 condition += " OR ";
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	482 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	483
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	484 condition += " content like '%" + term + "%' ";
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	485 }
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	486 condition += ")";
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	487
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	488
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	489 String sql = "SELECT contents.id, contents.books_id AS books_id, contents.line AS line, contents.content AS content " +
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	490 "FROM contents " +
40 35ed4e650a53 bug fixed: full text search when section not found in section_index table. add paginator Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 39 diff changeset	491 "WHERE " + condition;//+ "and (books_id='00204' or books_id='00219')"; // remove the books_id condition after debug
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	492
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	493 //logger.debug("sql: " + sql);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	494
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	495 long tmp = 0 , tmp2 = 0;
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	496
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	497 Connection conn = null;
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	498 Statement stmt = null;
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	499 List<DBContents> resultSet = new ArrayList<DBContents>();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	500 try {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	501 conn = getNewConnection();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	502 stmt = conn.createStatement();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	503
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	504 Integer count = 0;
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	505 ResultSet rs = stmt.executeQuery(sql);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	506
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	507 // log execution time
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	508 tmp = System.currentTimeMillis();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	509 logger.debug("Time execution mysql query [ms]: " + (tmp - start));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	510
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	511
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	512 while (rs.next()) {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	513 count++;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	514 DBContents content = new DBContents(rs);
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	515 content.setInx(count); // local index for row
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	516 resultSet.add(content);
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	517 }
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	518 logger.debug("*********************** Count " + count + " ********************************");
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	519
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	520 // log execution time
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	521 tmp2 = System.currentTimeMillis();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	522 logger.debug("Time execution parsing to objects [ms]: " + (tmp2 - tmp));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	523
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	524 rs.close();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	525 } catch (Exception e) {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	526 e.printStackTrace();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	527 } finally {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	528 conn.close();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	529 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	530
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	531
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	532
40 35ed4e650a53 bug fixed: full text search when section not found in section_index table. add paginator Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 39 diff changeset	533 // setting section in each DBContents content
35ed4e650a53 bug fixed: full text search when section not found in section_index table. add paginator Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 39 diff changeset	534 for (DBContents content : resultSet) {
35ed4e650a53 bug fixed: full text search when section not found in section_index table. add paginator Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 39 diff changeset	535 // set this.section by bookId and page
35ed4e650a53 bug fixed: full text search when section not found in section_index table. add paginator Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 39 diff changeset	536 content.setSection(DBService.getInstance().getSectionByBookIdAndPage(content.getBookId(), content.getPage()));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	537
40 35ed4e650a53 bug fixed: full text search when section not found in section_index table. add paginator Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 39 diff changeset	538 // set this.coordinatesBook by bookId
35ed4e650a53 bug fixed: full text search when section not found in section_index table. add paginator Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 39 diff changeset	539 content.setCoordinatesBook(DBService.getInstance().getCoordinatesBook(content.getBookId()));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	540 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	541
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	542
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	543 long end = System.currentTimeMillis();
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	544 logger.debug("Time execution setting sections [ms]: " + (end - tmp2));
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	545 logger.debug("Total Time execution full text search [ms]: " + (end - start));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	546
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	547 return resultSet;
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	548 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	549
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	550
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	551
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	552 /**
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	553 * This methods search from a list of terms.
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	554 * Every term is considered a subsequence of whole section name.
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	555 *
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	556 * @param termList
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	557 * @return
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	558 * @throws SQLException
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	559 */
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	560 public static List<DBSection> searchSection(List<String> termList) throws SQLException{
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	561
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	562 Long start = System.currentTimeMillis();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	563
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	564 List<DBSection> list = new ArrayList<DBSection>();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	565
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	566 Connection conn = null;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	567 Statement stmt = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	568
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	569 String query = "SELECT * FROM "+ SECTIONS_TABLE +" WHERE ";
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	570 for(int i=0; i<termList.size() ; i++){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	571 String term = termList.get(i);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	572 if(i>0){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	573 query += " OR ";
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	574 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	575 query += "name like '%" + term + "%' ";
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	576 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	577
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	578 try {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	579 Class.forName(JDBC_DRIVER);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	580 conn = getNewConnection();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	581 stmt = conn.createStatement();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	582
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	583 ResultSet rs = stmt.executeQuery(query);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	584 while (rs.next()) {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	585 DBSection section = new DBSection(rs);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	586 DBBook book = getInstance().getBook(section.getBookId());
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	587 section.setBook(book);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	588 list.add(section);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	589 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	590 rs.close();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	591 } catch (Exception e) {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	592 e.printStackTrace();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	593 } finally {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	594 conn.close();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	595 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	596
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	597 long end = System.currentTimeMillis();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	598 logger.debug("Time execution serching Sections [ms]: " + (end - start));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	599
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	600 return list;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	601 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	602
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	603 public static List<String> suggestBookName(String term, int limit) throws SQLException{
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	604 List<String> list = new ArrayList<String>();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	605
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	606 Connection conn = null;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	607 Statement stmt = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	608
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	609 String query = "SELECT name FROM books WHERE name like '" + term + "%' limit " + limit;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	610
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	611 try {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	612 Class.forName(JDBC_DRIVER);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	613 conn = getNewConnection();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	614 stmt = conn.createStatement();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	615
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	616 ResultSet rs = stmt.executeQuery(query);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	617 while (rs.next()) {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	618 String name = rs.getString("name");
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	619 if(!list.contains(name)){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	620 list.add(name);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	621 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	622 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	623 rs.close();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	624 } catch (Exception e) {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	625 e.printStackTrace();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	626 } finally {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	627 conn.close();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	628 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	629 return list;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	630 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	631
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	632 public static List<String> suggestSectionName(String term, int limit) throws SQLException {
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	633 List<String> list = new ArrayList<String>();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	634
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	635 Connection conn = null;
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	636 Statement stmt = null;
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	637
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	638 String query = "SELECT name FROM "+SECTIONS_TABLE+" WHERE name like '" + term + "%' limit " + limit;
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	639
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	640 try {
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	641 Class.forName(JDBC_DRIVER);
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	642 conn = getNewConnection();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	643 stmt = conn.createStatement();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	644
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	645 ResultSet rs = stmt.executeQuery(query);
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	646 while (rs.next()) {
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	647 String name = rs.getString("name");
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	648 if(!list.contains(name)){
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	649 list.add(name);
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	650 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	651 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	652 rs.close();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	653 } catch (Exception e) {
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	654 e.printStackTrace();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	655 } finally {
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	656 conn.close();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	657 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	658 return list;
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	659 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	660
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	661
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	662 public static List<String> suggestSectionId(String input, int limit) throws SQLException {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	663 List<String> list = new ArrayList<String>();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	664
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	665 Connection conn = null;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	666 Statement stmt = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	667
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	668 String query = "SELECT id FROM "+SECTIONS_TABLE+" WHERE id like '" + input + "%' limit " + limit;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	669
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	670 try {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	671 Class.forName(JDBC_DRIVER);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	672 conn = getNewConnection();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	673 stmt = conn.createStatement();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	674
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	675 ResultSet rs = stmt.executeQuery(query);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	676 while (rs.next()) {
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	677
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	678 String id = rs.getString("id");
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	679 list.add(id);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	680
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	681 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	682 rs.close();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	683 } catch (Exception e) {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	684 e.printStackTrace();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	685 } finally {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	686 conn.close();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	687 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	688
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	689
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	690
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	691 return list;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	692 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	693
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	694
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	695 public static DBSection getSectionWithContent(Long sectionId) throws SQLException {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	696
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	697 Connection conn = null;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	698 Statement stmt = null;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	699 DBSection section = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	700
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	701 String query = "SELECT * FROM "+SECTIONS_TABLE+" WHERE id = '" + sectionId + "'";
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	702
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	703 try {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	704 Class.forName(JDBC_DRIVER);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	705 conn = getNewConnection();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	706 stmt = conn.createStatement();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	707
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	708 ResultSet rs = stmt.executeQuery(query);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	709 while (rs.next()) {
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	710
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	711 section = new DBSection(rs);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	712 /*
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	713 String bookId = rs.getString("books_id");
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	714 int startPage = rs.getInt("start_page");
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	715 int endPage = rs.getInt("end_page");
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	716 String sectionName = rs.getString("name");
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	717
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	718 response.setBookId(bookId);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	719 response.setName(sectionName);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	720 */
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	721 //System.out.println("bookId=" + bookId + ", startPage=" + startPage + ", endPage=" + endPage);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	722 //String content = getContent(conn, bookId, startPage, endPage);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	723 String content = getContent(conn, section);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	724 section.setText(content);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	725
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	726 //DBBook book = getBook0FromDB(conn, bookId);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	727 DBBook book = DBService.getInstance().getBook(section.getBookId());
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	728 section.setBook(book);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	729
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	730 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	731 rs.close();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	732 } catch (Exception e) {
6 0378dbd683b8 Loggin an exception "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 1 diff changeset	733 e.printStackTrace();
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	734 } finally {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	735 conn.close();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	736 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	737 return section;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	738 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	739
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	740 public static DBSection getDeprecatedSectionWithContent(Long sectionId) throws SQLException {
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	741
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	742 Connection conn = null;
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	743 Statement stmt = null;
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	744 DBSection section = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	745
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	746 String query = "SELECT * FROM sections_revisions WHERE sections_id = '" + sectionId + "'";
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	747
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	748 try {
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	749 Class.forName(JDBC_DRIVER);
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	750 conn = getNewConnection();
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	751 stmt = conn.createStatement();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	752
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	753 ResultSet rs = stmt.executeQuery(query);
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	754 rs.next();
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	755 //while (rs.next()) {
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	756
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	757 section = new DBSection(rs);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	758
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	759 String content = getContent(conn, section);
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	760 section.setText(content);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	761
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	762 DBBook book = DBService.getInstance().getBook(section.getBookId());
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	763 section.setBook(book);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	764
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	765 //}
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	766 rs.close();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	767 } catch (Exception e) {
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	768 e.printStackTrace();
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	769 } finally {
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	770 conn.close();
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	771 }
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	772 return section;
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	773 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	774
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	775
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	776
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	777 public static String fixToNewline(String orig){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	778 char[] chars = orig.toCharArray();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	779 StringBuilder sb = new StringBuilder(100);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	780 for(char c : chars){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	781 switch(c){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	782 case '\r':
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	783 case '\f':
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	784 break;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	785 case '\n':
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	786 sb.append("<br>");
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	787 break;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	788 default:
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	789 sb.append(c);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	790 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	791 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	792 return sb.toString();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	793 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	794
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	795 //"SELECT `content`, `line`, `books_id` FROM `contents` WHERE `books_id`=\"%s\" AND `line`>=%d AND `line`<=%d
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	796 //private static String getContent(Connection conn, String bookId, Integer startLine, Integer endLine) throws Exception{
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	797 private static String getContent(Connection conn, DBSection section) throws Exception{
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	798 String query = "SELECT content, line FROM contents WHERE books_id = '" + section.getBookId() + "' AND line >= '" + section.getStart_page() + "' AND line <= '" + section.getEnd_page() + "'";
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	799 //logger.debug(query);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	800
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	801 Statement stmt = conn.createStatement();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	802 ResultSet rs = stmt.executeQuery(query);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	803
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	804 StringBuilder sb = new StringBuilder();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	805 while(rs.next()){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	806 String line = rs.getString("line");
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	807 String content = rs.getString("content");
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	808 sb.append("【" + line + "】" + content + "\n");
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	809 }
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	810 rs.close();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	811
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	812 return sb.toString();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	813 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	814
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	815 /*
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	816 public static DBBook getBookFromDB(String id) throws SQLException{
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	817 Connection conn = null;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	818 DBBook book = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	819
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	820 try {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	821 //Class.forName(JDBC_DRIVER);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	822 conn = getNewConnection();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	823 book = getBook0FromDB(conn, id);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	824 } catch (Exception e) {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	825 e.printStackTrace();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	826 } finally {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	827 conn.close();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	828 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	829 return book;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	830 }*/
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	831 /*
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	832 private static DBBook getBook0FromDB(Connection conn, String id) throws SQLException{
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	833 DBBook book = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	834
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	835 String query = "SELECT * FROM books WHERE id = '" + id + "'";
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	836 logger.debug(query);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	837
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	838 Statement stmt = conn.createStatement();
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	839 ResultSet rs = stmt.executeQuery(query);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	840
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	841 if(rs.next()){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	842 book = new DBBook(rs);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	843 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	844
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	845 return book;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	846 }*/
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	847
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	848 /**
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	849 * This method removed all files for a particular fileId.
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	850 * The elimination includes the current version as well as the old versions.
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	851 * @param fileId
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	852 * @return
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	853 */
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	854 protected static int deleteBranchFromDB(Long branchId){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	855 logger.info("Deleting Branch by branchId=" + branchId);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	856
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	857 int modifiedFiles;
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	858 Session session = HibernateUtil.getSessionFactory().openSession();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	859 Transaction tx = null;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	860
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	861 try{
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	862
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	863 tx = session.beginTransaction();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	864
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	865 Query query = session.createQuery("delete LGBranch where id = :id");
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	866 query.setLong("id", branchId);
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	867 modifiedFiles = query.executeUpdate();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	868
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	869 Query query0 = session.createQuery("delete LGFile where branchId = :branchId");
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	870 query0.setLong("branchId", branchId);
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	871 modifiedFiles += query0.executeUpdate();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	872
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	873 tx.commit();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	874
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	875 }catch (Exception e) {
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	876
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	877 if (tx!=null) tx.rollback();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	878
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	879 e.printStackTrace();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	880
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	881 throw e;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	882
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	883 }finally {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	884 session.close();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	885 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	886
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	887 return modifiedFiles;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	888 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	889
54 a00efd5d9e77 new: adding delete saved table function Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 43 diff changeset	890 protected static int deleteFullTextSearchFileFromDB(Long fileId){
a00efd5d9e77 new: adding delete saved table function Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 43 diff changeset	891 int modifiedFiles = 0;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	892
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	893 Session session = HibernateUtil.getSessionFactory().openSession();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	894 Transaction tx = null;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	895
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	896 try{
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	897
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	898 tx = session.beginTransaction();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	899
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	900 Query query0 = session.createQuery("delete LGFullTextSearchFile where id = :fileId");
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	901 query0.setLong("fileId", fileId);
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	902 modifiedFiles = query0.executeUpdate();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	903
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	904 tx.commit();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	905 }catch (Exception e) {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	906 if (tx!=null) tx.rollback();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	907
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	908 e.printStackTrace();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	909
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	910 throw e;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	911 }finally {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	912 session.close();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	913 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	914
54 a00efd5d9e77 new: adding delete saved table function Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 43 diff changeset	915 return modifiedFiles;
a00efd5d9e77 new: adding delete saved table function Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 43 diff changeset	916 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	917
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	918 protected static int deleteFileFromDB(Long fileId){
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	919
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	920 int modifiedFiles;
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	921 Session session = HibernateUtil.getSessionFactory().openSession();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	922 Transaction tx = null;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	923 try{
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	924 tx = session.beginTransaction();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	925
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	926 Query query0 = session.createQuery("delete LGFile where id = :fileId");
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	927 query0.setLong("fileId", fileId);
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	928 modifiedFiles = query0.executeUpdate();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	929
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	930 tx.commit();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	931 }catch (Exception e) {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	932 if (tx!=null) tx.rollback();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	933
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	934 e.printStackTrace();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	935
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	936 throw e;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	937 }finally {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	938 session.close();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	939 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	940
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	941 return modifiedFiles;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	942
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	943 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	944
34 2e1662afc81c new: add synchronization for files uploaded to LGDataverse Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	945 protected static List<LGFile> getLGFileInDatasetFromDB(String datasetPersistentId) {
2e1662afc81c new: add synchronization for files uploaded to LGDataverse Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	946 List<LGFile> list = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	947
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	948 Session session = HibernateUtil.getSessionFactory().openSession();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	949
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	950 try{
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	951
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	952 session.getTransaction().begin();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	953 Query query = session.createQuery("from LGFile where datasetPersistentId = :datasetPersistentId and fileIdInDv != NULL");
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	954 query.setString("datasetPersistentId", datasetPersistentId);
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	955 list = query.list();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	956 session.getTransaction().commit();
34 2e1662afc81c new: add synchronization for files uploaded to LGDataverse Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	957
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	958 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	959 catch(Exception e){
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	960 throw e;
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	961 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	962 finally{
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	963
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	964 if (session != null && session.isOpen()) {
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	965 session.close();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	966 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	967 }
34 2e1662afc81c new: add synchronization for files uploaded to LGDataverse Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	968
2e1662afc81c new: add synchronization for files uploaded to LGDataverse Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	969 return list;
2e1662afc81c new: add synchronization for files uploaded to LGDataverse Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	970 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	971
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	972
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	973 protected static List<LGFullTextSearchFile> getAllLGFullTextSearchFileFromDB() {
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	974
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	975 List<LGFullTextSearchFile> list = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	976
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	977 Session session = HibernateUtil.getSessionFactory().openSession();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	978
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	979 try{
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	980
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	981 session.getTransaction().begin();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	982 Query query = session.createQuery("from LGFullTextSearchFile");
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	983 list = query.list();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	984 session.getTransaction().commit();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	985
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	986 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	987 finally{
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	988
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	989 if (session != null && session.isOpen()) {
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	990 session.close();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	991 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	992 }
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	993
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	994 return list;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	995
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	996 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	997
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	998 protected static List<LGFile> getAllLGFileFromDB(){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	999 List<LGFile> list = null;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1000
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1001 Session session = HibernateUtil.getSessionFactory().openSession();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1002
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1003 try{
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1004
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1005 session.getTransaction().begin();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1006 Query query = session.createQuery("from LGFile");
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1007 list = query.list();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1008 session.getTransaction().commit();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1009
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1010 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1011 catch(Exception e){
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1012 throw e;
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1013 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1014 finally{
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1015
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1016 if (session != null && session.isOpen()) {
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1017 session.close();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1018 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1019 }
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1020
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1021 return list;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1022 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1023
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1024 protected static List<LGFile> getCurrentLGFilesFromDB(){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1025 List<LGFile> list = null;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1026
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1027 Session session = HibernateUtil.getSessionFactory().openSession();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1028
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1029 try{
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1030
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1031 session.getTransaction().begin();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1032 Query query = session.createQuery("from LGFile where lastVersion = :lastVersion");
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1033 query.setBoolean("lastVersion", true);
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1034 list = query.list();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1035 session.getTransaction().commit();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1036
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1037 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1038 catch(Exception e){
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1039 throw e;
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1040 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1041 finally{
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1042
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1043 if (session != null && session.isOpen()) {
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1044 session.close();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1045 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1046 }
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1047
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1048 return list;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1049 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1050
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1051
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1052
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1053 protected static List<LGBranch> getAllLGBranchFromDB(){
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1054 List<LGBranch> list = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1055
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1056 Session session = HibernateUtil.getSessionFactory().openSession();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1057
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1058 try{
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1059
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1060 session.getTransaction().begin();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1061 Query query = session.createQuery("from LGBranch");
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1062 list = query.list();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1063 session.getTransaction().commit();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1064
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1065 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1066 catch(Exception e){
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1067 throw e;
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1068 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1069 finally{
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1070
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1071 if (session != null && session.isOpen()) {
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1072 session.close();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1073 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1074 }
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1075
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1076 return list;
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1077 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1078
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1079 protected static void saveDBEntry(DBEntry entry, Date date){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1080
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1081 Session session = HibernateUtil.getSessionFactory().openSession();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1082 Transaction tx = null;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1083 try{
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1084 tx = session.beginTransaction();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1085
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1086 saveDBEntry0(session, entry, date);
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1087
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1088 tx.commit();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1089 }catch (Exception e) {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1090 if (tx!=null) tx.rollback();
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1091
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1092 e.printStackTrace();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1093
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1094 throw e;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1095 }finally {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1096 session.close();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1097 }
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1098 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1099
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1100 public static void saveDBEntry0(Session session, DBEntry entry, Date date){
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1101 entry.setLastChangeDate(date);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1102 if (entry.isPersistent()) {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1103 session.update(entry);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1104 } else {
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1105 entry.setCreationDate(date);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1106 session.save(entry);
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1107 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1108 logger.info("saveDBEntry: " + entry.toString());
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1109 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1110
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1111 public static Connection getNewConnection() throws SQLException, IOException{
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1112
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1113 return DriverManager.getConnection(
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1114 DB_URL + PropertiesUtils.getPropValue("db_gazetter_name") + "?useUnicode=yes&characterEncoding=UTF-8",
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1115 PropertiesUtils.getPropValue("db_gazetter_username"),
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1116 PropertiesUtils.getPropValue("db_gazetter_password"));
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1117
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1118 }
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1119
11 f15b0214cc1c Adding query for table SectionVersion "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 8 diff changeset	1120
f15b0214cc1c Adding query for table SectionVersion "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 8 diff changeset	1121 public List<DBSectionVersion> getSectionVersionList() throws SQLException {
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1122 List<DBSectionVersion> section_version = new ArrayList<DBSectionVersion>();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1123
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1124 Connection con = null;
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1125 try{
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1126 con = getNewConnection();
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1127 Statement stmt = con.createStatement();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1128 // query in sections_versions table.
13 9c6e74761f60 new: link to Edit Toc page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	1129 // Each line is a current version (with largest version number) for a book.
12 d57fe2179f61 Improvement of book page "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 11 diff changeset	1130 String query = "SELECT * FROM sections_versions s1 " +
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	1131 "JOIN ( " +
12 d57fe2179f61 Improvement of book page "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 11 diff changeset	1132 "SELECT books_id, MAX(version) AS version " +
d57fe2179f61 Improvement of book page "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 11 diff changeset	1133 "FROM sections_versions " +
d57fe2179f61 Improvement of book page "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 11 diff changeset	1134 "GROUP BY books_id) AS s2 " +
d57fe2179f61 Improvement of book page "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 11 diff changeset	1135 "ON s1.books_id = s2.books_id AND s1.version = s2.version";
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1136
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1137 ResultSet rs = stmt.executeQuery(query);
11 f15b0214cc1c Adding query for table SectionVersion "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 8 diff changeset	1138 while(rs.next()){
f15b0214cc1c Adding query for table SectionVersion "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 8 diff changeset	1139 DBSectionVersion sv = new DBSectionVersion(rs);
f15b0214cc1c Adding query for table SectionVersion "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 8 diff changeset	1140 section_version.add(sv);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1141
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1142 }
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	1143 rs.close();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1144
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1145 } catch (Exception e) {
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1146 e.printStackTrace();
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1147 } finally {
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1148 con.close();
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1149 }
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1150 // ----
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1151
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1152 return section_version;
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1153 }
14 3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1154
21 5b1856cd6b4f bug fixed: 1.TOC Done display issue 2.issue in firefox Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	1155 public void updateTocCorrection(String bookId, String finishedStatus) throws SQLException {
14 3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1156 Connection conn = null;
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1157 Statement stmt = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1158
14 3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1159 try {
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1160 String query = "UPDATE books SET toc_correction='"+ finishedStatus + "' WHERE id='" + bookId + "'";
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1161 conn = getNewConnection();
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1162 stmt = conn.createStatement();
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1163 int rs = stmt.executeUpdate(query);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1164
14 3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1165 } catch (Exception e) {
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1166 e.printStackTrace();
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1167 }finally{
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1168 conn.close();
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1169 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1170
14 3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1171 DBBook book = this.bookMap.get(bookId);
21 5b1856cd6b4f bug fixed: 1.TOC Done display issue 2.issue in firefox Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	1172 book.setTocCorrection(finishedStatus);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1173
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1174
14 3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1175 }
22 2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1176
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1177 public void updateComment(String bookId, String comment) throws SQLException {
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1178 Connection conn = null;
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1179 Statement stmt = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1180
22 2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1181 try {
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1182 String query = "UPDATE books SET comments='"+ comment + "' WHERE id='" + bookId + "'";
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1183 conn = getNewConnection();
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1184 stmt = conn.createStatement();
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1185 int rs = stmt.executeUpdate(query);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1186
22 2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1187 } catch (Exception e) {
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1188 e.printStackTrace();
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1189 }finally{
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1190 conn.close();
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1191 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1192
22 2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1193 DBBook book = this.bookMap.get(bookId);
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1194 book.setComments(comment);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1195
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1196
22 2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1197 }
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	1198
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1199
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1200 /* --- topic --- */
ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1201 protected static List<LGTopic> getAllLGTopicFromDB(){
ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1202 List<LGTopic> list = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1203
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1204 Session session = HibernateUtil.getSessionFactory().openSession();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1205
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1206 try{
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1207
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1208 session.getTransaction().begin();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1209 Query query = session.createQuery("from LGTopic");
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1210 list = query.list();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1211 session.getTransaction().commit();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1212
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1213 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1214 catch(Exception e){
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1215 throw e;
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1216 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1217 finally{
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1218
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1219 if (session != null && session.isOpen()) {
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1220 session.close();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1221 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1222 }
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1223
ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1224 return list;
ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1225 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1226
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1227 protected static int deleteTopicFromDB(Long topicId){
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1228
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1229 logger.info("Deleting topic by topicId=" + topicId);
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1230
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1231 int modifiedTopic;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1232
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1233 Session session = HibernateUtil.getSessionFactory().openSession();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1234
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1235 Transaction tx = null;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1236 try{
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1237 tx = session.beginTransaction();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1238 // delete record in Topic table
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1239 Query query = session.createQuery("delete LGTopic where id = :id");
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1240 query.setLong("id", topicId);
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1241 modifiedTopic = query.executeUpdate();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1242
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1243
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1244 // delete records in TopicSectionRelation table
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1245 Query query0 = session.createQuery("delete LGTopicSectionRelation where topicId = :topicId");
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1246 query0.setLong("topicId", topicId);
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1247 modifiedTopic += query0.executeUpdate();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1248
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1249 // delete records in TopicTagRelation table
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1250 Query query1 = session.createQuery("delete LGTopicTagRelation where topicId = :topicId");
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1251 query1.setLong("topicId", topicId);
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1252 modifiedTopic += query1.executeUpdate();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1253
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1254 tx.commit();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1255 }catch (Exception e) {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1256 if (tx!=null) tx.rollback();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1257
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1258 e.printStackTrace();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1259
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1260 throw e;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1261 }finally {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1262 session.close();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1263 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1264
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1265 return modifiedTopic;
ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1266 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1267
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1268
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1269 protected static List<LGTopicSectionRelation> getAllLGTopicSectionRelationFromDB(){
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1270
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1271 List<LGTopicSectionRelation> list = null;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1272
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1273 Session session = HibernateUtil.getSessionFactory().openSession();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1274
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1275 try{
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1276
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1277 session.getTransaction().begin();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1278 Query query = session.createQuery("from LGTopicSectionRelation");
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1279 list = query.list();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1280 session.getTransaction().commit();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1281
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1282 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1283 catch(Exception e){
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1284 session.getTransaction().rollback();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1285 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1286 finally{
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1287
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1288 if (session != null && session.isOpen()) {
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1289 session.close();
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1290 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1291 }
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1292
ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1293 return list;
ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1294 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1295
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1296 protected static int deleteTopicSectionRelationFromDB(Long relationId){
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1297
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1298 int modifiedRelation;
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1299 Session session = HibernateUtil.getSessionFactory().openSession();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1300 Transaction tx = null;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1301 try{
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1302 tx = session.beginTransaction();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1303
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1304
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1305 Query query0 = session.createQuery("delete LGTopicSectionRelation where id = :relationId");
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1306 query0.setLong("relationId", relationId);
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1307 modifiedRelation = query0.executeUpdate();
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1308
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1309 tx.commit();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1310 }catch (Exception e) {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1311 if (tx!=null) tx.rollback();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1312
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1313 e.printStackTrace();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1314
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1315 throw e;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1316 }finally {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1317 session.close();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1318 }
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1319
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1320 return modifiedRelation;
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1321
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1322 }
ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1323
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1324
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1325
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1326
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1327 /* --- end topic --- */
ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1328
85 110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1329
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1330
0 3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1331 }

Mercurial > hg > LGServices

annotate src/main/java/de/mpiwg/gazetteer/utils/DBService.java @ 88:f4242db6206b