[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

2009-07-14 Thread galder.zamarr...@jboss.com
niuxuetao_fiserv wrote : Btw, can I use the GenericTransactionManagerLookup in Websphere6.1? It should do. View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=4243564#4243564 Reply to the post :

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

2009-07-05 Thread mircea.markus
as the stack trace shows, both exceptions originate within the JDBCCacheLoader, and are most likely related to a change that was made to it, regarding https://jira.jboss.org/jira/browse/JBCACHE-1410. I've reopened the JIRA to test Oracle 10g integration. View the original post :

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

2009-07-05 Thread niuxuetao_fiserv
Thanks Mircea, can we expect any forseeable date of this issue being tested and solved if it is really a bug? Xuetao View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=4241712#4241712 Reply to the post :

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

2009-07-05 Thread niuxuetao_fiserv
Btw, can I use the GenericTransactionManagerLookup in Websphere6.1? View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=4241748#4241748 Reply to the post : http://www.jboss.org/index.html?module=bbop=postingmode=replyp=4241748

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

2009-07-02 Thread mircea.markus
anonymous wrote : No, sorry, I managed to reproduce the problem with one thread on DEBUG level. Here is the log: | Code: | | [2009-07-01 16:11:48,367] [Detection1] DEBUG JDBCCacheLoader - executing sql: INSERT INTO Cached_Eve | nts (fqn, node, parent) SELECT ?, ?, ? FROM Cached_Events_D

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

2009-07-02 Thread niuxuetao_fiserv
The 2nd problem I have occurs when running with multiple threads. This is a runtime exception being thrown, not a log message. (besides the 1-thread problem still arises in multiple thread environment) This problem appears differently in JSE environment (where only DummyTransactionManager is

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

2009-07-02 Thread niuxuetao_fiserv
Hi Mircea, Thanks for the response. Do you mean the version I am using does not work for Oracle? I actually have two problems: 1. Running with 1 thread, as pasted above, there are 3 exception traces logged by JBossCache at both WARN and ERROR level, they are not thrown by JbossCache as

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

2009-07-01 Thread mircea.markus
Can you please take a look at the created table in Oracle and post its structure/DDL (IIRC you can use DESC table_name for that). View the original post : http://www.jboss.org/index.html?module=bbop=viewtopicp=4241071#4241071 Reply to the post :

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

2009-07-01 Thread niuxuetao_fiserv
Thanks Mircea, Here is the table description: | DESC cached_events | Name Null Type

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

2009-07-01 Thread mircea.markus
The table looks okay. Can you please take a look(post) in the logs for the debug statement right before the failure. Should look like this: executing sql: INSERT INTO Also try execute that from the console, perhaps we can narrow down the problem this way. anonymous wrote : And there is

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

2009-07-01 Thread niuxuetao_fiserv
Hi Mircea, Thanks for the hints, I looked at the debug log, the sql statement being logged right before the exception is not a INSERT INTO, but a select: | | DEBUG JDBCCacheLoader - executing sql: select fqn from Cached_Events where parent=? (/) | | I tries to execute the

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

2009-07-01 Thread niuxuetao_fiserv
Btw, I was testing with 5 threads when seeing the DEBUG logs above. I also tested with 1 thread, bug with DEBUG level on org.jboss, I cannot recreate any exceptions. However, with WARN debug level for org.jboss I still can reproduce it as described on my original post. Weird... Xuetao View

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

2009-07-01 Thread niuxuetao_fiserv
No, sorry, I managed to reproduce the problem with one thread on DEBUG level. Here is the log: | [2009-07-01 16:11:48,367] [Detection1] DEBUG JDBCCacheLoader - executing sql: INSERT INTO Cached_Events (fqn, node, parent) SELECT ?, ?, ? FROM Cached_Events_D WHERE NOT EXISTS (SELECT fqn FROM

[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

2009-07-01 Thread niuxuetao_fiserv
And the error log from JDBCCacheLoader right after this debug log is this: | [2009-07-01 16:11:48,367] [Detection1] ERROR JDBCCacheLoader - Failed to insert node :ORA-01461: can bind a LONG value only for insert into a LONG column | And the error stack trace is the same as I posted on the