roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Boris (JIRA)" <nore...@atlassian.com>
Subject [Roller-JIRA] Commented: (ROL-1364) add new user
Date Mon, 07 May 2007 21:35:55 GMT

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

Boris commented on ROL-1364:
----------------------------

Please, can someone solve this problem.

I put in roller.properties OracleDialect, but hibernate still use MySqlDialect.
# Database configuration settings

# Hibernate dialect: You must override this to use a database other than MySQL4
#hibernate.dialect=org.hibernate.dialect.MySQLDialect
#hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
hibernate.dialect=org.hibernate.dialect.OracleDialect

INFO  2007-05-07 23:01:46,271 Dialect:<init> - Using dialect: org.hibernate.dialect.MySQLDialect

> 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