portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Todd Kuebler <tkueb...@cisco.com>
Subject Re: Problems importing into oracle
Date Mon, 17 Jun 2002 05:57:48 GMT

I've seen this oracle error before, try changing BLOB to LONG RAW.  It 
happens sometimes when there is a incompatibility between the oracle 
version and the driver version usually changing one of those versions fixes 
it for BLOB.

-tk

At 11:57 PM 6/16/2002 -0400, you wrote:
>I used the torque generated schema script to create the tables, and ran with
>the importer turned on.  It tried...
>
>[22:53:15,944 ERROR] Error saving
>profile:BaseProfile[anon/html/default.psml]
>[22:53:15,959 ERROR] Error occurred in Database PSML Manager:
>java.sql.SQLException: ORA-01465: invalid hex number
>         at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>         at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
>         at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
>         at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
>         at
>oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
>         at
>oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047
>)
>         at
>oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
>         at
>oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
>:2709)
>         at
>oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
>ment.java:589)
>         at com.workingdogs.village.Record.saveWithInsert(Unknown Source)
>         at com.workingdogs.village.Record.save(Unknown Source)
>         at com.workingdogs.village.Record.save(Unknown Source)
>         at
>org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:1050)
>         at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:897)
>         at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:774)
>         at
>org.apache.jetspeed.om.dbpsml.BaseJetspeedAnonProfilePeer.doInsert(BaseJetsp
>eedAnonProfilePeer.java:178)
>         at
>org.apache.jetspeed.om.dbpsml.BaseJetspeedAnonProfilePeer.doInsert(BaseJetsp
>eedAnonProfilePeer.java:156)
>         at
>org.apache.jetspeed.om.dbpsml.BaseJetspeedAnonProfilePeer.doInsert(BaseJetsp
>eedAnonProfilePeer.java:444)
>         at
>org.apache.jetspeed.om.dbpsml.JetspeedAnonProfilePeer.doInsertOrUpdate(Jetsp
>eedAnonProfilePeer.java:78)
>         at
>org.apache.jetspeed.om.dbpsml.JetspeedAnonProfilePeer.insert(JetspeedAnonPro
>filePeer.java:50)
>         at
>org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat
>eOrSaveDocument(DatabasePsmlManagerService.java:618)
>         at
>org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat
>eDocument(DatabasePsmlManagerService.java:542)
>         at
>org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService.export(Cas
>torPsmlManagerService.java:1243)
>         at
>org.apache.jetspeed.services.psmlmanager.PsmlImporter.run(PsmlImporter.java:
>123)
>         at
>org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.init(
>DatabasePsmlManagerService.java:225)
>
>And failed.  Any ideas?
>
>This is oracle 9 and the java 1.4 version of the oracle jdbc driver.  It's
>the latest tip cvs checkout and a deploy of this, modified only to point at
>the oracle db for turbine and psml.
>
>- Glenn
>
>--------------------------------------------
>Glenn R. Golden, Systems Research Programmer
>University of Michigan School of Information
>ggolden@umich.edu               734-615-1419
>--------------------------------------------
>
>
>--
>To unsubscribe, e-mail:   <mailto:jetspeed-dev-unsubscribe@jakarta.apache.org>
>For additional commands, e-mail: <mailto:jetspeed-dev-help@jakarta.apache.org>


--
To unsubscribe, e-mail:   <mailto:jetspeed-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:jetspeed-dev-help@jakarta.apache.org>


Mime
View raw message