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>
Ask this in a ejb3 forum.