Return-Path: Delivered-To: apmail-jakarta-jetspeed-dev-archive@apache.org Received: (qmail 7060 invoked from network); 17 Jun 2002 03:56:09 -0000 Received: from unknown (HELO nagoya.betaversion.org) (192.18.49.131) by daedalus.apache.org with SMTP; 17 Jun 2002 03:56:09 -0000 Received: (qmail 18008 invoked by uid 97); 17 Jun 2002 03:56:22 -0000 Delivered-To: qmlist-jakarta-archive-jetspeed-dev@jakarta.apache.org Received: (qmail 17987 invoked by uid 97); 17 Jun 2002 03:56:21 -0000 Mailing-List: contact jetspeed-dev-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Jetspeed Developers List" Reply-To: "Jetspeed Developers List" Delivered-To: mailing list jetspeed-dev@jakarta.apache.org Received: (qmail 17962 invoked by uid 98); 17 Jun 2002 03:56:21 -0000 X-Antivirus: nagoya (v4198 created Apr 24 2002) From: "David Sean Taylor" To: "'Jetspeed Developers List'" Subject: RE: Problems importing into oracle Date: Sun, 16 Jun 2002 20:56:00 -0700 Message-ID: <01a901c215b2$e5138960$4c58f742@MOZART> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal In-Reply-To: X-MDRemoteIP: 66.247.88.76 X-Return-Path: david@bluesunrise.com X-MDaemon-Deliver-To: jetspeed-dev@jakarta.apache.org X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N 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: > unsubscribe@jakarta.apache.org> > For > additional commands, > e-mail: > > -- To unsubscribe, e-mail: For additional commands, e-mail: