Using the Sun Data Mashup Engine

ProcedureTo Create Connection Pools and JDBC Resources

For an application configuration, you need to create one connection pool and one JDBC resource for each source database. You can use up to five source connections in an application configuration.

For more information about creating connection pools and JDBC resources, see Chapter 3, JDBC Resources, in Sun GlassFish Enterprise Server 2.1 Administration Guide.

  1. Launch the GlassFish Admin Console.

  2. For each source database used in the Data Mashup project, create one connection pool.


    Note –

    The URL property is mandator for Derby connection pools. Make sure to add that property in the connection pool and enter the URL in the correct format.


  3. For each connection pool you created, create a corresponding JDBC resource.