[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader puts data but will not get it back from

2009-05-12 Thread mariuszs 
09:31:16,248 INFO  [ManagementService]  Cache: JBossCache 'Naga' 3.0.2.GA
  | 09:31:16,287 ERROR [JDBCCacheLoader] Failed to insert node :DB2 SQL Error: 
SQLCODE=-418, SQLSTATE=42610, SQLERRMC=null, DRIVER=3.52.95
  | 09:31:16,289 ERROR [ManagementService] Putting to cache error: 
org.jboss.cache.CacheException: com.ibm.db2.jcc.a.nn: DB2 SQL Error: 
SQLCODE=-418, SQLSTATE=42610, SQLERRMC=null, DRIVER=3.52.95
  | 

I have problem with storing/accessing data from db2. Im using jboss501

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=4230296#4230296

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=4230296
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader puts data but will not get it back from

2009-05-12 Thread manik.surt...@jboss.com 
Could you enable TRACE level logging on org.jboss.cache.loader so that we can 
see the SQL that is being generated?


View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=4230360#4230360

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=4230360
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader puts data but will not get it back from

2009-05-12 Thread mariuszs 
Yes, i can. Thx for reply. I found than sql like this
INSERT INTO JBOSSCACHE (FQN,NODE,PARENT) SELECT /, null, / FROM 
JBOSSCACHE_D WHERE NOT EXISTS (SELECT FQN FROM JBOSSCACHE WHERE FQN = /);
is not workign in db2.

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=4230380#4230380

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=4230380
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader puts data but will not get it back from

2009-05-12 Thread mariuszs 
11:57:29,710 TRACE [NonManagedConnectionFactory] using connection: 
com.ibm.db2.jcc.t...@2fb7b837
  | 11:57:29,710 TRACE [JDBCCacheLoader] Executing SQL statement [INSERT INTO 
jbosscache (fqn, node, parent) SELECT ?, ?, ? FROM jbosscache_D WHERE NOT 
EXISTS (SELECT fqn FROM jbosscache WHERE fqn = ?)]
  | 11:57:29,713 ERROR [JDBCCacheLoader] Failed to insert node :DB2 SQL Error: 
SQLCODE=-418, SQLSTATE=42610, SQLERRMC=null, DRIVER=3.52.95
  | 11:57:29,714 TRACE [NonManagedConnectionFactory] closed non tx connection: 
com.ibm.db2.jcc.t...@2fb7b837
  | 

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=4230385#4230385

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=4230385
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader puts data but will not get it back from

2009-05-12 Thread mariuszs 
This error code mean:
anonymous wrote : A STATEMENT STRING TO BE PREPARED CONTAINS AN INVALID USE
  | OF PARAMETER MARKERS 
  | A parameter marker is not allowed.


View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=4230388#4230388

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=4230388
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader puts data but will not get it back from

2009-05-12 Thread manik.surt...@jboss.com 
Sorry, I don't actually have a DB2 environment to test on.  

Do you know what characters DB2 refers to as 'parameter markers'?

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=4230399#4230399

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=4230399
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader puts data but will not get it back from

2009-05-12 Thread mariuszs 
? - parameter marker

I think this is about last ? in subquery. Could we use simpler form of this 
sql, without jbosscache_d involved?

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=4230415#4230415

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=4230415
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader puts data but will not get it back from

2009-05-12 Thread mariuszs 
OK, I found that this is not working too (invalid marker usage)

  | INSERT INTO 
  |   db2jboss.JBOSSCACHE (fqn,node,parent) 
  | SELECT ?,?,? FROM db2jboss.JBOSSCACHE_D WHERE NOT EXISTS (SELECT fqn FROM
  | db2jboss.JBOSSCACHE
  | WHERE fqn = '/Cache')

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=4230422#4230422

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=4230422
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader puts data but will not get it back from

2009-05-12 Thread mariuszs 
https://jira.jboss.org/jira/browse/JBCACHE-1510

View the original post : 
http://www.jboss.org/index.html?module=bbop=viewtopicp=4230426#4230426

Reply to the post : 
http://www.jboss.org/index.html?module=bbop=postingmode=replyp=4230426
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user