2 Replies Latest reply on Feb 17, 2002 6:41 PM by glm

    JBoss 3.0 Login Failure

    glm Newbie

      Hi,
      I am trying to use JBoss3.0 with SQLServer2000 and when
      I startup the server I get the following error:


      [23:27:06,751,SQLServerPool] Unable to create ManagedConnection:
      javax.resource.ResourceException: Unable to create DB connection for url: jdbc:merant:sqlserver://localhost:1433;DatabaseName=PayeArchitecture;SelectM
      ethod=cursor, user: paye, exception: java.sql.SQLException: [MERANT][SQLServer JDBC Driver][SQLServer]Login failed for user 'paye'.
      at org.jboss.resource.adapter.jdbc.local.JDBCManagedConnectionFactory.createManagedConnection(JDBCManagedConnectionFactory.java:392)
      at org.jboss.resource.connectionmanager.ManagedConnectionPoolFactory.createObject(ManagedConnectionPoolFactory.java:77)
      at org.jboss.pool.ObjectPool.createNewObject(ObjectPool.java:1010)


      I am using a service.xml file that contains the following lines:


      ConnectionURL=jdbc:merant:sqlserver://localhost:1433;DatabaseName=PayeArchitecture;SelectMethod=cursor
      DriverClass=com.merant.datadirect.jdbc.sqlserver.SQLServerDriver
      UserName=paye
      Password=richrules
      SQLServerPool
      java:/TransactionManager

      <!--Anonymous mbean-ref to database being started -->
      <!--WARNING: DO NOT COPY BLINDLY! This is useful only if the database is
      started by an mbean in the jboss jmx framework! The only example of this
      we have right now is hsqldb! Do not use a line like this for external
      databases. -->
      <!--mbean-ref>JBOSS-SYSTEM:service=SQLServerPool</mbean-ref-->

      <mbean-ref name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter</mbean-ref>
      <mbean-ref name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</mbean-ref>
      #
      #Wed Aug 15 16:17:29 EDT 2001
      MinSize=0
      MaxSize=10
      BlockingTimeoutMillis=5000
      IdleTimeoutMinutes=30
      CleanupIntervalMinutes=10
      MaxIdleTimeoutPercent=1.0


      org.jboss.resource.security.ManyToOnePrincipalMapping


      UserName=paye
      Password=richrules



      The same driver and database works under JBoss2.4.4

      Why am I getting a login error?

      Thanks in advance,

      Gary