1 Reply Latest reply on Jan 20, 2004 3:19 PM by Mark Lybarger

    oracle table size

    Mark Lybarger Apprentice

      i'll probably get a few of the phrasing wrong here, but here goes. i'm moving from using postgresql as the jms data source provider to using oracle. i _think_ that jboss is unable to create the jms_messages table. in my server logs, i see a message such as:

      Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

      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:573).....

      i look at my database schema and i see the jms_transactions table, but not the jms_messages table.

      if i try to manually create the table as per the CREATE_MESSAGE_TABLE statement in the oracle-jdbc2-service.xml in the default/deploy/jms folder, i get the following message from oracle:

      ORA-03237: Initial Extent of specified size cannot be allocated

      are there any special parameters that my schema needs to be created with to be able to use this feature? space/size considerations? i asked for 100M of table space for my schema just to be on the safe side, but the actual data of my user tables is fairly small (currently < 300k)

      btw, the forum search isn't working so nicely, and there's no forum about the forums themsselves that i can see.

        • 1. Re: oracle table size
          Mark Lybarger Apprentice

          it seems that the create table i'm trying to use isn't a valid oracle script:

          CREATE TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL,
          DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER,
          TXOP CHAR(1),
          MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION) )

          i don't see a oracle-jdbc2-service.xml in the examples, so i'm not quite sure where this came from. anyone have a valid example of an oracle-jdbc2-service.xml file?

          thanks