[jboss-user] [JBoss Messaging] - CreateTablesOnStartup being ignored?

[beck4353]

I have installed JBoss Messaging RC4.  I have replaces the hsqldb persistence file with the supplier Oracle one.  After my first run, I see the JMS tables created in my Oracle instance.

Now, I set that value to false in oracle-persistence-service.xml and restart the server.  I have the console log level set to DEBUG.  I see the follwoing in server.log:

2006-08-10 11:35:42,578 DEBUG [org.jboss.system.ServiceConfigurator] CreateTablesOnStartup set to false in jboss.messaging:service=PersistenceManager

but further down, I see:

2006-08-10 11:36:01,718 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3 at 1cc0a7f, cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader at 1087d61{ url=null ,addedOrder=0}
2006-08-10 11:36:01,734 DEBUG [org.jboss.jms.server.plugin.JDBCChannelMapper] Failed to create users table: CREATE TABLE JMS_USER (USERID VARCHAR2(32) NOT NULL, PASSWD VARCHAR2(32) NOT NULL, CLIENTID VARCHAR2(128), PRIMARY KEY(USERID))
java.sql.SQLException: ORA-00955: name is already used by an existing object

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
....



I know that these are Debug messages that can be ignored, but any ideas as to why this could be happening?

Thanks




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

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