You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by Mark Orciuch <ma...@ngsltd.com> on 2002/10/25 23:07:30 UTC
Hypersonic 1.7.1 upgrade problem
I have built Jetspeed using CVS head. I reconfigured it to use
DatabasePsmlManager and imported the profiles. The import completed but I
got a lot of these errors:
<stack-trace>
[25 Oct 2002 15:24:43 WARN] -
DatabasePsmlManagerService.createOrSaveDocument: profile:
BaseProfile[user/admin/html/default.psml] tableName: JETSPEED_USER_PROFILE
java.sql.SQLException: Table not found: NULL in statement [select IDENTITY()
from null]
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.jdbcResultSet.<init>(Unknown Source)
at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
at org.hsqldb.jdbcConnection.execute(Unknown Source)
at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbcStatement.executeQuery(Unknown Source)
at com.workingdogs.village.QueryDataSet.<init>(Unknown Source)
at
org.apache.torque.oid.AutoIncrementIdGenerator.getIdAsVillageValue(AutoIncre
mentIdGenerator.java, Compiled Code)
at
org.apache.torque.oid.AutoIncrementIdGenerator.getIdAsBigDecimal(AutoIncreme
ntIdGenerator.java:127)
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java, Compiled Code)
at
org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer.doInsert(BaseJetsp
eedUserProfilePeer.java:206)
at
org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer.doInsert(BaseJetsp
eedUserProfilePeer.java:499)
at
org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.doInsertOrUpdate(Jetsp
eedUserProfilePeer.java:105)
at
org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.insert(JetspeedUserPro
filePeer.java:65)
at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat
eOrSaveDocument(DatabasePsmlManagerService.java:647)
at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat
eDocument(DatabasePsmlManagerService.java:607)
at
org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService.export(Cas
torPsmlManagerService.java, Compiled Code)
at
org.apache.jetspeed.services.psmlmanager.PsmlImporter.run(PsmlImporter.java:
210)
at
org.apache.jetspeed.services.psmlmanager.PsmlImporter.main(PsmlImporter.java
:179)
org.apache.torque.TorqueException: Table not found: NULL in statement
[select IDENTITY() from null]
at org.apache.torque.util.BasePeer.doInsert(BasePeer.java, Compiled Code)
at
org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer.doInsert(BaseJetsp
eedUserProfilePeer.java:206)
at
org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer.doInsert(BaseJetsp
eedUserProfilePeer.java:499)
at
org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.doInsertOrUpdate(Jetsp
eedUserProfilePeer.java:105)
at
org.apache.jetspeed.om.dbpsml.JetspeedUserProfilePeer.insert(JetspeedUserPro
filePeer.java:65)
at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat
eOrSaveDocument(DatabasePsmlManagerService.java:647)
at
org.apache.jetspeed.services.psmlmanager.db.DatabasePsmlManagerService.creat
eDocument(DatabasePsmlManagerService.java:607)
at
org.apache.jetspeed.services.psmlmanager.CastorPsmlManagerService.export(Cas
torPsmlManagerService.java, Compiled Code)
at
org.apache.jetspeed.services.psmlmanager.PsmlImporter.run(PsmlImporter.java:
210)
at
org.apache.jetspeed.services.psmlmanager.PsmlImporter.main(PsmlImporter.java
:179)
</stack-trace>
I deployed the .war file and all seems to work OK until I try to add any
users, roles, etc, via the admin interface. I get similar error: "Table not
found: NULL in statement [select IDENTITY() from null]". According to
Hypersonic docs, the statement to query the last generated id is "CALL
IDENTITY()" not "SELECT IDENTITY() from null" (well "SELECT IDENTITY from
[tablename]" works). I was expecting this to come from DBHypersonicSQL
adapter but what I see in that class does not make sense to me. The identity
stuff seems to work fine in HSQL Database Manager.
I know this stuff is fairly new, but is anyone successfully using
DatabasePsmlManager with Hypersonic using CVS head? There was somewhat
related post from Glen ("RE: Db psml service - psml id?") but it had to do
with Oracle and I don't know if he was able to resolve his problem.
Best regards,
Mark C. Orciuch
Next Generation Solutions, Ltd.
e-Mail: mark_orciuch@ngsltd.com
web: http://www.ngsltd.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Hypersonic 1.7.1 upgrade problem
Posted by David Sean Taylor <da...@bluesunrise.com>.
> -----Original Message-----
> From: Mark Orciuch [mailto:mark_orciuch@ngsltd.com]
> Sent: Friday, October 25, 2002 3:41 PM
> To: Jetspeed Developers List
> Subject: RE: Hypersonic 1.7.1 upgrade problem
>
>
> David,
>
> > >
> > >
> > > I have built Jetspeed using CVS head. I reconfigured it to use
> > > DatabasePsmlManager and imported the profiles. The import
> > completed but I
> > > got a lot of these errors:
> > >
> >
> > Never considered actually usually DB PSML + Hypersonic.
> > Didnt seem to make much sense to me, being configured as an in
> memory db.
> > Although it appears that its configured correctly.
> >
> > <table name="JETSPEED_USER_PROFILE" idMethod="native" >
> >
> > Could you get a clean checkout and retry it?
> > Make sure to do an ant clean.
> > I had similar problems if I didn't delete the OM binding files.
> > The latest build.xml removes the temp OM files (Base*)
>
> I did as you suggested and ran into problems compiling Jetspeed from
> scratch. I traced my compile problem to xml-apis-2.0.2.jar. After
> I replaced
> it with the old xml-apis.jar, I could compile again. Looks like
> I'm missing
> a .jar with stuff that was removed from xml-apis... Or it's another JDK
> issue - I tried both 1.2 and 1.3. No time to look into it further now.
I haven't seen your error msgs, but Im guessing maybe its jaxp.
Can you try adding the jaxp-api.jar from the jax pack, and see if that fixes
it?
>
> However, after rebuilding Jetspeed, the Hypersonic problem went
> away. Should
> I assume that torque-3.0-b5-dev.jar was built with sources from
> 10-24-2002?
yes, i checked in a few changes to torque's hypersonic adaptor in order to
get native id generation working
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Hypersonic 1.7.1 upgrade problem
Posted by Mark Orciuch <ma...@ngsltd.com>.
David,
> >
> >
> > I have built Jetspeed using CVS head. I reconfigured it to use
> > DatabasePsmlManager and imported the profiles. The import
> completed but I
> > got a lot of these errors:
> >
>
> Never considered actually usually DB PSML + Hypersonic.
> Didnt seem to make much sense to me, being configured as an in memory db.
> Although it appears that its configured correctly.
>
> <table name="JETSPEED_USER_PROFILE" idMethod="native" >
>
> Could you get a clean checkout and retry it?
> Make sure to do an ant clean.
> I had similar problems if I didn't delete the OM binding files.
> The latest build.xml removes the temp OM files (Base*)
I did as you suggested and ran into problems compiling Jetspeed from
scratch. I traced my compile problem to xml-apis-2.0.2.jar. After I replaced
it with the old xml-apis.jar, I could compile again. Looks like I'm missing
a .jar with stuff that was removed from xml-apis... Or it's another JDK
issue - I tried both 1.2 and 1.3. No time to look into it further now.
However, after rebuilding Jetspeed, the Hypersonic problem went away. Should
I assume that torque-3.0-b5-dev.jar was built with sources from 10-24-2002?
Thanks again!
Best regards,
Mark C. Orciuch
Next Generation Solutions, Ltd.
e-Mail: mark_orciuch@ngsltd.com
web: http://www.ngsltd.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: Hypersonic 1.7.1 upgrade problem
Posted by David Sean Taylor <da...@bluesunrise.com>.
> -----Original Message-----
> From: Mark Orciuch [mailto:mark_orciuch@ngsltd.com]
> Sent: Friday, October 25, 2002 2:08 PM
> To: Jetspeed Developers List
> Subject: Hypersonic 1.7.1 upgrade problem
>
>
> I have built Jetspeed using CVS head. I reconfigured it to use
> DatabasePsmlManager and imported the profiles. The import completed but I
> got a lot of these errors:
>
Never considered actually usually DB PSML + Hypersonic.
Didnt seem to make much sense to me, being configured as an in memory db.
Although it appears that its configured correctly.
<table name="JETSPEED_USER_PROFILE" idMethod="native" >
Could you get a clean checkout and retry it?
Make sure to do an ant clean.
I had similar problems if I didn't delete the OM binding files.
The latest build.xml removes the temp OM files (Base*)
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>