I am trying to create a Java web based survey for my organization, and as a result I am trying to setup the Web Survey Toolbox which I downloaded from
http://websurveytoolbox.orgI have sucessfully downloaded MySQL and installed in my machine (Windows 2000 Professional) (Note:- This is the first time I am using MySQL)
I am getting the following error/exception. I am using JDK 1.5, Tomcat 5.5.12 and MySQL 5.0
**************************
**********
**********
**********
**********
****
DATE: Fri Dec 16 20:46:46 GMT+05:30 2005 [sendBug()]
Program: WebSurveyToolbox Survey Manager (using Web Survey Toolbox)
-------------------
DatabaseStorageMySQL: Exception trying to set new password for MySQL User(3):
-------------------
--Exception 1--
Throwable: 'cmu.survey.data.FailedReq
uest$Datab
aseFailure
: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin'@'localhost' IDENTIFIED BY PASSWORD 'null'' at line 1"'
-------------------
### Throwable trail: ###
cmu.survey.data.FailedRequ
est$Databa
seFailure:
java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin'@'localhost' IDENTIFIED BY PASSWORD 'null'' at line 1"
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.dec
ideWhatToT
hrow(Datab
aseStorage
MySQL.java
:555)
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.cre
ateUser(Da
tabaseStor
ageMySQL.j
ava:574)
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.upd
ateUser(Da
tabaseStor
ageMySQL.j
ava:710)
at cmu.jspsurveymanager.data.
DatabaseOb
jectStorag
e.updateUs
er(Databas
eObjectSto
rage.java:
637)
at cmu.jspsurveymanager.Contr
oller.doLo
ginAction(
Controller
.java:473)
at cmu.jspsurveymanager.Contr
oller.doPo
st(Control
ler.java:1
92)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
709)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
802)
at org.apache.catalina.core.A
pplication
FilterChai
n.internal
DoFilter(A
pplication
FilterChai
n.java:252
)
at org.apache.catalina.core.A
pplication
FilterChai
n.doFilter
(Applicati
onFilterCh
ain.java:1
73)
at org.apache.catalina.core.S
tandardWra
pperValve.
invoke(Sta
ndardWrapp
erValve.ja
va:213)
at org.apache.catalina.core.S
tandardCon
textValve.
invoke(Sta
ndardConte
xtValve.ja
va:178)
at org.apache.catalina.core.S
tandardHos
tValve.inv
oke(Standa
rdHostValv
e.java:126
)
at org.apache.catalina.valves
.ErrorRepo
rtValve.in
voke(Error
ReportValv
e.java:105
)
at org.apache.catalina.core.S
tandardEng
ineValve.i
nvoke(Stan
dardEngine
Valve.java
:107)
at org.apache.catalina.connec
tor.Coyote
Adapter.se
rvice(Coyo
teAdapter.
java:148)
at org.apache.coyote.http11.H
ttp11AprPr
ocessor.pr
ocess(Http
11AprProce
ssor.java:
831)
at org.apache.coyote.http11.H
ttp11AprPr
otocol$Htt
p11Connect
ionHandler
.process(H
ttp11AprPr
otocol.jav
a:652)
at org.apache.tomcat.util.net
.AprEndpoi
nt$Worker.
run(AprEnd
point.java
:1203)
at java.lang.Thread.run(Unkno
wn Source)
Caused by: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin'@'localhost' IDENTIFIED BY PASSWORD 'null'' at line 1"
at com.mysql.jdbc.MysqlIO.che
ckErrorPac
ket(MysqlI
O.java:190
5)
at com.mysql.jdbc.MysqlIO.sen
dCommand(M
ysqlIO.jav
a:1109)
at com.mysql.jdbc.MysqlIO.sql
QueryDirec
t(MysqlIO.
java:1203)
at com.mysql.jdbc.MysqlIO.sql
Query(Mysq
lIO.java:1
164)
at com.mysql.jdbc.Connection.
execSQL(Co
nnection.j
ava:2087)
at com.mysql.jdbc.Connection.
execSQL(Co
nnection.j
ava:2037)
at com.mysql.jdbc.Statement.e
xecute(Sta
tement.jav
a:900)
at cmu.survey.jsp.tags.Databa
seQuery.do
Query(Data
baseQuery.
java:776)
at cmu.survey.jsp.tags.Databa
seQuery.do
QueryThrow
ErrorsNoRe
sults(Data
baseQuery.
java:726)
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.cre
ateUser(Da
tabaseStor
ageMySQL.j
ava:572)
... 18 more
### End Throwable trail ###
### Caused by another Throwable trail: ###
java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin'@'localhost' IDENTIFIED BY PASSWORD 'null'' at line 1"
at com.mysql.jdbc.MysqlIO.che
ckErrorPac
ket(MysqlI
O.java:190
5)
at com.mysql.jdbc.MysqlIO.sen
dCommand(M
ysqlIO.jav
a:1109)
at com.mysql.jdbc.MysqlIO.sql
QueryDirec
t(MysqlIO.
java:1203)
at com.mysql.jdbc.MysqlIO.sql
Query(Mysq
lIO.java:1
164)
at com.mysql.jdbc.Connection.
execSQL(Co
nnection.j
ava:2087)
at com.mysql.jdbc.Connection.
execSQL(Co
nnection.j
ava:2037)
at com.mysql.jdbc.Statement.e
xecute(Sta
tement.jav
a:900)
at cmu.survey.jsp.tags.Databa
seQuery.do
Query(Data
baseQuery.
java:776)
at cmu.survey.jsp.tags.Databa
seQuery.do
QueryThrow
ErrorsNoRe
sults(Data
baseQuery.
java:726)
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.cre
ateUser(Da
tabaseStor
ageMySQL.j
ava:572)
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.upd
ateUser(Da
tabaseStor
ageMySQL.j
ava:710)
at cmu.jspsurveymanager.data.
DatabaseOb
jectStorag
e.updateUs
er(Databas
eObjectSto
rage.java:
637)
at cmu.jspsurveymanager.Contr
oller.doLo
ginAction(
Controller
.java:473)
at cmu.jspsurveymanager.Contr
oller.doPo
st(Control
ler.java:1
92)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
709)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
802)
at org.apache.catalina.core.A
pplication
FilterChai
n.internal
DoFilter(A
pplication
FilterChai
n.java:252
)
at org.apache.catalina.core.A
pplication
FilterChai
n.doFilter
(Applicati
onFilterCh
ain.java:1
73)
at org.apache.catalina.core.S
tandardWra
pperValve.
invoke(Sta
ndardWrapp
erValve.ja
va:213)
at org.apache.catalina.core.S
tandardCon
textValve.
invoke(Sta
ndardConte
xtValve.ja
va:178)
at org.apache.catalina.core.S
tandardHos
tValve.inv
oke(Standa
rdHostValv
e.java:126
)
at org.apache.catalina.valves
.ErrorRepo
rtValve.in
voke(Error
ReportValv
e.java:105
)
at org.apache.catalina.core.S
tandardEng
ineValve.i
nvoke(Stan
dardEngine
Valve.java
:107)
at org.apache.catalina.connec
tor.Coyote
Adapter.se
rvice(Coyo
teAdapter.
java:148)
at org.apache.coyote.http11.H
ttp11AprPr
ocessor.pr
ocess(Http
11AprProce
ssor.java:
831)
at org.apache.coyote.http11.H
ttp11AprPr
otocol$Htt
p11Connect
ionHandler
.process(H
ttp11AprPr
otocol.jav
a:652)
at org.apache.tomcat.util.net
.AprEndpoi
nt$Worker.
run(AprEnd
point.java
:1203)
at java.lang.Thread.run(Unkno
wn Source)
### End Caused by Throwable trail ###
ErrorCode: 1064
SQLState: 42000
-------------------
System Properties:
-- listing properties --
java.runtime.name=Java(TM)
2 Runtime Environment, Stand...
sun.boot.library.path=C:\P
rogram Files\Java\jre1.5.0_06\bin
java.vm.version=1.5.0_06-b
05
shared.loader=${catalina.b
ase}/share
d/classes,
${cat...
java.vm.vendor=Sun Microsystems Inc.
java.vendor.url=
http://java.sun.com/path.separator=;
java.vm.name=Java HotSpot(TM) Client VM
tomcat.util.buf.StringCach
e.byte.ena
bled=true
file.encoding.pkg=sun.io
java.util.logging.config.f
ile=C:\Tom
cat\conf\l
ogging.pro
perties
user.country=US
sun.os.patch.level=Service
Pack 4
java.vm.specification.name
=Java Virtual Machine Specification
user.dir=C:\Tomcat
java.runtime.version=1.5.0
_06-b05
java.awt.graphicsenv=sun.a
wt.Win32Gr
aphicsEnvi
ronment
java.endorsed.dirs=C:\Tomc
at\common\
endorsed
os.arch=x86
java.io.tmpdir=C:\Tomcat\t
emp
line.separator=
java.vm.specification.vend
or=Sun Microsystems Inc.
user.variant=
java.util.logging.manager=
org.apache
.juli.Clas
sLoaderLog
Manager
java.naming.factory.url.pk
gs=org.apa
che.naming
os.name=Windows 2000
sun.jnu.encoding=Cp1252
java.library.path=C:\Tomca
t\bin;.;C:
\WINNT\sys
tem32;C:\.
..
java.specification.name=Ja
va Platform API Specification
java.class.version=49.0
sun.management.compiler=Ho
tSpot Client Compiler
os.version=5.0
user.home=C:\Documents and Settings\Default User
user.timezone=GMT+05:30
catalina.useNaming=true
java.awt.printerjob=sun.aw
t.windows.
WPrinterJo
b
java.specification.version
=1.5
file.encoding=Cp1252
catalina.home=C:\Tomcat
user.name=SYSTEM
java.class.path=C:\Tomcat\
bin\bootst
rap.jar
java.naming.factory.initia
l=org.apac
he.naming.
java.javaU
RLContext.
..
package.definition=sun.,ja
va.,org.ap
ache.catal
ina.,org.a
...
java.vm.specification.vers
ion=1.0
sun.arch.data.model=32
java.home=C:\Program Files\Java\jre1.5.0_06
java.specification.vendor=
Sun Microsystems Inc.
user.language=en
awt.toolkit=sun.awt.window
s.WToolkit
java.vm.info=mixed mode, sharing
java.version=1.5.0_06
java.ext.dirs=C:\Program Files\Java\jre1.5.0_06\lib
...
sun.boot.class.path=C:\Pro
gram Files\Java\jre1.5.0_06\lib
...
java.vendor=Sun Microsystems Inc.
server.loader=${catalina.h
ome}/serve
r/classes,
${cat...
catalina.base=C:\Tomcat
file.separator=\
java.vendor.url.bug=
http://java.sun.com/cgi-bin/bugreport...
common.loader=${catalina.h
ome}/commo
n/classes,
${cat...
sun.cpu.endian=little
sun.io.unicode.encoding=Un
icodeLittl
e
package.access=sun.,org.ap
ache.catal
ina.,org.a
pache....
sun.desktop=windows
sun.cpu.isalist=
-------------------
Last 4000 characters of debugging output:
.jdbc.MysqlIO.checkErrorPa
cket(Mysql
IO.java:19
05)
at com.mysql.jdbc.MysqlIO.sen
dCommand(M
ysqlIO.jav
a:1109)
at com.mysql.jdbc.MysqlIO.sql
QueryDirec
t(MysqlIO.
java:1203)
at com.mysql.jdbc.MysqlIO.sql
Query(Mysq
lIO.java:1
164)
at com.mysql.jdbc.Connection.
execSQL(Co
nnection.j
ava:2087)
at com.mysql.jdbc.Connection.
execSQL(Co
nnection.j
ava:2037)
at com.mysql.jdbc.Statement.e
xecute(Sta
tement.jav
a:900)
at cmu.survey.jsp.tags.Databa
seQuery.do
Query(Data
baseQuery.
java:776)
at cmu.survey.jsp.tags.Databa
seQuery.do
QueryThrow
ErrorsNoRe
sults(Data
baseQuery.
java:726)
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.cre
ateUser(Da
tabaseStor
ageMySQL.j
ava:572)
... 18 more
### End Throwable trail ###
### Caused by another Throwable trail: ###
java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin'@'localhost' IDENTIFIED BY PASSWORD 'null'' at line 1"
at com.mysql.jdbc.MysqlIO.che
ckErrorPac
ket(MysqlI
O.java:190
5)
at com.mysql.jdbc.MysqlIO.sen
dCommand(M
ysqlIO.jav
a:1109)
at com.mysql.jdbc.MysqlIO.sql
QueryDirec
t(MysqlIO.
java:1203)
at com.mysql.jdbc.MysqlIO.sql
Query(Mysq
lIO.java:1
164)
at com.mysql.jdbc.Connection.
execSQL(Co
nnection.j
ava:2087)
at com.mysql.jdbc.Connection.
execSQL(Co
nnection.j
ava:2037)
at com.mysql.jdbc.Statement.e
xecute(Sta
tement.jav
a:900)
at cmu.survey.jsp.tags.Databa
seQuery.do
Query(Data
baseQuery.
java:776)
at cmu.survey.jsp.tags.Databa
seQuery.do
QueryThrow
ErrorsNoRe
sults(Data
baseQuery.
java:726)
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.cre
ateUser(Da
tabaseStor
ageMySQL.j
ava:572)
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.upd
ateUser(Da
tabaseStor
ageMySQL.j
ava:710)
at cmu.jspsurveymanager.data.
DatabaseOb
jectStorag
e.updateUs
er(Databas
eObjectSto
rage.java:
637)
at cmu.jspsurveymanager.Contr
oller.doLo
ginAction(
Controller
.java:473)
at cmu.jspsurveymanager.Contr
oller.doPo
st(Control
ler.java:1
92)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
709)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
802)
at org.apache.catalina.core.A
pplication
FilterChai
n.internal
DoFilter(A
pplication
FilterChai
n.java:252
)
at org.apache.catalina.core.A
pplication
FilterChai
n.doFilter
(Applicati
onFilterCh
ain.java:1
73)
at org.apache.catalina.core.S
tandardWra
pperValve.
invoke(Sta
ndardWrapp
erValve.ja
va:213)
at org.apache.catalina.core.S
tandardCon
textValve.
invoke(Sta
ndardConte
xtValve.ja
va:178)
at org.apache.catalina.core.S
tandardHos
tValve.inv
oke(Standa
rdHostValv
e.java:126
)
at org.apache.catalina.valves
.ErrorRepo
rtValve.in
voke(Error
ReportValv
e.java:105
)
at org.apache.catalina.core.S
tandardEng
ineValve.i
nvoke(Stan
dardEngine
Valve.java
:107)
at org.apache.catalina.connec
tor.Coyote
Adapter.se
rvice(Coyo
teAdapter.
java:148)
at org.apache.coyote.http11.H
ttp11AprPr
ocessor.pr
ocess(Http
11AprProce
ssor.java:
831)
at org.apache.coyote.http11.H
ttp11AprPr
otocol$Htt
p11Connect
ionHandler
.process(H
ttp11AprPr
otocol.jav
a:652)
at org.apache.tomcat.util.net
.AprEndpoi
nt$Worker.
run(AprEnd
point.java
:1203)
at java.lang.Thread.run(Unkno
wn Source)
### End Caused by Throwable trail ###
ErrorCode: 1064
SQLState: 42000
<<<<<<<<<<<<<<<<<<<<<<<<<<
<<<<<<<
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseObjectStorage -- creating tomcat manager connection from path C:\Tomcat\webapps\surveyma
nager\..\.
.
SendMail.sendEmail():
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseObjectStorage -- creating tomcat manager connection from path ../../
Failed to send message using server smtp.andrew.cmu.edu
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseObjectStorage -- creating tomcat manager connection from path C:\Tomcat\webapps\surveyma
nager\..\.
.
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseObjectStorage -- creating tomcat manager connection from path ../../
DatabaseQuery.doQuery(SELE
CT * FROM `admins` WHERE (`username`<=>'admin')):
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
DatabaseQuery.doQuery(SELE
CT * FROM `admins` WHERE (`username`<=>'admin')):
DatabaseQuery.doQuery(SELE
CT Host FROM mysql.user WHERE User='admin'):
DatabaseStorageMySQL Warning: user admin isn't in the MySQL user table!
DatabaseQuery.doQuery(UPDA
TE mysql.user SET Host='127.0.0.1' WHERE User='admin'):
DatabaseQuery.doQuery(SELE
CT Host FROM mysql.user WHERE User='admin'):
DatabaseQuery.doQuery(CREA
TE 'admin'@'localhost' IDENTIFIED BY PASSWORD 'null'):
>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>
DATE: Fri Dec 16 20:46:46 GMT+05:30 2005 [sendBug()]
Program: WebSurveyToolbox Survey Manager (using Web Survey Toolbox)
-------------------
DatabaseStorageMySQL: Exception trying to set new password for MySQL User(3):
-------------------
--Exception 1--
Throwable: 'cmu.survey.data.FailedReq
uest$Datab
aseFailure
: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin'@'localhost' IDENTIFIED BY PASSWORD 'null'' at line 1"'
-------------------
### Throwable trail: ###
cmu.survey.data.FailedRequ
est$Databa
seFailure:
java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin'@'localhost' IDENTIFIED BY PASSWORD 'null'' at line 1"
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.dec
ideWhatToT
hrow(Datab
aseStorage
MySQL.java
:555)
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.cre
ateUser(Da
tabaseStor
ageMySQL.j
ava:574)
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.upd
ateUser(Da
tabaseStor
ageMySQL.j
ava:710)
at cmu.jspsurveymanager.data.
DatabaseOb
jectStorag
e.updateUs
er(Databas
eObjectSto
rage.java:
637)
at cmu.jspsurveymanager.Contr
oller.doLo
ginAction(
Controller
.java:473)
at cmu.jspsurveymanager.Contr
oller.doPo
st(Control
ler.java:1
92)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
709)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
802)
at org.apache.catalina.core.A
pplication
FilterChai
n.internal
DoFilter(A
pplication
FilterChai
n.java:252
)
at org.apache.catalina.core.A
pplication
FilterChai
n.doFilter
(Applicati
onFilterCh
ain.java:1
73)
at org.apache.catalina.core.S
tandardWra
pperValve.
invoke(Sta
ndardWrapp
erValve.ja
va:213)
at org.apache.catalina.core.S
tandardCon
textValve.
invoke(Sta
ndardConte
xtValve.ja
va:178)
at org.apache.catalina.core.S
tandardHos
tValve.inv
oke(Standa
rdHostValv
e.java:126
)
at org.apache.catalina.valves
.ErrorRepo
rtValve.in
voke(Error
ReportValv
e.java:105
)
at org.apache.catalina.core.S
tandardEng
ineValve.i
nvoke(Stan
dardEngine
Valve.java
:107)
at org.apache.catalina.connec
tor.Coyote
Adapter.se
rvice(Coyo
teAdapter.
java:148)
at org.apache.coyote.http11.H
ttp11AprPr
ocessor.pr
ocess(Http
11AprProce
ssor.java:
831)
at org.apache.coyote.http11.H
ttp11AprPr
otocol$Htt
p11Connect
ionHandler
.process(H
ttp11AprPr
otocol.jav
a:652)
at org.apache.tomcat.util.net
.AprEndpoi
nt$Worker.
run(AprEnd
point.java
:1203)
at java.lang.Thread.run(Unkno
wn Source)
Caused by: java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin'@'localhost' IDENTIFIED BY PASSWORD 'null'' at line 1"
at com.mysql.jdbc.MysqlIO.che
ckErrorPac
ket(MysqlI
O.java:190
5)
at com.mysql.jdbc.MysqlIO.sen
dCommand(M
ysqlIO.jav
a:1109)
at com.mysql.jdbc.MysqlIO.sql
QueryDirec
t(MysqlIO.
java:1203)
at com.mysql.jdbc.MysqlIO.sql
Query(Mysq
lIO.java:1
164)
at com.mysql.jdbc.Connection.
execSQL(Co
nnection.j
ava:2087)
at com.mysql.jdbc.Connection.
execSQL(Co
nnection.j
ava:2037)
at com.mysql.jdbc.Statement.e
xecute(Sta
tement.jav
a:900)
at cmu.survey.jsp.tags.Databa
seQuery.do
Query(Data
baseQuery.
java:776)
at cmu.survey.jsp.tags.Databa
seQuery.do
QueryThrow
ErrorsNoRe
sults(Data
baseQuery.
java:726)
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.cre
ateUser(Da
tabaseStor
ageMySQL.j
ava:572)
... 18 more
### End Throwable trail ###
### Caused by another Throwable trail: ###
java.sql.SQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''admin'@'localhost' IDENTIFIED BY PASSWORD 'null'' at line 1"
at com.mysql.jdbc.MysqlIO.che
ckErrorPac
ket(MysqlI
O.java:190
5)
at com.mysql.jdbc.MysqlIO.sen
dCommand(M
ysqlIO.jav
a:1109)
at com.mysql.jdbc.MysqlIO.sql
QueryDirec
t(MysqlIO.
java:1203)
at com.mysql.jdbc.MysqlIO.sql
Query(Mysq
lIO.java:1
164)
at com.mysql.jdbc.Connection.
execSQL(Co
nnection.j
ava:2087)
at com.mysql.jdbc.Connection.
execSQL(Co
nnection.j
ava:2037)
at com.mysql.jdbc.Statement.e
xecute(Sta
tement.jav
a:900)
at cmu.survey.jsp.tags.Databa
seQuery.do
Query(Data
baseQuery.
java:776)
at cmu.survey.jsp.tags.Databa
seQuery.do
QueryThrow
ErrorsNoRe
sults(Data
baseQuery.
java:726)
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.cre
ateUser(Da
tabaseStor
ageMySQL.j
ava:572)
at cmu.survey.data.mysql.Data
baseStorag
eMySQL.upd
ateUser(Da
tabaseStor
ageMySQL.j
ava:710)
at cmu.jspsurveymanager.data.
DatabaseOb
jectStorag
e.updateUs
er(Databas
eObjectSto
rage.java:
637)
at cmu.jspsurveymanager.Contr
oller.doLo
ginAction(
Controller
.java:473)
at cmu.jspsurveymanager.Contr
oller.doPo
st(Control
ler.java:1
92)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
709)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
802)
at org.apache.catalina.core.A
pplication
FilterChai
n.internal
DoFilter(A
pplication
FilterChai
n.java:252
)
at org.apache.catalina.core.A
pplication
FilterChai
n.doFilter
(Applicati
onFilterCh
ain.java:1
73)
at org.apache.catalina.core.S
tandardWra
pperValve.
invoke(Sta
ndardWrapp
erValve.ja
va:213)
at org.apache.catalina.core.S
tandardCon
textValve.
invoke(Sta
ndardConte
xtValve.ja
va:178)
at org.apache.catalina.core.S
tandardHos
tValve.inv
oke(Standa
rdHostValv
e.java:126
)
at org.apache.catalina.valves
.ErrorRepo
rtValve.in
voke(Error
ReportValv
e.java:105
)
at org.apache.catalina.core.S
tandardEng
ineValve.i
nvoke(Stan
dardEngine
Valve.java
:107)
at org.apache.catalina.connec
tor.Coyote
Adapter.se
rvice(Coyo
teAdapter.
java:148)
at org.apache.coyote.http11.H
ttp11AprPr
ocessor.pr
ocess(Http
11AprProce
ssor.java:
831)
at org.apache.coyote.http11.H
ttp11AprPr
otocol$Htt
p11Connect
ionHandler
.process(H
ttp11AprPr
otocol.jav
a:652)
at org.apache.tomcat.util.net
.AprEndpoi
nt$Worker.
run(AprEnd
point.java
:1203)
at java.lang.Thread.run(Unkno
wn Source)
### End Caused by Throwable trail ###
ErrorCode: 1064
SQLState: 42000
<<<<<<<<<<<<<<<<<<<<<<<<<<
<<<<<<<
DatabaseQuery.doQuery(SELE
CT * FROM `prefs`):
**************************
**********
**********
**********
**********
****
Any help is highly appreciated.
Start Free Trial