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