1 Reply Latest reply on Sep 3, 2001 6:28 AM by kulrich

    Jboss doesn't create a the table on it's own.

    kulrich

      Jboss doesn't create a the table "cabin" existing DataBase "titan" on it's own when I use the Bean.
      When I create the Table "cabin" I dont have any Problems no more.

      Here my jar.xml

      <jaws>
       <datasource>titan</datasource>
       <type-mapping>mySQL</type-mapping>
      
       <enterprise-beans>
       <entity>
       <ejb-name>CabinBean</ejb-name>
       <table-name>cabin</table-name>
       <create-table>true</create-table>
       <remove-table>false</remove-table>
      
       <cmp-field>
       <field-name>id</field-name>
       <column-name>id</column-name>
       <jdbc-type>VARCHAR</jdbc-type>
       <sql-type>int(11)</sql-type>
       </cmp-field>
       <cmp-field>
       <field-name>name</field-name>
       <column-name>name</column-name>
       <jdbc-type>VARCHAR</jdbc-type>
       <sql-type>VARCHAR(100)</sql-type>
       </cmp-field>
       <cmp-field>
       <field-name>deckLevel</field-name>
       <column-name>deckLevel</column-name>
       <jdbc-type>VARCHAR</jdbc-type>
       <sql-type>VARCHAR(100)</sql-type>
       </cmp-field>
       <cmp-field>
       <field-name>ship</field-name>
       <column-name>ship</column-name>
       <jdbc-type>VARCHAR</jdbc-type>
       <sql-type>VARCHAR(100)</sql-type>
       </cmp-field>
       <cmp-field>
       <field-name>bedCount</field-name>
       <column-name>bedCount</column-name>
       <jdbc-type>VARCHAR</jdbc-type>
       <sql-type>VARCHAR(100)</sql-type>
       </cmp-field>
       </entity>
       </enterprise-beans>
      
      </jaws>


        • 1. Re: Jboss doesn't create a the table on it's own.
          kulrich

          Something new :
          When I create the Table "cabin" Jboss says:
          ...
          [J2EE Deployer Default] Deploy J2EE application: file:/C:/development/JBoss-2.2.2_Tomcat-3.2.2/jboss/deploy/titan.jar
          [J2EE Deployer Default] Create application titan.jar
          [J2EE Deployer Default] install module titan.jar
          [Container factory] eploying:file:/C:/development/JBoss-2.2.2_Tomcat-3.2.2/jboss/tmp/deploy/Default/titan.jar/
          [Verifier] Verifying file:/C:/development/JBoss-2.2.2_Tomcat-3.2.2/jboss/tmp/deploy/Default/titan.jar/ejb1005.jar

          [Container factory] Deploying CabinBean

          [Container factory] Deploying TravelAgentBean

          [JAWS] Table 'cabin' already exists

          [Container factory] Deployed application: file:/C:/development/JBoss-2.2.2_Tomcat-3.2.2/jboss/tmp/deploy/Default/titan.j
          ar/

          [J2EE Deployer Default] J2EE application: file:/C:/development/JBoss-2.2.2_Tomcat-3.2.2/jboss/deploy/titan.jar is deploy
          ....

          if I dont create table cabin jboss says:

          ....
          [Container factory] Deploying CabinBean
          [Container factory] Deploying TravelAgentBean
          [Container factory] Deployed application: file:/C:/development/JBoss-2.2.2_Tomcat-3.2.2/jboss/tmp/deploy/Default/titan.j
          ar/
          ...