geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Peter Petersson (JIRA)" <j...@apache.org>
Subject [jira] Commented: (GERONIMO-2994) Apache Roller plugin
Date Sun, 22 Jul 2007 15:43:06 GMT

    [ https://issues.apache.org/jira/browse/GERONIMO-2994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12514478
] 

Peter Petersson commented on GERONIMO-2994:
-------------------------------------------

Roller using the wrong database dictionary after aliasing 

After installing roller-tomcat, roller-mysql and manually setting the org.apache.geronimo.plugins/roller-derby-database//car=org.apache.geronimo.plugins/roller-mysql-database/2.0-SNAPSHOT/car
line in artifact_aliases.properties and restarting the G server to make it read the aliasing
line to use mysql, roller is using the wrong database dictionary settings _15:37:22,368 INFO
 [JDBC] Using dictionary class "org.apache.openjpa.jdbc.sql.DerbyDictionary"_ resulting in
the wrong database schema tables being created in the mysql database using rollers installation.type=auto
property. 

The persistence setting used (in roller-tomcat) is as follows:

        <persistence-unit name="RollerPU">
            <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
            <jta-data-source>jdbc/rollerdb</jta-data-source>
            <non-jta-data-source>jdbc/NoTxrollerdb</non-jta-data-source>
            <properties>
                <!--  <property name="openjpa.jdbc.DBDictionary" value="org.apache.openjpa.jdbc.sql.DerbyDictionary"/>-->
                <!--  <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(ForeignKeys=true)"/>-->
                  <property name="openjpa.jdbc.SynchronizeMappings" value=""/>
                <property name="openjpa.Sequence" value="table(Table=OPENJPASEQ, Increment=100)"/>
            </properties>
        </persistence-unit>

One potiential reason for this error may indirectly be the dependancy on the roller-derby-database
in the roller-tomcat module I am not sure of this but the same settings and db creation strategy
works for configuration not requiring a aliasing switch (test module roller-tomcat-mysql)
that have a dependency on the roller-mysql-database, except for the incompatible entity and
schema definitions (field size differences) previously noted by David Jenks. 

Also tried override settings by adding a "mysql specific" persistence.xml file in roller-mysql-resources
but I still get the same errors so I may not have got it to overriding stuff correctly.  

