Re: field with auto-increment

Pierre,
I've had trouble with the latest jdbc jar that is included by default, I 
think it is a late 3.1.xx beta version. I've downloaded the latest 
version 3.0.xx version and had much better success.  What version of 
mysql are you running against?  I copied and pasted the sql statement 
from your error message, and it works ok in MySQL Query Browser (as it 
should, it looks fine to me) with mysql v.4.1.3

snippets

<an entity:>

     /**
      * Does ...
      *
      * @persist.field
      *   name="id"
      *   db-name="id"
      *   type="INTEGER"
      *   length="8"
      *   null-allowed="false"
      *   primary-key="true"
      *   auto-increment="identity"
      *   descrip="This employee record ID"
      *
      * @return Integer The ID
      */
     public Integer getId() {
         return this.id;
     }

<keel.properties>

jdbc.keel-dbpool.driver=com.mysql.jdbc.Driver
jdbc.keel-dbpool.dburl=jdbc:mysql://keeldbserver:3306/keel
jdbc.keel-dbpool.user=xxxxxxxx
jdbc.keel-dbpool.password=xxxxxxxxx
jdbc.keel-dbpool.keep-alive-disable=false

svc.persist.dbtype.mysql=keel-dbtype

<system.xconf not sure what you'd like here, I can't see anything that 
affects auto_increment>

     <jdbc id="keel-dbpool">
       <pool-controller timeout="-1" min="1" blocking="true" 
connection-class="org.apache.avalon.excalibur.datasource.JdbcConnection" 
trim-interval="60000" maxStrict="true" max="10" auto-commit="true">
         <keep-alive disable="true"/>
       </pool-controller>
       <driver>com.mysql.jdbc.Driver</driver>
       <dburl>jdbc:mysql://keeldbserver:3306/keel</dburl>
       <user>xxxxxxxxxx</user>
       <password>xxxxxxxxxx</password>
     </jdbc>
     <mysql logger="persist-default" activation="startup" id="keel-dbtype">
       <type to="text" suffix="'" prefix="'" from="longvarchar"/>
       <type to="tinyint(1)" suffix="" prefix="" from="boolean"/>
       <type to="blob" suffix="" prefix="" from="blob"/>
       <type to="datetime" suffix="" prefix="" from="datetime"/>
       <type to="float" suffix="" prefix="" from="float"/>
     </mysql>

gene

Raoul Pierre wrote:
> Gene,
> 
> I must do some wrong thing, as with Mysql I get also error like:
> 
> GRAVE: Stack for error from createdb, Key: 'nodb Message: Unable to 
> create database tables:Unable to build/execute create statement 'CREATE 
> TABLE T_worker (workerId INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
> entrance DATE, ident VARCHAR(20) not null, personId INTEGER not null)' 
> for table 'T_worker'Unexpected token: AUTO_INCREMENT in statement 
> [CREATE TABLE T_worker (workerId INT NOT NULL AUTO_INCREMENT]
> org.keel.services.persist.PersistenceException: Unable to build/execute 
> create statement 'CREATE TABLE T_worker (workerId INT NOT NULL 
> AUTO_INCREMENT PRIMARY KEY, entrance DATE, ident VARCHAR(20) not null, 
> personId INTEGER not null)' for table 'T_worker'Unexpected token: 
> AUTO_INCREMENT in statement [CREATE TABLE T_worker (workerId INT NOT 
> NULL AUTO_INCREMENT]
>    at 
> org.keel.services.persist.defaultpersist.DefaultPersistentFactory.createTables(DefaultPersistentFactory.java:211) 
> 
> 
> 
> May I ask you some snippets from your system.xconf, keel.properties and 
> from your meta-data.
> 
> Pierre
> 
> 
> Gene a écrit :
> 
>> I use it successfully with svc-persist-default and mysql, but don't 
>> know about hsqlDB.  All that confirms is that the xdoclet tags are 
>> being generated properly.
>>
>> hth
>> gene
>>
>> Raoul Pierre wrote:
>>
>>> Hello,
>>>
>>> Can we use
>>>
>>>     *  auto-increment="identity"
>>>
>>> in a @persist.field meta data with svc-persist-default and hsqlDB?
>>>
>>> Pierre
>>>
>>>
>>>
>>>
>>> http://keelframework.org/documentation.shtml
>>> Keelgroup mailing list
>>> [email protected]
>>> http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com
>>>
>> http://keelframework.org/documentation.shtml
>> Keelgroup mailing list
>> [email protected]
>> http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com
>>
>>
>>
> 
> 
> 
> 
> http://keelframework.org/documentation.shtml
> Keelgroup mailing list
> [email protected]
> http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com
> 
http://keelframework.org/documentation.shtml
Keelgroup mailing list
[email protected]
http://lists.keelframework.com/listinfo.cgi/keelgroup-keelframework.com