Do you use JNDI lookups?

We recommend that you use resource references, not direct JNDI lookups.

Do you use SELECT *?

SELECT * is not allowed with JDBC.

Do you obtain database connections from the connection pool or directly from the driver?

To obtain a connection to the underlying database, we recommend that you always use the connection pool.

Do you use local transactions?

We recommend that you use JTA transactions.

Have you set the field length of dictionary types char and binary?

If you use the dictionary types char and binary in your project, we recommend that you set the field length. If the field length is not set, the Java Dictionary will interpret the types as clob and blob, respectively.

Have you set the reference to your Java Dictionary project with SQLJ, JDBC, and JDO?

Do you create your database objects in accordance with the NWDI?

If you work on component-based projects, you must create your database objects in accordance with the rules for creating new components in the NWDI.

Do you save your work in the Java Dictionary with Save All Metadata?

To save your work in the Java Dictionary, choose Save All Metadata.

To close your Java Dictionary project, change to the Navigator view first.

To deploy your Java Dictionary project with your latest changes, choose Project ® Rebuild Project first.

Do you use single-length strings?

For portability reasons, zero length strings are not supported. We recommend that you use one single space to represent an initial value.

Do you use strings containing trailing blanks?

For portability reasons, strings containing trailing blanks are not supported, because the comparison semantics differ from database vendor to database vendor.

Do you use empty LOBs?

For portability reasons, empty LOBs are not supported.

Do you use positioned java.sql.ResultSet getter methods?

Positioned java.sql.ResultSet getter methods are not allowed in combination with "SELECT *" queries because the table layout can vary from installation to installation.

Do you use java.sql.Date objects?

We recommend that you create normalized java.sql.Date objects using the  java.sql.Date.valueOf(String) method.

Do you use java.sql.Time objects?

We recommend that  you create normalized java.sql.Time objects using the java.sql.Time.valueOf(String) method.

Do you close all connection-, statement- and ResultSet objects?

We recommend that you close all connection-, statement- and ResultSet objects as soon as possible.

Do you run the JDO Enhancer after rebuilding you project?

We recommend that you run the JDO Enhancer after rebuilding your project.