Hi Geert, indeed. confirmed.
thanks very much. On 9/7/06, Geert Bevin <[EMAIL PROTECTED]> wrote:
Hi John, thanks for this report, I fixed it in the repository: http://rifers.org:8088/changelog/rifers/?cs=3502 Best regards, Geert On 07 Sep 2006, at 04:13, John Lukar 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.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 >> > > [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 >> > >> >> <error.gif> > _______________________________________________ > 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
