I have been trying to get the gangster example working with MS SQL Server 2000, but am having problems connecting to the database. A brief snapshot of the output is shown below:
-- START OUTPUT --
20:53:33,406 WARN [ServiceController] Problem starting service jboss.j2ee:jndiN
org.jboss.deployment.DeploymentException: Error while fixing table name; - neste
d throwable: (org.jboss.util.NestedSQLException: Could not create connection; -
nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]Cannot open database requested in login 'jboss_odbc'. Login fail
s.); - nested throwable: (org.jboss.resource.ResourceException: Could not create
connection; - nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2
000 Driver for JDBC][SQLServer]Cannot open database requested in login 'jboss_od
bc'. Login fails.)))
-- END OUTPUT --
The examples worked fine, when I used the default Hypersonic database. I have also tried using BMP with SQLServer, in some of my earlier examples, and everything worked fine, in that I was able to establish a database connection, modify data etc. My only problem is with CMP and SQLServer.
I've tried looking through the forums for any similar problems, but to avail. I would be very grateful for any help on this subject.
Thanks in advance,