[jboss-jira] [JBoss JIRA] Updated: (JBAS-1081) CreateTableDDL for EJBTimerService

[Dimitris Andreadis (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBAS-1081?page=all ]

Dimitris Andreadis updated JBAS-1081:
-------------------------------------

    Component/s: Scheduling/Timers

> CreateTableDDL for EJBTimerService
> ----------------------------------
>
>                 Key: JBAS-1081
>                 URL: http://jira.jboss.com/jira/browse/JBAS-1081
>             Project: JBoss Application Server
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Scheduling/Timers
>    Affects Versions: JBossAS-4.0.0 Final
>            Reporter: SourceForge User
>         Assigned To: Thomas Diesler
>             Fix For: Closed issues from sourceforge
>
>
> SourceForge Submitter: juanmartinez .
> Hi. 
>  
> I don't if should report this as a bug, so feel free to delete this 
> report. 
>  
> I'm using Branch_4_0 with the PostgreSQL as the only datasource 
> (requirement). 
>  
> The EJBTimerService has the CreateTableDDL element defined as 
>  
>       <attribute name="CreateTableDDL"> 
>         create table TIMERS ( 
>            TIMERID varchar(50) not null, 
>            TARGETID varchar(50) not null, 
>            INITIALDATE timestamp not null, 
>            INTERVAL bigint, 
>            INSTANCEPK other, 
>            INFO other, 
>            constraint timers_pk primary key (TIMERID) 
>         ) 
>      </attribute> 
>  
> which is a problem for PostgreSQL since the datatype "other" isn't 
> defined (INSTANCEPK and INFO). 
>  
> I'm hoping that another (standard) datatype could be used or 
> samples for the different database mappings could be provided. 
>  
> Let me know if I can provide more information. 
>  Juan

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira