On Sun, 6 Aug 2000, Greg Morris wrote:
> I also moved the various database initialization scripts around. I put
> the master database schema spec. in src/sql/jyve-schema.xml. Eventually I
> would like for that to be the only form of the schema distributed with
> Jyve, and set it up so building a database-appropriate script is as simple
> as running "build-jyve.(sh|bat) schema <dbtype>". In the mean time, I
> generated schemas for all the databases Torque claims to support, and put
> them in "bin/sql/<db>_schema.xml". (Note to Jason: there is something
> wrong with the DB2 templates in Torque, so I was not able to generate a
> script for DB2.)
There are templates for several databases, but I've only tested
MySQL, PostgreSQL, Hypersonic. I have used Oracle before and
the output looked OK to me, but I haven't installed Oracle
to try it. I was hoping someone else would.
There is also a little problem with PostgreSQL that
has to do with binary objects being automatically
dropped. I think I just have to add something in
the templates to support it. If anyone tries to
install Jyve2 and has problems with the SQL scripts
generated just send them my way with the error
messages and I'll will try to fix them quickly.
jvz.
--
Jason van Zyl
[EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
