User: d_jencks
  Date: 02/04/09 18:44:41

  Added:       src/etc/example-config mssql-service.xml
  Log:
  example mssql server config thanks to Ove Ranheim
  
  Revision  Changes    Path
  1.1                  jbosscx/src/etc/example-config/mssql-service.xml
  
  Index: mssql-service.xml
  ===================================================================
  <?xml version="1.0" encoding="UTF-8"?>
  
  <!-- ===================================================================== -->
  <!--                                                                       -->
  <!--  JBoss Server Configuration                                           -->
  <!--                                                                       -->
  <!-- ===================================================================== -->
  
  <server>
  
    <!-- ======================================================================-->
    <!-- New ConnectionManager setup for Microsoft SQL Server 2000  driver     -->
    <!-- You may download the latest Microsoft JDBC driver from *Microsoft*    -->
    <!-- 
http://msdn.microsoft.com/downloads/default.asp?url=/downloads/sample.asp?url=/MSDN-FILES/027/001/779/msdncompositedoc.xml&frame=true
 -->
    <!-- Build jmx-api (build/build.sh all) and view for config documentation  -->
    <!-- ===================================================================== -->
  
    <mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager" 
name="jboss.jca:service=LocalTxCM,name=MSSQLDS">
      <!--make the rar deploy! hack till better deployment-->
      <depends>jboss.jca:service=RARDeployer</depends>
  
  
      <depends optional-attribute-name="ManagedConnectionFactoryName">
        <!--embedded mbean-->
        <mbean code="org.jboss.resource.connectionmanager.RARDeployment" 
name="jboss.jca:service=LocalTxDS,name=MSSQLDS">
          <!--hack-->
          <depends 
optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=Minerva
 JDBC LocalTransaction ResourceAdapter</depends>
  
          <!--real attributes-->
          <attribute name="ManagedConnectionFactoryProperties">
            <properties>
              <config-property>
                <config-property-name>ConnectionURL</config-property-name>
                <config-property-type>java.lang.String</config-property-type>
                
<config-property-value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyDatabase</config-property-value>
              </config-property>
              <config-property>
                <config-property-name>DriverClass</config-property-name>
                <config-property-type>java.lang.String</config-property-type>
                
<config-property-value>com.microsoft.jdbc.sqlserver.SQLServerDriver</config-property-value>
              </config-property>
              <config-property>
                <config-property-name>UserName</config-property-name>
                <config-property-type>java.lang.String</config-property-type>
                <config-property-value>sa</config-property-value>
              </config-property>
              <config-property>
                <config-property-name>Password</config-property-name>
                <config-property-type>java.lang.String</config-property-type>
                <config-property-value></config-property-value>
              </config-property>
            </properties>
  
          </attribute>
          <attribute name="JndiName">MSSQLDS</attribute>
        </mbean>
      </depends>
  
      <depends optional-attribute-name="ManagedConnectionPool">
        <!--embedded mbean-->
        <mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" 
name="jboss.jca:service=LocalTxPool,name=MSSQLDS">
  
          <attribute name="MinSize">0</attribute>
          <attribute name="MaxSize">50</attribute>
          <attribute name="BlockingTimeoutMillis">5000</attribute>
          <attribute name="IdleTimeoutMinutes">15</attribute>
          <!--criteria indicates if Subject (from security domain) or app supplied
              parameters (such as from getConnection(user, pw)) are used to distinguish
              connections in the pool. Choices are 
              ByContainerAndApplication (use both), 
              ByContainer (use Subject),
              ByApplication (use app supplied params only),
              ByNothing (all connections are equivalent, usually if adapter supports
                reauthentication)-->
          <attribute name="Criteria">ByContainer</attribute>
        </mbean>
  
      </depends>
      <depends 
optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager</depends>
      <attribute name="SecurityDomainJndiName">java:/jaas/MSSQLDbRealm</attribute>
      <attribute name="TransactionManager">java:/TransactionManager</attribute>
    </mbean>
  
  </server>
  
  
  

_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to