[JBoss-dev] Is defaultscreate-table working?

2001-11-29 Thread Ignacio Coloma

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
  datasourcejava:/CanplasticaMySQLDS/datasource
  type-mappingmySQL/type-mapping
  debugtrue/debug
  create-tablefalse/create-table
  remove-tablefalse/remove-table
   /defaults

...

entity
ejb-nameOferta/ejb-name
table-nameOFERTA/table-name
cmp-field
field-nameid/field-name
column-nameID/column-name
/cmp-field
cmp-field
field-namenombre/field-name
column-nameNOMBRE/column-name
/cmp-field
cmp-field
field-namefechaInicio/field-name
column-nameFECHA_INICIO/column-name
/cmp-field
cmp-field
field-namefechaFin/field-name
column-nameFECHA_FIN/column-name
/cmp-field
/entity

conf/default/standardjbosscmp-jdbc.xml:=
   defaults
  datasourcejava:/DefaultDS/datasource
  type-mappingHypersonic SQL/type-mapping
  debugtrue/debug

  create-tablefalse/create-table
  remove-tablefalse/remove-table
  read-onlyfalse/read-only
  time-out300/time-out
  select-for-updatefalse/select-for-update
  preferred-relation-mappingforeign-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



RE: [JBoss-dev] Is defaultscreate-table working?

2001-11-29 Thread Dain Sundstrom

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 defaultscreate-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
   datasourcejava:/CanplasticaMySQLDS/datasource
   type-mappingmySQL/type-mapping
   debugtrue/debug
   create-tablefalse/create-table
   remove-tablefalse/remove-table
/defaults
 
 ...
 
 entity
 ejb-nameOferta/ejb-name
 table-nameOFERTA/table-name
 cmp-field
 field-nameid/field-name
 column-nameID/column-name
 /cmp-field
 cmp-field
 field-namenombre/field-name
 column-nameNOMBRE/column-name
 /cmp-field
 cmp-field
 field-namefechaInicio/field-name
 column-nameFECHA_INICIO/column-name
 /cmp-field
 cmp-field
 field-namefechaFin/field-name
 column-nameFECHA_FIN/column-name
 /cmp-field
 /entity
 
 conf/default/standardjbosscmp-jdbc.xml:=
defaults
   datasourcejava:/DefaultDS/datasource
   type-mappingHypersonic SQL/type-mapping
   debugtrue/debug
 
   create-tablefalse/create-table
   remove-tablefalse/remove-table
   read-onlyfalse/read-only
   time-out300/time-out
   select-for-updatefalse/select-for-update
   
 preferred-relation-mappingforeign-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



Re: [JBoss-dev] Is defaultscreate-table working?

2001-11-29 Thread Dave Smith

Ever since I have used RH it has never worked.

Dain Sundstrom wrote:

 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 defaultscreate-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
  datasourcejava:/CanplasticaMySQLDS/datasource
  type-mappingmySQL/type-mapping
  debugtrue/debug
  create-tablefalse/create-table
  remove-tablefalse/remove-table
   /defaults

...

entity
ejb-nameOferta/ejb-name
table-nameOFERTA/table-name
cmp-field
field-nameid/field-name
column-nameID/column-name
/cmp-field
cmp-field
field-namenombre/field-name
column-nameNOMBRE/column-name
/cmp-field
cmp-field
field-namefechaInicio/field-name
column-nameFECHA_INICIO/column-name
/cmp-field
cmp-field
field-namefechaFin/field-name
column-nameFECHA_FIN/column-name
/cmp-field
/entity

conf/default/standardjbosscmp-jdbc.xml:=
   defaults
  datasourcejava:/DefaultDS/datasource
  type-mappingHypersonic SQL/type-mapping
  debugtrue/debug

  create-tablefalse/create-table
  remove-tablefalse/remove-table
  read-onlyfalse/read-only
  time-out300/time-out
  select-for-updatefalse/select-for-update
  
preferred-relation-mappingforeign-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
 
 



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