>My only suggestion here is to throw SQLException ("Not implemented") in the
>places where things are not implemented or not needed.
It is up at;
http://users.rcn.com/kymcam/
DbOdbc.java
http://users.rcn.com/kymcam/DBOdbc.java
I updated the ready-to-go .mdb, it is updated to the JOB_ID. Could you
replace that in the distribution please;
http://users.rcn.com/kymcam/Turbine-AccessY2K.mdb
I also updated the .sql scripts pretty much in their entirety to get the
constraints to work properly in Access, could you replace them too please;
http://users.rcn.com/kymcam/Odbc_id_table.sql
http://users.rcn.com/kymcam/Odbc_users_roles_permissions.sql
Could you replace the Turbine-AccessY2K-relationships.gif too, the other
is ugly.
http://users.rcn.com/kymcam/Turbine-AccessY2K-relationships.gif
I documented the Odbc stuff as you requested;
http://users.rcn.com/kymcam/UsingOdbcWithTurbine.html
I also added some documentation for the Core Turbine Schema;
http://users.rcn.com/kymcam/TurbineCoreSchema.html
Sorry for all the differant links.
>Lastly, why are you using ODBC? :-) Are there no native JDBC drivers for
>your database? ODBC is a kludge these days. I haven't seen someone using it
>with Java in quite a long time. JDBC + ODBC is like a compatibility layer
on
>top of a compatibility layer.
It is horses for courses, there hasnt been any reason not to use it in
certain projects. I make pretty specific web based applications for
engineering projects essentially. The largest ODBC based one I have done has
a controlled users list of around 160 of which about 30 are consistant
users. There is little in the way of traffic and data transport. None are
taxing the JDBC:ODBC bridge, the Access db or the servers they run on, so no
reason to change.
The current project I am doing is part and parcel of a larger engineering
project, it is currently serving as an internal design and documentation
application. When the facilities are built it will get handed over to the
client, they have the oppurtunity to buy extra functionality for the
website, which depending on the load, may require it being ported to another
db. They are not 1 million hits an hour type applications :)
What is the convention and the correct time for adding [PATCH] to a mail
subject heading? Is there a similar one for Documentation? I was going to
add it but not sure if I would be putting it in the correct place. So please
advise.
Cameron Riley
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