15:37:14,565 INFO  [DatabaseInstaller] Creating Roller Weblogger database tables.
15:37:22,221 INFO  [WebloggerFactory] Bootstrapping Roller Weblogger business tier
15:37:22,221 INFO  [WebloggerFactory] Weblogger Provider = org.apache.roller.weblogger.business.GuiceWebloggerProvider
15:37:22,228 INFO  [DatabaseProvider] SUCCESS: Got parameters. Using configuration type JNDI_NAME
15:37:22,228 INFO  [DatabaseProvider] -- Using JNDI datasource name: java:comp/env/jdbc/rollerdb
15:37:22,231 INFO  [DatabaseProvider] SUCCESS: located JNDI DataSource [java:comp/env/jdbc/rollerdb]
15:37:22,245 INFO  [IndexManagerImpl] search enabled: true
15:37:22,246 INFO  [IndexManagerImpl] index dir: /root/roller_data/search-index
15:37:22,273 INFO  [ReferrerQueueManagerImpl] Instantiating Referrer Queue Manager
15:37:22,273 INFO  [ReferrerQueueManagerImpl] Asynchronous referrer processing = false
15:37:22,274 INFO  [ThreadManagerImpl] Instantiating Thread Manager
15:37:22,285 INFO  [WebloggerFactory] Roller Weblogger business tier successfully bootstrapped
15:37:22,285 INFO  [WebloggerFactory]    Version: 4.0-dev
15:37:22,285 INFO  [WebloggerFactory]    Revision: 557441
15:37:22,285 INFO  [WebloggerImpl] Initializing Roller Weblogger business tier
15:37:22,292 INFO  [Runtime] Starting OpenJPA 1.0.0-SNAPSHOT
15:37:22,368 INFO  [JDBC] Using dictionary class "org.apache.openjpa.jdbc.sql.DerbyDictionary".
15:37:25,278 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.name ... setting
value to [Roller Site]
15:37:25,278 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.shortName
... setting value to [Front Page]
15:37:25,278 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.description
... setting value to [A default install of the Roller Weblogger open source blog server]
15:37:25,278 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.frontpage.weblog.handle
... setting value to []
15:37:25,278 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.frontpage.weblog.aggregated
... setting value to [false]
15:37:25,278 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.adminemail
... setting value to []
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.absoluteurl
... setting value to []
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property pings.suspendPingProcessing
... setting value to [false]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.debugMode
... setting value to [false]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property users.registration.enabled
... setting value to [true]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property user.account.activation.enabled
... setting value to [false]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property user.account.activation.mail.from
... setting value to []
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property users.registration.url
... setting value to []
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property users.editor.pages
... setting value to [editor-text.jsp,editor-rte.jsp,editor-xinha.jsp]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.pages.maxEntries
... setting value to [30]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.newsfeeds.defaultEntries
... setting value to [30]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.newsfeeds.styledFeeds
... setting value to [true]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property users.comments.enabled
... setting value to [true]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property comments.ignoreSpam.enabled
... setting value to [false]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property users.trackbacks.enabled
... setting value to [true]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property trackbacks.ignoreSpam.enabled
... setting value to [true]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property users.comments.htmlenabled
... setting value to [true]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property users.comments.plugins
... setting value to []
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property users.comments.emailnotify
... setting value to [false]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property users.moderation.required
... setting value to [false]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.trackbackVerification.enabled
... setting value to [false]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.linkbacks.enabled
... setting value to [false]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property uploads.enabled
... setting value to [true]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property uploads.types.allowed
... setting value to []
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property uploads.types.forbid
... setting value to [exe]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property uploads.file.maxsize
... setting value to [1.00]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property uploads.dir.maxsize
... setting value to [4.00]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property users.themes.path
... setting value to [/themes]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property themes.customtheme.allowed
... setting value to [true]
15:37:25,279 INFO  [JPAPropertiesManagerImpl] Found uninitialized property spam.blacklist
... setting value to []
15:37:25,341 INFO  [ThemeManagerImpl] Loaded 4 themes from disk.
15:37:25,341 INFO  [ThreadManagerImpl] Initializing task: ScheduledEntriesTask
15:37:25,348 INFO  [ThreadManagerImpl] Initializing task: ResetHitCountsTask
15:37:25,355 INFO  [ThreadManagerImpl] Initializing task: TurnoverReferersTask
15:37:25,363 INFO  [ThreadManagerImpl] Initializing task: PingQueueTask
15:37:25,427 INFO  [PingConfig] Creating common ping target 'Technorati' from configuration
properties.
15:37:25,427 INFO  [PingConfig] Creating common ping target 'Weblogs.com' from configuration
properties.
15:37:25,427 INFO  [PingConfig] Creating common ping target 'blo.gs' from configuration properties.
15:37:25,428 INFO  [PingConfig] Creating common ping target 'java.blogs' from configuration
properties.
15:37:25,428 INFO  [PingConfig] Creating common ping target 'blogrolling.com' from configuration
properties.
15:37:25,428 INFO  [PingConfig] Creating common ping target 'IceRocket' from configuration
properties.
15:37:25,490 INFO  [WebloggerImpl] Roller Weblogger business tier successfully initialized
15:37:25,502 INFO  [PlanetConfig] successfully loaded default properties.
15:37:25,503 INFO  [PlanetConfig] successfully loaded custom properties file from classpath
15:37:25,503 INFO  [PlanetConfig] no custom properties file specified via jvm option
15:37:25,503 INFO  [DatabaseProvider] SUCCESS: Got parameters. Using configuration type JNDI_NAME
15:37:25,503 INFO  [DatabaseProvider] -- Using JNDI datasource name: java:comp/env/jdbc/rollerdb
15:37:25,505 INFO  [DatabaseProvider] SUCCESS: located JNDI DataSource [java:comp/env/jdbc/rollerdb]
15:37:25,577 WARN  [GeronimoConnectionEventListener] connectionErrorOccurred called with null
java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'TIMESTAMP) < CAST(CURRENT_TIMESTAMP
AS TIMESTAMP)))' at line 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
        at org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:103)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:856)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1363)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:505)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:432)
        at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeUpdate(ExpressionStoreQuery.java:689)
        at org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1038)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:802)
        at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:877)
        at org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:573)
        at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:311)
        at org.apache.roller.weblogger.business.jpa.JPAThreadManagerImpl.registerLease(JPAThreadManagerImpl.java:103)
        at org.apache.roller.weblogger.business.runnable.RollerTaskWithLeasing.run(RollerTaskWithLeasing.java:60)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
