JBoss + SQLBase + EntityBeans

[mistamoasn]

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

[mistamoasn]

problem already fixed...

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

best regards
patrik meisinger

[mistamoasn]

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.

[adrian.brock]

Moderated: Post CMP questions in the CMP forum.