mysql错误
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.elan.quick.config.SqlSessionInterceptor.invoke(SqlSessionInterceptor.java:36)
at com.sun.proxy.
P
r
o
x
y
123.
s
e
l
e
c
t
L
i
s
t
(
U
n
k
n
o
w
n
S
o
u
r
c
e
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
b
i
n
d
i
n
g
.
M
a
p
p
e
r
M
e
t
h
o
d
.
e
x
e
c
u
t
e
F
o
r
M
a
n
y
(
M
a
p
p
e
r
M
e
t
h
o
d
.
j
a
v
a
:
139
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
b
i
n
d
i
n
g
.
M
a
p
p
e
r
M
e
t
h
o
d
.
e
x
e
c
u
t
e
(
M
a
p
p
e
r
M
e
t
h
o
d
.
j
a
v
a
:
76
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
b
i
n
d
i
n
g
.
M
a
p
p
e
r
P
r
o
x
y
.
i
n
v
o
k
e
(
M
a
p
p
e
r
P
r
o
x
y
.
j
a
v
a
:
59
)
a
t
c
o
m
.
s
u
n
.
p
r
o
x
y
.
Proxy123.selectList(Unknown Source) at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) at com.sun.proxy.
Proxy123.selectList(UnknownSource)atorg.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139)atorg.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)atorg.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)atcom.sun.proxy.Proxy157.selectTotal(Unknown Source)
at com.elan.expo.schedule.DashSchedule.getTotalExceldata(DashSchedule.java:186)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:93)
at java.util.concurrent.Executors
R
u
n
n
a
b
l
e
A
d
a
p
t
e
r
.
c
a
l
l
(
E
x
e
c
u
t
o
r
s
.
j
a
v
a
:
511
)
a
t
j
a
v
a
.
u
t
i
l
.
c
o
n
c
u
r
r
e
n
t
.
F
u
t
u
r
e
T
a
s
k
.
r
u
n
(
F
u
t
u
r
e
T
a
s
k
.
j
a
v
a
:
266
)
a
t
j
a
v
a
.
u
t
i
l
.
c
o
n
c
u
r
r
e
n
t
.
S
c
h
e
d
u
l
e
d
T
h
r
e
a
d
P
o
o
l
E
x
e
c
u
t
o
r
RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor
RunnableAdapter.call(Executors.java:511)atjava.util.concurrent.FutureTask.run(FutureTask.java:266)atjava.util.concurrent.ScheduledThreadPoolExecutorScheduledFutureTask.access
201
(
S
c
h
e
d
u
l
e
d
T
h
r
e
a
d
P
o
o
l
E
x
e
c
u
t
o
r
.
j
a
v
a
:
180
)
a
t
j
a
v
a
.
u
t
i
l
.
c
o
n
c
u
r
r
e
n
t
.
S
c
h
e
d
u
l
e
d
T
h
r
e
a
d
P
o
o
l
E
x
e
c
u
t
o
r
201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor
201(ScheduledThreadPoolExecutor.java:180)atjava.util.concurrent.ScheduledThreadPoolExecutorScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutorKaTeX parse error: Expected 'EOF', got '#' at position 152: …Exception: \##̲# Error queryin…Proxy189.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
… 26 more
Caused by: com.foundationdb.sql.parser.SQLParserException: Encountered " <SINGLEQUOTED_STRING> "‘企业id’ “” at line 1, column 25.
Was expecting one of:
…
<BACKQUOTED_IDENTIFIER> …
<DOUBLEQUOTED_IDENTIFIER> …
at com.foundationdb.sql.parser.SQLParser.parseStatement(SQLParser.java:106)
at com.job1001.util.DynamicUtil.executeInvocation(DynamicUtil.java:59)
at com.job1001.plugins.DynamicOtherSQLPlugin.intercept(DynamicOtherSQLPlugin.java:71)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
… 28 more
Caused by: com.foundationdb.sql.parser.ParseException: Encountered " <SINGLEQUOTED_STRING> "‘企业id’ “” at line 1, column 25.
Was expecting one of:
…
<BACKQUOTED_IDENTIFIER> …
<DOUBLEQUOTED_IDENTIFIER> …
at com.foundationdb.sql.parser.SQLGrammar.generateParseException(SQLGrammar.java:22325)
at com.foundationdb.sql.parser.SQLGrammar.jj_consume_token(SQLGrammar.java:22170)
at com.foundationdb.sql.parser.SQLGrammar.internalIdentifier(SQLGrammar.java:15458)
at com.foundationdb.sql.parser.SQLGrammar.identifier(SQLGrammar.java:15467)
at com.foundationdb.sql.parser.SQLGrammar.asClause(SQLGrammar.java:4570)
at com.foundationdb.sql.parser.SQLGrammar.derivedColumn(SQLGrammar.java:4543)
at com.foundationdb.sql.parser.SQLGrammar.selectSublist(SQLGrammar.java:4529)
at com.foundationdb.sql.parser.SQLGrammar.selectColumnList(SQLGrammar.java:4481)
at com.foundationdb.sql.parser.SQLGrammar.selectList(SQLGrammar.java:4475)
at com.foundationdb.sql.parser.SQLGrammar.querySpecification(SQLGrammar.java:4424)
at com.foundationdb.sql.parser.SQLGrammar.simpleTable(SQLGrammar.java:4378)
at com.foundationdb.sql.parser.SQLGrammar.nonJoinQueryPrimary(SQLGrammar.java:4357)
at com.foundationdb.sql.parser.SQLGrammar.nonJoinQueryTerm(SQLGrammar.java:4246)
at com.foundationdb.sql.parser.SQLGrammar.queryExpression(SQLGrammar.java:4151)
at com.foundationdb.sql.parser.SQLGrammar.preparableSelectStatement(SQLGrammar.java:2259)
at com.foundationdb.sql.parser.SQLGrammar.preparableSQLDataStatement(SQLGrammar.java:2127)
at com.foundationdb.sql.parser.SQLGrammar.StatementPart(SQLGrammar.java:1870)
at com.foundationdb.sql.parser.SQLGrammar.Statement(SQLGrammar.java:1768)
at com.foundationdb.sql.parser.SQLGrammar.parseStatement(SQLGrammar.java:1754)
at com.foundationdb.sql.parser.SQLParser.parseStatement(SQLParser.java:103)
… 31 more
java.lang.NullPointerException
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:142)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.
P
r
o
x
y
157.
s
e
l
e
c
t
T
o
t
a
l
(
U
n
k
n
o
w
n
S
o
u
r
c
e
)
a
t
c
o
m
.
e
l
a
n
.
e
x
p
o
.
s
c
h
e
d
u
l
e
.
D
a
s
h
S
c
h
e
d
u
l
e
.
g
e
t
T
o
t
a
l
E
x
c
e
l
d
a
t
a
(
D
a
s
h
S
c
h
e
d
u
l
e
.
j
a
v
a
:
186
)
a
t
s
u
n
.
r
e
f
l
e
c
t
.
N
a
t
i
v
e
M
e
t
h
o
d
A
c
c
e
s
s
o
r
I
m
p
l
.
i
n
v
o
k
e
0
(
N
a
t
i
v
e
M
e
t
h
o
d
)
a
t
s
u
n
.
r
e
f
l
e
c
t
.
N
a
t
i
v
e
M
e
t
h
o
d
A
c
c
e
s
s
o
r
I
m
p
l
.
i
n
v
o
k
e
(
N
a
t
i
v
e
M
e
t
h
o
d
A
c
c
e
s
s
o
r
I
m
p
l
.
j
a
v
a
:
62
)
a
t
s
u
n
.
r
e
f
l
e
c
t
.
D
e
l
e
g
a
t
i
n
g
M
e
t
h
o
d
A
c
c
e
s
s
o
r
I
m
p
l
.
i
n
v
o
k
e
(
D
e
l
e
g
a
t
i
n
g
M
e
t
h
o
d
A
c
c
e
s
s
o
r
I
m
p
l
.
j
a
v
a
:
43
)
a
t
j
a
v
a
.
l
a
n
g
.
r
e
f
l
e
c
t
.
M
e
t
h
o
d
.
i
n
v
o
k
e
(
M
e
t
h
o
d
.
j
a
v
a
:
497
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
c
h
e
d
u
l
i
n
g
.
s
u
p
p
o
r
t
.
S
c
h
e
d
u
l
e
d
M
e
t
h
o
d
R
u
n
n
a
b
l
e
.
r
u
n
(
S
c
h
e
d
u
l
e
d
M
e
t
h
o
d
R
u
n
n
a
b
l
e
.
j
a
v
a
:
84
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
c
h
e
d
u
l
i
n
g
.
s
u
p
p
o
r
t
.
D
e
l
e
g
a
t
i
n
g
E
r
r
o
r
H
a
n
d
l
i
n
g
R
u
n
n
a
b
l
e
.
r
u
n
(
D
e
l
e
g
a
t
i
n
g
E
r
r
o
r
H
a
n
d
l
i
n
g
R
u
n
n
a
b
l
e
.
j
a
v
a
:
54
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
c
h
e
d
u
l
i
n
g
.
c
o
n
c
u
r
r
e
n
t
.
R
e
s
c
h
e
d
u
l
i
n
g
R
u
n
n
a
b
l
e
.
r
u
n
(
R
e
s
c
h
e
d
u
l
i
n
g
R
u
n
n
a
b
l
e
.
j
a
v
a
:
93
)
a
t
j
a
v
a
.
u
t
i
l
.
c
o
n
c
u
r
r
e
n
t
.
E
x
e
c
u
t
o
r
s
Proxy157.selectTotal(Unknown Source) at com.elan.expo.schedule.DashSchedule.getTotalExceldata(DashSchedule.java:186) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:93) at java.util.concurrent.Executors
Proxy157.selectTotal(UnknownSource)atcom.elan.expo.schedule.DashSchedule.getTotalExceldata(DashSchedule.java:186)atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)atjava.lang.reflect.Method.invoke(Method.java:497)atorg.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)atorg.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)atorg.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:93)atjava.util.concurrent.ExecutorsRunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access
201
(
S
c
h
e
d
u
l
e
d
T
h
r
e
a
d
P
o
o
l
E
x
e
c
u
t
o
r
.
j
a
v
a
:
180
)
a
t
j
a
v
a
.
u
t
i
l
.
c
o
n
c
u
r
r
e
n
t
.
S
c
h
e
d
u
l
e
d
T
h
r
e
a
d
P
o
o
l
E
x
e
c
u
t
o
r
201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor
201(ScheduledThreadPoolExecutor.java:180)atjava.util.concurrent.ScheduledThreadPoolExecutorScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
查看 Mapper.xml
是否 as 后面接的是 单引号，将as后面的单引号改为双引号 问题解决
select t.cid,t.cn,
sum(case t.eduId1 when '本科以下' then t.num else 0 end) as '本科以下',
sum(case t.eduId1 when '本科' then t.num else 0 end) as '本科',
sum(case t.eduId1 when '硕士' then t.num else 0 end) as '硕士',
扫一扫
2591
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
