Julien Giovannnoni wrote:
>
> Hi World,
>
> I asked a paar days ago, but i have unfortunately no responses and my
> problem persist!
>
> This question was:
>
> I need to use Oracle as DB. Before, I used mySQL.
> I want to use sequences to deal with autoincrement. So in the
> MapBuilders, I used setPrimaryKeyMethod(TableMap.SEQUENCE); But I don't
> know how to tell Turbine to use the sequence I want.
>
> This is a part of my MapBuilder. I would like to have the Company_sid
> autoincremented by a sequence named seq_company_sid
<snip>
>
> I think I should use the setSequenceInfo(Object), but I don't know what
> to put as object.
The Object is the String: "seq_company_sid". I would like to be clear
that this is not being used in an "autoincrement" fashion, as I did not
know how to call the sequence as part of the insert and also obtain the
value of the key. BasePeer queries the sequence for the id and then
uses it to insert the new row. (It is a two step process.)
>
> Any suggestions or doc to read are welcome.
>
> and the second question is:
>
> What about password encryption with a DB Oracle!
>
> I can see what is it work with mysql, because is it the standar DB name
> for Turbine I think?!
>
> So, the probleme is, if I have a non encrypted password in the DB, and I
> try a login: The comparaison
> will failed because is it non encrypted or encrypted with an
> incompatible system?!
I do not understand the question, so I will answer to ways, in the hope
that one of them is relevant.
Turbine uses standard jdbc methods to obtain connections to the
database, any encryption that might exist is outside the scope of
Turbine. Turbine does provide some rudimentary support for encrypting
user passwords, but this is completely orthogonal to any database as the
database is just storing a String.
>
> Thanks to Help me!
>
> Julien
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]