[Alfresco ] How to update content with ContentWriter class

此問題欲解決要利用ContentWriter變更Node的內容， 不是指新增版本的方式，目前尚未用到，待驗證 :)

ContentWriter contentWriter = contentService.getWriter(nodeCurrentLogFile, ContentModel.PROP_CONTENT, true);
contentWriter.setMimetype("text/plain");
FileChannel fileChannel = contentWriter.getFileChannel(false);
ByteBuffer bf = ByteBuffer.wrap(logLine.getBytes());
fileChannel.position(contentWriter.getSize());
fileChannel.write(bf);
fileChannel.force(false);
fileChannel.close();

[Alfresco] Java Foundation API

記錄一下Alfresco low level的java API學習資源 :)

Content repository services

Content repository services are the fundamental services for working with content in Alfresco. Content repository services are written in Java.

Content repository services are built on the storage and query engines. As with the engines, the same infrastructure is shared. The concept of users and groups is introduced into these services, such as recording the author of content, who has content locked or access to content. Implementation of the standards-defined services is packaged into the Alfresco content repository.

Out-of-the-box content repository services provide capabilities to:

• Organize and manage content
• Control versions
• Record changes and updates
• Enforce security
• Model content types
• Search for information in the repository

• File Folders service
  The File Folders service manages nodes for modeling files and folders in the repository. The service provides methods to create and update nodes and define the relationships between them.
• Versioning service
  The Versioning service manages versions of individual content nodes. To enable versioning behavior, you must apply the versionable aspect to the node.
• Check Out / Check In service
  Check Out and Check In services control updates to document and prevent unwanted overwrites.
• Audit service
  The Audit service provides a configurable record of actions and events. It collects information and stores it in a simple database form.
• Authority service
  The Authority service supports the creation and updating of users and groups.
• Permission service
  The Permission service supports methods relating to various permissions.
• Person service
  The Person service supports various methods relating to users.
• Dictionary service
  The Dictionary service supports methods to access and view content models and their definitions.
• Search service
  The Search service provides methods for querying the repository and returning a filtered collection of nodes based on a user’s permission.
• 
  

Search Service
http://wiki.alfresco.com/wiki/Search#Search_Parameters
https://wiki.alfresco.com/wiki/Search_Documentation#Lucene_Language
How to exceed Lucene Limit Search?

node from uuid
Alfresco: Lucene query by ID returns 2 rows

Node Service
http://wiki.alfresco.com/wiki/NodeRef_cookbook#Obtaining_a_NodeRef

[Java] Jersey Client

本文記錄如何使用Jersey client API
Reference:
https://blogs.oracle.com/enterprisetechtips/entry/consuming_restful_web_services_with

[jQuery plugin] checkboxtree

https://code.google.com/p/checkboxtree/

[Alfresco] How to create Java backed web script in alfresco (3)

這個範例在Google都找的到，沒做多大的修改。
重點是記錄Spring Bean XML的差異性。
Spring Bean XML 
重點在於property標籤設定，如果你參考了foundation的api請記得把他加進來!!，
所以這個範例要使用了Repository，請設定rel=repositoryHelper。

 <bean
         id="webscript.org.example.simplejavadir.get"
         class="org.example.SimpleJavaDir"
         parent="webscript">
                <property name="repository" ref="repositoryHelper"/>
        </bean>

Java backed controller
透過xml的設定， 就可以透過 public void setRepository(Repository repository) {}直接呼叫alfresco的核心api了。

package org.example;
import java.util.HashMap;
import java.util.Map;

import org.alfresco.repo.model.Repository;
import org.alfresco.service.cmr.repository.NodeRef;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.extensions.webscripts.Cache;
import org.springframework.extensions.webscripts.DeclarativeWebScript;
import org.springframework.extensions.webscripts.Status;
import org.springframework.extensions.webscripts.WebScriptException;
import org.springframework.extensions.webscripts.WebScriptRequest;

public class SimpleJavaDir extends DeclarativeWebScript {
 
 private Repository repository;
 
    private static Log s_logger = LogFactory.getLog(SimpleJavaDir.class);


 public void setRepository(Repository repository) {
  this.repository = repository;
 }

 @Override
 protected Map<string, object>  executeImpl(WebScriptRequest req,
   Status status, Cache cache) {

  s_logger.debug("SimpleJavaDir entry");
  
  // extract folder listing arguments from URI
  String verboseArg = req.getParameter("verbose");
  Boolean verbose = Boolean.parseBoolean(verboseArg);
  Map<string, string>  templateArgs = req.getServiceMatch().getTemplateVars();
  String folderPath = templateArgs.get("folderpath");
  String nodePath = "workspace/SpacesStore/" + folderPath;

//  @param1 one of "node", "path", or "avmpath"
  NodeRef folder = repository.findNodeRef("path", nodePath.split("/"));
  // validate that folder has been found
  if (folder == null) {  
   throw new WebScriptException(Status.STATUS_NOT_FOUND, "Folder "
     + folderPath + " not found");
   //you will see the followning messages in your server
//    ERROR [extensions.webscripts.AbstractRuntime] Exception from executeScript - redirecting to status template error: 05190001 Folder Company Homes not found

  }
  
  // construct model for response template to render
   Map<string, object> model = new HashMap<string, object>();
  model.put("verbose", verbose);
  model.put("folder", folder);
  model.put("nodePath", nodePath);
  return model;
 }
}

