RE: OSUser - issues encountered when de p l oying the example

Yup, thanks for the reply.

The OS_USER, OS_GROUP, and OS_MEMBERSHIP tables are created at runtime but
the OS_PROPERTY* tables are not. 

Nick

-----Original Message-----
From: Hani Suleiman [mailto:[email protected]] 
Sent: Friday, 2 January 2004 3:42 PM
To: [email protected]
Subject: Re: [Opensymphony-developers] OSUser - issues encountered when de p
l oying the example

the default ear app uses ejbs, and the tables are autocreated when the 
ear is deployed. You can change the datasource used by modifying 
build.xml and specifying whatever datasource name you want.

On Jan 1, 2004, at 9:34 PM, Nick Faiz wrote:

> 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



-------------------------------------------------------
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_id78&alloc_id371&op=click
_______________________________________________
Opensymphony-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/opensymphony-developers


-------------------------------------------------------
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_id78&alloc_id371&op=click