Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
linking_to_other_databases_jspx__8619
linking_to_other_databases_jspx__8619
In order to link to tables in another database, you must first tell the application server about that database by adding a datasource descriptor file.

...

Companyname
only supports external tables with single primary key field which must be of exact numeric type

...

, like bigint

...

or integ

...

.

See examples of datasource configurations in EW_HOME/jboss/server/sw/deploy/ew-ds.xml as xml as well as JBoss AS Config DataSources. More detailed information is available in Configuring JDBC DataSources document from JBoss AS documentation.

MSSQL Example for MSSQL: 

Code Block
languagesql
<no-tx-datasource>
<jndi-name>DATABASE_NAME</jndi-name>
<min-pool-size>10</min-pool-size>
<max-pool-size>20</max-pool-size>
<blocking-timeout-millis>7500</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-timeout-minutes>
<connection-url>jdbc:sqlserver://SQL_SERVER_HOSTNAME:1433;database=DATABASE_NAME;
SelectMethod=direct;lastupdatecount=true;responseBuffering=adaptive;
lockTimeout=900000;packetSize=512;applicationName=EW</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<user-name>USER_NAME</user-name>
<password>PASSWORD</password>
<type-mapping>MS SQLSERVER2000</type-mapping>
</no-tx-datasource>
HTML
<p style="page-break-after:always;"></p>

To prevent the datasource file from being overwritten on update give it a name matching one of the following patterns:

  • *ewcustom*-ds.xml
  • ew_datasource_*-ds.xml
Info
titleExample

 ew ew_datasource_my_external_db_ds.xml or myxml or my_db_ewcustom-ds.xml.

Note

Jboss AS picks up the changes to this file immediately, so it is advisable to stop the server process before making changes to this file and start again only after changes are complete.

Hide If
displayprintable

Content by Label
showLabelsfalse
max5
spacesPROD
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("fields","database","linked") and type = "page" and space = currentSpace()
labelslinked fields database