portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Sean Taylor <da...@bluesunrise.com>
Subject [j2] database platform support
Date Wed, 05 May 2004 21:07:43 GMT
I have now built, tested, deployed and run J2 with the following 
database platforms:

Hypersonic SQL
Oracle 8.1.6
Oracle 9.2.0.1 (Ate)
MySQL 3.0.8 driver, MySQL 4.0.18

The documentation for switching and configuring databases is here:

http://portals.apache.org/jetspeed-2/database.html

Im having a problem with MySQL in that I cannot get this syntax to 
execute (when populating the entities):

INSERT INTO TABLE (ID, SOME_FK, DESCRIPTION) VALUES (1, SELECT ID FROM 
OTHERTABLE WHERE NAME = 'SOMETHING'), 'test');

But MySQL doesn't support a SELECT in the VALUES
Any MySQL experts know how to do this in a script?
(Its fully supported by Oracle and Hypersonic)



---------------------------------------------------------------------
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