Is it possible to have datasource aliases in JBoss? E.g. instead of:
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>ds-1</jndi-name>
<connection-url>jdbc:abc</connection-url>
<user-name>def</user-name>
<password>ghi</password>
...
</local-tx-datasource>
</datasources>
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>ds-2</jndi-name>
<connection-url>jdbc:abc</connection-url>
<user-name>def</user-name>
<password>ghi</password>
...
</local-tx-datasource>
</datasources>
have something like:
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>ds-1</jndi-name>
<connection-url>jdbc:abc</connection-url>
<user-name>def</user-name>
<password>ghi</password>
...
</local-tx-datasource>
</datasources>
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>ds-2</jndi-name>
<alias>ds-1</alias>
</local-tx-datasource>
</datasources>
or something in that fashion. This would allow for:
- Not having duplicate information (e.g. connection URLs, usernames, passwords, etc.)
- Supporting legacy or just other applications that require the same logical connection, but use different data-source names
- Easy testing of multiple data-sources on one database (i.e. on the same data, even though the apps were designed to use physically different
DBs)
Any ideas appreciated. Also - as a general thing - is it possible to have aliases for other things (e.g. MQ topic aliases, etc.).![]()