Alex I'didn't understand about pk generator. As you have suggested I'm already using a Sequence gen session bean. I've put those directives on db, as redundant code.
Ps.: You are a mith, thx very much ! ;-) Alex Loubyansky wrote:
k> Alex, I've found the problem k> if calendar id is 0 it doesn't work. If it's the only problem, then checkout a fresh version from CVS. I fixed it yesterday in 3.0, 3.2 and HEAD. How do you obtain a Calendar before doing wHome.create( pView, lCalendar )? There is no guarantee that calendar will have the correct pk value with such a table setup. This is why I warned you that, generally, it won't work. I suggest you to implement your own sequence generator pattern (or ask me to share mine :)) or use pk-sql entity-command. alex Thursday, November 14, 2002, 3:17:44 PM, you wrote: k> Alex, I've found the problem k> if calendar id is 0 it doesn't work. k> But I can't understand why? I've never read about it. k> Alex Loubyansky wrote:AFAIK, generally, this won't work.
If you would like to make use of db sequences consider pk-sql entity
command. But it's available since 3.2.
Anyway, try to fetch calendar's pk before assigning a relationship and
see what value it has. Post the results here, please.
alex
Thursday, November 14, 2002, 1:36:16 PM, you wrote:
k> Thx for your attention Alex,
k> this is a piece o sql (postgresql) I use to create tables.
k> --calendar section--
k> CREATE SEQUENCE calendar_seq;
k> CREATE TABLE calendar (
k> id INTEGER DEFAULT nextval('calendar_seq'),
k> validity_start date NOT NULL,
k> validity_end date CHECK(validity_end >= validity_start),
k> description varchar(255) NOT NULL,
k> rounds INTEGER,
k> PRIMARY KEY (id)
k> );
k> CREATE UNIQUE INDEX cal_descr_ix ON calendar(description);
k> CREATE SEQUENCE workweek_seq;
k> CREATE TABLE workweek (
k> id INTEGER DEFAULT nextval('workweek_seq') PRIMARY KEY,
k> week_day INTEGER DEFAULT 1,
k> round INTEGER,
k> start_t time DEFAULT('00:00') NOT NULL,
k> end_t time DEFAULT('23:59') CHECK (end_t > start_t),
k> calendar_id INTEGER REFERENCES calendar(id) k> );
k> while in bean generated calendarPk is
k> public CalendarPK( int id )
k> {
k> this.id = id;
k> }
k> generated from
k> /**
k> * Retrieve the Calendars's id.
k> *
k> * @return Returns the id of this Calendar.
k> * @ejb.persistent-field
k> * @ejb.pk-field
k> * @jboss.column-name
k> * name="id"
k> */
k> public abstract int getId();
k> /**
k> * Sets the Calendar's id.
k> *
k> * @param pId The id of this Calendar.
k> */
k> public abstract void setId(int pId);
k> I've consulted some manuals but I can's see the problem.
k> Alex Loubyansky wrote:
Hello kiuma,
what is the type of Calendar's primary key? What pk values you tried?
alex
Thursday, November 14, 2002, 11:38:27 AM, you wrote:
k> I've tryed also setting the post create method, but whit no result.
k> public WorkweekPK ejbCreate( WorkweekData pWorkweek, CalendarLocal k> lCalendar )
k> throws
k> InvalidValueException,
k> EJBException,
k> CreateException
k> {
k> // Clone the given Value Object to keep changed private
k> WorkweekData lData = (WorkweekData) pWorkweek.clone();
k> // Save the new Workweek
k> try {
k> lData.setId( generateUniqueId() );
k> setId( lData.getId() );
k> } catch (ServiceUnavailableException e) { k> System.out.println("Workweek Creation Error: \n" + k> e.getMessage());
k> throw new EJBException(e.getMessage());
k> }
k> setValueObject( lData ); k> // This is only possible in CMPs. Otherwise return a valid PK.
k> return null;
k> }
k> /**
k> */
k> public void ejbPostCreate( WorkweekData pWorkweek, CalendarLocal lCalendar )
k> {
k> setCalendar( lCalendar );
k> }
k> In my database calendar_id is always clean.
k> Please help me!!!!
k> kiuma wrote:
Hi I'm using jboss3.2b + xdoclet cvs
I've a calendar with many workweek days
so I configured xdoclet directives for
WorkweekBean
/**
* @ejb.interface-method
* view-type="local"
* @ejb.relation
* name="calendar-workweeks"
* role-name="workweek-has-calendar"
* cascade-delete="yes"
* target-ejb="Calendar"
* @jboss.relation
* fk-constraint="true"
* fk-column="calendar_id"
* related-pk-field="id"
*/
public abstract CalendarLocal getCalendar();
/**
* @ejb.interface-method
* view-type="local"
*/
public abstract void setCalendar(CalendarLocal pCalendarData);
while for
CalendarBean
/**
* @ejb.relation
* name="calendar-workweeks"
* role-name="calendar-has-workweeks"
* @ejb.interface-method
* view-type="local"
*/
public abstract Collection getWorkweeks(); /**
* @ejb.interface-method
* view-type="local"
*/
public abstract void setWorkweeks(Collection pHolydays);
when in my session I execute the following commands
WorkweekLocal wEntity = wHome.create( pView ); wEntity.setCalendar( lCalendar );
Workweek is created, but no calendar_id is set.
Could you help me please ?
the piece of the generated jboss_cmp is:
<ejb-relation>
<ejb-relation-name>calendar-workweeks</ejb-relation-name>
<foreign-key-mapping/>
<ejb-relationship-role>
<ejb-relationship-role-name>workweek-has-calendar</ejb-relationship-role-name>
<fk-constraint>true</fk-constraint>
<key-fields/>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>calendar-has-workweeks</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>id</field-name>
<column-name>calendar_id</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
-------------------------------------------------------
This sf.net email is sponsored by: To learn the basics of securing your web site with SSL, click here to get a FREE TRIAL of a Thawte Server Certificate: http://www.gothawte.com/rd524.html
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
