The story that Domino and I had to tell (serialized 2016-3-2)

• 1, about Notesviewentry

Note: When you get the value of a column by notesviewentry, it will not be displayed if the value of the column is @isexpandable or @DocNumber or constant.

Set entry = view. Getentrybykey ("Sports car", False)
Messagebox entry. Columnvalues (0),, "Column 1"
Explanation of the Help documentation:

A column value is not returned if it's determined by:

• A formula containing a ui-only function such as @IsExpandable or @DocNumber.

• A constant.

Conclusion: To read more help documents, there are. The new man of bitter force!

• 2. About exporting Excel in Domino

2.1) When you export Excel by view, a column constant is not derived.

Workaround: Add a non-existent variable after the constant.    such as: "One" +a; "A" +a

2.2) When you export Excel by view, a column value is numbered, preceded by 0, such as 021, 089, and so on, but not displayed. That is, the previous 0 was lost when exporting.

Workaround: The location where the data is written in the agent, add a   to the left or right of the data Can.

Tip: The agent is written for the LotusScript language of Domino and is exported through Excel, which is written in table format. The specific code that can be seen here:

• 3 . Take data from Oracle 11g through a Java proxy, introduce a Java agent in Domino, print to a page, or export the data to Excel. This problem has been out before, and then I do not know how to debug it. This time because the computer crashes the Domino Server, the data is the same, the Java Proxy encoding has not changed, Eclipse is completely copied to the machine, Domino's form has not changed.  However, written directly in the agent of the Chinese, after the output to the page, all become garbled.

After I modified Domino Server on the Domino service, all the data from the Java proxy output to the page was garbled.

In addition, the result of JS hint is garbled, the reason is because the JS file itself coding problems. Because the current Domino code is UTF-8, the file encoding is GB2312. Convert this file to GBK, copy it into Notepad, save the file as Utf-8 format, and finally upload and replace the original file.

Finally, I remembered the encoding settings of the printed data, changed it from Utf-8 to gb2312, and the Chinese garbled in the data obtained from Oracle disappeared.

• 4 . A customer needs to take the data from the Domino system via the Web Service interface. At first blush, unintelligible. The colleagues who have been asked have not been able to speak clearly. So, had to degree Niang inquire inquire. Take a look at the comments behind the article, as well as the bloggers ' answers, and there will be some other gains.

Invoking the Web Service in Domino85
http://windindream.blog.163.com/blog/static/4935919201011285263783/

Publishing a Web Service in Domino8.5

http://windindream.blog.163.com/blog/static/493591920101128423493/

It is important to note that:

1, because the client's interface is written in Java, in Domino designer through the WSDL file in the Web service to obtain these. java. I don't know if it's Domino's problem, the client that gets it on the designer side. The Java code is compiled, and the client-given method is all turned into a. Java class.

At this point, you need to find two important interfaces in the. java file.

The first is, Xxxxlocator, ending with locator, this class should be the total interface of all methods when domino parsing.

The second is that the client passes through the WebService interface, which can be found in the WSDL.

You can look at the following figure:

123	WebserviceCommonserviceLocator comLoc = newWebserviceCommonserviceLocator();ICommon ic = comLoc.getCommonImplPort();ic.方法

• 5, about the problem of reference JS in Domino

JS file in the database resource file, in the HTML first page content reference, src= ' test.js '.

Reference in form, <script type = "Text/javascript" src = "test.js" ></script>

• 6. How to write HTML code in Domino view.

Wrap the code in [].

For example: "[<input name= ' Gdcheck ' type= ' text ' value=" +unid+ "' ></input>]"

• 7. The problem of JS file encoding in Domino database

Description: When doing the project, the common JS method is put into the JS file, convenient to call. However, after the migration, the JS file again in the JS method to modify, after saving, found that the application calls the method error, the JS file method can not be called.

After inspection, the following conditions were found:

1) After the modification save, again open JS file, Chinese display as garbled.

2) Open the JS file, set the current text file encoding to gb2312, the code appears normal. When you save, you are prompted with a problem with the encoding. (Menu "Edit"-set encoding--)

3) The contents of the JS file through Notepad to Utf-8 encoding, and then copied to, JS file, the problem is still.

4) The encoding for UTF-8 encoded JS file directly imported, the problem is still.

Conclusion: There is a problem in the coding of the current database. Because every time as long as the JS file is not changed, save, then there will be no garbled problem. Obviously, when saving, the database will automatically convert the JS file encoding. Looking for a while did not find exactly where to make changes, by consulting the company master, found the menu "project"--and the property---The text file encoding, the default is GB18030.

Solution:

1) First modify the resource-to-text file encoding of the database to change the encoding to Utf-8. So each time you save, the JS file will automatically become UTF-8 encoding.

2) Pass all the JS files through Notepad, turn the code into Utf-8, and then import them in.

3) test.

• 8. By webservice the attachments in the Domino document to a Java system, the result is no problem in the XP environment. However, in the AIX environment when the error.

Description: for this interface, we extract the contents of the document from OA (including attachments, body, domain values), and then call the method provided by the other party to deliver the content to the other party. The way they are transmitted is to first convert the attachment into a byte stream, then package all the attachments into an object as a parameter, and the body is simply converted into a byte stream, which is transmitted as a parameter, and the domain value selects the important one to transmit. Results in the XP environment Test no problem, started the Times "outofmemoryerror" problem, configuration javamaxheapsize later resolved the problem. But it always fails in the AIX environment and has been reporting a problem with insufficient memory.

The current reported errors, such as:

Now it's stuck here.

This link is a summary of the JVM exception handling method: http://blog.csdn.net/zys5212/article/details/7046066

Note:

At present the problem has been solved. Our solution is to convert the attachment into a file stream and put it into the collection so that a memory overflow error can be avoided. However, the memory overflow error is still reported when the attachment reaches around 100M. (Javamaxheapsize is set to 1G)

• 9. About Lotus Domino Complex query

Description: information about Domino queries can be found on the web, and I'm here to record complex queries. Complex queries are also db. Search (Formula).

Formula= "form=\" ffawen\ ""

Numeric type: "& @texttonumber (num) =" +num2

Text type: "& @contains (" ";" ")"

Date type: "& @texttotime (Riqi) >[email protected] (" 2011-09-09 ")"

• 10. Error: ... ' Waiting for READ-LOCK on Frwsem ' ... ' for 30000 MS ' ...

Description: This problem encountered two times, the previous look for a long time did not find how to solve, the following this seems to restart Domino server after the prompt does not appear. Find a solution on the Internet, the following links:

Add parameters to Note.ini: Schedule_no_calcstats=1.

http://www-01.ibm.com/support/docview.wss?uid=swg21315806

• 11, the login form was originally submitted through action, and then directly through the button call agent submitted to the background agent for processing. However, the value entered in the current form cannot be taken from the discovery agent. If the default value, no problem.

Description: After several tossing and finding, the original is the top of the form, there is a label </form>. When the call button is submitted to the proxy, content other than the default <form> (including the domain) of the page is not part of this submission. So, when we submit, JS shows the content. However, the most recent domain value cannot be obtained at all in the agent.

The previous forms can, mainly because, they write a new form directly wrapped up the content that needs to be submitted. While I was modifying it, I stopped using the action, but I submitted it as an entire form, and the form would find the first form to be processed directly.

I have found this </form> before, but I did not know its function was not removed. As a result, a lot of wasted time.

The story that Domino and I had to tell (serialized 2016-3-2)