15:37:25,581 WARN  [JPAThreadManagerImpl] Error obtaining lease, assuming race condition.
<1.0.0-SNAPSHOT-SNAPSHOT nonfatal general error> org.apache.openjpa.persistence.PersistenceException:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'TIMESTAMP) < CAST(CURRENT_TIMESTAMP AS TIMESTAMP)))'
at line 1 {prepstmnt 31005306 UPDATE roller_tasklock SET timeacquired = CURRENT_TIMESTAMP,
timeleased = ?, client = ? WHERE id IN (SELECT DISTINCT t0.id FROM roller_tasklock t0 WHERE
(t0.name = ? AND t0.timeacquired = ? AND CAST(? AS TIMESTAMP) < CAST(CURRENT_TIMESTAMP
AS TIMESTAMP))) [params=(int) 30, (String) defaultClientId, (String) ScheduledEntriesTask,
(Timestamp) 1970-01-01 01:00:00.0, (Timestamp) 1970-01-01 00:59:59.0]} [code=1064, state=42000]
FailedObject: org.apache.openjpa.jdbc.kernel.exps.ExpContext@97388b
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3836)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:512)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:432)
        at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeUpdate(ExpressionStoreQuery.java:689)
        at org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1038)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:802)
        at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:877)
        at org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:573)
        at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:311)
        at org.apache.roller.weblogger.business.jpa.JPAThreadManagerImpl.registerLease(JPAThreadManagerImpl.java:103)
        at org.apache.roller.weblogger.business.runnable.RollerTaskWithLeasing.run(RollerTaskWithLeasing.java:60)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for the right syntax
to use near 'TIMESTAMP) < CAST(CURRENT_TIMESTAMP AS TIMESTAMP)))' at line 1 {prepstmnt
31005306 UPDATE roller_tasklock SET timeacquired = CURRENT_TIMESTAMP, timeleased = ?, client
= ? WHERE id IN (SELECT DISTINCT t0.id FROM roller_tasklock t0 WHERE (t0.name = ? AND t0.timeacquired
= ? AND CAST(? AS TIMESTAMP) < CAST(CURRENT_TIMESTAMP AS TIMESTAMP))) [params=(int) 30,
(String) defaultClientId, (String) ScheduledEntriesTask, (Timestamp) 1970-01-01 01:00:00.0,
(Timestamp) 1970-01-01 00:59:59.0]} [code=1064, state=42000]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:57)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:858)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1363)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:505)
        ... 18 more
NestedThrowables:
java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'TIMESTAMP) < CAST(CURRENT_TIMESTAMP
AS TIMESTAMP)))' at line 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
        at org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:103)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:856)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1363)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:505)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:432)
        at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeUpdate(ExpressionStoreQuery.java:689)
        at org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1038)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:802)
        at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:877)
        at org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:573)
        at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:311)
        at org.apache.roller.weblogger.business.jpa.JPAThreadManagerImpl.registerLease(JPAThreadManagerImpl.java:103)
        at org.apache.roller.weblogger.business.runnable.RollerTaskWithLeasing.run(RollerTaskWithLeasing.java:60)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
15:37:25,648 INFO  [PlanetFactory] Bootstrapping Roller Planet business tier
15:37:25,648 INFO  [PlanetFactory] Planet Provider = org.apache.roller.planet.business.GuicePlanetProvider
15:37:25,691 INFO  [PlanetFactory] Roller Planet business tier successfully bootstrapped
15:37:25,942 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.name ... setting
value to [Roller Planet]
15:37:25,942 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.description
... setting value to [A default install of the Roller Planet open source aggregation server]
15:37:25,942 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.adminname
... setting value to []
15:37:25,942 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.adminemail
... setting value to []
15:37:25,942 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.absoluteurl
... setting value to []
15:37:25,942 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.proxyhost
... setting value to []
15:37:25,942 INFO  [JPAPropertiesManagerImpl] Found uninitialized property site.proxyport
... setting value to [0]
15:37:26,417 WARN  [GeronimoConnectionEventListener] connectionErrorOccurred called with null
java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'TIMESTAMP) < CAST(CURRENT_TIMESTAMP
AS TIMESTAMP)))' at line 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
        at org.tranql.connector.jdbc.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:103)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:856)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1363)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:505)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:432)
        at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeUpdate(ExpressionStoreQuery.java:689)
        at org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1038)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:802)
        at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:877)
        at org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:573)
        at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:311)
        at org.apache.roller.weblogger.business.jpa.JPAThreadManagerImpl.registerLease(JPAThreadManagerImpl.java:103)
        at org.apache.roller.weblogger.business.runnable.RollerTaskWithLeasing.run(RollerTaskWithLeasing.java:60)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
