[Building Sakai] Profile2 SQL problem
Johan Zaxmy
Johan.Zaxmy at his.se
Wed Aug 18 23:02:01 PDT 2010
JIRA KNL-264
From: sakai-dev-bounces at collab.sakaiproject.org
[mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Steve
Swinsburg
Sent: den 19 augusti 2010 00:09
To: Johan Zaxmy
Cc: sakai-dev at collab.sakaiproject.org
Subject: Re: [Building Sakai] Profile2 SQL problem
Hi,
This isn't Profile2. The method call originates from Profile2 to call
the UserDirectoryService via
SakaiProxyImpl.searchUsers
and that method does this:
return userDirectoryService.searchUsers(search,
ProfileConstants.FIRST_RECORD,ProfileConstants.MAX_RECORDS);
where those numbers are 0 and 99 respectively.
Looks like it's in the Kernel. Can you file a JIRA?
cheers,
Steve
On 18/08/2010, at 11:53 PM, Johan Zaxmy wrote:
Not sure if this is a bug in profile 2 or some other problem, anyone who
can shed a light?
Seems like some databinding that never occurs, but I don't know. ;-)
2010-08-18 15:48:18,069 WARN http-8080-Processor18
org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select
SAKAI_USER.USER_ID,SAKAI_USER.EMAIL,SAKAI_USER.EMAIL_LC,SAKAI_USER.FIRST
_NAME,SAKAI_USER.LAST_NAME,SAKAI_USER.TYPE,SAKAI_USER.PW,SAKAI_USER.CREA
TEDBY,SAKAI_USER.MODIFIEDBY,SAKAI_USER.CREATEDON,SAKAI_USER.MODIFIEDON
from SAKAI_USER,SAKAI_USER_ID_MAP where SAKAI_USER.USER_ID =
SAKAI_USER_ID_MAP.USER_ID AND (SAKAI_USER.USER_ID = ? OR UPPER(EID) LIKE
UPPER(?) OR EMAIL_LC LIKE ? OR UPPER(FIRST_NAME) LIKE UPPER(?) OR
UPPER(LAST_NAME) LIKE UPPER(?)) order by
SAKAI_USER_ID_MAP.EID,SAKAI_USER.LAST_NAME,SAKAI_USER.FIRST_NAME limit
100 offset -1 linda %linda% %linda% %linda% %linda%
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '-1' at line 1
at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorA
ccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java:27)
at
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at
com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at
com.mysql.jdbc.Util.getInstance(Util.java:384)
at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:
2105)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:226
4)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:93)
at
org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:545
)
at
org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:464
)
at
org.sakaiproject.util.BaseDbFlatStorage.getSelectedResources(BaseDbFlatS
torage.java:619)
at
org.sakaiproject.user.impl.DbUserService$DbStorage.search(DbUserService.
java:329)
at
org.sakaiproject.user.impl.BaseUserDirectoryService.searchUsers(BaseUser
DirectoryService.java:1218)
at
org.sakaiproject.profile2.logic.SakaiProxyImpl.searchUsers(SakaiProxyImp
l.java:496)
at
org.sakaiproject.profile2.logic.ProfileLogicImpl.findUsersByNameOrEmail(
ProfileLogicImpl.java:1887)
at
org.sakaiproject.profile2.logic.ProfileLogicImpl.findUsersByNameOrEmail(
ProfileLogicImpl.java:531)
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
a:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at
java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(
AopUtils.java:307)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinp
oint(ReflectiveMethodInvocation.java:182)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref
lectiveMethodInvocation.java:149)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invok
e(TransactionInterceptor.java:106)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref
lectiveMethodInvocation.java:171)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAo
pProxy.java:204)
at $Proxy21.findUsersByNameOrEmail(Unknown
Source)
at
org.sakaiproject.profile2.tool.pages.MySearch$3.onSubmit(MySearch.java:3
84)
at
org.apache.wicket.ajax.markup.html.form.AjaxButton$1.onSubmit(AjaxButton
.java:115)
at
org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmi
tBehavior.java:128)
at
org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:
163)
at
org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDef
aultAjaxBehavior.java:297)
at
org.apache.wicket.request.target.component.listener.BehaviorRequestTarge
t.processEvents(BehaviorRequestTarget.java:104)
at
org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(Ab
stractRequestCycleProcessor.java:91)
at
org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java
:1220)
at
org.apache.wicket.RequestCycle.step(RequestCycle.java:1297)
at
org.apache.wicket.RequestCycle.steps(RequestCycle.java:1399)
at
org.apache.wicket.RequestCycle.request(RequestCycle.java:529)
at
org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:356
)
at
org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:
145)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:188)
at
org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:585)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:188)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatc
her.java:659)
at
org.apache.catalina.core.ApplicationDispatcher.processRequest(Applicatio
nDispatcher.java:457)
at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDisp
atcher.java:359)
at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispat
cher.java:311)
at
org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(Acti
veToolComponent.java:500)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(Skinnab
leCharonPortal.java:1221)
at
org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(ToolHandler.j
ava:204)
at
org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(ToolHandler.ja
va:96)
at
org.sakaiproject.portal.charon.handlers.ToolHandler.doPost(ToolHandler.j
ava:73)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.doPost(SkinnableCha
ronPortal.java:1064)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:188)
at
org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:646)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:172)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
74)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:87
9)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:689)
at java.lang.Thread.run(Thread.java:619)
regards
Johan Zaxmy
_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
TO UNSUBSCRIBE: send email to
sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
"unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100819/a5baf3a3/attachment.html
More information about the sakai-dev
mailing list