Hi David, --- David Sean Taylor <[EMAIL PROTECTED]> wrote:
> Dan Moore wrote: > > > In order to get the PSML working in Oracle, from the 1.5 binary > > distribution of Jetspeed, in addition to following the instructions > > here regarding importing, > > http://portals.apache.org/jetspeed-1/psml_db.html, I also had to > make > > some changes to class files and sql files. > > > > You need both the src and binary distributions. There's a diff of > the > > relevant files below. > > > > Modify the java files: > > Add _SEQ onto the value in setPrimaryKeyMethodInfo in each of the > > org/apache/jetspeed/om/dbpsml/map/Jetspeed* files. > > > The files that are you recommended for patching are not in the CVS. > They > are Torque generated files. > > To use Oracle, or any other database besides Hypersonic with > Jetspeed-1, > follow the steps here: > > http://portals.apache.org/jetspeed-1/database.html I'm certainly no Torque expert. Thanks for the link. I followed the instructions on that page. I changed Torque.properties: torque.database.default.adapter=oracle I didn't change the other config in Torque.properties yet--my database is down at the moment. Does Torque need to connect to the db to generate the sql? (I hope not.) Anyway, maven dist did generate new sql files here: jetspeed-1.5/target/jetspeed-1.5/src/jetspeed-1.5/src/sql/external I couldn't find any others. Unfortunately, these sql files do not use the correct primary key. Perhaps the torque-schema is incorrect? I don't know. When I look at jetspeed-1.5/src/torque-schema/dbpsml-schema.xml, it certainly looks like the columns are named correctly. > I believe that the Jetspeed team has made things unnecessarily > complicated for end users to change their databsae. Asking people to > dl > the source and recompile just to change the database is not user > friendly and a pain in the ass. Look at all the hell we've caused > Dan. > > Proposed solution: > > Move the Torque generation into a separate sub-project of J1. Create > a > jar for the OM-mapping for each database. Put each of these jars on > the > distribution site with the release: > > jetspeed-om-1.6-oracle.jar > jetspeed-om-1.6-mysl.jar > ... This sounds like a fantastic idea! Thanks, Dan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]