You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by "hall hu (JIRA)" <no...@atlassian.com> on 2007/04/25 10:56:55 UTC
[Roller-JIRA] Commented: (ROL-1364) add new user
[ http://opensource.atlassian.com/projects/roller/browse/ROL-1364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_13718 ]
hall hu commented on ROL-1364:
------------------------------
I got this problem too. Could somebody tell me how to fit this bug, or tell me which java class this sql script in.
> add new user
> ------------
>
> Key: ROL-1364
> URL: http://opensource.atlassian.com/projects/roller/browse/ROL-1364
> Project: Roller
> Issue Type: Bug
> Components: Database Access & Data Model
> Affects Versions: 3.1
> Environment: tomcat 5.5, Oracle10g
> Reporter: Boris
> Assignee: Roller Unassigned
>
> There is a bug when adding a new roller user when running roller on Oracle DB.
> Roller log file:
> ERROR 2007-03-04 20:35:05,115 UserNewAction:add - ERROR in addUser
> org.apache.roller.RollerException
> ...
> --- ROOT CAUSE ---
> org.hibernate.exception.SQLGrammarException: could not execute query
> ...
> Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
> Please, correct a SQL script for Oracle DB. In following script the syntax "order by this_.datecreated desc limit " is wrong.
> 1 select this_.id as id1_0_
> 2 , this_.isenabled as isenabled1_0_
> 3 , this_.username as username1_0_
> 4 , this_.passphrase as passphrase1_0_
> 5 , this_.fullname as fullname1_0_
> 6 , this_.emailaddress as emailadd6_1_0_
> 7 , this_.datecreated as datecrea7_1_0_
> 8 , this_.locale as locale1_0_
> 9 , this_.timeZone as timeZone1_0_ from rolleruser this_
> 10 where this_.datecreated<sysdate -1 and this_.isenabled=1
> 11* order by this_.datecreated desc limit 10
> SQL> /
> order by this_.datecreated desc limit 10
> *
> ERROR at line 11:
> ORA-00933: SQL command not properly ended
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/roller/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira