Advertisement
martyychang

database-conf.xml bean for SQL Server 2012 Express

Jul 8th, 2013
1,125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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"
  5.      destroy-method="close">
  6.    
  7.     <!-- Driver class name taken from MSDN page, "Using the JDBC Driver"
  8.         http://msdn.microsoft.com/en-us/library/ms378526.aspx -->
  9.     <property name="driverClassName"
  10.              value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
  11.    
  12.     <!-- SQL Server connection string -->
  13.     <property name="url"
  14.              value="jdbc:sqlserver://localhost\SQLEXPRESS;databaseName=a_db;user=sa;password=sa_pass"/>
  15.    
  16.     <!-- username property not needed
  17.    <property name="username" value="user"/> -->
  18.    
  19.     <!-- password property not needed
  20.    <property name="password" value="password"/> -->
  21. </bean>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement