I confirmed that this is an issue when using MySql 5.022
I installed mySql 4.1 on another windows box and switched the
eCalendar to use that instance and it workd fine. The DB table names
as created on that DB were all lower case. see further below.
I opened a Jira issue:
http://uwyn.com/issues/browse/RIFECRUD-2
article
articleattachment
articlenote
articletype
author
authoremail
authornote
authorurl
contentattribute
contentinfo
contentproperty
contentrepository
contentstoreimage
contentstorerawchunk
contentstorerawinfo
contentstoretext
publication
On 9/6/06, John Lukar <[EMAIL PROTECTED]> wrote:
Hi Geert,
I have collected more information. Attached is the browser snapshot of
the error stack trace as neatly reported by Rife engine.
Further below are the name of the tables exactly as they are created
in the DB. As you can see some are upper case(looks like the content
management stuff) and the rest are lower case.
I would appreciate comments or if you could tell me where I should
look to fix this, I'll be more than happy to do it.
again, environment:
MySQL 5.0.22-Debian_0ubuntu6.06.2-log
JDBC versions tried:
mysql-connector-java-3.1.13-bin.jar and mysql-connector-java-5.0.3-bin.jar
JDK version 1.5.07 running with IDEA
thanks.
ContentAttribute
ContentInfo
ContentProperty
ContentRepository
ContentStoreImage
ContentStoreRawChunk
ContentStoreRawInfo
ContentStoreText
article
articleattachment
articlenote
articletype
author
authoremail
authornote
authorurl
publication
On 9/6/06, John Lukar <[EMAIL PROTECTED]> wrote:
> 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
> > > 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
> >
>
_______________________________________________
Rife-users mailing list
Rife-users@uwyn.com
http://lists.uwyn.com/mailman/listinfo/rife-users
