portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Sean Taylor" <da...@bluesunrise.com>
Subject RE: Problems importing into oracle
Date Mon, 17 Jun 2002 04:09:19 GMT
I think Village has problems with BLOBs on Oracle, see the
Turbine/Torque mailing lists. Try replacing the BLOB with 

> >          PROFILE LONG RAW,


> -----Original Message-----
> From: Glenn Golden [mailto:ggolden@umich.edu] 
> Sent: Sunday, June 16, 2002 9:09 PM
> To: 'Jetspeed Developers List'
> Subject: RE: Problems importing into oracle
> 
> 
> No, here's the schema that torque generated: (PROFILE BLOB)
> 
> - Glenn
> 
> --------------------------------------------------------------
> --------------
> -
> -- JETSPEED_USER_PROFILE
> --------------------------------------------------------------
> --------------
> -
> DROP TABLE JETSPEED_USER_PROFILE CASCADE CONSTRAINTS;
> 
> CREATE TABLE JETSPEED_USER_PROFILE
> (
>     PSML_ID NUMBER NOT NULL,
>     USER_NAME VARCHAR2 (32) NOT NULL,
>     MEDIA_TYPE VARCHAR2 (99),
>     LANGUAGE VARCHAR2 (2),
>     COUNTRY VARCHAR2 (2),
>     PAGE VARCHAR2 (99),
>     PROFILE BLOB,
>     CONSTRAINT JETSPEED_USER_PROFILE_UNIQUE UNIQUE 
> (USER_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE) );
> 
> ALTER TABLE JETSPEED_USER_PROFILE
>     ADD CONSTRAINT JETSPEED_USER_PROFILE_PK
> PRIMARY KEY (PSML_ID);
> 
> 
> 
> --------------------------------------------------------------
> --------------
> -
> -- JETSPEED_GROUP_PROFILE
> --------------------------------------------------------------
> --------------
> -
> DROP TABLE JETSPEED_GROUP_PROFILE CASCADE CONSTRAINTS;
> 
> CREATE TABLE JETSPEED_GROUP_PROFILE
> (
>     PSML_ID NUMBER NOT NULL,
>     GROUP_NAME VARCHAR2 (99) NOT NULL,
>     MEDIA_TYPE VARCHAR2 (99),
>     LANGUAGE VARCHAR2 (2),
>     COUNTRY VARCHAR2 (2),
>     PAGE VARCHAR2 (99),
>     PROFILE BLOB,
>     CONSTRAINT JETSPEED_GROUP_PROFILE_UNIQUE UNIQUE 
> (GROUP_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE) );
> 
> ALTER TABLE JETSPEED_GROUP_PROFILE
>     ADD CONSTRAINT JETSPEED_GROUP_PROFILE_PK
> PRIMARY KEY (PSML_ID);
> 
> 
> 
> --------------------------------------------------------------
> --------------
> -
> -- JETSPEED_ROLE_PROFILE
> --------------------------------------------------------------
> --------------
> -
> DROP TABLE JETSPEED_ROLE_PROFILE CASCADE CONSTRAINTS;
> 
> CREATE TABLE JETSPEED_ROLE_PROFILE
> (
>     PSML_ID NUMBER NOT NULL,
>     ROLE_NAME VARCHAR2 (99) NOT NULL,
>     MEDIA_TYPE VARCHAR2 (99),
>     LANGUAGE VARCHAR2 (2),
>     COUNTRY VARCHAR2 (2),
>     PAGE VARCHAR2 (99),
>     PROFILE BLOB,
>     CONSTRAINT JETSPEED_ROLE_PROFILE_UNIQUE UNIQUE 
> (ROLE_NAME, MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE) );
> 
> ALTER TABLE JETSPEED_ROLE_PROFILE
>     ADD CONSTRAINT JETSPEED_ROLE_PROFILE_PK
> PRIMARY KEY (PSML_ID);
> 
> 
> 
> --------------------------------------------------------------
> --------------
> -
> -- JETSPEED_ANON_PROFILE
> --------------------------------------------------------------
> --------------
> -
> DROP TABLE JETSPEED_ANON_PROFILE CASCADE CONSTRAINTS;
> 
> CREATE TABLE JETSPEED_ANON_PROFILE
> (
>     PSML_ID NUMBER NOT NULL,
>     MEDIA_TYPE VARCHAR2 (99),
>     LANGUAGE VARCHAR2 (2),
>     COUNTRY VARCHAR2 (2),
>     PAGE VARCHAR2 (99),
>     PROFILE BLOB,
>     CONSTRAINT JETSPEED_ANON_PROFILE_UNIQUE UNIQUE 
> (MEDIA_TYPE, LANGUAGE, COUNTRY, PAGE) );
> 
> ALTER TABLE JETSPEED_ANON_PROFILE
>     ADD CONSTRAINT JETSPEED_ANON_PROFILE_PK
> PRIMARY KEY (PSML_ID);
> 
> 
> 
> > -----Original Message-----
> > From: David Sean Taylor [mailto:david@bluesunrise.com]
> > Sent: Sunday, June 16, 2002 11:56 PM
> > To: 'Jetspeed Developers List'
> > Subject: RE: Problems importing into oracle
> > 
> > 
> > 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: <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>
> > 
> 
> --
> 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