Hi,

I'm having trouble setting up a DataSource with JBoss 3.0, it seems to have changed 
from previous versions of JBoss and I have tried several things including the examples 
provided in the docs directory. 

I'm trying to establish the DataSource connection to Microsoft SQL Server 2000 with 
the Microsoft JDBC driver, I have copied the driver to the %JBOSS_HOME%/lib directory 
and added the following mbean, but I am not sure if this is the correct thing to do or 
not. My question really boils down to how you setup a DataSource in JBoss 3.0??!?!

Any help would be appreciated, below is what I have added to my server config, but it 
doesn't seem to work.

  <mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager" 
name="jboss.jca:service=LocalTxCM,name=MSSQLDS">

    <attribute name="SecurityDomainJndiName">MSSQLDbRealm</attribute>

    <depends optional-attribute-name="ManagedConnectionFactoryName">
      <!--embedded mbean-->
      <mbean code="org.jboss.resource.connectionmanager.RARDeployment" 
name="jboss.jca:service=LocalTxDS,name=MSSQLDS">

        <attribute name="JndiName">MSSQLDS</attribute>

        <attribute name="ManagedConnectionFactoryProperties">
          <properties>
            <config-property name="ConnectionURL" 
type="java.lang.String">jdbc:microsoft:sqlserver://217.34.143.44:1433;DatabaseName=loadingbay</config-property>
            <config-property name="DriverClass" 
type="java.lang.String">com.microsoft.jdbc.sqlserver.SQLServerDriver</config-property>
            <!--set these only if you want only default logins, not through JAAS-->
            <config-property name="UserName" type="java.lang.String"></config-property>
            <config-property name="Password" type="java.lang.String"></config-property>
          </properties>
        </attribute>

<!--Below here are advanced properties -->
        <!--hack-->
        <depends 
optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss 
LocalTransaction JDBC Wrapper</depends>
      </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>

    <depends 
optional-attribute-name="JaasSecurityManagerService">jboss.security:name=JaasSecurityManager</depends>

    <attribute name="TransactionManager">java:/TransactionManager</attribute>
    <!--make the rar deploy! hack till better deployment-->
    <depends>jboss.jca:service=RARDeployer</depends>

  </mbean>

-------------------------------
Graeme Rocher
Software Developer
Channelbay
[EMAIL PROTECTED]
www.channelbay.tv
------------------------------- 
BEGIN:VCARD
VERSION:2.1
N:Rocher;Graeme
FN:Graeme Rocher
ORG:Channelbay
TITLE:Software Developer
NOTE;ENCODING=QUOTED-PRINTABLE:=0D=0A=0D=0A
TEL;WORK;VOICE:02072365566
TEL;HOME;VOICE:01273706707
TEL;CELL;VOICE:07747612883
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Gate 27=0D=0ALondon Central Markets=0D=0ASmithfield;London;;EC1A 9ND;Unite=
d Kingdom
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Gate 27=0D=0ALondon Central Markets=0D=0ASmithfield=0D=0ALondon EC1A 9ND=0D=
=0AUnited Kingdom
ADR;HOME;ENCODING=QUOTED-PRINTABLE:;;47 Sheppard Way=0D=0APortslade;Brighton;East Sussex;BN41 2JD;United Kingdo=
m
LABEL;HOME;ENCODING=QUOTED-PRINTABLE:47 Sheppard Way=0D=0APortslade=0D=0ABrighton, East Sussex BN41 2JD=0D=0AUnit=
ed Kingdom
URL;WORK:http://www.channelbay.tv
BDAY:19800202
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
EMAIL;INTERNET:[EMAIL PROTECTED]
REV:20020417T112523Z
END:VCARD

Reply via email to