You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by "Henri Yandell (JIRA)" <no...@atlassian.com> on 2007/06/27 20:06:30 UTC
[Roller-JIRA] Closed: (ROL-1364) add new user
[ http://opensource.atlassian.com/projects/roller/browse/ROL-1364?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Henri Yandell closed ROL-1364.
------------------------------
Resolution: Won't Fix
The issue here is that you need to also change the MySQLDialect to OracleDialect in the roller.properties.
Presumably changing things with a custom-roller.properties file would also work and is the preferred option; I'm just lazy and edit the central files manually.
> 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