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