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