config file contents
mattcolgan Aug 15, 2002 11:13 PMI am using JBoss 3.01 and JDK 1.3.1_04. I do have servlets connecting to Firebird with straight JDBC connections, so I am inclined to think the problem is either with my setup in the attached configs or in the driver...
<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 -->
<!--
==================================================================== -
->
<!--FBManager can be used to create and drop databases.
Drop is especially useful during testing, since it
assures a clean start next time. -->
<!--
c:\firebird\data\test1_db.gdb
sysdba
super666
false
false
-->
<!--make the rar deploy - A BIG HACK till xslt based deployment
is written-->
jboss.jca:service=RARDeployer
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--more hack-->
<depends optional-attribute-
name="OldRarDeployment">jboss.jca:service=RARDeployment,name=Firebird
Database Connector
<!--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>localhost/c:\\firebird\\data\\test_db.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>sysdba</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>masterkey</config-property-value>
</config-property>
FirebirdService
<depends optional-attribute-name="ManagedConnectionPool">
0
50
5000
15
<!--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)-->
ByContainer
<depends optional-attribute-
name="CachedConnectionManager">jboss.jca:service=CachedConnectionManag
er
<!-- Include a login module configuration named FirebirdDBRealm.
Update your login-conf.xml, here is an example for a
ConfiguredIdentityLoginModule:
<application-policy name = "FirebirdDBRealm">
<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>
</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 -->
java:/jaas/FirebirdDBRealm
<depends optional-attribute-
name="JaasSecurityManagerService">jboss.security:name=JaasSecurityMana
ger
java:/TransactionManager
<ra.xml> (in firebirdsql.rar)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE connector PUBLIC "-//Sun Microsystems, Inc.//DTD Connector
1.0//EN" "file:///usr/java/jca/connector_1_0.dtd">
<!-- DOCTYPE connector PUBLIC"-//Sun Microsystems, Inc.//DTD
Connector 1.0//EN" "http://java.sun.com/dtd/connector_1_0.dtd"-->
<display-name>Firebird Database Connector</display-name>
<vendor-name>David Jencks</vendor-name>
<spec-version>1.0</spec-version>
<eis-type>Relational Database</eis-type>
1.0
<managedconnectionfactory-
class>org.firebirdsql.jca.FBManagedConnectionFactory</managedconnectio
nfactory-class>
<connectionfactory-
interface>javax.sql.DataSource</connectionfactory-interface>
<connectionfactory-impl-
class>org.firebirdsql.jdbc.FBDataSource</connectionfactory-impl-class>
<connection-interface>java.sql.Connection</connection-interface>
<connection-impl-
class>org.firebirdsql.jdbc.FBConnection</connection-impl-class>
<transaction-support>XATransaction</transaction-support>
<config-property>
<config-property-name>Database</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-
value>localhost/c:\\firebird\\data\\test_db.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>sysdba</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>super666</config-property-value>
</config-property>
<config-property>
<config-property-name>BlobBufferLength</config-property-name>
<config-property-type>int</config-property-type>
<config-property-value></config-property-value>
</config-property>
<authentication-mechanism>
<authentication-mechanism-type>BasicPassword</authentication-
mechanism-type>
<credential-
interface>javax.resource.security.PasswordCredential</credential-
interface>
</authentication-mechanism>
<reauthentication-support>false</reauthentication-support>
<added to login-config.xml>
<application-policy name = "FirebirdDBRealm">
<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>
</application-policy>