--- David Jencks <[EMAIL PROTECTED]>
wrote:
> Can you show the windows ConnectionManager config
> that isn't working?
>
Yes :
<?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>
<mbean code="org.firebirdsql.management.FBManager"
name="jboss.jca:service=FirebirdManager">
<attribute
name="FileName">c:\databases\ejb.gdb</attribute>
<attribute name="UserName">sysdba</attribute>
<attribute name="Password">masterkey</attribute>
<attribute name="CreateOnStart">true</attribute>
<attribute name="DropOnStop">false</attribute>
</mbean>
<!--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.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:\databases\ejb.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>
</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>
<!-- 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.
-->
<!--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=JaasSecurityManager</depends>
<attribute
name="TransactionManager">java:/TransactionManager</attribute>
</mbean>
</service>
And the error message I got when I try to use the
connection :
2002-05-22 10:05:14,851 DEBUG
[org.jboss.resource.connectionmanager.IdleRemover]
internalRegisterPool: registering pool with interval
900000 old interval: 9223372036854775807
2002-05-22 10:05:14,851 DEBUG
[org.jboss.resource.connectionmanager.IdleRemover]
internalRegisterPool: about to notify thread: old
next: 1022073164851, new next: 1022073164851
2002-05-22 10:05:21,661 INFO
[org.firebirdsql.jca.FBManagedConnectionFactory] Could
not get a db connection!
org.firebirdsql.gds.GDSException:
at
org.firebirdsql.jgds.GDS_Impl.connect(GDS_Impl.java:1240)
at
org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:263)
at
org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:247)
Andre S.
__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
_______________________________________________________________
Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
