SHOW:
|
|
- or go back to the newest paste.
| 1 | <!-- bean for connecting Salesforce's Data Loader | |
| 2 | to SQL Server 2012 Express running on the same computer --> | |
| 3 | <bean id="sqlServerDataSource" | |
| 4 | - | class="org.apache.commons.dbcp.BasicDataSource" |
| 4 | + | class="org.apache.commons.dbcp.BasicDataSource" |
| 5 | - | destroy-method="close"> |
| 5 | + | destroy-method="close"> |
| 6 | - | |
| 6 | + | |
| 7 | - | <!-- Driver class name taken from MSDN page, "Using the JDBC Driver" |
| 7 | + | <!-- Driver class name taken from MSDN page, "Using the JDBC Driver" |
| 8 | - | http://msdn.microsoft.com/en-us/library/ms378526.aspx --> |
| 8 | + | http://msdn.microsoft.com/en-us/library/ms378526.aspx --> |
| 9 | - | <property name="driverClassName" |
| 9 | + | <property name="driverClassName" |
| 10 | - | value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/> |
| 10 | + | value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/> |
| 11 | - | |
| 11 | + | |
| 12 | - | <!-- SQL Server connection string --> |
| 12 | + | <!-- SQL Server connection string --> |
| 13 | - | <property name="url" |
| 13 | + | <property name="url" |
| 14 | - | value="jdbc:sqlserver://localhost\SQLEXPRESS;databaseName=a_db;user=sa;password=sa_pass"/> |
| 14 | + | value="jdbc:sqlserver://localhost\SQLEXPRESS;databaseName=a_db;user=sa;password=sa_pass"/> |
| 15 | - | |
| 15 | + | |
| 16 | - | <!-- username property not needed |
| 16 | + | <!-- username property not needed |
| 17 | - | <property name="username" value="user"/> --> |
| 17 | + | <property name="username" value="user"/> --> |
| 18 | - | |
| 18 | + | |
| 19 | - | <!-- password property not needed |
| 19 | + | <!-- password property not needed |
| 20 | - | <property name="password" value="password"/> --> |
| 20 | + | <property name="password" value="password"/> --> |
| 21 | </bean> |