Re: OSUser - issues encountered when deploying 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