I'm having some problems configuring Firebird as the JBoss MQ persistence, JBoss 3.2.7, using the Firebird RAR. I think it's my connection factory deployment, and how that gets referenced in the state-service and jdbc2-service xmls.
My connection factory looks like this: <connection-factories> | <tx-connection-factory> | <jndi-name>jdbc/triversity/transactionware/2.5.2.0.315/FirebirdJMSDS</jndi-name> | <!--<local-transaction/>--> | <adapter-display-name>Firebird Database Connector</adapter-display-name> | <config-property name="Database" type="java.lang.String">localhost/3050:c:/fbdb/te_jms.gdb</config-property> | <user-name>trivers</user-name> | <password>odyssey</password> | <config-property name="TransactionIsolationName">TRANSACTION_READ_COMMITTED</config-property> | <min-pool-size>2</min-pool-size> | <prepared-statement-cache-size>5</prepared-statement-cache-size> | <track-connection-by-tx>true</track-connection-by-tx> | </tx-connection-factory> | </connection-factories> When I reference this in my firebird-jdbc2-service.xml, I do the following: <mbean code="org.jboss.mq.pm.jdbc2.PersistenceManager" | name="jboss.mq:service=PersistenceManager"> | <depends optional-attribute-name="ConnectionManager">jboss.jca:service=TxCM,name=jdbc/triversity/transactionware/2.5.2.0.315/FirebirdJMSDS</depends> | ...... | </...> Similarly, I did the same for firebird-jdbc-state-service.xml. When I tried this, it seems to connect to the database fine, but the results earlier in a transaction are not found later in the transaction. I enabled MQ tracing, and it inserts to JMS_MESSAGES fine, but when it goes to delete the same transaction, it gets 0 results found. I also found that I couldn't set "CREATE_TABLES_ON_STARTUP" to true, because, again, the creation would work, but the very next set of statements to the database would get "table JMS_MESSAGES doesn't exist". So, I'm thinking I'm doing something wrong in my "ConnectionManager" setting. Is there a difference when the database is configured in a ConnectionFactory instead of a data source? BTW, I tried setting <local-transaction/>, and it made no appreciable difference. Let me know if posting the trace log would help. Thanks in advance, Rick View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3940470#3940470 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3940470 ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
