More info: it doesn't always cause an exception, but it never returns any query 
results. If I put % in all the fields or a * in all the fields then it doesn't 
cause an exception.

This is probably closer to the root cause (SQL Error: -227):

20:58:00,121 INFO  [STDOUT] Hibernate: select top ? rolleruser0_.id as id58_, 
rolleruser0_.locale as locale58_, rolleruser0_.username as username58_, 
rolleruser0_.passphrase as passphrase58_, rolleruser0_.fullname as fullname58_, 
rolleruser0_.emailaddress as emailadd6_58_, rolleruser0_.datecreated as 
datecrea7_58_, rolleruser0_.timezone as timezone58_, rolleruser0_.isenabled as 
isenabled58_ from roller.rolleruser rolleruser0_ where (rolleruser0_.username 
like ?) and (rolleruser0_.fullname like ?) and (rolleruser0_.locale like ?) and 
(rolleruser0_.timezone like ?) and rolleruser0_.isenabled=?
20:58:00,124 WARN  [JDBCExceptionReporter] SQL Error: -227, SQLState: 3F000
20:58:00,124 ERROR [JDBCExceptionReporter] invalid schema name: ROLLER in 
statement [select top ? rolleruser0_.id as id58_, rolleruser0_.locale as 
locale58_, rolleruser0_.username as username58_, rolleruser0_.passphrase as 
passphrase58_, rolleruser0_.fullname as fullname58_, rolleruser0_.emailaddress 
as emailadd6_58_, rolleruser0_.datecreated as datecrea7_58_, 
rolleruser0_.timezone as timezone58_, rolleruser0_.isenabled as isenabled58_ 
from roller.rolleruser rolleruser0_ where (rolle  ... 


View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3957954#3957954

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3957954
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to