[jboss-user] [JBossCache] - Re: JDBCCacheLoader and MySQL problems

[boniek]

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