2 Replies Latest reply on Mar 5, 2002 8:19 PM by Geoff Weatherall

    JBoss 3 alpha datasource setup

    Geoff Weatherall Newbie

      I'm attempting to get JBoss 3 (alpha) going with ms sql 2000, using the Atinav driver example provided in the on-line documentation.

      First, I've installed the alpha version, deployed the CMP example that comes with the pay $$$$ documentation, and I've tested this example is work 100% with the (default) hypersonic driver.

      With all this working, I'm trying to swap just the data source to a ms sql 2000 database. I've copied the example for SQL server config given in the free documentation (downloaded the driver and deployed it etc), which appears to deploy ok:

      [12:09:08,627,AutoDeployer] Auto-deploying file:/C:/jboss/deploy/mssql-service.xml
      [12:09:08,627,AutoDeployer] Auto deploy of file:/C:/jboss/deploy/mssql-service.xml
      [12:09:08,657,Default] Libraries adding URLClassLoader -2046610982 key URL file:/C:/jboss//lib/ext/TaveConn25C.jar
      [12:09:08,657,ServiceCreator] About to create the beanJBOSS-SYSTEM:service=ConnectionFactoryLoader,name=MSSQL2000DS
      [12:09:08,667,ServiceCreator] Created the beanJBOSS-SYSTEM:service=ConnectionFactoryLoader,name=MSSQL2000DS

      Finally, I've change the datasource in the jbosscmp-jdbc.xml configuration file from java:/DefaultDS to java:/MSSQL2000DS (also tried MSSQL2000DS on it own). When I do this I'm getting:

      [12:15:02,994,J2eeDeployer#Default] Deploy J2EE application: file:/C:/jboss/deploy/cmp2-example.ear
      [12:15:03,014,J2eeDeployer#Default] Create application cmp2-example.ear
      [12:15:03,024,J2eeDeployer#Default] install EJB module cmp2-example.jar
      [12:15:03,064,J2eeDeployer#Default] add all ejb jar files to the common classpath
      [12:15:03,074,J2eeDeployer#Default] about to invoke deploy on jardeployer:JBOSS-SYSTEM:service=ContainerFactory
      [12:15:03,074,ContainerFactory] got to deploy in ContainerFactory
      [12:15:03,094,ContainerFactory] Deploying:file:/C:/jboss/deploy/Default/cmp2-example.ear/
      [12:15:03,234,ContainerFactory] Verifying file:/C:/jboss/deploy/Default/cmp2-example.ear/ejb1004.jar
      [12:15:03,244,ContainerFactory] Deploying UserEJB
      [12:15:03,274,ContainerFactory] Deploying CustomerEJB
      [12:15:03,274,ContainerFactory] Deploying OrderEJB
      [12:15:03,284,ContainerFactory] Deploying AddressEJB
      [12:15:03,304,ContainerFactory] Deploying LineItemEJB
      [12:15:03,314,ContainerFactory] Deploying ProductEJB
      [12:15:03,324,ContainerFactory] Deploying ProductCategoryEJB
      [12:15:03,334,ContainerFactory] Deploying EJBTestRunnerEJB
      [12:15:05,017,ContainerFactory] Could not deploy file:/C:/jboss/deploy/Default/cmp2-example.ear/
      org.jboss.ejb.DeploymentException: Error: can't find data source: java:/MSSQL2000DS
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.init(JDBCStoreManager.java:113)
      at org.jboss.ejb.plugins.CMPPersistenceManager.init(CMPPersistenceManager.java:141)
      at org.jboss.ejb.EntityContainer.init(EntityContainer.java:313)
      at org.jboss.ejb.Application.start(Application.java:201)
      at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:382)
      at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:308)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:42)
      [....]

      I'm guessing that there is something else I need to do to setup the new datasource? Can anyone point me in the right direction to see what I'm doing wrong? I've hunted through both the paid and free doco, and cannot see anything I'm missing, so if it a case of RTFM, please point me at the right FM.

      Thanks,
      Geoff.