It should work, but I don't know. I'll check it out. -dain
> -----Original Message----- > From: Ignacio Coloma [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 29, 2001 4:15 PM > To: Jboss Development > Subject: [JBoss-dev] Is <defaults><create-table> working? > > > 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 > _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
