I'm trying to configure all of JBoss' related services database table to reside in
their own schema (jboss). The database with the name of "jboss" was created and
I was able to change successfully all of the JMS' configuration files to refer to this
schema when performing create/insert/delete/select operations. This was easily
accomplished by adding the schema name followed by a dot before the table's name.
However, for the EJBTimerService, it doesn't seem to work:
| <!--
| A persistence policy that persists timers to a database.
|
| The 2 supported db persistence plugins are:
| org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin
| org.jboss.ejb.txtimer.OracleDatabasePersistencePlugin
|
| The table name defaults to "TIMERS". It can be overriden using the
| 'TimersTable' attribute if the persistence plugin supports it.
| When overriding the timers table, an optional schema can be specified
| using the syntax [schema.]table
| -->
| <mbean code="org.jboss.ejb.txtimer.DatabasePersistencePolicy"
name="jboss.ejb:service=EJBTimerService,persistencePolicy=database">
| <!-- DataSourceBinding ObjectName -->
| <depends
optional-attribute-name="DataSource">jboss.jca:service=DataSourceBinding,name=MySqlDs</depends>
| <!-- The plugin that handles database persistence -->
| <attribute
name="DatabasePersistencePlugin">org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin</attribute>
| <!-- The timers table name -->
| <attribute name="TimersTable">jboss.TIMERS</attribute>
| </mbean>
|
Upon startup, I'm getting:
| 17:39:46,459 WARN [ServiceController] Problem starting service
jboss.ejb:service=EJBTimerService,persistencePolicy=database
| com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Incorrect table name
'jboss'
|
Any ideas?
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4158236#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...