about The multisource for help
wanglei Mar 18, 2014 11:05 AMSome Day ago I have ask for help, details in the link is :https://community.jboss.org/thread/238054
Now I'm using multiple source previous questions,but there are still some questions:
The VDBs configure is:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <vdb name="SybiqVDB" version="1"> <description>My sybiq VDB</description> <property name="UseConnectorMetadata" value="true" /> <model visible="true" type="PHYSICAL" name="sybiq"> <property name="importer.useFullSchemaName" value="true"/> <property name="supports-multi-source-bindings" value="true"/> <source name="sybiq21" translator-name="sybase" connection-jndi-name="java:sybiq21DS"/> <source name="sybiq22" translator-name="sybase" connection-jndi-name="java:sybiq22DS"/> </model> </vdb>
DataSource sybiq21(sybiq22) configure is:
<datasource jndi-name="java:/sybiq21DS" pool-name="sybiq21DS" enabled="true" use-java-context="true"> <connection-url>jdbc:sybase:Tds:172.1.0.21:2640/dmpiq1</connection-url> <driver>sybase</driver> <security> <user-name>zcss7db</user-name> <password>zcss7db</password> </security> </datasource> <datasource jndi-name="java:/sybiq22DS" pool-name="sybiq22DS" enabled="true" use-java-context="true"> <connection-url>jdbc:sybase:Tds:172.1.0.22:2640/dmpiq1</connection-url> <driver>sybase</driver> <security> <user-name>zcss7db</user-name> <password>zcss7db</password> </security> </datasource>
The VDBs is running,no error.
Data source “sybiq21” have two table that table user_tb(userna varchar(12),passw varchar(12)) and table vmt_tb(name varchar(16),count int)
Now I want to query the VDBs,How can I set Data sources to make the following SQL statements are normal
query the table vmt_tb's sql: select name ,count from vmt_tb
query the table user_tb's sql : select userna , passw form user_tb
I also want to know, when disconnected sybiq21 data source, how to set up the data source or VDBs, can make the VDBs at startup without verifying the validity of data source sybiq21, only when the data source is used to verify