[
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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.
