I'm trying to make Oracle9i as the default DS, but keep the JMS persistence stuff to use Hsql. I've done:
- changed the default DS file (which used hsql) to hsql-ds.xml, and change the name "DefaultDS" to "HsqlDS" - added a default DS file which points to Oracle (the settings are working in my JDBC test programs) - change the "DefaultDS" in deploy/jms/hsql-jdbc2-service.xml to "HsqlDS" - same for the file deploy/jms/hsql-jdbc-state-service.xml I've not put in my own stuff yet, just an empty JBoss with the default server config. But I'm having all kinds of problems. I thought Oracle9i is well supported. | ... | 2004-12-29 14:49:43,542 DEBUG [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Driver already registered for url: jdbc:oracle:thin:@tank.idsignet.com:1521:tank | 2004-12-29 14:49:44,105 DEBUG [org.jboss.ejb.txtimer.DatabasePersistencePolicy] Executing DDL: create table TIMERS ( | TIMERID varchar(50) not null, | TARGETID varchar(50) not null, | INITIALDATE timestamp not null, | INTERVAL bigint, | INSTANCEPK other, | INFO other, | constraint timers_pk primary key (TIMERID) | ) | 2004-12-29 14:49:44,136 ERROR [org.jboss.ejb.txtimer.DatabasePersistencePolicy] Starting failed jboss.ejb:persistencePolicy=database,service=EJBTimerService | java.sql.SQLException: ORA-00902: Invalid type | | at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) | at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) | | ... | I dig around but couldn't find where the config file is. "Interval" seems to be a keyword in Oracle. How do you make Oracle9i work out of the box? thx View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3860079#3860079 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3860079 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
