1 Reply Latest reply on Aug 3, 2007 5:55 AM by Pete Muir

    Datasource settings question

    Andy Shiue Newbie

      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>