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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
> [EMAIL PROTECTED]
> -------------------------------------
> http://jakarta.apache.org/jetspeed
> -------------------------------------
>
>
>
>
> > -----Original Message-----
> > From: Steve Davis [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, June 24, 2001 12:11 PM
> > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
