...
The SQL macro markup will look like: {sql:dataSource=myDS| ... } See Examples - 1011.x.
Further configuration management
See how to limit active database connections.
Other databases
Support for other databases depends on the capabilities provided by the JDBC driver. SQL requires that certain JDBC features are available. In some cases, choosing certain parameter options can affect the capabilities. User testing and community support are the only help resources available for less popular databases or JDBC drivers. If you have had success with other databases, let us know about the method in your comments on this page.
Problem determination
See Troubleshooting Application Server Based Data Sources - 1011.x.