Know one :) also fixed in the cvs Change all your sql generated by torque to use "LONG RAW" instead of "BLOB", it will work.
> -----Message d'origine----- > De : Karen Davies [mailto:kdavies@;ecceleration.ie] > Envoy� : vendredi 8 novembre 2002 12:03 > � : 'Jetspeed Users List' > Objet : RE: build/deploy/war file and PSML database > > > Hi Pierre, > I found that the psml-db-oracle.sql provided to create the > psml tables in > oracle didn't create the correct tables when running with > jetspeed 1.4.1b. > Using the ant build file given in the torque directory i > managed to create > the new sql files, and run them. > > As Aurelien said (thanks by the way), you don't need to run > ant 'import', if > you just comment out those lines in the JetspeedResources.properties > configuration file, then when you run tomcat it runs the psml > importer for > you. > > However i am still having problems importing, as i now get the error: > > [10:49:15,921 DEBUG] BasePeer.doUpdate: > whereClause=TABLE_NAME='JETSPEED_USER_PROFILE' > [10:49:15,984 DEBUG] updateRow: UPDATE ID_TABLE SET NEXT_ID = > 130 WHERE > TABLE_NAME = 'JETSPEED_USER_PROFILE' > [10:49:16,218 ERROR] Error saving > profile:BaseProfile[user/admin/html/default.psml] > [10:49:16,218 ERROR] Error occurred in Database PSML Manager: > java.sql.SQLException: ORA-01465: invalid hex number > at > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) > at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542) > at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311) > at > oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:738) > at > oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleState > ment.java:1313 > ) > at > oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatem > ent.java:1232) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithBatch(OracleSt > atement.java:1 > 353) > at > oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.j > ava:1760) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle > Statement.java > :1805) > at ... > > > any suggestions? -- To unsubscribe, e-mail: <mailto:jetspeed-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:jetspeed-user-help@;jakarta.apache.org>
