Hi All,

I am a newbie and just starting and evaluating RIFE for a midsized web
application with 20 concurrent user base and admin and content
management modules.

I tried to run the eCalendar app switching over the  datasource ot a
mysql 5.0 databse.

the auto schema creation using the CreateCrud..  participants seem to
result in table names being created in lower case. So instead of
"Publication" the table is created as "publication".  Wondering if
this is because of 5.0x  version of mysql.  I am using the mysql
driver:
mysql-connector-java-5.0.3-bin.jar



This results in subsequent page access to result in the following stack:


com.mysql.jdbc.exceptions.MySQLSyntaxErrorException

Table 'mydbschema.Publication' doesn't exist

at  com.mysql.jdbc.SQLError        createSQLException           ( SQLError.java 
: 936 )
at  com.mysql.jdbc.MysqlIO         checkErrorPacket     ( MysqlIO.java : 2870 )
at  com.mysql.jdbc.MysqlIO         sendCommand          ( MysqlIO.java : 1573 )
at  com.mysql.jdbc.MysqlIO         sqlQueryDirect       ( MysqlIO.java : 1665 )
at  com.mysql.jdbc.Connection      execSQL      ( Connection.java : 3124 )
at  com.mysql.jdbc.PreparedStatement       executeInternal      (
PreparedStatement.java : 1149 )
at  com.mysql.jdbc.PreparedStatement       executeQuery         (
PreparedStatement.java : 1262 )
at  com.uwyn.rife.database.DbPreparedStatement     executeQuery         (
DbPreparedStatement.java : 187 )
at  com.uwyn.rife.database.DbQueryManager          executeQuery         (
DbQueryManager.java : 197 )
at  com.uwyn.rife.database.DbQueryManager          executeFetchAll      (
DbQueryManager.java : 2395 )
at  com.uwyn.rife.database.DbQueryManager          executeFetchAll      (
DbQueryManager.java : 2345 )
at  com.uwyn.rife.database.querymanagers.generic.AbstractGenericQueryManager
           _restore     ( AbstractGenericQueryManager.java : 708 )
at  com.uwyn.rife.database.querymanagers.generic.databasedrivers.generic
           restore      ( generic.java : 183 )
at  com.uwyn.rife.database.querymanagers.generic.GenericQueryManagerDelegate
           restore      ( GenericQueryManagerDelegate.java : 141 )
at  com.uwyn.ecalendar.elements.ListScheduledArticles   
processElement          ( ListScheduledArticles.java : 36 )
at  com.uwyn.rife.engine.ElementContext            processContext       (
ElementContext.java : 443 )
at  com.uwyn.rife.engine.RequestState      service      ( RequestState.java : 
342 )



any ideas ?
_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users

Reply via email to