Hi,
I am trying to connect to one of the server inside my uni with JDBC and using the Booking example as the canvas.
I modify the ds.xml file as follows. But the problem is that I need to specify the database I am querying for.
How should I do it?
Do I specify it in the ds.xml file or somewhere else?
By the way, the server is microsoft sql server.
<datasources>
<local-tx-datasource>
<jndi-name>xxxDatasource</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://xxx.xxx.xxx.edu.au:1433</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<user-name>xxx</user-name>
<password>xxx</password>
</local-tx-datasource>
</datasources>
