You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by "N.C." <ho...@rocketmail.com> on 2004/06/24 12:53:38 UTC

Jetspeed 1.5 --database error (please help)

To whom it may concern,

First of all, I am greatful for the documents. They are so
helpful to me. The steps are clear and easy to follow.  

I have explored the jetspeed for several weeks and wanted to
change database from the Hypersonic to Oracle; however, I could
not. I followed all of the steps suggested from the documents,
and yet it does not seem to work.  

These are what I did ...
-  In Torque.properties, I comment...
#torque.database.default.adapter=hypersonic
#torque.dsfactory.default.connection.driver =
org.hsqldb.jdbcDriver
#torque.dsfactory.default.connection.url =     
jdbc:hsqldb:${webappRoot}/WEB-INF/db/jetspeed
#torque.dsfactory.default.connection.user = sa 
#torque.dsfactory.default.connection.password = 

   ... and uncomment...
torque.database.default.adapter=oracle
torque.dsfactory.default.connection.driver =
oracle.jdbc.driver.OracleDriver
torque.dsfactory.default.connection.url =
jdbc:oracle:thin:@happy:1521:admindb
torque.dsfactory.default.connection.user = scott
torque.dsfactory.default.connection.password = tiger

- Next, I executed "populate-oracle.sql" and
"turbine-oracle.sql" in my oracle database,  Also I could
convert PSML files to PSML database successfully.

I would be appreciated if you could give me some suggestion of
what I did wrong or did not do.   

Thank you very much for your time.

Sincerely,
Nattaporn Choksathian
ps. the below are error messages I got...


2004-06-24 17:03:29,406 [Thread-1] INFO 
JetspeedPortletCacheService - JetspeedPortletCacheService early
init()....starting!
2004-06-24 17:03:29,406 [Thread-1] INFO 
JetspeedPortletCacheService - JetspeedPortletCacheService - By
default refreshable objects will be removed after 2700000 Millis
( 45 minutes 0.0 Seconds )
2004-06-24 17:03:29,406 [Thread-1] INFO 
JetspeedPortletCacheService - JetspeedPortletCacheService early
init()....finished!
2004-06-24 17:03:29,469 [Thread-1] DEBUG
JetspeedTemplateLocatorService - TemplateLocator: Adding
templateRoot:/WEB-INF/templates/
2004-06-24 17:03:38,266 [Servlet.Engine.Transports : 0] DEBUG
JetspeedRunDataService - JetspeedRunDataService: storing rundata
org.apache.jetspeed.services.rundata.DefaultJetspeedRunData@3d19fb28
for thread: Thread[Servlet.Engine.Transports : 0,5,main]
2004-06-24 17:03:42,062 [Servlet.Engine.Transports : 1] DEBUG
JetspeedRunDataService - JetspeedRunDataService: storing rundata
org.apache.jetspeed.services.rundata.DefaultJetspeedRunData@5594fb29
for thread: Thread[Servlet.Engine.Transports : 1,5,main]
2004-06-24 17:03:43,578 [Servlet.Engine.Transports : 0] ERROR
TurbineUserManagement - Failed to retrieve user 'anon'
java.sql.SQLException: ORA-00600: internal error code,
arguments: [ttcgcshnd-1], [0], [], [], [], [], [], []
	at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
	at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
	at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
	at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
	at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1681)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)









		
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org