0 Replies Latest reply on Aug 26, 2004 10:27 AM by ricky

    sql 2000 + jboss 3.0

    ricky Newbie


      --------------------------------------------------------------------------------

      1, index.jsp
      Context ic = new InitialContext();
      DataSource ds = (DataSource) ic.lookup("java:/ testdb ");
      Connection con = ds.getConnection();
      String sql = "select top 5 * from tbnewsphoto ";


      2, mssql-xa-service.xml

      <depends optional-attribute-name="ManagedConnectionFactoryName">
      <!--embedded mbean-->


      MSSQLXaDS

      <!--real attributes-->


      <config-property name="XADataSourceProperties" type="java.lang.String">ServerName= localhost ;DatabaseName= MyData ;SelectMethod=cursor</config-property>

      <config-property name="XADataSourceClass" type="java.lang.String">com.microsoft.jdbcx.sqlserver.SQLServerDataSource</config-property>


      <!--hack-->
      <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=Minerva JDBC XATransaction ResourceAdapter

      3, mssql-service.xml
      <depends optional-attribute-name="ManagedConnectionFactoryName">
      <!--embedded mbean-->


      testdb



      <config-property name="ConnectionURL" type="java.lang.String">jdbc:microsoft:sqlserver:// localhost :1433;DatabaseName= MyData </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"> sa </config-property>
      <config-property name="Password" type="java.lang.String"></config-property>




      4. when i run jboss 3.0
      Incompletely deployed packages:
      [org.jboss.deployment.DeploymentInfo@e978ec45 { url=file:/C:/JBOSS/server/defaul
      t/deploy/mssql-service.xml }
      deployer: org.jboss.deployment.SARDeployer@fe748f
      status: null
      state: FAILED
      watch: file:/C:/JBOSS/server/default/deploy/mssql-service.xml
      lastDeployed: 1093518248968
      lastModified: 1093518248921
      mbeans:
      , org.jboss.deployment.DeploymentInfo@514fbd09 { url=file:/C:/JBOSS/server/defau
      lt/deploy/mssql-xa-service.xml }
      deployer: org.jboss.deployment.SARDeployer@fe748f
      status: null
      state: FAILED
      watch: file:/C:/JBOSS/server/default/deploy/mssql-xa-service.xml
      lastDeployed: 1093518249046
      lastModified: 1093518249031
      mbeans:
      ]MBeans waiting for classes:

      MBeans waiting for other MBeans:


      19:04:11,765 INFO [URLDeploymentScanner] Started
      19:04:11,765 INFO [MainDeployer] Deployed package: file:/C:/JBOSS/server/defaul
      t/conf/jboss-service.xml
      19:04:11,765 INFO [Server] JBoss (MX MicroKernel) [3.0.8 (CVSTag=JBoss_3_0_8 Da
      te=200306050849)] Started in 0m:8s:719ms

      5, browser looks like this
      HTTP ERROR: 500 testdb not bound