Subject | Re: firebird datasource & Sun Java application server 8 PE |
---|---|
Author | jan_hradek |
Post date | 2004-05-10T08:36:24Z |
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:
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,I
>
> > several days I spend with trying to create the connection to
> > Firebird 1.0.0.338 from Sun Java System Application server. When
> > try to get the connection from data source, I receive this errordatabase
> > message:
> >
> > Connection could not be allocated because: Resource Exception.
> > unrecognized database parameter block Reason: unrecognized
> > parameter blockresource
>
> Why do you specify tpbMapping parameter to be "1"? It is the
> bundle name with TPB mappings. Also idleTimeout andcalled "USER",
> idleTimeoutInMinutes are the same property that uses different time
> units. Only one is needed. Also, check if you have role
> otherwise remove this property.obtain
>
> > when I remove the conf. parameter MinSize or set it to 0. I
> > this error message:because:
> >
> > Target exception message: Connection could not be allocated
> > Could not obtain connection during blocking timeout (5000 ms)reason.
> >
> > is there any way to find the reason of the timeout above ?
>
> Because it could not obtain connection because of the previous
> I will add logging into the warn level of log4j.
>
> Roman