An introduction to best practices using Java, JDBC with Oracle (8i, 9i, 10g)

Graph Display of Table Data (above):

The red arrow highlights the best performance

Test Execution Details:

The provided test sources can be used by developers to select the most efficient coding approach to make the CSV upload more efficient process. It will help to speed up CSV loading.

How to make testsuite work:

1. Please DO NOT use on production DB schema; it will populate junk data into SDS_LAB_SESSION table. It is better todedicate some empty test schema for this.
2. Launch test.sql script on target DB to create tables, types and stored procedures. Should have permissions to create types and stored procedures.
3. Setup loadtest.properties - db connection
4. ant run.test

The tools that make these functions possible are called Components, Modules and Mambots.

What is the distinction among Components, Modules & Mambots?

• You can consider a Component as a full application that runs inside Mambo. Components extend Mambo and give it extra functionality. The output of a component is displayed inside the main content area.
• Modules are smaller, generally “helper” applications. Some run autonomously, others work in cooperation with Components. They are generally displayed around the edges of the main content area, in places defined inside the templates (called “module positions”).
• Mambots are small pieces of code that enable a new feature across the entire site. There are two types of Mambots: Those that have a visual effect (like ), and those that affect the way Mambo behaves but without adding any true visual impact (like the search Mambots).

Just to make things a bit more confusing, sometimes a function will require a combination of these tools. For example, the Banners and the Polls functions include both a Component and a Module.

While the technical distinction between these items is useful information, the most important points concern what they can do, and how you can use them. To assist with that, we have provided below a quick summary of the Components and Modules bundled in your Mambo package.