>it is in CVS now.
Thanks, glad it was of use, the only thing I would suggest is putting the
executeOdbcTurbineSchema.java, Turbine-AccessY2K.mdb and the
turbine-table-relationships.gif into a directory off of schemas named "ODBC"
or something like that. It looks a bit ugly thrown in with the SQL files.
I dont think I have the relationships for the schema correct though. I
imported the .sql files for Oracle, Postgres and MySQL into Visible Analyst
(http://users.rcn.com/kymcam/Turbine-Oracle-relationships.gif). The only
relationships that showed up were;
PERMISSION >o------|- ROLEPERMISSION -|------o< USERROLE
VISITOR and VISITORROLE arent connected to permissions or roles by any
relationships. Is the idea of the schema to give each role many permissions
and for a visitor to only have one role or many roles? I dont think I am
clear on how the permissions and roles link up to the visitor table.
>take a look at what i did to your .java code. that is the
>format that the files need to be in.
ok got it. I have put the DBOdbc.java for the turbine connection pool up at;
http://users.rcn.com/kymcam/
and the diff for the TurbineResources.properties;
RCS file: /products/cvs/turbine/turbine/conf/TurbineResources.properties,v
retrieving revision 1.53
diff -r1.53 TurbineResources.properties
54a55,57
> #### Odbc
> #database.default.driver=sun.jdbc.odbc.JdbcOdbcDriver
> #database.default.url=jdbc:odbc:turbine
85a89,90
> database.adaptor=DBOdbc
> database.adaptor=sun.jdbc.odbc.JdbcOdbcDriver
>thanks,
No worries. Thanks for putting it in.
Cameron Riley
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
