Versions Compared

Key

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

...

Code Block
#### Microsoft SQL Server
jdbcDriver=net.sourceforge.jtds.jdbc.Driver
jdbcUrl=jdbc:jtds:sqlserver://replaceWithServerName:1433/replaceWithDatabaseName;SelectMethod=cursor 
jdbcUser=replaceWithUsername 
jdbcPassword=replaceWithPassword

...

Code Block
    <!-- JDBC Properties -->
        <driver>net.sourceforge.jtds.jdbc.Driver</driver>
     <url>jdbc:jtds:sqlserver://replaceWithServerName:1433/DepotreplaceWithDatabaseName;SelectMethod=cursor</url>
        <logonid>replaceWithUsername</logonid>
        <logonpassword>replaceWithPassword</logonpassword> 
        <uidquery>SELECT FIRST_NAME + ' ' + LAST_NAME AS FIRST_LAST, FIRST_NAME, LAST_NAME, EMAIL FROM UP_PERSON_DIR WHERE USER_NAME=?</uidquery>

...