Bugs item #1029232, was opened at 2004-09-16 14:38
Message generated for change (Comment added) made by tdiesler
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=1029232&group_id=22866

Category: JBossServer
Group: v4.0
>Status: Closed
Resolution: None
Priority: 5
Submitted By: Juan Martinez (juanmartinez)
Assigned to: Thomas Diesler (tdiesler)
Summary: CreateTableDDL for EJBTimerService

Initial Comment:
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 
 

----------------------------------------------------------------------

>Comment By: Thomas Diesler (tdiesler)
Date: 2004-09-21 12:31

Message:
Logged In: YES 
user_id=423364

Fixed in jboss-head and jboss-4.0.

DatabasePersistencePolicy.createTableIfNotExists
DatabasePersistencePolicy.doInsertTimer
DatabasePersistencePolicy.doSelectTimers

I use the sql-type that maps to java.lang.Object, serialize 
the object internally and write to db using setBytes().


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=1029232&group_id=22866


-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to