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

annotate src/main/java/de/mpiwg/gazetteer/utils/DBService.java @ 105:16a0796e3871 default tip

remove "console.log" from general.js

author	Calvin Yeh <cyeh@mpipw-berlin.mpg.com>
date	Fri, 29 Sep 2017 16:18:02 +0200
parents	090035f79373
children

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
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	41 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	42
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	43
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	44 // 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	45 // 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	46
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	47
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	48 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	49
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	50 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	51 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	52 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	53 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	54 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	55 }
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	56
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	57 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	58
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	59 private List<String> dynastyList;
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	60
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	61 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	62
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	63 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	64 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	65 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	66 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	67 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	68 }
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	69
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	70 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	71 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	72 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	73 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	74 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	75
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	76 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	77 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	78 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	79 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	80 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	81 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	82
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	83 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	84 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	85 }
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	86 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	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 } 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	89 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	90 }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	91 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	92 }
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	93
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	94 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	95 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	96 }
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	97
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	98 public List<DBBook> getBooks(){
14 3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	99 try {
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	100 this.loadBookMap();
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	101 } 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	102
14 3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	103 e.printStackTrace();
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	104 }
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	105
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	106 // 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	107 return new ArrayList<DBBook>(getBookMap().values());
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	108 }
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	109
110be241ff54 All session of ?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
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	111 public DBCoordinatesBook getCoordinatesBook(String bookId) {
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	112 return getCoordinatesBookMap().get(bookId);
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 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
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	115 private Map<String, DBCoordinatesBook> getCoordinatesBookMap() {
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	116 if (coordinatesBookMap == null) {
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	117 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	118 this.loadCoordinatesBookMap();
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	119 } catch (Exception e) {
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	120 e.printStackTrace();
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	121 }
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	122 }
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	123 return this.coordinatesBookMap;
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	124 }
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	125
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	126 private void loadCoordinatesBookMap() throws SQLException{
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	127 Long start = System.currentTimeMillis();
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	128 Connection conn = null;
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	129 Statement stmt = null;
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	130 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	131
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	132 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	133 String query = "SELECT * FROM coordinates_books";
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	134 logger.debug(query);
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	135 conn = getNewConnection();
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	136 stmt = conn.createStatement();
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	137 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	138
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	139 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	140 DBCoordinatesBook book = new DBCoordinatesBook(rs);
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	141 this.coordinatesBookMap.put(book.getBooks_id(), book);
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	142 }
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	143 rs.close();
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	144 } catch (Exception e) {
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	145 e.printStackTrace();
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	146 }finally{
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	147 conn.close();
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	148 }
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	149
19 9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	150 long end = System.currentTimeMillis();
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	151 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	152 }
9c4937b290c6 new: coordinates books Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	153
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	154 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	155 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	156 }
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	157
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	158 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	159 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	160 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	161 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	162 } 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	163 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	164 }
3e62083dbcbf First commit. This project 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 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	166 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	167 }
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	168
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	169 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	170 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	171 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	172 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	173 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	174
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	175 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	176 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	177 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	178 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	179 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	180 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	181
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 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	183 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	184
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	185 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	186 }
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	187 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	188
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	189 } 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	190 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	191 }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	192 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	193 }
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	194
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	195 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	196 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	197 }
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	198
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	199 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	200 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	201
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	202 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	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 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	205 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	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 //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	208 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	209 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	210 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	211 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	212 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	213 }
3e62083dbcbf First commit. This project 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 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	215 }
3e62083dbcbf First commit. This project 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
3e62083dbcbf First commit. This project 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 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	218 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	219 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	220
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	221 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	222 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	223 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	224
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	225 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	226 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	227 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	228 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	229 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	230 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	231 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	232 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	233 }
3e62083dbcbf First commit. This project 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 }
3e62083dbcbf First commit. This project 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 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	236 } 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	237 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	238 } 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	239 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	240 }
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	241
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	242 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	243 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	244
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	245 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	246 }
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	247
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	248 /*
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	249 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	250 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	251
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	252 String condition = "";
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	253 for(int i=0; i<termList.size() ; i++){
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	254 String term = termList.get(i);
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	255 if(i>0){
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	256 condition += " OR ";
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	257 }
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	258 condition += " contents.content like '%" + term + "%' ";
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	259 }
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	260
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	261
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	262 String sql =
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	263 "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	264 "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	265 "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	266 "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	267 "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	268 "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	269 "FROM contents " +
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	270 "JOIN books ON contents.books_id = books.id " +
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	271 "WHERE " + condition + " " +
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	272 "ORDER BY contents.books_id, contents.line";
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	273
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	274
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	275 Connection conn = null;
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	276 Statement stmt = null;
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	277 List<DBBook> resultSet = new ArrayList<DBBook>();
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	278 // 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	279 try {
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	280 conn = getNewConnection();
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	281 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	282
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	283 int count = 0;
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	284 ResultSet rs = stmt.executeQuery(sql);
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	285 while (rs.next()) {
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	286 count++;
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	287 DBBook book = new DBBook(rs);
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	288 resultSet.add(book);
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	289 }
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	290
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	291 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	292
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	293 rs.close();
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	294 } catch (Exception e) {
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	295 e.printStackTrace();
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	296 } finally {
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	297 conn.close();
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	298 }
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	299
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	300 long end = System.currentTimeMillis();
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	301 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	302
1 1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	303 return resultSet;
1af9d7db348e Changes in the pom configuration "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 0 diff changeset	304 }
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	305 */
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	306
110be241ff54 All session of ?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
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	308 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	309
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	310 Connection conn = null;
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	311 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	312
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	313 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	314
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	315 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	316 "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	317
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	318 try {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	319 Class.forName(JDBC_DRIVER);
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	320 conn = getNewConnection();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	321 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	322
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	323 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	324
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	325 while (rs.next()) {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	326 section = new DBSection(rs);
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	327 DBBook book = getInstance().getBook(bookId);
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	328 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	329
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	330 }
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	331 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	332
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	333 } catch (Exception e) {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	334 e.printStackTrace();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	335 } finally {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	336 conn.close();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	337 }
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	338
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	339 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	340 // 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	341
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	342 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	343 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	344 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	345 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	346 }
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	347
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	348 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	349
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	350 }
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 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
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	353 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	354 //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	355
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	356 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	357
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	358 String condition = "(";
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	359 for(int i=0; i<termList.size() ; i++){
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	360 String term = termList.get(i);
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	361 if(i>0){
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	362 condition += " OR ";
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	363 }
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	364
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	365 condition += " content like '%" + term + "%' ";
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	366 }
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	367 condition += ")";
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 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	371
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	372 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	373 "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	374 "(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	375 "(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	376 "(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	377 "(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	378
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	379 "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	380 "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	381
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	382 //logger.debug("sql: " + sql);
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	383
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	384 Connection conn = null;
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	385 Statement stmt = null;
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	386 List<DBContents> resultSet = new ArrayList<DBContents>();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	387 try {
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	388 conn = getNewConnection();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	389 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	390
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	391 Integer count = 0;
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	392 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	393
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	394 // log execution time
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	395 long tmp = System.currentTimeMillis();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	396 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	397
110be241ff54 All session of ?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 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	400
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	401 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	402 DBContents content = new DBContents(rs);
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	403 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	404
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	405 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	406
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	407 // set this.section by bookId and page
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	408 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	409
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	410 section.setId(rs.getLong("section_id"));
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	411 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	412
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	413 section.setBookId(books_id);
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	414 section.setStart_page(rs.getInt("start_page"));
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	415 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	416
110be241ff54 All session of ?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 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	419
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	420 // set this.coordinatesBook by bookId
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	421 /*
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	422 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	423
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	424 coordinatesBook.setId(rs.getInt("cb_id"));
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	425 coordinatesBook.setBooks_id(books_id);
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	426 coordinatesBook.setPlace_name(rs.getString("place_name"));
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	427 coordinatesBook.setX(rs.getString("x"));
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	428 coordinatesBook.setY(rs.getString("y"));
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	429 */
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	430
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	431 // set this.coordinatesBook by bookId
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	432 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	433
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	434 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	435
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	436
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	437 }
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	438 logger.debug("*********************** Count " + count + " ********************************");
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	439 // log execution time
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	440 long tmp2 = System.currentTimeMillis();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	441 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	442
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	443
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	444 rs.close();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	445 } catch (Exception e) {
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	446 e.printStackTrace();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	447 } finally {
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	448 conn.close();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	449 }
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	450 /*
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	451 // setting section in each DBContents content
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	452 for (DBContents content : resultSet) {
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	453 // set this.section by bookId and page
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	454 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	455
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	456 // set this.coordinatesBook by bookId
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	457 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	458 }
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	459 */
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
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	461
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	462 long end = System.currentTimeMillis();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	463 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	464
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	465 return resultSet;
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	466 }
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	467
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	468 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	469
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	470 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	471
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	472 String condition = "(";
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	473 for(int i=0; i<termList.size() ; i++){
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	474 String term = termList.get(i);
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	475 if(i>0){
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	476 condition += " OR ";
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	477 }
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	478
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	479 condition += " content like '%" + term + "%' ";
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	480 }
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	481 condition += ")";
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 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	485 "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	486 "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	487
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	488 //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	489
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	490 long tmp = 0 , tmp2 = 0;
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	491
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	492 Connection conn = null;
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	493 Statement stmt = null;
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	494 List<DBContents> resultSet = new ArrayList<DBContents>();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	495 try {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	496 conn = getNewConnection();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	497 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	498
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	499 Integer count = 0;
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	500 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	501
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	502 // log execution time
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	503 tmp = System.currentTimeMillis();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	504 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	505
110be241ff54 All session of ?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
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	507 while (rs.next()) {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	508 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	509 DBContents content = new DBContents(rs);
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	510 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	511 resultSet.add(content);
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	512 }
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	513 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	514
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	515 // log execution time
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	516 tmp2 = System.currentTimeMillis();
f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	517 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	518
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	519 rs.close();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	520 } catch (Exception e) {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	521 e.printStackTrace();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	522 } finally {
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	523 conn.close();
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	524 }
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	525
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	526
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	527
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	528 // 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	529 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	530 // 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	531 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	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 // 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	534 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	535 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	536
110be241ff54 All session of ?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
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	538 long end = System.currentTimeMillis();
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	539 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	540 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	541
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	542 return resultSet;
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	543 }
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	544
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	545
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	546
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	547 /**
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	548 * 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	549 * 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	550 *
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	551 * @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	552 * @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	553 * @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	554 */
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	555 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	556
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	557 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	558
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	559 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	560
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	561 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	562 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	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 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	565 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	566 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	567 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	568 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	569 }
3e62083dbcbf First commit. This project 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 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	571 }
3e62083dbcbf First commit. This project 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
3e62083dbcbf First commit. This project 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 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	574 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	575 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	576 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	577
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	578 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	579 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	580 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	581 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	582 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	583 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	584 }
3e62083dbcbf First commit. This project 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 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	586 } 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	587 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	588 } 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	589 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	590 }
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	591
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	592 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	593 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	594
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	595 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	596 }
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	597
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	598 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	599 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	600
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	601 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	602 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	603
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	604 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	605
3e62083dbcbf First commit. This project 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 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	607 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	608 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	609 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	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 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	612 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	613 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	614 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	615 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	616 }
3e62083dbcbf First commit. This project 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 }
3e62083dbcbf First commit. This project 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 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	619 } 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	620 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	621 } 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	622 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	623 }
3e62083dbcbf First commit. This project 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 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	625 }
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	626
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	627 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	628 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	629
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	630 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	631 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	632
110be241ff54 All session of ?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 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	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 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	636 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	637 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	638 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	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 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	641 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	642 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	643 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	644 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	645 }
110be241ff54 All session of ?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 }
110be241ff54 All session of ?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 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	648 } 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	649 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	650 } 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	651 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	652 }
110be241ff54 All session of ?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 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	654 }
110be241ff54 All session of ?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
110be241ff54 All session of ?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
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	657 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	658 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	659
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	660 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	661 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	662
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	663 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	664
3e62083dbcbf First commit. This project 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 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	666 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	667 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	668 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	669
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	670 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	671 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	672
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	673 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	674 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	675
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	676 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	677 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	678 } 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	679 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	680 } 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	681 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	682 }
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	683
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	684
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	685
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	686 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	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
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	690 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	691
3e62083dbcbf First commit. This project 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 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	693 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	694 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	695
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	696 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	697
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	698 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	699 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	700 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	701 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	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 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	704 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	705
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	706 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	707 /*
3e62083dbcbf First commit. This project 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 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	709 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	710 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	711 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	712
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	713 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	714 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	715 */
3e62083dbcbf First commit. This project 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 //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	717 //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	718 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	719 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	720
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	721 //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	722 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	723 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	724
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	725 }
3e62083dbcbf First commit. This project 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 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	727 } catch (Exception e) {
6 0378dbd683b8 Loggin an exception "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 1 diff changeset	728 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	729 } 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	730 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	731 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	732 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	733 }
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	734
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	735 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	736
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	737 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	738 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	739 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	740
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	741 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	742
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	743 try {
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	744 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	745 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	746 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	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 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	749 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	750 //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	751
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	752 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	753
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	754 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	755 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	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 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	758 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	759
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	760 //}
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	761 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	762 } 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	763 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	764 } finally {
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	765 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	766 }
3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	767 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	768 }
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	769
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	770
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	771
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	772 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	773 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	774 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	775 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	776 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	777 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	778 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	779 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	780 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	781 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	782 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	783 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	784 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	785 }
3e62083dbcbf First commit. This project 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 }
3e62083dbcbf First commit. This project 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 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	788 }
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	789
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	790 //"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	791 //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	792 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	793 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	794 //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	795
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	796 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	797 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	798
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	799 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	800 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	801 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	802 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	803 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	804 }
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	805 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	806
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	807 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	808 }
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	809
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	810 /*
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	811 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	812 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	813 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	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 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	816 //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	817 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	818 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	819 } 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	820 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	821 } 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	822 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	823 }
3e62083dbcbf First commit. This project 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 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	825 }*/
3e62083dbcbf First commit. This project 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 /*
3e62083dbcbf First commit. This project 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 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	828 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	829
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	830 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	831 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	832
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	833 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	834 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	835
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	836 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	837 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	838 }
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	839
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	840 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	841 }*/
3e62083dbcbf First commit. This project 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
3e62083dbcbf First commit. This project 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 /**
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	844 * 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	845 * 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	846 * @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	847 * @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	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 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	850 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	851
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	852 int modifiedFiles;
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	853 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	854 Transaction tx = null;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	855
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	856 try{
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	857
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	858 tx = session.beginTransaction();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	859
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	860 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	861 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	862 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	863
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	864 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	865 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	866 modifiedFiles += query0.executeUpdate();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	867
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	868 tx.commit();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	869
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	870 }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	871
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	872 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	873
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	874 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	875
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	876 throw e;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	877
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	878 }finally {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	879 session.close();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	880 }
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	881
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	882 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	883 }
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	884
54 a00efd5d9e77 new: adding delete saved table function Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 43 diff changeset	885 protected static int deleteFullTextSearchFileFromDB(Long fileId){
a00efd5d9e77 new: adding delete saved table function Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 43 diff changeset	886 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	887
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	888 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	889 Transaction tx = null;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	890
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	891 try{
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	892
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	893 tx = session.beginTransaction();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	894
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	895 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	896 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	897 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	898
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	899 tx.commit();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	900 }catch (Exception e) {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	901 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	902
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	903 e.printStackTrace();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	904
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	905 throw e;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	906 }finally {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	907 session.close();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	908 }
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	909
54 a00efd5d9e77 new: adding delete saved table function Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 43 diff changeset	910 return modifiedFiles;
a00efd5d9e77 new: adding delete saved table function Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 43 diff changeset	911 }
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	912
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	913 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	914
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	915 int modifiedFiles;
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	916 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	917 Transaction tx = null;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	918 try{
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	919 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	920
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	921 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	922 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	923 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	924
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	925 tx.commit();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	926 }catch (Exception e) {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	927 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	928
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	929 e.printStackTrace();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	930
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	931 throw e;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	932 }finally {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	933 session.close();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	934 }
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	935
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	936 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	937
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	938 }
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	939
34 2e1662afc81c new: add synchronization for files uploaded to LGDataverse Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	940 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	941 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	942
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	943 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	944
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	945 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	946
110be241ff54 All session of ?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 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	948 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	949 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	950 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	951 session.getTransaction().commit();
34 2e1662afc81c new: add synchronization for files uploaded to LGDataverse Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	952
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	953 }
110be241ff54 All session of ?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 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	955 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	956 }
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	957 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	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 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	960 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	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 }
34 2e1662afc81c new: add synchronization for files uploaded to LGDataverse Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	963
2e1662afc81c new: add synchronization for files uploaded to LGDataverse Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	964 return list;
2e1662afc81c new: add synchronization for files uploaded to LGDataverse Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	965 }
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	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
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	968 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	969
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	970 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	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 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	973
110be241ff54 All session of ?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 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	975
110be241ff54 All session of ?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 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	977 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	978 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	979 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	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 }
110be241ff54 All session of ?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 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	983
110be241ff54 All session of ?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 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	985 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	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 }
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	988
37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	989 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	990
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	991 }
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	992
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	993 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	994 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	995
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	996 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	997
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	998 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	999
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1000 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	1001 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	1002 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	1003 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	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 }
110be241ff54 All session of ?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 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	1007 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	1008 }
110be241ff54 All session of ?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 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	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 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	1012 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	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 }
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	1015
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1016 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	1017 }
110be241ff54 All session of ?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
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	1019 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	1020 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	1021
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 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	1023
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1024 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	1025
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1026 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	1027 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	1028 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	1029 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	1030 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	1031
110be241ff54 All session of ?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 }
110be241ff54 All session of ?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 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	1034 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	1035 }
110be241ff54 All session of ?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 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	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 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	1039 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	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 }
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	1042
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1043 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	1044 }
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	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
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1047
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1048 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	1049 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	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 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	1052
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1053 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	1054
110be241ff54 All session of ?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 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	1056 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	1057 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	1058 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	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 }
110be241ff54 All session of ?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 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	1062 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	1063 }
110be241ff54 All session of ?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 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	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 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	1067 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	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 }
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	1070
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1071 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	1072 }
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	1073
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	1074 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	1075
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1076 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	1077 Transaction tx = null;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1078 try{
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1079 tx = session.beginTransaction();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1080
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1081 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	1082
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1083 tx.commit();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1084 }catch (Exception e) {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1085 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	1086
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1087 e.printStackTrace();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1088
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1089 throw e;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1090 }finally {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1091 session.close();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1092 }
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	1093 }
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1094
3e62083dbcbf First commit. This project comes from LGServer. We removed the framework icefaces. Now, LGServices uses just JSP and jquery. "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: diff changeset	1095 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	1096 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	1097 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	1098 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	1099 } 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	1100 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	1101 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	1102 }
3e62083dbcbf First commit. This project 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 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	1104 }
3e62083dbcbf First commit. This project 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
3e62083dbcbf First commit. This project 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 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	1107
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	1108 return DriverManager.getConnection(
103 090035f79373 extract db url into config file Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 88 diff changeset	1109 PropertiesUtils.getPropValue("db_gazetter_url") +
090035f79373 extract db url into config file Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 88 diff changeset	1110 PropertiesUtils.getPropValue("db_gazetter_name") + "?useUnicode=yes&characterEncoding=UTF-8",
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	1111 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	1112 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	1113
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	1114 }
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1115
11 f15b0214cc1c Adding query for table SectionVersion "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 8 diff changeset	1116
f15b0214cc1c Adding query for table SectionVersion "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 8 diff changeset	1117 public List<DBSectionVersion> getSectionVersionList() throws SQLException {
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1118 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	1119
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1120 Connection con = null;
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1121 try{
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1122 con = getNewConnection();
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1123 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	1124 // query in sections_versions table.
13 9c6e74761f60 new: link to Edit Toc page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	1125 // 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	1126 String query = "SELECT * FROM sections_versions s1 " +
39 37840afb7b80 new: full text search Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 34 diff changeset	1127 "JOIN ( " +
12 d57fe2179f61 Improvement of book page "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 11 diff changeset	1128 "SELECT books_id, MAX(version) AS version " +
d57fe2179f61 Improvement of book page "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 11 diff changeset	1129 "FROM sections_versions " +
d57fe2179f61 Improvement of book page "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 11 diff changeset	1130 "GROUP BY books_id) AS s2 " +
d57fe2179f61 Improvement of book page "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 11 diff changeset	1131 "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	1132
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1133 ResultSet rs = stmt.executeQuery(query);
11 f15b0214cc1c Adding query for table SectionVersion "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 8 diff changeset	1134 while(rs.next()){
f15b0214cc1c Adding query for table SectionVersion "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 8 diff changeset	1135 DBSectionVersion sv = new DBSectionVersion(rs);
f15b0214cc1c Adding query for table SectionVersion "jurzua <jurzua@mpiwg-berlin.mpg.de>" parents: 8 diff changeset	1136 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	1137
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1138 }
66 f106f2487ac1 fix connection not close Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	1139 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	1140
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1141 } catch (Exception e) {
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1142 e.printStackTrace();
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1143 } finally {
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1144 con.close();
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1145 }
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1146 // ----
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	1147
8 8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1148 return section_version;
8702aa85d0fb add bookBean Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	1149 }
14 3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1150
21 5b1856cd6b4f bug fixed: 1.TOC Done display issue 2.issue in firefox Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	1151 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	1152 Connection conn = null;
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1153 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	1154
14 3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1155 try {
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1156 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	1157 conn = getNewConnection();
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1158 stmt = conn.createStatement();
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1159 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	1160
14 3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1161 } catch (Exception e) {
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1162 e.printStackTrace();
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1163 }finally{
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1164 conn.close();
3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1165 }
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	1166
14 3387d855a194 new: toc status in books page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	1167 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	1168 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	1169
110be241ff54 All session of ?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 }
22 2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1172
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1173 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	1174 Connection conn = null;
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1175 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	1176
22 2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1177 try {
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1178 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	1179 conn = getNewConnection();
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1180 stmt = conn.createStatement();
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1181 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	1182
22 2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1183 } catch (Exception e) {
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1184 e.printStackTrace();
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1185 }finally{
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1186 conn.close();
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1187 }
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	1188
22 2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1189 DBBook book = this.bookMap.get(bookId);
2c6f44ef34ab new: add comment textarea Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	1190 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	1191
110be241ff54 All session of ?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 }
27 3b3e2963c8f7 new: rewrite LGServices for LGDataverse with the new dataverse, dataverse4.0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	1194
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
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1196 /* --- topic --- */
ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1197 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	1198 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	1199
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1200 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	1201
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1202 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	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.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	1205 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	1206 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	1207 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	1208
110be241ff54 All session of ?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 }
110be241ff54 All session of ?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 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	1211 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	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 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	1214
110be241ff54 All session of ?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 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	1216 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	1217 }
110be241ff54 All session of ?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 }
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1219
ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1220 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	1221 }
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	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 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	1224
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1225 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	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 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	1228
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1229 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	1230
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1231 Transaction tx = null;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1232 try{
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1233 tx = session.beginTransaction();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1234 // 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	1235 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	1236 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	1237 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	1238
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1239
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1240 // 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	1241 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	1242 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	1243 modifiedTopic += query0.executeUpdate();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1244
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1245 // 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	1246 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	1247 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	1248 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	1249
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1250 tx.commit();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1251 }catch (Exception e) {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1252 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	1253
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1254 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	1255
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1256 throw e;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1257 }finally {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1258 session.close();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1259 }
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	1260
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1261 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	1262 }
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	1263
110be241ff54 All session of ?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 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	1266
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1267 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	1268
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1269 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	1270
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1271 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	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.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	1274 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	1275 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	1276 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	1277
110be241ff54 All session of ?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 }
110be241ff54 All session of ?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 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	1280 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	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 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	1283
110be241ff54 All session of ?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 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	1285 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	1286 }
110be241ff54 All session of ?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 }
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1288
ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1289 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	1290 }
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	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 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	1293
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1294 int modifiedRelation;
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1295 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	1296 Transaction tx = null;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1297 try{
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1298 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	1299
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1300
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1301 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	1302 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	1303 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	1304
88 f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1305 tx.commit();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1306 }catch (Exception e) {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1307 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	1308
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1309 e.printStackTrace();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1310
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1311 throw e;
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1312 }finally {
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1313 session.close();
f4242db6206b Refactoring : replace getCurrentSession with openSession for nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 85 diff changeset	1314 }
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	1315
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1316 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	1317
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1318 }
ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1319
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	1320
110be241ff54 All session of ?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
110be241ff54 All session of ?select? statement are changed to openSession() from getCurreentSession() to avoid nested transaction exception Calvin Yeh <cyeh@mpipw-berlin.mpg.com> parents: 68 diff changeset	1322
41 ba9515f22897 new: topic management and adding sections from searching result into topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 40 diff changeset	1323 /* --- 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	1324
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	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
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	1327 }

Mercurial > hg > LGServices

annotate src/main/java/de/mpiwg/gazetteer/utils/DBService.java @ 105:16a0796e3871 default tip