Subject Re: firebird datasource & Sun Java application server 8 PE
Author jan_hradek
Dear Roman,

thank you for the fast response. In the previous conf. file I have
filled all possible parameters for datasource to eliminate
so "wrong" default parameter. But I obtain the same error message
for this minimal configuration:

<property name="UserName" value="SYSDBA"/>
<property name="LoginTimeout" value="5000"/>
<property name="UserName" value="SYSDBA"/>
<property name="MaxSize" value="5"/>
<property name="MinSize" value="1"/>
<property name="LoginTimeout" value="5000"/>
<property name="Database"
value="localhost/3050:c:/data/ejb_experiment.gdb"/>
<property name="Password" value="masterkey"/>
<property name="Pooling" value="true"/>
<property name="IdleTimeoutMinutes" value="35"/>
<property name="Database"
value="localhost/3050:c:/data/ejb_experiment.gdb"/>
<property name="Password" value="masterkey"/>
<property name="Pooling" value="true"/>

this is very strange for me, when write the DataSource connection in
standalone Java App, it is working fine.

Thank you, Jan


--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:
> Hi,
>
> > several days I spend with trying to create the connection to
> > Firebird 1.0.0.338 from Sun Java System Application server. When
I
> > try to get the connection from data source, I receive this error
> > message:
> >
> > Connection could not be allocated because: Resource Exception.
> > unrecognized database parameter block Reason: unrecognized
database
> > parameter block
>
> Why do you specify tpbMapping parameter to be "1"? It is the
resource
> bundle name with TPB mappings. Also idleTimeout and
> idleTimeoutInMinutes are the same property that uses different time
> units. Only one is needed. Also, check if you have role
called "USER",
> otherwise remove this property.
>
> > when I remove the conf. parameter MinSize or set it to 0. I
obtain
> > this error message:
> >
> > Target exception message: Connection could not be allocated
because:
> > Could not obtain connection during blocking timeout (5000 ms)
> >
> > is there any way to find the reason of the timeout above ?
>
> Because it could not obtain connection because of the previous
reason.
> I will add logging into the warn level of log4j.
>
> Roman