Brian, I may have misread your post. I take it you were able to
create your database and tables, read/write data, but not perform
finder functions? If so, I'm in the same boat. See my other post. -
- Wayne.

--- In Firebird-Java@y..., Bryan Napier <bryan_napier@y...> wrote:
> I'm trying to get Firebird 1.0 (Windows) configured
> for JBoss 3.0 RC3 (Windows) using the JCA driver. I
> receive no errors until I execute one of the Finder
> methods of one of my CMP beans. I used the
> firebird-service.xml from docs/examples/jca as a
> template, and tried downloading the latest version
> from CVS to make sure that wasn't the problem. The
> following is the error I receive:
>
> 2002-06-04 09:01:05,283 ERROR
> [org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand]
> Failed to create finder results
> java.sql.SQLException: Problem getting connection:
> javax.resource.ResourceException: Wrong
> ManagedConnectionFactory sent to allocateConnection!
> at
> org.firebirdsql.jdbc.FBDataSource.getConnection
(FBDataSource.java:100)
> at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getConnection
(JDBCCommand.java:694)
> at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute
(JDBCCommand.java:167)
> at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCFinderCommand.execute
(JDBCFinderCommand.java:114)
> at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCFindEntitiesCommand.execute
(JDBCFindEntitiesCommand.java:194)
> at
> org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.findEntities
(JAWSPersistenceManager.java:269)
> at
> org.jboss.ejb.plugins.CMPPersistenceManager.findEntities
(CMPPersistenceManager.java:348)
> at
>
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findE
ntities(CachedConnectionInterceptor.java:284)
> at
> org.jboss.ejb.EntityContainer.find(EntityContainer.java:662)
> at java.lang.reflect.Method.invoke(Native Method)
> at
> org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome
(EntityContainer.java:1116)
> at
> org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome
(EntitySynchronizationInterceptor.java:257)
> at
>
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invok
eHome(CachedConnectionInterceptor.java:176)
> at
> org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome
(EntityInstanceInterceptor.java:134)
> at
> org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome
(EntityLockInterceptor.java:79)
> at
> org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome
(EntityCreationInterceptor.java:44)
> at
> org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:98)
> at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions
(TxInterceptorCMT.java:167)
> at
> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome
(TxInterceptorCMT.java:52)
> at
> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome
(SecurityInterceptor.java:104)
> at
> org.jboss.ejb.plugins.LogInterceptor.invokeHome
(LogInterceptor.java:109)
> at
> org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487)
> at org.jboss.ejb.Container.invoke(Container.java:726)
> at
> org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
> org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:98)
> at
> org.jboss.invocation.InvokerInterceptor.invoke
(InvokerInterceptor.java:102)
> at
> org.jboss.proxy.TransactionInterceptor.invoke
(TransactionInterceptor.java:73)
> at
> org.jboss.proxy.SecurityInterceptor.invoke
(SecurityInterceptor.java:76)
> at
> org.jboss.proxy.ejb.HomeInterceptor.invoke(HomeInterceptor.java:185)
> at
> org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:76)
> at $Proxy35.findAllOpenJobs(Unknown Source)
> at
> com.providicom.jms.JobManagementEJB.findAllOpenJobs
(JobManagementEJB.java:90)
> at java.lang.reflect.Method.invoke(Native Method)
> at
> org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke
(StatelessSessionContainer.java:664)
> at
>
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invok
e(CachedConnectionInterceptor.java:147)
> at
> org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke
(StatelessSessionInstanceInterceptor.java:77)
> at
> org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext
(AbstractTxInterceptor.java:96)
> at
> org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions
(TxInterceptorCMT.java:167)
> at
> org.jboss.ejb.plugins.TxInterceptorCMT.invoke
(TxInterceptorCMT.java:61)
> at
> org.jboss.ejb.plugins.SecurityInterceptor.invoke
(SecurityInterceptor.java:129)
> at
> org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:166)
> at
> org.jboss.ejb.StatelessSessionContainer.invoke
(StatelessSessionContainer.java:313)
> at org.jboss.ejb.Container.invoke(Container.java:705)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
> org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:98)
> at
> org.jboss.invocation.InvokerInterceptor.invoke
(InvokerInterceptor.java:102)
> at
> org.jboss.proxy.TransactionInterceptor.invoke
(TransactionInterceptor.java:73)
> at
> org.jboss.proxy.SecurityInterceptor.invoke
(SecurityInterceptor.java:76)
> at
> org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke
(StatelessSessionInterceptor.java:111)
> at
> org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:76)
> at $Proxy43.findAllOpenJobs(Unknown Source)
> at
>
com.providicom.jms.servlets.JobManagementFindServletSection.processPos
t(JobManagementFindServletSection.java:101)
> at
> com.providicom.jms.servlets.JobManagementFindServletSection.process
(JobManagementFindServletSection.java:43)
> at
> com.providicom.jms.servlets.JobManagementServlet.processRequest
(JobManagementServlet.java:98)
> at
> com.providicom.jms.servlets.JobManagementServlet.handleRequest
(JobManagementServlet.java:38)
> at
> org.apache.velocity.servlet.VelocityServlet.doRequest
(VelocityServlet.java:326)
> at
> org.apache.velocity.servlet.VelocityServlet.doGet
(VelocityServlet.java:287)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.mortbay.jetty.servlet.ServletHolder.handle
(ServletHolder.java:326)
> at
> org.mortbay.jetty.servlet.ServletHandler.handle
(ServletHandler.java:595)
> at
> org.mortbay.http.HttpContext.handle(HttpContext.java:1357)
> at
> org.mortbay.http.HttpContext.handle(HttpContext.java:1309)
> at
> org.mortbay.http.HttpServer.service(HttpServer.java:744)
> at org.jboss.jetty.Jetty.service(Jetty.java:525)
> at
> org.mortbay.http.HttpConnection.service(HttpConnection.java:743)
> at
> org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:916)
> at
> org.mortbay.http.HttpConnection.handle(HttpConnection.java:758)
> at
> org.mortbay.http.SocketListener.handleConnection
(SocketListener.java:145)
> at
> org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:287)
> at
> org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:715)
> at java.lang.Thread.run(Thread.java:484)
> 2002-06-04 09:01:05,283 INFO [STDOUT] Error
> javax.ejb.FinderException: Find failed:
> java.sql.SQLException: Problem getting connection:
> javax.resource.ResourceException: Wrong
> ManagedConnectionFactory sent to allocateConnection!
>
>
>
> This is my firebird-service.xml :
>
> <?xml version="1.0" encoding="UTF-8"?>
>
> <!--
> ====================================================================
> -->
> <!-- New ConnectionManager setup for firebird dbs
> using jca-jdbc xa driver-->
> <!-- Build jmx-api (build/build.sh all) and view for
> config documentation -->
> <!--
> ====================================================================
> -->
>
> <service>
>
> <!--FBManager can be used to create and drop
> databases.
> Drop is especially useful during testing, since it
>
> assures a clean start next time. -->
> <mbean code="org.firebirdsql.management.FBManager"
> name="jboss.jca:service=FirebirdManager">
> <attribute
> name="FileName">c:\cvs\jms\db\JOBS.GDB</attribute>
> <attribute name="UserName">sysdba</attribute>
> <attribute name="Password">masterkey</attribute>
> <attribute name="CreateOnStart">true</attribute>
> <attribute name="DropOnStop">false</attribute>
> </mbean>
>
> <mbean
> code="org.jboss.resource.connectionmanager.XATxConnectionManager"
> name="jboss.jca:service=XaTxCM,name=FirebirdDS">
> <!--make the rar deploy - A BIG HACK till xslt
> based deployment is written-->
> <depends>jboss.jca:service=RARDeployer</depends>
>
> <depends
> optional-attribute-name="ManagedConnectionFactoryName">
> <mbean
> code="org.jboss.resource.connectionmanager.RARDeployment"
> name="jboss.jca:service=XaTxDS,name=FirebirdDS">
> <!--more hack-->
> <depends
> optional-attribute-
name="OldRarDeployment">jboss.jca:service=RARDeployment,name=Firebird
> Database Connector</depends>
> <attribute
> name="ManagedConnectionFactoryProperties">
> <properties>
> <!--config-property>
>
> <config-property-name>Server</config-property-name>
>
> <config-property-type>java.lang.String</config-property-type>
>
> <config-property-value>localhost</config-property-value>
> </config-property>
> <config-property>
>
> <config-property-name>Port</config-property-name>
>
> <config-property-type>java.lang.Integer</config-property-type>
>
> <config-property-value>3050</config-property-value>
> </config-property-->
> <config-property>
>
> <config-property-name>Database</config-property-name>
>
> <config-property-type>java.lang.String</config-property-type>
>
> <config-property-value>c:\cvs\jms\db\JOBS.GDB</config-property-
value>
> </config-property>
> <config-property>
>
> <config-property-name>UserName</config-property-name>
>
> <config-property-type>java.lang.String</config-property-type>
>
> <config-property-value>xxxxxx</config-property-value>
> </config-property>
> <config-property>
>
> <config-property-name>Password</config-property-name>
>
> <config-property-type>java.lang.String</config-property-type>
>
> <config-property-value>xxxxxx</config-property-value>
> </config-property>
> </properties>
> </attribute>
> <attribute name="JndiName">JMS</attribute>
> </mbean>
>
> </depends>
> <depends
> optional-attribute-name="ManagedConnectionPool">
> <mbean
>
code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool"
> name="jboss.jca:service=XaTxPool,name=FirebirdDS">
>
> <attribute name="MinSize">0</attribute>
> <attribute name="MaxSize">50</attribute>
> <attribute
> name="BlockingTimeoutMillis">5000</attribute>
> <attribute
> name="IdleTimeoutMinutes">15</attribute>
> <!--criteria indicates if Subject (from
> security domain) or app supplied
> parameters (such as from
> getConnection(user, pw)) are used to distinguish
> connections in the pool. Choices are
> ByContainerAndApplication (use both),
> ByContainer (use Subject),
> ByApplication (use app supplied params
> only),
> ByNothing (all connections are equivalent,
> usually if adapter supports
> reauthentication)-->
> <attribute
> name="Criteria">ByContainer</attribute>
> </mbean>
> </depends>
> <depends
> optional-attribute-
name="CachedConnectionManager">jboss.jca:service=CachedConnectionManag
er</depends>
> <!-- Include a login module configuration named
> FirebirdDBRealm.
> Update your login-conf.xml, here is an
> example for a
> ConfiguredIdentityLoginModule:
>
> <application-policy name = "FirebirdDBRealm">
> <authentication>
> <login-module code =
> "org.jboss.resource.security.ConfiguredIdentityLoginModule"
> flag = "required">
> <module-option name =
> "principal">sysdba</module-option>
> <module-option name =
> "userName">sysdba</module-option>
> <module-option name =
> "password">masterkey</module-option>
> <module-option name =
> "managedConnectionFactoryName">jboss.jca:service=XaTxCM,name=Firebir
dDS</module-option>
> </login-module>
> </authentication>
> </application-policy>
>
> NOTE: the application-policy name attribute must
> match SecurityDomainJndiName, and the
> module-option name =
> "managedConnectionFactoryName"
> must match the object name of the
> ConnectionManager you are configuring here.
> -->
> <!--comment out this line if you want component
> managed security or want
> to use the default values in the
> ManagedConnectionFactoryProperties -->
> <attribute
> name="SecurityDomainJndiName">FirebirdDBRealm</attribute>
>
> <depends
> optional-attribute-
name="JaasSecurityManagerService">jboss.security:name=JaasSecurityMana
ger</depends>
>
> <attribute
> name="TransactionManager">java:/TransactionManager</attribute>
> </mbean>
>
> </service>
>
> I have not changed the sysdba password for Firebird
> yet (this is on a development workstation, just trying
> to get things working first).
>
> Any help would be much appreciated!
>
> Bryan Napier
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com