topic Re: database access in Alfresco Archive

database access

soeursourire — Tue, 07 Feb 2006 10:03:01 GMT

Hi everybody!I am writing to you for help about access to users entered in the database. I added an attribute "country" in MyNewUserWizard class (sub-class of NewUserWizard) and added it as aspect and prop and I would like to display this attribute for each user on the page users.jsp. How can I do?I

Re: database access

turgayz — Tue, 07 Feb 2006 10:20:45 GMT

Hi,
I didn't understand what you mean by "final class repository", can you describe it?

I guess if everything is in place, you should be able to access the property with


<h:outputText value="#{r.country}" /> 
‍‍‍

Hope this helps, if not, please show the code.

Re: database access

soeursourire — Tue, 07 Feb 2006 10:50:23 GMT

Effectively by doing that I do not have error message anymore but in users.jsp page this is appearing:

MISSING: department :MISSING

and if I want to modify the properties of a user I do not have the values in the person-properties page anymore (the name last name etc are not appearing)…

Re: database access

soeursourire — Tue, 07 Feb 2006 13:52:12 GMT

It seems that my attribute (property) "country" is not well defined as it does not appear in Node Browser. Please would you mind telling me what I am doing wrong here:

-I added an aspect and property in CustomModel:
<aspects>
      <aspect name="custom:Myperson">
         <title>Country</title>
         <properties>
            <property name="custom:country">
               <type>d:text</type>
            </property>
         </properties>
      </aspect>
   </aspects>

-Then I added to ContentModel:
static final QName PROP_COUNTRY = QName.createQName(NamespaceService.CONTENT_MODEL_1_0_URI, "country");
static final QName ASPECT_Myperson = QName.createQName(NamespaceService.CONTENT_MODEL_1_0_URI, "Myperson");

-And then I modify finish() in NewUserWizard by adding this code:

after this code:
props.put(MyContentModel.PROP_HOMEFOLDER, newHomeFolderRef);
props.put(MyContentModel.PROP_EMAIL, super.getEmail());
props.put(EthicFlow_ContentModel.PROP_ORGID, super.getCompanyId());
this.nodeService.setProperties(nodeRef, props);

I add this code:
Map<QName, Serializable> myprops = new HashMap<QName, Serializable>(5);
myprops.put(MyContentModel.PROP_COUNTRY, this.country);
this.nodeService.addAspect(nodeRef, MyContentModel.ASPECT_Myperson,myprops);

Re: database access

soeursourire — Wed, 08 Feb 2006 08:36:29 GMT

Should I add this property Country in PersonService? And if yes what is the best way to do it:
- adding a sub-class of PersonServiceImpl
- adding a new bean MyPersonService
- importing this bean in Application-context
- using MyPersonService instead of PersonService in my classes
??

Thanks for help

Re: database access

gavinc — Wed, 08 Feb 2006 09:02:54 GMT

I can see a couple of potential problems…

You have defined (quite rightly) the aspect in it's own namespace i.e. custom:Myperson. However when you create the static members in ContentModel you use the default cm: namespace:

static final QName PROP_COUNTRY = QName.createQName(NamespaceService.CONTENT_MODEL_1_0_URI, "country");
static final QName ASPECT_Myperson = QName.createQName(NamespaceService.CONTENT_MODEL_1_0_URI, "Myperson"); ‍‍

You need to use the URI for your namespace that you would have defined in your model:

static final QName ASPECT_Myperson = QName.createQName("your uri", Myperson);
‍‍

Then to refer to your property in the list you will need to use the following syntax:

<hutputText value='#{r["custom:Myperson"]}' />

Hope this helps

Re: database access

soeursourire — Wed, 08 Feb 2006 09:55:48 GMT

So if I well understand I will have the following in MyContentModel.java:

static final QName PROP_COUNTRY = QName.createQName("custom.model", "country");
static final QName ASPECT_Myperson = QName.createQName("custom.model", "Myperson");

and in my jsp page I need to add this taglib:
<%@ taglib uri="custom.model" prefix="custom" %>

and this access:
<hutputText value="#{r["custom:country"]}"/>

But what is this custom.model where is it defined and how can I define it, should I create a file custom.model and put it in WEB-INF like repo.tld or alfresco.tld? I am lost..

Re: database access

gavinc — Wed, 08 Feb 2006 10:13:26 GMT

I presumed you had defined a custom model as explained in http://www.alfresco.org/mediawiki/index.php/Data_Dictionary_Guide#Content_Models to define the property and the aspect you are adding?

