Connection Aliases and SQL Specifications

To connect to a database and access data using a Select, Modify, or ProcedureCall bean, you specify values for the following properties:

Each of the properties has the following:

Connection aliases and SQL specifications are stored by name in database access classes that VisualAge for Java generates for you. When you create a Select, Modify, or ProcedureCall bean, you can use an exisitng connection alias and/or SQL specification or create new ones. If you create a new one, you can store it in an existing database access class or create a new database access class. Your bean can use a connection alias from one database access class and an SQL specification from another database access class or it can use one database access class for both.

If you create multiple Select, Modify, or ProcedureCall beans for your program, the beans can share one connection alias and/or one SQL specification. If multiple beans use the same connection alias, at run time they share the same physical connection to the database and when one of the beans commits an update to the database, all uncommitted updates made by the other beans are committed also.  


Parameterized SQL Statements
Select Bean
Modify Bean
ProcedureCall Bean


Accessing Relational Data