portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chris Anderson" <c...@mindspring.com>
Subject Re: Database scripts out of date
Date Sun, 24 Jun 2001 19:44:31 GMT
Doesn't the TDK use Torque as well?  It seems to me to be the best choice
instead of having to fine tune each .sql script.

ymmv

Chris Anderson

----- Original Message -----
From: "David Sean Taylor" <david@bluesunrise.com>
To: <jetspeed-dev@jakarta.apache.org>
Sent: Sunday, June 24, 2001 3:39 PM
Subject: RE: Database scripts out of date


> > latest scripts from jakarta-turbine/src/sql.  The current
> > scripts are not up to date for the version of Turbine that
> > is included in the CVS HEAD.
>
> Yes, i know.
> We have been discussing this on some recent threads in the last week.
>
> I proposed distributing Torque with Jetspeed to keep the scripts in sync
in
> the future, but I received  no response on my proposal.
> I prefer distributing Torque, and removing the scripts. Anyone else have
any
> thoughts on this subject?
>
>
> -------------------------------------
> David Sean Taylor
> taylor@apache.org
> -------------------------------------
> http://jakarta.apache.org/jetspeed
> -------------------------------------
>
>
>
>
> > -----Original Message-----
> > From: Steve Davis [mailto:steve.davis@digitalevergreen.com]
> > Sent: Sunday, June 24, 2001 12:11 PM
> > To: jetspeed-user@jakarta.apache.org; jetspeed-dev@jakarta.apache.org
> > Subject: Database scripts out of date
> >
> >
> > Could someone with CVS commit permission update the
> > jakarta-jetspeed/src/sql/external directory to include the
> > latest scripts from jakarta-turbine/src/sql.  The current
> > scripts are not up to date for the version of Turbine that
> > is included in the CVS HEAD.
> >
> > I am using mysql and there are 3 new scripts for Turbine
> >
> > mysql-id-table-schema.sql
> > mysql-turbine-id-table-init.sql
> > mysql-turbine-security.sql
> >
> > in addition to
> >
> > mysql-turbine.sql
> >
> > Turbine evidently needs an additional table "ID_TABLE" now to
> > create or delete a user. I was playing around with the new user/roles
> > admin and kept getting the following exception whenever I tried to
> > create or delete a user.
> >
> >          Exception:  java.lang.reflect.InvocationTargetException
> >         Stack Trace follows:
> >         java.lang.reflect.InvocationTargetException:
> > java.sql.SQLException: General error: Table
> > 'JETSPEED.ID_TABLE' doesn't
> > exist
> >         at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
> >         at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
> >         at org.gjt.mm.mysql.MysqlIO.sqlQuery(MysqlIO.java:635)
> >         at org.gjt.mm.mysql.Connection.execSQL(Connection.java:882)
> >         at org.gjt.mm.mysql.Connection.execSQL(Connection.java:815)
> >         at org.gjt.mm.mysql.Statement.executeQuery(Statement.java:169)
> >         at
> > org.gjt.mm.mysql.jdbc2.Statement.executeQuery(Statement.java:78)
> >         at com.workingdogs.village.Schema.schema(Schema.java:140)
> >         at com.workingdogs.village.Schema.schema(Schema.java:107)
> >         at com.workingdogs.village.DataSet.<init>(DataSet.java:167)
> >         at
> > com.workingdogs.village.TableDataSet.<init>(TableDataSet.java:130)
> >         at
> > org.apache.turbine.om.peer.BasePeer.doUpdate(BasePeer.java:1666)
> >         at
> > org.apache.turbine.util.db.IDBroker.storeIDs(IDBroker.java:554)
> >         at
> > org.apache.turbine.util.db.IDBroker.getNextIds(IDBroker.java:371)
> >         at
> > org.apache.turbine.util.db.IDBroker.getIdAsBigDecimal(IDBroker
> > .java:285)
> >         at
> > org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:746)
> >         at
> > org.apache.turbine.om.peer.BasePeer.doInsert(BasePeer.java:657)
> >         at
> > org.apache.turbine.services.security.db.DBUserManager.createAc
> > count(DBUs
> > erManager.java:399)
> >
> > Thanks,
> >
> > -- Steve Davis
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
> >
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org
>


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


Mime
View raw message