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