[jboss-user] [JBoss Cache: Core Edition] - Getting Failed to insert node

[atifoxon]

I am using cache loader but getting following in log
two syntax errors 
1. while executing creating table
2. whil executing insert node sql

insert node sql log
org.jboss.cache.loader.AdjListJDBCCacheLoader insertNode
SEVERE: Failed to insert node :A syntax error has occurred.

query i am getting is 

INSERT INTO jbosscache (fqn, node , parent) SELECT ?, ?, ? FROM jbosscache_D WHERE NOT EXISTS (SELECT fqn FROM jbosscache WHERE fqn = ?)

help me in resolving the problem

2. further i think the sql generated by api is not correct (or expected)
e.g for table creation when using jdbc loader i get following query

CREATE TABLE jbosscache
  | (
  | fqn VARCHAR(255) NOT NULL, 
  | node  blob, 
  | parent VARCHAR(255), 
  | CONSTRAINT jbosscache_pk PRIMARY KEY (fqn)
  | ) 

which generates a syntax error

complete config file is


  | <?xml version="1.0" encoding="UTF-8"?>
  | <jbosscache xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:jboss:jbosscache-core:config:3.0">
  | 
  |    <!-- Configure the TransactionManager -->
  |    <transaction transactionManagerLookupClass="org.jboss.cache.transaction.GenericTransactionManagerLookup"/>
  | 
  | 
  |    <!--      wakeUpInterval: time interval (millis) when the eviction thread kicks in.   -->
  |    <eviction wakeUpInterval="5000">
  |       <!--
  |          Cache wide defaults
  |          default algorithmClass: if an algorithm class is not specified for a region, this one is used by default.
  |          default eventQueueSize  if an event queue size is not specified for a region, this one is used by default.
  |       -->
  |       <default algorithmClass="org.jboss.cache.eviction.LRUAlgorithm" eventQueueSize="200000">
  |          <property name="maxNodes" value="5000" />
  |          <property name="timeToLive" value="100" />
  |       </default>
  |       <region name="/MCP/cards/">
  | 		<property name="maxNodes" value="3000" />
  | 		<property name="minTimeToLive" value="400" />
  |       </region>
  | 
  |    </eviction>
  | 
  | <!-- Cache Passivation for Tree Cache
  | On passivation, The objects are written to the backend store on eviction if passivation
  | is true, otherwise the objects are persisted. On activation, the objects are restored in
  | the memory cache and removed from the cache loader if 'passivation' attribute is true,
  | otherwise the objects are only loaded from the cache loader -->
  |     <loaders passivation="true" shared="true">
  |         <!-- if passivation is true, only the first cache loader is used; the rest are ignored -->
  |         <loader
  |                 class="org.jboss.cache.loader.JDBCCacheLoader"
  |                 async="false">
  |             <properties>
  |                 cache.jdbc.table.name=jbosscache
  |                 cache.jdbc.table.create=true
  |                 cache.jdbc.table.drop=true
  |                 cache.jdbc.table.primarykey=jbosscache_pk
  |                 cache.jdbc.fqn.column=fqn
  |                 cache.jdbc.fqn.type=VARCHAR(255)
  |                 cache.jdbc.node.column=node 
  |                 cache.jdbc.node.type=blob
  |                 cache.jdbc.parent.column=parent
  |                 cache.jdbc.driver=com.informix.jdbc.IfxDriver
  |                 cache.jdbc.url=jdbc:informix-sqli://<host>:<port1533>/<database>:informixserver=<dbservername>
  |                 cache.jdbc.user=userid
  |                 cache.jdbc.password=password
  |             </properties>
  |         </loader>
  |     </loaders>
  | 
  | 
  | </jbosscache>
  | 



Thanks
Atif

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4208608#4208608

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4208608