custom.model is the namespace you define for your model it doesn't have anything to do with taglibs so you won't need <%@ taglib uri="custom.model" prefix="custom" %> in your page.

One thing to be careful of is the quotes in your example, make sure it is as follows i.e. use single quotes around the whole expression.

<hutputText value='#{r["custom:country"]}'/>

Re: database access

soeursourire — Wed, 08 Feb 2006 10:25:31 GMT

Thanks a lot. I guess it was the problem and I added my aspect in web-client-config.xml

However I still have MISSING:Country:MISSING appearing in my users.jsp and I still do not have the attribute country in Node Browser from Administration Console for people…. Should I modify PersonService?

Re: database access

gavinc — Wed, 08 Feb 2006 20:27:40 GMT

Hi,

MISSING:Country:MISSING means that you have not added an entry in webclient.properties for an I18N string.

No, you shouldn't need to change PersonService, the property should be visible with what you have done.

Re: database access

soeursourire — Thu, 09 Feb 2006 12:36:00 GMT

I think I added a entry in webclient.properties..

But now I have other troubles after trying to add a calendar in a jsp page. I removed what I did for that but now I can compile and build my program but when I launch Alfresco I have error such as:

MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM

and I cannot launch Alfresco. How can I find from which bean the problem comes from exactly. Is there a way to debug the program with Eclipse ? (I am more used to VC++).

Thanks for your help.

Re: database access

turgayz — Thu, 09 Feb 2006 13:21:24 GMT

Is there a way to debug the program with Eclipse ?

Yes there is, look here: http://www.alfresco.org/forums/viewtopic.php?p=3669#3669

HTH,

Re: database access

soeursourire — Thu, 09 Feb 2006 13:32:30 GMT

Thanks a lot for your help… I found my error.

But I still cannot see my attribute Country in the properties of people of the system in Node Browser… despite aspect added etc.

Re: database access

soeursourire — Mon, 13 Feb 2006 07:50:31 GMT

Please would you mind telling me how the attributes of a class such as firstName, lastName, OrganizationId… are stored in the database after entered on the jsp page.

Is it, e.g., this code that stores the organizationId in MySQL?
props.put(ContentModel.PROP_ORGID, super.getCompanyId());
this.nodeService.setProperties(nodeRef, props);

Creating an aspect allows us to store an attribute into the database MySQL? What do I do wrong while doing that:
-I add an attribute department in my class MyNewUserWizard
-I add an aspect via extension-context.xml as follow:
<namespaces>
      <namespace uri="custom.model" prefix="custom"/>
   </namespaces>

   <!–types–>

   <!– Definition of new Content Aspect: Department of the user –>
    <aspects>
      <aspect name="custom:Myperson">
         <title>Department</title>
         <properties>
            <property name="custom:department">
               <type>d:text</type>
            </property>
         </properties>
      </aspect>
   </aspects>
-I add the variables in my sub class of ContentModel:
public interface MyContentModel extends ContentModel
{
    // person
    static final QName PROP_DEPARTMENT = QName.createQName("custom.model", "department");
    static final QName ASPECT_Myperson = QName.createQName("custom.model", "Myperson");
}
-I add this code in the function finish() of MyNewUserWizad:
Map<QName, Serializable> myprops = new HashMap<QName, Serializable>(5);
myprops.put(MyContentModel.PROP_DEPARTMENT, this.department);
this.nodeService.addAspect(nodeRef, MyContentModel.ASPECT_Myperson,myprops);

Is there another way to store attributes values in the database than using aspects?
Thanks in advance for your help

Re: database access

soeursourire — Mon, 13 Feb 2006 08:46:20 GMT

I guess I should do a type instead of an aspect? But how should I use employ it? If I want to add attributes to the type person how should I do, add my own person and repeat the properties firstname, lastname…. and use soemthing like nodeService.setType()?

Re: database access

soeursourire — Mon, 13 Feb 2006 09:17:44 GMT

When I added this type into customModel.xml and I am not using it yet:

   <type name="custom:Myperson">
         <title>MyPerson</title>
         <parent>sys:base</parent>
         <properties>
            <property name="custom:department">
               <type>d:text</type>
            </property>
         </properties>
      </type>
My program compiled but alfresco fails to launch. What is wrong here? I also added the import:
<import uri="http://www.alfresco.org/model/system/1.0" prefix="sys"/>