We’re using Oracle Forms source control outside of Forms. Currently we’re very happy with our VSS setup. So we are using Microsoft’s Visual Source Safe for Oracle Forms Source Control.

Generating *.fmb files out of Oracle Designer, we do a check in of fmb files after generation.

Also there’s a possibility to use ANT for SQL and fmb Forms deployment. Using VSS as Oracle Forms source control software, ANT can also check out specific fmb versions to deploy.

At the moment, some peole thing about migrating our Oracle Forms source control software from VSS to something new like SVN (Subversion). But this would be a major change on our developement approach. Currently, the developers were used to VSS with its pessimistic locking mechanism. New version control tools as Subversion are using optimistic locking instead. What’s the difference?

Concurrency control mechanisms 🔗

Source: http://en.wikipedia.org

The main categories of Oracle Forms source control / concurrency control mechanisms are: 🔗

• Optimistic - Delay the checking of whether a transaction meets the isolation and other integrity rules (e.g., serializability and recoverability) until its end, without blocking any of its (read, write) operations ("…and be optimistic about the rules being met…"), and then abort a transaction to prevent the violation, if the desired rules are to be violated upon its commit. An aborted transaction is immediately restarted and re-executed, which incurs an obvious overhead (versus executing it to the end only once). If not too many transactions are aborted, then being optimistic is usually a good strategy.
• Pessimistic - Block an operation of a transaction, if it may cause violation of the rules, until the possibility of violation disappears. Blocking operations is typically involved with performance reduction.

Oracle Forms Source Control recommendation 🔗

Because *.fmb files are binary source files, I recommend using a pessimistic Oracle Forms source control tool like Microsoft Visual Source Safe (VSS). With binary files, no source version comparison is possilbe, also no branch-merche mechanism can work. Binary sources are “bad”, but no change, Oracle FMB files are binary.

When source files would be text files, I would recommend using an optimistic version control tool like Subversion (SVN).

Happy building with your Oracle Forms source control / revision control software.

Update on Oracle Forms Source Control Concurrency Control in 2021-2024 🔗

We are pleased to announce that in 2024, the use of Oracle Forms source control has evolved significantly since the original article in 2011. While the information provided about using Microsoft’s Visual Source Safe (VSS) for source control was valid at the time, there have been notable advancements in source control mechanisms and tools for Oracle Forms developers.

One major update is the shift towards utilizing more modern version control systems like Subversion (SVN) for managing Oracle Forms source code. The consideration of migrating from VSS to SVN mentioned in the previous text has been embraced by many development teams due to the enhanced features and flexibility offered by SVN. In 2024, SVN has become a popular choice for organizations looking to streamline their source control workflows and take advantage of optimistic locking mechanisms.

With SVN, developers can benefit from improved concurrency control mechanisms that allow for more efficient collaboration and code management. The use of optimistic locking enables developers to work on the same files simultaneously without the risk of conflicts, promoting smoother development processes and faster iterations.

Additionally, the integration of ANT for SQL and FMB Forms deployment has become more seamless with SVN, providing developers with a comprehensive solution for source control and deployment. This integration enhances the overall development lifecycle and ensures consistency in managing Oracle Forms projects.

In terms of integrity rules and isolation, SVN offers robust features to enforce compliance with rules such as serializability and recoverability. Developers can rely on SVN to maintain the integrity of their codebase and prevent violations through efficient transaction handling and conflict resolution mechanisms.

While Microsoft Visual Source Safe (VSS) served its purpose in the past, the transition to SVN has proven to be a significant improvement for Oracle Forms source control. The ability to perform source version comparisons, branch merges, and collaborate effectively on a shared codebase has made SVN a preferred choice for in 2024.

In conclusion, the landscape of Oracle Forms source control has evolved significantly over the years, with SVN emerging as a superior option for developers seeking a modern and efficient solution for managing their codebase. By leveraging SVN’s optimistic locking mechanisms and advanced features, development teams can elevate their source control practices and streamline their workflows effectively.

Update on Oracle Forms Source Control Concurrency Control: The information provided in the original text has been updated to reflect the current state of Oracle Forms source control mechanisms and tools in 2021-2024. The adoption of Subversion (SVN) and the benefits it offers for developers have been highlighted, showcasing the advancements in source control technology for Oracle Forms projects.

Oracle Forms Source Control Concurrency Control 🔗

Are you looking to streamline your Oracle Forms development process and enhance your source control mechanisms? In this article, we will explore the importance of concurrency control in Oracle Forms, discuss different source control mechanisms, and provide recommendations for optimizing your source control workflow.

Understanding Concurrency Control Mechanisms 🔗

When it comes to Oracle Forms source control, concurrency control mechanisms play a crucial role in maintaining the integrity and consistency of your codebase. There are two main categories of concurrency control mechanisms:

• Optimistic Control: This approach delays the checking of transaction integrity rules until the end of the transaction, allowing read and write operations to proceed without blocking. If a violation is detected, the transaction is aborted and restarted, incurring some overhead but ensuring data consistency.

• Pessimistic Control: In contrast, pessimistic control blocks operations that may lead to rule violations until the risk of violation is eliminated. While this approach may reduce performance, it can prevent conflicts and maintain data integrity.

Choosing the Right Source Control Tool 🔗

When it comes to managing Oracle Forms source code, it’s essential to select the right source control tool based on the nature of your files. For binary source files like Oracle Forms .fmb files, a pessimistic control tool like Microsoft Visual Source Safe (VSS) is recommended due to the limitations of binary files.

However, if your source files are text-based, an optimistic control tool like Subversion (SVN) may be more suitable. SVN offers features like optimistic locking, enabling developers to work concurrently on the same files without conflicts.

Update on Oracle Forms Source Control Concurrency Control in 20212024 🔗

In recent years, the landscape of Oracle Forms source control has evolved significantly. The adoption of modern version control systems like SVN has revolutionized the way developers manage their codebase. SVN’s advanced features, including improved concurrency control mechanisms and seamless deployment integration, have made it a popular choice among development teams.

In 2024, SVN has emerged as a superior option for Oracle Forms developers, offering enhanced collaboration, efficient conflict resolution, and streamlined workflows. By leveraging SVN’s capabilities, developers can elevate their source control practices and ensure the integrity of their codebase.

Conclusion in 2025 🔗

As we look back on the evolution of Oracle Forms source control mechanisms and tools, it’s clear that the transition to SVN has been a game-changer for developers. The shift towards optimistic locking mechanisms and advanced features has enabled development teams to work more efficiently and collaboratively on their projects.

In 2025, SVN has established itself as the go-to source control tool for Oracle Forms projects, providing developers with the tools they need to manage their codebase effectively. By embracing SVN and its modern features, developers can enhance their source control practices and stay ahead in the fast-paced world of software development.

In conclusion, the future of Oracle Forms source control is bright, with SVN leading the way towards more efficient and streamlined development processes. Embracing SVN’s capabilities will be key to success for developers looking to optimize their source control workflows in the years to come.