15:37:26,418 WARN  [JPAThreadManagerImpl] Error obtaining lease, assuming race condition.
<1.0.0-SNAPSHOT-SNAPSHOT nonfatal general error> org.apache.openjpa.persistence.PersistenceException:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'TIMESTAMP) < CAST(CURRENT_TIMESTAMP AS TIMESTAMP)))'
at line 1 {prepstmnt 24447713 UPDATE roller_tasklock SET timeacquired = CURRENT_TIMESTAMP,
timeleased = ?, client = ? WHERE id IN (SELECT DISTINCT t0.id FROM roller_tasklock t0 WHERE
(t0.name = ? AND t0.timeacquired = ? AND CAST(? AS TIMESTAMP) < CAST(CURRENT_TIMESTAMP
AS TIMESTAMP))) [params=(int) 30, (String) defaultClientId, (String) PingQueueTask, (Timestamp)
1970-01-01 01:00:00.0, (Timestamp) 1970-01-01 00:59:59.0]} [code=1064, state=42000]
FailedObject: org.apache.openjpa.jdbc.kernel.exps.ExpContext@11d5b59
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3836)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:512)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeUpdate(JDBCStoreQuery.java:432)
        at org.apache.openjpa.kernel.ExpressionStoreQuery$DataStoreExecutor.executeUpdate(ExpressionStoreQuery.java:689)
        at org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1038)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:802)
        at org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:877)
        at org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:573)
        at org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:311)
        at org.apache.roller.weblogger.business.jpa.JPAThreadManagerImpl.registerLease(JPAThreadManagerImpl.java:103)
        at org.apache.roller.weblogger.business.runnable.RollerTaskWithLeasing.run(RollerTaskWithLeasing.java:60)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
        at java.lang.Thread.run(Thread.java:595)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for the right syntax
to use near 'TIMESTAMP) < CAST(CURRENT_TIMESTAMP AS TIMESTAMP)))' at line 1 {prepstmnt
24447713 UPDATE roller_tasklock SET timeacquired = CURRENT_TIMESTAMP, timeleased = ?, client
= ? WHERE id IN (SELECT DISTINCT t0.id FROM roller_tasklock t0 WHERE (t0.name = ? AND t0.timeacquired
= ? AND CAST(? AS TIMESTAMP) < CAST(CURRENT_TIMESTAMP AS TIMESTAMP))) [params=(int) 30,
(String) defaultClientId, (String) PingQueueTask, (Timestamp) 1970-01-01 01:00:00.0, (Timestamp)
1970-01-01 00:59:59.0]} [code=1064, state=42000]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:57)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:858)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1363)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreQuery.executeBulkOperation(JDBCStoreQuery.java:505)
        ... 18 more
NestedThrowables:
java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'TIMESTAMP) < CAST(CURRENT_TIMESTAMP
AS TIMESTAMP)))' at line 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) 
      :
      :


> Apache Roller plugin 
> ---------------------
>
>                 Key: GERONIMO-2994
>                 URL: https://issues.apache.org/jira/browse/GERONIMO-2994
>             Project: Geronimo
>          Issue Type: New Feature
>      Security Level: public(Regular issues) 
>          Components: Plugins
>    Affects Versions: 1.2
>            Reporter: Peter Petersson
>            Assignee: David Jencks
>            Priority: Minor
>         Attachments: geronimo-plugins.xml, geronimo-plugins.xml, geronimo-plugins_070602.xml,
geronimo-web.xml, geronimo-web.xml, plan.xml, PluginInstallerGBean.patch, pom.xml, pom.xml,
roller-custom.properties, roller-custom.properties, roller-custom.properties, roller-derbydb-plan-g1_2.xml,
roller-mysql-db-plan-1-2.xml, roller070409.patch, roller12_070602.zip, roller_g20_svn_070602.patch,
roller_plugin.patch, roller_plugin_070717.patch
>
>
> Have been working on getting Apache Roller running under Geronimo I finally got to the
point where the roller application seems to be running smoothly in Geronimo v1.2 (current
snapshot). It would be great to eventually see this application as a plugin in G so here are
pointers to resources and attached plans.
> Apache Roller v3.1 Resources (soon to be released)
> Apache roller home: http://rollerweblogger.org/project/
> The bundle: http://people.apache.org/~snoopdave/apache-roller-3.1/ (until it will be
available directly via roller home)
> Required jars: https://roller.dev.java.net/servlets/ProjectDocumentList?expandFolder=6959&folderID=0
> Path to database create scripts can be found in the bundle above under: apache-roller-3.1/webapp/roller/WEB-INF/dbscripts/
> I have tested with the derby database and mysql 5. 
> There is currently a issue with G v1.2 and hibernates v3.1 (used by roller 3.1) property
loader that gets a
>  
> FATAL [HibernateRollerImpl] Error initializing Hibernate
> java.lang.ClassCastException: java.util.HashSet
>         at org.hibernate.util.PropertiesHelper.resolvePlaceHolders(PropertiesHelper.java:88)
  
> Hibernate is expecting a String value (This issue is fixed in hibernate 3.2 with a instanceOf
check)
> Fortunately David Jencks hit this problem in trunk and suggested turning off the activemq
and activemq-broker modules in config.xml, to test things out, and after that everything was
running smothly :).
>     

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message