JBoss 3.0 Login Failure
garymarsh Feb 16, 2002 2:39 AMHi,
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