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

[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 statement: select fqn from Cached_Events where parent='/', it finds something in the table.

The 1st insert into statement is logged far after the exception is logged. This is the log msg for it, and it is surprisingly involving the automatically created table 'cached_events_d':

  | DEBUG JDBCCacheLoader - executing sql: INSERT INTO Cached_Events (fqn, node, parent) SELECT ?, ?, ? FROM Cached_Events_D WHERE NOT EXISTS (SELECT fqn FROM Cached_Events WHERE fqn = ?) (/RTDE/time-distance-analysis-gps/0)
  | 

I don't know how to execute this in the console (Oracle SQL Developer)

Any idea?

Xuetao

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

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