0 Replies Latest reply on Jun 5, 2003 4:16 PM by jayson_d

    Problem with Gangster example and MS SQLServer 2000

    jayson_d Newbie

      Hi All,

      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
      ame=crimeportal/Organization,service=EJB
      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.)))
      at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:67)
      at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.(JDBCEnt
      ityBridge.java:103)

      -- 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,

      Jayson_d