roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Henri Yandell (JIRA)" <nore...@atlassian.com>
Subject [Roller-JIRA] Commented: (ROL-1364) add new user
Date Wed, 27 Jun 2007 18:06:31 GMT

    [ http://opensource.atlassian.com/projects/roller/browse/ROL-1364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_13834
] 

Henri Yandell commented on ROL-1364:
------------------------------------

Btw... OracleDialect = Oracle 8. Oracle9Dialect = Oracle 9i and Oracle 10g  as I understand
it.

> 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

        

Mime
View raw message