SQLServer

From Resin 3.0

(Difference between revisions)
Jump to: navigation, search
(New page: <b>WEB-INF/resin-web.xml</b> <code><pre> <web-app xmlns="http://caucho.com/ns/resin"> <database> <name>jdbc/sqlserver</name> <driver type="com.micro...)
 
 
Line 1: Line 1:
−
 
 
<b>WEB-INF/resin-web.xml</b>
 
<b>WEB-INF/resin-web.xml</b>
  
Line 8: Line 7:
 
     &lt;name&gt;jdbc/sqlserver&lt;/name&gt;
 
     &lt;name&gt;jdbc/sqlserver&lt;/name&gt;
 
     &lt;driver type="com.microsoft.jdbcx.sqlserver.SQLServerDataSource"&gt;
 
     &lt;driver type="com.microsoft.jdbcx.sqlserver.SQLServerDataSource"&gt;
−
       &lt;serverName&gt;csdevsqla01.office.foo&lt;/serverName&gt;
+
       &lt;url&gt;jdbc:sqlserver://localhost:1433;databaseName=Reports&gt;
−
      &lt;portNumber&gt;1433&lt;/portNumber&gt;
+
−
      &lt;databaseName&gt;Reports&lt;/databaseName&gt;
+
 
       &lt;user&gt;XXX&lt;/user&gt;
 
       &lt;user&gt;XXX&lt;/user&gt;
 
       &lt;password&gt;YYY&lt;/password&gt;
 
       &lt;password&gt;YYY&lt;/password&gt;
−
      &lt;selectMethod&gt;cursor&lt;/selectMethod&gt;
 
 
     &lt;/driver&gt;
 
     &lt;/driver&gt;
−
    &lt;xa&gt;true&lt;/xa&gt;
 
 
   &lt;/database&gt;
 
   &lt;/database&gt;
  
 
&lt;/web-app>
 
&lt;/web-app>
 
</pre></code>
 
</pre></code>
 +
 +
[http://msdn.microsoft.com/en-us/library/ms378428.aspx Microsoft Connection URL documentation]

Latest revision as of 22:11, 15 July 2009

WEB-INF/resin-web.xml 

<web-app xmlns="http://caucho.com/ns/resin">

   <database>
     <name>jdbc/sqlserver</name>
     <driver type="com.microsoft.jdbcx.sqlserver.SQLServerDataSource">
       <url>jdbc:sqlserver://localhost:1433;databaseName=Reports>
       <user>XXX</user>
       <password>YYY</password>
     </driver>
  </database>

</web-app>

Microsoft Connection URL documentation

Retrieved from "http://wiki3.caucho.com/index.php?title=SQLServer&oldid=3384"
Personal tools