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

   public void doBuild ( ) throws Exception
    {
        String string = new String("");
        Integer integer = new Integer(0);
        java.util.Date date = new Date();

        dbMap = PoolBrokerService.getInstance()
            .getDatabaseMap(PoolBrokerService.DEFAULT);

        dbMap.addTable(getTable());
        TableMap tMap = dbMap.getTable(getTable());
        tMap.addPrimaryKey ( getCompany_CompanySid(), integer );
        tMap.setPrimaryKeyMethod(TableMap.SEQUENCE);

        tMap.addColumn ( getCompany_Name(), string );
        tMap.addColumn ( getCompany_Comment(), string );
.......
}

I think I should use the setSequenceInfo(Object), but I don't know what
to put as object.

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?!

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]

Reply via email to