[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: EJB3 Timer Service Problem with Oracle Datasource

[ilangocal]

"jaikiran" wrote : anonymous wrote : ner) sql failed: CREATE TABLE QRTZ_JOB_DETAILS(JOB_NAME  VARCHAR2(80) NOT NULL, JOB_GROUP VARCHAR2(8
  |   | 0) NOT NULL, DESCRIPTION VARCHAR2(120) NULL, JOB_CLASS_NAME   VARCHAR2(128) NOT NULL, IS_DURABLE VAR
  |   | CHAR2(1) NOT NULL, IS_VOLATILE VARCHAR2(1) NOT NULL, IS_STATEFUL VARCHAR2(1) NOT NULL, REQUESTS_RECO
  |   | VERY VARCHAR2(1) NOT NULL, JOB_DATA BLOB NULL, PRIMARY KEY (JOB_NAME,JOB_GROUP))
  |   | java.sql.SQLException: ORA-00955: name is already used by an existing object
  | 
  | Does your Oracle database already has this table and JBoss is trying to create it again on startup?
  | 

You are right. I can see tables in the database. Maybe that would explain why it is complaining when it sees a create table statement again (in ejb3-timer-service.xml??)
I am not sure what to do about this problem. Please help.



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

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