...
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> |
...