RE: OSUser - issues encountered when de pl oying the example

Ok,

      How did you create your db schema when you deployed it `out of the
box'?

      I haven't located any documentation describing how to do it and the
mckoi.sql is inadequate as an example.

      I'm not asking for spoon feeding here, but some kind of basic
indication as to how to build the back end. 

 

Nick

 

 

-----Original Message-----
From: Hani Suleiman [mailto:[email protected]] 
Sent: Friday, 2 January 2004 12:33 PM
To: [email protected]
Subject: Re: [Opensymphony-developers] OSUser - issues encountered when depl
oying the example

 

 

On Jan 1, 2004, at 7:24 PM, Nick Faiz wrote:

 

> Hi,

>     I've hit a couple of issues when deploying the osuser example in

> weblogic 7.2.

>

Hmm, the example ear application deploys out of the box on wl 8.1 as of 

a few days ago. Make sure you're trying the latest cvs stuff.

 

>     1. The lack of documentation is already known. I lost time because I

> (or the DBA working here) had to work out the following things:

>

>           a. the DDL in mckoi.sql should declare its primary keys in

> OS_USER and OS_GROUP (see the attached file). If it doesn't, MSSQL 

> 2000 will

> complain that said p.k.s do not exist when it begins creating 

> OS_MEMBERSHIP.

> I also quickly tested it on Oracle 8.1.7, which complained of the same 

> fact.

> Also, the IF EXISTS commands won't work on MS SQL and pulls up in 

> error on

> Oracle 8.1.7.

>

Well, this is hardly surprising, mckoi.sql is for...mckoi. Using some 

other db would require porting the script to use the syntax for the 

target db. Feel free to file issues in jira with the correct script for 

various dbs attached and I'll check them in.

 

 

 

-------------------------------------------------------

This SF.net email is sponsored by: IBM Linux Tutorials.

Become an expert in LINUX or just sharpen your skills.  Sign up for IBM's

Free Linux Tutorials.  Learn everything from the bash shell to sys admin.

Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click

_______________________________________________

Opensymphony-developers mailing list

[email protected]

https://lists.sourceforge.net/lists/listinfo/opensymphony-developers