0 Replies Latest reply on Jul 24, 2003 10:12 AM by tsorrows

    data source config for read only in ms sql server

    tsorrows Newbie

      we are looking for config variables that may be affecting reports creating locks and deadlocks on our instance. could someone with experience in this area shed some light on this?

      HERE IS ORACLE-SERVICES.XML ENTRY:

      - <!-- SERVERNAME Production Inventory Sources
      -->
      -
      - <depends optional-attribute-name="ManagedConnectionFactoryName">
      -
      DS_SERVERNAME
      -
      -
      <config-property name="ConnectionURL" type="java.lang.String">jdbc:inetdae7:SERVERNAME:1433</config-property>
      <config-property name="DriverClass" type="java.lang.String">com.inet.tds.TdsDriver</config-property>
      <config-property name="UserName" type="java.lang.String">USERNAME</config-property>
      <config-property name="Password" type="java.lang.String">PASSWORD</config-property>


      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss LocalTransaction JDBC Wrapper


      - <depends optional-attribute-name="ManagedConnectionPool">
      -
      0
      50
      5000
      15
      ByContainer


      <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
      <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager
      java:/TransactionManager
      jboss.jca:service=RARDeployer