Hi,
I am getting an error "Table not found" and I find that mysql is
case-sensitive. What I don't understand from the DEBUG messages below is
"why is the error showing lower case database instance name while the query
itself shows UPPER CASE database name "SA". Thanks for any insights!!!
DEBUG - opening JDBC connection
DEBUG - select user0_.id as id36_, user0_.version as version36_,
user0_.address
as address36_, user0_.country as country36_, user0_.city as city36_,
user0_.prov
ince as province36_, user0_.postal_code as postal7_36_, user0_.password as
passw
ord36_, user0_.username as username36_, user0_.account_enabled as
account10_36_,
user0_.email as email36_, user0_.password_hint as password12_36_,
user0_.first_
name as first13_36_, user0_.last_name as last14_36_, user0_.phone_number as
phon
e15_36_, user0_.website as website36_, user0_.account_expired as
account17_36_,
user0_.account_locked as account18_36_, user0_.credentials_expired as
credent19_
36_ from SA.app_user user0_ where user0_.username=?
DEBUG - preparing statement
DEBUG - binding 'mraible' to parameter: 1
DEBUG - about to close PreparedStatement (open PreparedStatements: 1,
globally:
1)
DEBUG - closing statement
DEBUG - could not execute query [select user0_.id as id36_, user0_.version
as ve
rsion36_, user0_.address as address36_, user0_.country as country36_,
user0_.cit
y as city36_, user0_.province as province36_, user0_.postal_code as
postal7_36_,
user0_.password as password36_, user0_.username as username36_,
user0_.account_
enabled as account10_36_, user0_.email as email36_, user0_.password_hint as
pass
word12_36_, user0_.first_name as first13_36_, user0_.last_name as
last14_36_, us
er0_.phone_number as phone15_36_, user0_.website as website36_,
user0_.account_e
xpired as account17_36_, user0_.account_locked as account18_36_,
user0_.credenti
als_expired as credent19_36_ from SA.app_user user0_ where
user0_.username=?]
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'sa.app_user'
doesn't
exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
thanks a lot!!
mraible wrote:
>
> Then it must be loading hibernate.cfg.xml from a different location
> than the one you think it is. I'd search your classpath, including
> JARs that you might suspect its in.
>
> Matt
>
> On 5/24/07, nmall <[EMAIL PROTECTED]> wrote:
>>
>> Yes, I do !! It actually shows me errors if I don't have something mapped
>> right.
>>
>> Thanks!!
>>
>>
>> mraible wrote:
>> >
>> > Do you have org.appfuse.model.User as a mapped class in your
>> > hibernate.cfg.xml file?
>> >
>> > On 5/24/07, nmall <[EMAIL PROTECTED]> wrote:
>> >>
>> >> Hi,
>> >>
>> >> When I try to login on the login page, my appfuse based application
>> >> gives
>> >> me the following error. It is according to ACEGI docs an internal
>> >> authentication error. It doesn't even go into my UserAction or other
>> >> classes. Any idea what ths is Thanks a lot!! ( The user here is
>> mraible
>> >> as I
>> >> tried to give mraible/tomcat)
>> >>
>> >> WARN - Authentication event
>> AuthenticationFailureServiceExceptionEvent:
>> >> mraible;
>> >> details: [EMAIL PROTECTED]:
>> >> RemoteIpAddress:
>> >> 127.0.0.1; SessionId: 3pfcll2ka5o9j; exception: User is not mapped.
>> [from
>> >> User w
>> >> here username=?]; nested exception is
>> >> org.hibernate.hql.ast.QuerySyntaxException
>> >> : User is not mapped. [from User where username=?]; nested exception
>> is
>> >> org.spri
>> >> ngframework.orm.hibernate3.HibernateQueryException: User is not
>> mapped.
>> >> [from Us
>> >> er where username=?]; nested exception is
>> >> org.hibernate.hql.ast.QuerySyntaxExcep
>> >> tion: User is not mapped. [from User where username=?]
>> >>
>> >> --
>> >> View this message in context:
>> >> http://www.nabble.com/ACEGI-exception-tf3812455s2369.html#a10791628
>> >> Sent from the AppFuse - User mailing list archive at Nabble.com.
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> >> For additional commands, e-mail: [EMAIL PROTECTED]
>> >>
>> >>
>> >
>> >
>> > --
>> > http://raibledesigns.com
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: [EMAIL PROTECTED]
>> > For additional commands, e-mail: [EMAIL PROTECTED]
>> >
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/ACEGI-exception-tf3812455s2369.html#a10792318
>> Sent from the AppFuse - User mailing list archive at Nabble.com.
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>
>
> --
> http://raibledesigns.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
--
View this message in context:
http://www.nabble.com/ACEGI-exception-tf3812455s2369.html#a10796617
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
