JBC version is 1.4.1.SP7 JBoss 4.2.1 MySQL Driver 5.0.8 Yes I have read it. My configuration: <cacheloader> | | <class>org.jboss.cache.loader.JDBCCacheLoader</class> | | <!-- properties to pass in to the cache loader --> | <properties> | cache.jdbc.datasource=java:/LocalMySqlDS | cache.jdbc.sql-concat=concat(1,2) | cache.jdbc.table.drop=false | ache.jdbc.node.type=LONGBLOB | </properties> | | <!-- whether the cache loader writes are asynchronous --> | <async>true</async> | | <!-- only one cache loader in the chain may set fetchPersistentState to true. | An exception is thrown if more than one cache loader sets this to true. --> | <fetchPersistentState>false</fetchPersistentState> | | <!-- determines whether this cache loader ignores writes - defaults to false. --> | <ignoreModifications>false</ignoreModifications> | | <!-- if set to true, purges the contents of this cache loader when the cache starts up. | Defaults to false. --> | <purgeOnStartup>false</purgeOnStartup> | | <!-- defines the cache loader as a singleton store where only the coordinator of the | cluster will store modifications. Setting pushStateWhenCoordinator to true enables a | newly elected coordinator to push the in-memory state to the underlying cache store. | Both default to false. --> | <singletonStore pushStateWhenCoordinator="false">false</singletonStore> | </cacheloader> <datasources> | <local-tx-datasource> | <jndi-name>LocalMySqlDS</jndi-name> | <connection-url>jdbc:mysql://host:port/database?autoReconnect=true</connection-url> | <driver-class>com.mysql.jdbc.Driver</driver-class> | <user-name>u</user-name> | <password>p</password> | <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> | <exception-sorter-class-name>com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name> | <valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name> | <idle-timeout-minutes>1</idle-timeout-minutes> | <max-pool-size>15</max-pool-size> | <metadata> | <type-mapping>mySQL</type-mapping> | </metadata> | </local-tx-datasource> | </datasources>
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4112858#4112858 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4112858 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
