I have been down this painfull road already. Trying to understand the
connection process looking at the firebird code is a nightmare. It seems
however for windows no username / password is required on establishing the
connection to the server only on opening the database.

The XML in firebird-services file is very sensitive to exactly how you lay
out the user name and password here is a sample for the firebird-service.XML
file which works with the alpha version 3 of JBOSS on a few machines:


<server>



<!-- ====================================================================
-->
<!-- Example ConnectionFactoryLoader for Firebird jca-jdbc connector
-->
<!-- Put firebirdsql.rar in deploy also.
-->
<!-- ====================================================================
-->


<mbean code="org.jboss.resource.ConnectionFactoryLoader"
name="JCA:service=ConnectionFactoryLoader,name=FirebirdDS">
<attribute
name="ManagedConnectionFactoryProperties">Database=localhost/3050:c:\databas
es\htmlengine.gdb</attribute>
<attribute name="JndiName">HtmlEngineDS</attribute>
<attribute
name="TransactionManagerName">java:/TransactionManager</attribute>
<mbean-ref
name="ResourceAdapterName">JCA:service=RARDeployment,name=Firebird Database
Connector</mbean-ref>
<mbean-ref
name="ConnectionManagerFactoryLoaderName">JCA:service=ConnectionManagerFacto
ryLoader,name=MinervaXACMFactory</mbean-ref>
<attribute name="ConnectionManagerProperties">#
BlockingTimeoutMillis=500000
IdleTimeoutMinutes=30
MaxSize=10
CleanupIntervalMinutes=30
MinSize=0
MaxIdleTimeoutPercent=1.0
</attribute>
<attribute name="PrincipalMappingClass">
org.jboss.resource.security.ManyToOnePrincipalMapping
</attribute>
<attribute name="PrincipalMappingProperties">UserName=SYSDBA
password=masterkey</attribute>
</mbean>

</server>

Hope this is of some help, PS case also seems to be an issue

Andrew

A developer from Sunny Suth Africa
-----Original Message-----
From: patcom123 [mailto:lister-filter@...]
Sent: Monday, January 28, 2002 10:35 AM
To: IB-Java@yahoogroups.com
Subject: [IB-Java] Re: Firebirdsql and Jboss Connection pooling, how to
use it?

--- In IB-Java@y..., "patcom123" <lister-filter@p...> wrote:
>
> > I've managed to get tomcat to start and get a connection from the
> > resource, but if i try and use the connection (executeQuery) i
get
> a
> > ResourceException (Unable to start local transaction - from
> memory).
> > Any clues?
>
> Having read through previous mails it seems that the url is
probably
> wrong - i'll check this later...

Just been playing with the code last night and it seems to be an
authentication problem (invalid username/password, see db
administrator). I am running under windows (me). However, if i run my
old jdbc 1 style code and create a connection, it works fine. One
thing i noted (although i am probably wrong) is that connect in
GDS_Impl, doesn't seem to use the supplied user information?

Apologies, i have left the full error/debugging text at home, but can
bring it in if needed. I might get to play with it again tonight.

JOHN


To unsubscribe from this group, send an email to:
IB-Java-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/