RE: PSML Database Problem

[Oscar Jim�nez Ribera]

I got the solution, i�m using Oracle, and the schemas that create Torque
uses fields of type BLOB, the solution is change that fields by LONG RAW
fields.


-----Mensaje original-----
De: Oscar Jim�nez Ribera [mailto:[EMAIL PROTECTED]]
Enviado el: martes, 23 de julio de 2002 10:57
Para: [EMAIL PROTECTED]
Asunto: PSML Database Problem


I follow this steps:

change database params from:
        build/torque/build.properties
        build/torque/dbpsml.properties
        webapps/WEB-INF/conf/Torque.properties

change
        locale.default=es in build/build.properties

change the following lines in JetspeedResources.properties


#services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.Cas
torPsmlManagerService

services.PsmlImportManager.classname=org.apache.jetspeed.services.psmlmanage
r.CastorPsmlManagerService

services.PsmlManager.classname=org.apache.jetspeed.services.psmlmanager.db.D
atabasePsmlManagerService

At this step i make the new war file (ant war) with no erros

Generate the sql scripts from:
        src/sql/security-schema.sql             adding the creation of table ID_TABLE
        src/sql/dbpsml-schema.sql
        src/sql/external/populate-oracle.sql


when i try to connect i've have the following error:

        Running PSMLImporter...
        java.lang.RuntimeException: Could not create new profile in DB

and when i look into the log file it's said:

        [10:27:29,515 INFO ] Forced id retrieval - no available vector
        [10:27:31,203 DEBUG] BasePeer.doUpdate:
whereClause=TABLE_NAME='JETSPEED_USER_PROFILE'
        [10:27:31,250 DEBUG] updateRow: UPDATE ID_TABLE SET NEXT_ID = 130 WHERE
TABLE_NAME = 'JETSPEED_USER_PROFILE'
        [10:27:31,421 ERROR] Error saving
profile:BaseProfile[user/admin/html/default.psml]
        [10:27:31,421 ERROR] Error occurred in Database PSML Manager:
        java.sql.SQLException: ORA-01465: n�mero hexadecimal no v�lido
                at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
                at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
                ......
                ......

Any idea?

Thanks.


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


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