3 Replies Latest reply on Apr 12, 2005 9:52 PM by Adrian Brock

    JBoss + SQLBase + EntityBeans

    Patrik Meisinger Newbie

      hi!

      i'm trying to configure jboss in a way to use it with the gupta sqlbase database.

      in this forum i found out, that i have to create a datasource-mapping and datatype mappings for the jdbc-driver.

      although i'm trying hard, i was not able to get running config-files (sqlbase-ds.xml, standardjbosscmp-jdbc.xml, standardjaws.xml, login-config.xml). do i miss something else?

      please provide information about proper config-files for sqlbase. maybe a few users among the forum guests already have a running config.

      thanks in adavance!

      best regards
      patrik meisigner

        • 1. Re: JBoss + SQLBase + EntityBeans
          Patrik Meisinger Newbie

          problem already fixed...

          i had my <type-mapping>...</type-mapping> tag outside the <type-mappings>...</type-mappings> tag.

          best regards
          patrik meisinger

          • 2. Re: JBoss + SQLBase + EntityBeans
            Patrik Meisinger Newbie

            but i got another problem:

            14:38:23,442 INFO [LocalTxConnectionManager] getManagedConnection returning unassociated connection
            14:38:23,492 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=SampleEjb,service=EJB
            org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (org.jboss.util.NestedSQLException: Apparently wrong driver class specified for URL: class: jdbc.gupta.sqlbase.SqlbaseDriver, url: jdbc:sqlbase://localhost:2155/ISLAND; - nested throwable: (javax.resource.ResourceException: Apparently wrong driver class specified for URL: class: jdbc.gupta.sqlbase.SqlbaseDriver, url: jdbc:sqlbase://localhost:2155/ISLAND))
            at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:67)
            at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.(JDBCEntityBridge.java:103)
            at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:397)
            at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:339)
            at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
            at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
            at org.jboss.ejb.Container.invoke(Container.java:756)
            at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1058)

            ... I SKIPPED THE REST OF THE ERROR MESSAGES

            a copy of SQLBaseJDBC.jar is in the jboss/server/lib directory, so i don't know what's the reason of this message.

            during the install of the sqlbase-jdbc-driver i recognized that a path variable was created which points to the installation-directory. with or without this path-variable, the above mentioned error still exists. so that can't be the reason.

            a simple java application with a jdbc connection already works with the following settings:
            connection-url: jdbc:sqlbase://localhost:2155/ISLAND
            driver-class: jdbc.gupta.sqlbase.SqlbaseDriver

            what am i missing?

            best regards
            patrik meisinger

            ps.: i'm using jboss 3.0.3, sqlbase 9.0 with it's jdbc-driver. my developer tools are eclipse 3.0 including the lomboz 3.1 plugin.

            • 3. Re: JBoss + SQLBase + EntityBeans
              Adrian Brock Master

              Moderated: Post CMP questions in the CMP forum.