Re: Problem with Oracle Database - cannot insert null into Turbine_user

["Frank W. Nolden" <fr...@maxware.nl>]

That was my problem as well. A collegue of mine told me to get the Turbine CVS code, but I understood from Jason that this code would be in the TDK 2.1b4. Now I just received another mail mentioning that it is still hardcoded in that code.
So, I am lost as well. Maybe John can answer this question?

Frank
  ----- Original Message ----- 
  From: BERWART Thierry 
  To: frank.nolden@maxware.nl 
  Sent: Tuesday, June 12, 2001 09:55
  Subject: RE: Problem with Oracle Database - cannot insert null into Turbine_user



  I am a little bit lost ...

  What CVS code must I get ? the code for jetspeed ? turbine ?

  thanks you

  Thierry

  -----Message d'origine-----
  De : Frank W. Nolden [mailto:frank.nolden@maxware.nl]
  Envoyé : mardi 12 juin 2001 9:46
  À : turbine-user@jakarta.apache.org
  Objet : Re: Problem with Oracle Database - cannot insert null into
  Turbine_user


  I had the same discussion some time ago with John and he told me that
  the support for sequences was not in the torque release, but only in the
  CVS code. I haven't checked it, but you may try and find the CVS code.
  With that code you can use the sequences in Oracle.

  Frank

    ----- Original Message ----- 
    From: BERWART Thierry 
    To: turbine-user@jakarta.apache.org 
    Sent: Tuesday, June 12, 2001 09:39
    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:hlb@aspectgroup.co.uk]
    Envoyé : mardi 12 juin 2001 9:01
    À : 'turbine-user@jakarta.apache.org'
    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/turbine-user@jakarta.apache.org/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:thierry.berwart@staff.win.be]
    Sent: 11 June 2001 15:36
    To: turbine-user@jakarta.apache.org
    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: turbine-user-unsubscribe@jakarta.apache.org
    For additional commands, e-mail: turbine-user-help@jakarta.apache.org

    ---------------------------------------------------------------------
    To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
    For additional commands, e-mail: turbine-user-help@jakarta.apache.org


    ---------------------------------------------------------------------
    To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
    For additional commands, e-mail: turbine-user-help@jakarta.apache.org