Step 10. Execute generated SQL.
If this step is not completed, the Method Server will not start and will throw a very lengthy wt.pom.DatastoreException exception:
wt.services.ManagerException: wt.util.WTException: (wt.pom.pomResource/0) wt.pom.PersistenceException:
A persistence error occurred. System message follows:
Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement
"(SELECT ’com.ptc.windchill.enterprise.report.ThirdPartyReportModelData’ FROM
...
This indicates there is no table for the extensions that need to be
persisted.
a. Navigate to the WT_HOME/db/sql/com/customer directory. Access SQL*Plus as the Windchill database user.
b. Always build tables before indexes. Execute the following:
Example:
@Make_pkg_customer_Table.sql
@Make_pkg_customer_Index.sql
c. Exit SQL*Plus.
Step 11. Restart Tomcat and the Method Server.
If this step is not completed, the Method Server does not reload the
registry property files and subsequently does not know about the new
customization.
Step 12. Test.
a. Test in the UI. The function Create Document should have an additional type —com.customer.doc.CustomerOrder:
Example:
Operations in Rational Rose equate to methods in Java.
• Firstly, classes should have the same constructor methods as the parent class.
• Once the class has the same constructor methods, developers can add any other additional methods driven by the requirements.
• In Rational Rose, operations are summarized in the Operations tab of the Class Specification window:
Figure 6-4: Operations Tab of Class Specification Window
• Operations also have a separate Operation Specification window to set detailed properties for the operation:
Figure 6-5: Operation Specification Window
• Adding operations does not change the database structure; any existing tables for modeled custom classes should not need to be changed.
– Of course, the generated Java needs to be recompiled.
If this step is not completed, the Method Server will not start and will throw a very lengthy wt.pom.DatastoreException exception:
wt.services.ManagerException: wt.util.WTException: (wt.pom.pomResource/0) wt.pom.PersistenceException:
A persistence error occurred. System message follows:
Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement
"(SELECT ’com.ptc.windchill.enterprise.report.ThirdPartyReportModelData’ FROM
...
This indicates there is no table for the extensions that need to be
persisted.
a. Navigate to the WT_HOME/db/sql/com/customer directory. Access SQL*Plus as the Windchill database user.
b. Always build tables before indexes. Execute the following:
Example:
@Make_pkg_customer_Table.sql
@Make_pkg_customer_Index.sql
c. Exit SQL*Plus.
Step 11. Restart Tomcat and the Method Server.
If this step is not completed, the Method Server does not reload the
registry property files and subsequently does not know about the new
customization.
Step 12. Test.
a. Test in the UI. The function Create Document should have an additional type —com.customer.doc.CustomerOrder:
Example:
Operations in Rational Rose equate to methods in Java.
• Firstly, classes should have the same constructor methods as the parent class.
• Once the class has the same constructor methods, developers can add any other additional methods driven by the requirements.
• In Rational Rose, operations are summarized in the Operations tab of the Class Specification window:
Figure 6-4: Operations Tab of Class Specification Window
• Operations also have a separate Operation Specification window to set detailed properties for the operation:
Figure 6-5: Operation Specification Window
• Adding operations does not change the database structure; any existing tables for modeled custom classes should not need to be changed.
– Of course, the generated Java needs to be recompiled.
本文介绍了解决Windchill平台在执行定制SQL过程中遇到的DatastoreException异常的方法。包括执行生成的SQL脚本、正确建立表格及索引、重启Tomcat及MethodServer等步骤,并验证UI中功能是否正常。
4713

被折叠的 条评论
为什么被折叠?



