<use-java-context>false</use-java-context>

<datasources>
	<local-tx-datasource>
		<jndi-name>remoteDS</jndi-name>
		<connection-url>jdbc:oracle:thin:и_так_далее</connection-url>
		<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
		<user-name>*******</user-name>
		<password>*******</password>
		<max-pool-size>50</max-pool-size>
		<background-validation>true</background-validation>
		<background-validation-minutes>1</background-validation-minutes>
		<valid-connection-checker-class-name>
			org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker
		</valid-connection-checker-class-name>

		<use-java-context>false</use-java-context>
	</local-tx-datasource>
</datasources>

	public static DataSource getRemoteDatasource() throws NamingException {
		final Properties jndiProperties = new Properties();

		jndiProperties.put(Context.INITIAL_CONTEXT_FACTORY, "org.jnp.interfaces.NamingContextFactory");
		jndiProperties.put(Context.PROVIDER_URL, "jnp://localhost:1099");  // заменяем на адрес где jboss
		jndiProperties.put(Context.URL_PKG_PREFIXES, "org.jboss.naming:org.jnp.interfaces");

		final Context ctx = new InitialContext(jndiProperties);
		DataSource ds = (DataSource)ctx.lookup("remoteDS");
		return ds;
	}

	public static void main(String[] args) throws NamingException, SQLException {
		DataSource ds = getRemoteDatasource();
		Connection con = ds.getConnection();
		try {
			// какая-то полезная работа
			Statement query = con.createStatement();
			ResultSet rs = query.executeQuery("select * from bla_bla_bla");
			while (rs.next()) {
				System.out.println(rs.getString(1));
			}
		} finally {
			con.close();
		}
	}

%JBOSS_HOME/client/jbossall-client.jar