· 9 years ago · Oct 13, 2016, 04:30 AM
1Establishing connnection .... ! [connectionSource] com.j256.ormlite.jdbc.JdbcConnectionSource@55a18a2a
2DataAccess is READY! [sidik.model.information.ClassForumTopic] com.j256.ormlite.dao.BaseDaoImpl$5
3 queryBuilder : com.j256.ormlite.stmt.QueryBuilder@737bb3d0
4Establishing connnection .... ! [connectionSource] com.j256.ormlite.jdbc.JdbcConnectionSource@55a18a2a
5Oct 13, 2016 11:27:57 AM com.j256.ormlite.table.TableUtils log
6INFO: creating table 'class_forum_topic'
7Oct 13, 2016 11:27:57 AM com.j256.ormlite.table.TableUtils log
8INFO: executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS "class_forum_topic" ("id" VARCHAR(255) , "period_class_id" VARCHAR(255) , "title" VARCHAR(255) , "created_at" VARCHAR(50) , "updated_at" VARCHAR(50) , "created_by" VARCHAR(255) , "user_id" VARCHAR(255) , "user_type" VARCHAR(255) , "post_count" INTEGER , "updated_by" VARCHAR(255) , PRIMARY KEY ("id") )
9Failed creating table [sidik.model.information.ClassForumPost]: SQL statement failed: CREATE SEQUENCE "class_forum_post_id_seq"
10DataAccess is READY! [sidik.model.information.ClassForumPost] com.j256.ormlite.dao.BaseDaoImpl$5
11 queryBuilder : com.j256.ormlite.stmt.QueryBuilder@434c1066
12Establishing connnection .... ! [connectionSource] com.j256.ormlite.jdbc.JdbcConnectionSource@55a18a2a
13DataAccess is READY! [sidik.model.academic.PeriodClass] com.j256.ormlite.dao.BaseDaoImpl$5
14 queryBuilder : com.j256.ormlite.stmt.QueryBuilder@4428694
15Establishing connnection .... ! [connectionSource] com.j256.ormlite.jdbc.JdbcConnectionSource@1287ccd5
16Oct 13, 2016 11:27:57 AM com.j256.ormlite.table.TableUtils log
17INFO: creating table 'class_forum_post'
18Oct 13, 2016 11:27:57 AM com.j256.ormlite.table.TableUtils log
19INFO: creating table 'period_class'
20Oct 13, 2016 11:27:57 AM com.j256.ormlite.table.TableUtils log
21INFO: executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS "period_class" ("id" VARCHAR(255) , "unit_grade_id" INTEGER NOT NULL , "homeroom_teacher_id" VARCHAR(255) , "capacity" INTEGER , "grade_name" VARCHAR(255) NOT NULL , "period_name" VARCHAR(255) NOT NULL , "class_name" VARCHAR(255) NOT NULL , "service_unit_code" VARCHAR(255) NOT NULL , "location" VARCHAR(255) , "created_by" VARCHAR(255) , "created_time" VARCHAR(50) , "updated_by" VARCHAR(255) , "updated_time" VARCHAR(50) , "deleted_by" VARCHAR(255) , "delete_time" VARCHAR(50) , "academic_year" VARCHAR(255) , PRIMARY KEY ("id") , UNIQUE ("unit_grade_id","class_name","service_unit_code","academic_year") )
22Oct 13, 2016 11:27:57 AM com.j256.ormlite.table.TableUtils log
23INFO: creating table 'sidik_user'
24Oct 13, 2016 11:27:57 AM com.j256.ormlite.table.TableUtils log
25INFO: executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS "sidik_user" ("user_id" VARCHAR(255) , "email" VARCHAR(255) , "institution" VARCHAR(255) , "user_name" VARCHAR(255) , "password" VARCHAR(255) , "telegram_id" VARCHAR(255) , "active_edu_code" VARCHAR(255) , "active_academic_year" VARCHAR(255) , "active_period_name" VARCHAR(255) , PRIMARY KEY ("user_id") )
26Oct 13, 2016 11:27:57 AM sidik.model.other.DataAccess save
27SEVERE: null
28java.sql.SQLException: Unable to run insert stmt on object {"id":"4dbb25a5-de20-419d-b530-49e8e882ca64","title":"Test FCM","createdBy":"Abdul Wahab","periodClassId":"8","userId":"c44c9d7c-5f91-418d-ba35-5991bea562ca","userType":"TEACHER","createdAt":"Thu Oct 13 11:27:57 WIB 2016","updatedAt":"Thu Oct 13 11:27:57 WIB 2016","postCount":0,"updatedBy":"[unknown]"}: INSERT INTO "class_forum_topic" ("id" ,"period_class_id" ,"title" ,"created_at" ,"updated_at" ,"created_by" ,"user_id" ,"user_type" ,"post_count" ,"updated_by" ) VALUES (?,?,?,?,?,?,?,?,?,?)
29 at com.j256.ormlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:25)
30 at com.j256.ormlite.stmt.mapped.MappedCreate.insert(MappedCreate.java:137)
31 at com.j256.ormlite.stmt.StatementExecutor.create(StatementExecutor.java:472)
32 at com.j256.ormlite.dao.BaseDaoImpl.create(BaseDaoImpl.java:314)
33 at sidik.model.other.DataAccess.save(DataAccess.java:345)
34 at sidik.ajax.information.ClassForumUtil.createTopic(ClassForumUtil.java:270)
35 at sidik.ajax.information.ClassForumUtil.createResource(ClassForumUtil.java:236)
36 at sidik.ajax.information.ClassForumUtil.execute(ClassForumUtil.java:105)
37 at sidik.ajax.AjaxHandler.dispatch(AjaxHandler.java:129)
38 at org.apache.jsp.pages.AjaxHandler_jsp._jspService(AjaxHandler_jsp.java:251)
39 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
40 at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
41 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
42 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
43 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
44 at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
45 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
46 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
47 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
48 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
49 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
50 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
51 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
52 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
53 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
54 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
55 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
56 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
57 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
58 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
59 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
60 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
61 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
62 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
63 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
64 at java.lang.Thread.run(Thread.java:745)
65Caused by: org.postgresql.util.PSQLException: ERROR: column "period_class_id" is of type integer but expression is of type character varying
66 Hint: You will need to rewrite or cast the expression.
67 Position: 174
68 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
69 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
70 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
71DataAccess is READY! [sidik.model.system.SidikUser] com.j256.ormlite.dao.BaseDaoImpl$5
72 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:645)
73 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:495)
74 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:441)
75 at com.j256.ormlite.jdbc.JdbcDatabaseConnection.insert(JdbcDatabaseConnection.java:172)
76 at com.j256.ormlite.stmt.mapped.MappedCreate.insert(MappedCreate.java:91)
77 ... 34 more
78
79Oct 13, 2016 11:27:57 AM com.j256.ormlite.table.TableUtils log
80INFO: creating table 'sidik_user'
81Oct 13, 2016 11:27:57 AM com.j256.ormlite.table.TableUtils log
82INFO: executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS "sidik_user" ("user_id" VARCHAR(255) , "email" VARCHAR(255) , "institution" VARCHAR(255) , "user_name" VARCHAR(255) , "password" VARCHAR(255) , "telegram_id" VARCHAR(255) , "active_edu_code" VARCHAR(255) , "active_academic_year" VARCHAR(255) , "active_period_name" VARCHAR(255) , PRIMARY KEY ("user_id") )
83 queryBuilder : com.j256.ormlite.stmt.QueryBuilder@16149b2b
84Establishing connnection .... ! [connectionSource] com.j256.ormlite.jdbc.JdbcConnectionSource@1287ccd5
85DataAccess is READY! [sidik.model.system.SidikUser] com.j256.ormlite.dao.BaseDaoImpl$5
86 queryBuilder : com.j256.ormlite.stmt.QueryBuilder@67d5ff00
87Closing connSource .... [CLOSED] connSource
88Closing sysConnSource .... [CLOSED] sysConnSource
89Closing jdbcConnection .... Closing sysJdbcConnection .... [CLOSED] sysJdbcConnection
90Closing connSource .... [CLOSED] connSource
91Closing sysConnSource .... [CLOSED] sysConnSource
92Closing jdbcConnection .... Closing sysJdbcConnection .... [CLOSED] sysJdbcConnection
93Oct 13, 2016 11:27:57 AM sidik.model.other.DataAccess save
94SEVERE: null
95java.lang.NullPointerException
96 at sidik.model.information.ClassForumPost.toString(ClassForumPost.java:150)
97 at java.lang.String.valueOf(String.java:2994)
98 at java.lang.StringBuilder.append(StringBuilder.java:131)
99 at com.j256.ormlite.stmt.mapped.MappedCreate.insert(MappedCreate.java:137)
100 at com.j256.ormlite.stmt.StatementExecutor.create(StatementExecutor.java:472)
101 at com.j256.ormlite.dao.BaseDaoImpl.create(BaseDaoImpl.java:314)
102 at sidik.model.other.DataAccess.save(DataAccess.java:345)
103 at sidik.ajax.information.ClassForumUtil.createPost(ClassForumUtil.java:321)
104 at sidik.ajax.information.ClassForumUtil.createTopic(ClassForumUtil.java:271)
105 at sidik.ajax.information.ClassForumUtil.createResource(ClassForumUtil.java:236)
106 at sidik.ajax.information.ClassForumUtil.execute(ClassForumUtil.java:105)
107 at sidik.ajax.AjaxHandler.dispatch(AjaxHandler.java:129)
108 at org.apache.jsp.pages.AjaxHandler_jsp._jspService(AjaxHandler_jsp.java:251)
109 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
110 at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
111 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
112 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
113 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
114 at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
115 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
116 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
117 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
118 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
119 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
120 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
121 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
122 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
123 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
124 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
125 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
126 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
127 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
128 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
129 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
130 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
131 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
132 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
133 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
134 at java.lang.Thread.run(Thread.java:745)
135
136Oct 13, 2016 11:27:57 AM sidik.ajax.information.ClassForumUtil createResource
137SEVERE: null
138java.lang.Exception: Topic not found
139 at sidik.ajax.information.ClassForumUtil.updateMetaData(ClassForumUtil.java:348)
140 at sidik.ajax.information.ClassForumUtil.createPost(ClassForumUtil.java:322)
141 at sidik.ajax.information.ClassForumUtil.createTopic(ClassForumUtil.java:271)
142 at sidik.ajax.information.ClassForumUtil.createResource(ClassForumUtil.java:236)
143 at sidik.ajax.information.ClassForumUtil.execute(ClassForumUtil.java:105)
144 at sidik.ajax.AjaxHandler.dispatch(AjaxHandler.java:129)
145 at org.apache.jsp.pages.AjaxHandler_jsp._jspService(AjaxHandler_jsp.java:251)
146 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
147 at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
148 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
149 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
150 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
151 at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
152 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
153 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
154 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
155 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
156 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
157 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
158 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
159 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
160 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
161 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
162 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
163 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
164 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
165 at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
166 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
167 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
168 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
169 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
170 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
171 at java.lang.Thread.run(Thread.java:745)