Hi John,
MySQL is very sensitive to JDBC driver versions. There seem to be a
lot of behavioral differences between individual versions. Please try
with mysql-connector-java-3.1.12-bin.jar, which was the GA release
when RIFE 1.5 was released.
Best regards,
Geert
On 06 Sep 2006, at 02:36, John Lukar wrote:
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.AbstractGenericQueryManag
er
_restore ( AbstractGenericQueryManager.java : 708 )
at
com.uwyn.rife.database.querymanagers.generic.databasedrivers.generic
restore ( generic.java : 183 )
at
com.uwyn.rife.database.querymanagers.generic.GenericQueryManagerDelega
te
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
Rife-users@uwyn.com
http://lists.uwyn.com/mailman/listinfo/rife-users
--
Geert Bevin
Uwyn "Use what you need" - http://uwyn.com
RIFE Java application framework - http://rifers.org
Music and words - http://gbevin.com
_______________________________________________
Rife-users mailing list
Rife-users@uwyn.com
http://lists.uwyn.com/mailman/listinfo/rife-users