Resolution:

Instructions follow. 

1). Build as-jdbc jar (as-jdbcdriver.jar) by using the Java code at "<AS_HOME>\examples\java\JDBCDriver\" .

2). Copy the as-jdbcdriver.jar file into tra lib "<TIBCO_HOME>\tra\5.*\lib" .

3). Create DUAL space in the cluster which you trying to connect as a JDBC connection. 

Sample DUAL space definition. 
===================
You have to create DUAL space in the cluster to mimic like ORACLE. All the JDBC drivers and its connection will refer to the DUAL table. For more details, refer to:

https://en.wikipedia.org/wiki/DUAL_table

create space name 'DUAL' ( field name 'DUMMY' type 'String' nullable false) key (type 'hash' fields ('DUMMY')) distribution_policy 'distributed' replication_count 1 replication_policy 'async' persistence_policy 'none' persistence_type 'none' eviction_policy 'none' cache_policy 'read_write_through' lock_scope 'thread' min_seeders 1 capacity -1 ttl -1 lock_ttl -1 lock_wait 0 space_wait 60000 write_timeout 300000 read_timeout 300000 query_timeout -1 virtual_node_count 1000 phase_count -1 phase_interval 200 forget_old_value false host_aware_replication true routed false phase_ratio 100 query_limit -1
===================================

4). Once you create this space, you will be able to query the data from AS just as you do with other databases.

 

How to use the BW JDBC connection palette with ActiveSpaces JDBC Driver.