I want to switch create-table off by default, but the tag is being ignored.
I checked the dtd to be sure that everything's ok. Maybe it's time to
download the latest sources?

Only tell me that it works for someone out there and I'll keep trying...

jbosscmp-jdbc:=====================

<jbosscmp-jdbc>
   <defaults>
      <datasource>java:/CanplasticaMySQLDS</datasource>
      <type-mapping>mySQL</type-mapping>
      <debug>true</debug>
      <create-table>false</create-table>
      <remove-table>false</remove-table>
   </defaults>

...

        <entity>
            <ejb-name>Oferta</ejb-name>
            <table-name>OFERTA</table-name>
            <cmp-field>
                <field-name>id</field-name>
                <column-name>ID</column-name>
            </cmp-field>
            <cmp-field>
                <field-name>nombre</field-name>
                <column-name>NOMBRE</column-name>
            </cmp-field>
            <cmp-field>
                <field-name>fechaInicio</field-name>
                <column-name>FECHA_INICIO</column-name>
            </cmp-field>
            <cmp-field>
                <field-name>fechaFin</field-name>
                <column-name>FECHA_FIN</column-name>
            </cmp-field>
        </entity>

conf/default/standardjbosscmp-jdbc.xml:=====================
   <defaults>
      <datasource>java:/DefaultDS</datasource>
      <type-mapping>Hypersonic SQL</type-mapping>
      <debug>true</debug>

      <create-table>false</create-table>
      <remove-table>false</remove-table>
      <read-only>false</read-only>
      <time-out>300</time-out>
      <select-for-update>false</select-for-update>
      <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
   </defaults>


server log:=====================
[2001-11-29 22:06:15,468,CMP,DEBUG] Start command executing: CREATE TABLE
OFERTA (ID INTEGER, FECHA_FIN DATETIME, NOMBRE VARCHAR(255) BINARY,
FECHA_INICIO DATETIME)
[2001-11-29 22:06:15,468,CanplasticaMySQLDS,DEBUG] Pool CanplasticaMySQLDS
[0/0/10] destroyed object
org.jboss.resource.adapter.jdbc.local.JDBCManagedConnection@8deb8a.
[2001-11-29 22:06:15,478,CMP,DEBUG] java.sql.SQLException: General error:
Table 'oferta' already exists
[2001-11-29 22:06:15,478,CMP,DEBUG] Could not create table OFERTA



_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to