RE: Problems importing into oracle

[David Sean Taylor <da...@bluesunrise.com>]

No idea why its doing that. I had PSML-DB working with Oracle before,
let me look into it...
Is it generating the same schema as what is checked into cvs?
Seem to remember a problem with the PROFILE column. Does it look like
this:

         PROFILE LONG RAW,

> -----Original Message-----
> From: Glenn Golden [mailto:ggolden@umich.edu] 
> Sent: Sunday, June 16, 2002 8:57 PM
> To: 'Jetspeed-Dev (jetspeed-dev@jakarta.apache.org)'
> Subject: Problems importing into oracle
> 
> 
> 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.j
> ava:1093)
> 	at 
> oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleState
> ment.java:2047
> )
> 	at
> oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatem
> ent.java:1940)
> 	at 
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle
> Statement.java
> :2709)
> 	at 
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Oracl
> ePreparedState
> 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.doIn
> sert(BaseJetsp
> eedAnonProfilePeer.java:178)
> 	at 
> org.apache.jetspeed.om.dbpsml.BaseJetspeedAnonProfilePeer.doIn
> sert(BaseJetsp
> eedAnonProfilePeer.java:156)
> 	at 
> org.apache.jetspeed.om.dbpsml.BaseJetspeedAnonProfilePeer.doIn
> sert(BaseJetsp
> eedAnonProfilePeer.java:444)
> 	at 
> org.apache.jetspeed.om.dbpsml.JetspeedAnonProfilePeer.doInsert
> OrUpdate(Jetsp
> eedAnonProfilePeer.java:78)
> 	at 
> org.apache.jetspeed.om.dbpsml.JetspeedAnonProfilePeer.insert(J
> etspeedAnonPro
> filePeer.java:50)
> 	at 
> org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManage
> rService.creat
> eOrSaveDocument(DatabasePsmlManagerService.java:618)
> 	at 
> org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManage
> rService.creat
> eDocument(DatabasePsmlManagerService.java:542)
> 	at 
> org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerServ
> ice.export(Cas
> torPsmlManagerService.java:1243)
> 	at
> org.apache.jetspeed.services.psmlmanager.PsmlImporter.run(Psml
> Importer.java:
> 123)
> 	at 
> org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManage
> rService.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: <ma...@jakarta.apache.org>
> 
> 



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>