Hi Geert, I tried mysql-connector-java-3.1.12-bin.jar with the same effect last night. I am wondering if its the mysql 5.022 version that is the problem.
Also to provide more details, some of the tables are created with upper case. The author and publisher and authortype and some others are created lower case I suspect having to do with the custom crud creation code vs.(RIFE's internal??) unfortunately I don't have access to my work station to tell you exactly which ones. John. On 9/6/06, Geert Bevin <[EMAIL PROTECTED]> wrote:
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 > [email protected] > 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 [email protected] http://lists.uwyn.com/mailman/listinfo/rife-users
_______________________________________________ Rife-users mailing list [email protected] http://lists.uwyn.com/mailman/listinfo/rife-users
