Hi David.
Have you checked in an updated sample yet?
The attached sample, which I believe has your suggested changes, still does not work
for me.
I get an "Incomplete Deployment" error, using the rar file supplied by the Firebird
project.
Thanks,
Steve
David Jencks wrote:
> On 2002.07.28 09:03:59 -0400 Stephen Davidson wrote:
>
>>Hi David.
>>
>>Would that be in the MCF or in the FirebirdManager, or both?
>>
>
> More inconsistent programming!!
>
> MCF needs host/3050:/wherever.gdb
>
> FirebirdManager has properties for (badly named) URL (host) and port , and
> the FileName is just the file name.
>
> david
>
>>-Steve
>>
>>David Jencks wrote:
>>
>>
>>>When will I learn to be neater and not leave junk lying around???
>>>
>>>I didn't implement the server and port attributes in the mcf. You have
>>>
>>to
>>
>>>specify them so:
>>>
>>>server/port:/path/to/mydb.gdb
>>>
>>>which is undeniably unusual nonstandard and confusing syntax, but
>>>
>>matches
>>
>>>the native C connection string for firebird.
>>>
>>>david jencks
>>>
--
Java Developer
Looking for a new job opportunity
214-724-7741
<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- ==================================================================== -->
<!-- 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. -->
<!--SPDBUG?
<mbean code="org.firebirdsql.management.FBManager" name="jboss.jca:service=FirebirdManager">
-->
<mbean code="org.firebirdsql.management.FBManager" name="jboss.jca:service=XaTxCM,name=FirebirdDS">
<attribute name="FileName">/home/firebird/mawkercoffee/coffee.gdb</attribute>
<attribute name="UserName">sysdba</attribute>
<attribute name="Password">maucher</attribute>
<attribute name="CreateOnStart">true</attribute>
<attribute name="DropOnStop">false</attribute>
</mbean>
<!-- 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=FirebirdDS</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.
-->
<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>Database</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>test1/3050:/home/firebird/mawkercoffee/coffee.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></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></config-property-value>
</config-property>
</properties>
</attribute>
<!--
<attribute name="JndiName">DefaultDS</attribute>
-->
<attribute name="JndiName">jdbc/CatalogDB</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=CachedConnectionManager</depends>
<!--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:service=JaasSecurityManager</depends>
<attribute name="TransactionManager">java:/TransactionManager</attribute>
</mbean>
</service>
