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.AbstractGenericQueryMana
g
> > 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.GenericQueryManagerDeleg
a
> > 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
>
<error.gif>