[Java] Zxing create a QRCode

http://www.cnblogs.com/tompandas/archive/2012/04/10/2440513.html
http://code.google.com/p/zxing/downloads/list

[phpmyadmin] stored procedure and trigger

查看目前已建立的stored procedure
show procedure status

查看目前已建立的stored procedure

select * from information_schema.routines where routine_type = 'procedure'

查看指定資料庫內已有的stored procedure

select * from information_schema.routines where routine_type = 'procedure' and routine_schema = 'your_db'

新建stored procedure

1. Open phpMyadmin.
2. Select a database to work with.
3. Open the SQL tab.
4. Select all of the SQL statements between the DELIMITER statements in your stored procedure script. Do not include the DELIMITER statements! Here’s what my example script should look like:

   DROP PROCEDURE IF EXISTS spFoo $$
   CREATE PROCEDURE spFoo ()
   BEGIN
    SELECT 'Foo' FROM DUAL;
   END $$
   

5. In the delimiter field, just below the SQL editor’s text area, enter $$ as your delimiter.

Reference:
如何使用MySQL的Stored Procedure與Trigger
Using phpMyAdmin to Create Stored Procedures

[Java] Jersey Session

Session控制

@Path("/helloworld")
public class HelloWorld {

    @GET
    @Produces("text/plain")
    public String hello(@Context HttpServletRequest req) {

        HttpSession session= req.getSession(true);
        Object foo = session.getAttribute("foo");
        if (foo!=null) {
                System.out.println(foo.toString());
        } else {
                foo = "bar";
                session.setAttribute("foo", "bar");
        }
        return foo.toString();


    }
}

[Java] java.lang.UnsupportedClassVersionError: example/Hello : Unsupported major.minor version 51.0 (unable to load class example.Hello)

今天在local編譯完java後，丟到機器後就爆炸了。
是JDK版本不一樣導致XD，記錄一下這個痛!!

java.lang.UnsupportedClassVersionError: example/Hello : Unsupported major.minor version 51.0 (unable to load class example.Hello)

Major Class Versions of Various JDK
Following are the major version of class file format in standard JDK environment.

JDK 1.1 = 45
JDK 1.2 = 46
JDK 1.3 = 47
JDK 1.4 = 48
JDK 1.5 = 49
JDK 1.6 = 50

Read more: http://javarevisited.blogspot.com/2011/07/javalangunsupportedclassversionerror.html#ixzz1wkGsPmna

[Java] org.apache.catalina.LifecycleException: Failed to start component [StandardServer[8005]]

案例:

本地端(mac)的JRE使用1.7的64bit版本，build出來的程式在機器上都爆炸XD

目前先把elicpse的環境設回1.6的版本就可以在server正常跑了。

有遇到一樣情形的朋友一定要先確定Java的版本到底有沒有一致

專案按右鍵選擇Properties設定

JAVA BUILD PATH 設定

JAVA COMPILER 設定

[Java] Name comp is not bound in this Context

[Mysql] Host ‘yourhost’ is not allowed to connect to this MySQL server錯誤

連線MySQL時，出現標題上的錯誤訊息，
這個問題是此IP位址未授權給MYSQL

解決方法：直接在下SQL語法設定即可

補充:

進入設定檔 改bind-address

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

bind-address = 0.0.0.0

1.登入mysql
shell>mysql -u root -p
mysql>use mysql

2.設定資料庫的使用權限

允許所有連線

mysql>GRANT ALL PRIVILEGES ON *.* TO ‘MySQL帳號’@'%’ IDENTIFIED BY ‘MySQL密碼’ WITH GRANT OPTION;
Tip:% 代表不限client的連線ip

設定特地連結的ip

mysql>GRANT ALL PRIVILEGES ON *.* TO ‘MySQL帳號’@'你要連線IP‘ IDENTIFIED BY ‘MySQL密碼’ WITH GRANT OPTION;

3.最後一定要更新權限
mysql>FLUSH PRIVILEGES;

Reference:
[MySQL]解決ERROR 1130: Host ‘yourhost’ is not allowed to connect to this MySQL server錯誤無法遠端連接MySQL：message from server: "Host xxx is not allowed to connect to this MySQL server"
MySQL的重要語法

[Java] DBCP Sample

簡單的DBCP範例，主要記錄Reference物件的用法
Setting up initial context for DBCP connection pool.

[Java] OpenID4Java

今天在處理OpenID的議題時，發現在local測試跑很正常。
但BUILD到伺服器的時候，會產生類別找不到的問題。
發現在tomcat/lib放了二個版本的openid4java的函式庫，
把舊的砍掉就執行正常了