OSUser - issues encountered when deploying the example

Hi,
	I've hit a couple of issues when deploying the osuser example in
weblogic 7.2.

	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.

		b. the varbinary type doesn't exist in Oracle, to my
knowledge.

		c. I had to work out for myself that the application needed
a datasource called defaultDS using an account which required create and
drop privileges. I haven't used PropertySet before ...

		d. the IF EXISTS command didn't work on either of the db.s I
was using.

	2. After making the DDL work for MSSQL 2000 and finally deploying
the example ear I hit an error in the PropertySet ejb jar file ... It's
mapping to fields which don't exist in the OS_PROPERTYENTRY table:

	from WL 7.2 stdout:
	The database table: OS_PROPERTYENTRY does not contain the columns:
entityid, keyvalue, entityname, type, id. 

	From the ejb-jar.xml in the propertyset.jar:

         <abstract-schema-name>PropertyEntry</abstract-schema-name>
         <cmp-field >
            <description><![CDATA[]]></description>
            <field-name>entityId</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[]]></description>
            <field-name>entityName</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[]]></description>
            <field-name>id</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[]]></description>
            <field-name>key</field-name>
         </cmp-field>
         <cmp-field >
            <description><![CDATA[]]></description>
            <field-name>type</field-name>
         </cmp-field>
         <primkey-field>id</primkey-field>
	

	I'll stop and work on something else for my app., at this point. I
don't want to use guess work to map the 6 PropertyEntry fields to a
combination of the 8 OS_PROPERTYENTRY fields. If someone has some
suggestions for what I've done wrong or how to fix the propertyset issue,
please let me know.

Regards,
Nick Faiz
B2B Developer
Corporate Express Australia Ltd.

Phone: +61-2-9335-0495, Fax: 9335-0753, Email: [email protected]