Does it work using the sequences by only changing this code?
Thanks,

Frank
  -----Message d'origine-----
  De : Heather Boyd [mailto:[EMAIL PROTECTED]]
  Envoy� : mardi 12 juin 2001 9:53
  � : '[EMAIL PROTECTED]'
  Objet : RE: Problem with Oracle Database - cannot insert null into
  Turbine_user



  The src I have is :

          tMap = dbMap.getTable(getTableUser());
          tMap.setPrimaryKeyMethod(TableMap.IDBROKERTABLE);

  you could do this

          tMap.setPrimaryKeyMethod(TableMap.SEQUENCE);


  The src Im referring to comes with tdk2.1b4.



  -----Original Message-----
  From: BERWART Thierry [mailto:[EMAIL PROTECTED]]
  Sent: 12 June 2001 08:39
  To: [EMAIL PROTECTED]
  Subject: RE: Problem with Oracle Database - cannot insert null into
  Turbine_user



  Thanks you

  I think that this is the problem !
  in the java source, they use :

  TableMap tMap = dbMap.getTable(getTableUser());
  tMap.setPrimaryKeyMethod("idbroker_table");

  must I replace idbroker by sequence or idbroker_table by sequence_table
  ?

  PS I read some documentation about turbine but I didn't find any info
  about the primary key method :(

  Thanks

  Thierry
          

  -----Message d'origine-----
  De : Heather Boyd [mailto:[EMAIL PROTECTED]]
  Envoy� : mardi 12 juin 2001 9:01
  � : '[EMAIL PROTECTED]'
  Objet : RE: Problem with Oracle Database - cannot insert null into
  Turbine_user




  I have managed to susccessfully insert into an Oracle database
  by using the IDBroker approach - but have also been unsuccessful
  using sequences.

  Trawling through the mailing list archives I came across this :

  http://www.mail-archive.com/[email protected]/msg00194.htm
  l

  I checked my version of TurbineMapBuilder.java and found that, indeed, 
  the IDBROKER option was hardcoded.  So this maybe the cause of your
  problem.




  -----Original Message-----
  From: BERWART Thierry [mailto:[EMAIL PROTECTED]]
  Sent: 11 June 2001 15:36
  To: [EMAIL PROTECTED]
  Subject: Problem with Oracle Database - cannot insert null into
  Turbine_user



  Hello,

  I have another problem :/
  When I try to create a new User, i have the following message :

  Exception: java.sql.SQLException: ORA-01400: cannot insert NULL into
  ("SW1"."TURBINE_USER"."USER_ID")

  at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
  at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)

  ...
  I checked whether the sequence turbine_user_seq exists and it exists !
  I can loggin into the system with admin/jetspeed and it's working ..

  It seems that there is a problem with the ID of the table and the
  sequence number
  If ever you already had this problem, please help me !

  Thanks you in advance 

  Thierry

  ---------------------------------------------------------------------
  To unsubscribe, e-mail: [EMAIL PROTECTED]
  For additional commands, e-mail: [EMAIL PROTECTED]

  ---------------------------------------------------------------------
  To unsubscribe, e-mail: [EMAIL PROTECTED]
  For additional commands, e-mail: [EMAIL PROTECTED]


  ---------------------------------------------------------------------
  To unsubscribe, e-mail: [EMAIL PROTECTED]
  For additional commands, e-mail: [EMAIL PROTECTED]

  ---------------------------------------------------------------------
  To unsubscribe, e-mail: [EMAIL PROTECTED]
  For additional commands, e-mail: [EMAIL PROTECTED]


  ---------------------------------------------------------------------
  To unsubscribe, e-mail: [EMAIL PROTECTED]
  For additional commands, e-mail: [EMAIL PROTECTED]


Reply via email to