[firebird-support] FB 3.0 Multiuser Environment

[Hugo Eyng hugoe...@msn.com [firebird-support]]

Hello.

I am testing FB 3.0.0.31374 BETA.
Instalation Classic
Database size 4 gigabytes
Delphi 2007

Windows 2008 Server Enterprise Edition 32 bits
16 gigabytes RAM
800 gigabytes HD Raid 10

When I try to open the database in a second session I get the error message:

Servidor de banco de dados não foi encontrado! *(Database server not found)*
I/O error during "CreateFile (open)" operation for file 
"C:\TEXTIL\DADOS\DM\SGBT\DADOS\DATAMAIS.FDB" *(Entire path for my database)*

Error while trying to open file
O arquivo já está sendo usado por outro processo. *(File is in use by 
another process) *


So my application cannot be opened by two or more users. Even using 
IBExpert, I cannot open the same database more than one time.


Did anybody faced this situation?

--
 Atenciosamente,

Hugo Eyng

Re: [firebird-support] URGENT - Help

['m...@lawinegevaar.nl' m...@lawinegevaar.nl [firebird-support]]

Actually, not entirely, format would be either 
jdbc:firebirdsql:hostname/port:path-to-db or 
jdbc:firebirdsql://hostname:port/path-to-db.
Where path-to-db is either an alias or an absolute or relative path. Which on 
Unix might lead to a double slash with the second url format.

Mark

- Reply message -
Van: "'m...@lawinegevaar.nl' m...@lawinegevaar.nl [firebird-support]" 

Aan: 
Onderwerp: [firebird-support] URGENT - Help
Datum: vr, dec. 19, 2014 21:08

Good thought! Technically without the slash should work as long as the location 
of the database is relative to the firebird root directory iirc, and otherwise 
you should get a different error.
Mark


- Reply message -
Van: "'Dr. Boris Neubert' om...@online.de [firebird-support]" 

Aan: 
Onderwerp: [firebird-support] URGENT - Help
Datum: vr, dec. 19, 2014 20:52












 




 

The connection string
we are using
is:

2014-12-15
11:29:12,357
DEBUG DefaultQuartzScheduler_Worker-1
IN_ADT_A04 - Using source
connection URL: jdbc:firebirdsql:10.112.33.3/3050:work/banco/sghdados.718


















Looks to me as if it should be



jdbc:firebirdsql:10.112.33.3:3050/work/banco/sghdados.718



Cheers,

Boris

Re: [firebird-support] URGENT - Help

['m...@lawinegevaar.nl' m...@lawinegevaar.nl [firebird-support]]

Good thought! Technically without the slash should work as long as the location 
of the database is relative to the firebird root directory iirc, and otherwise 
you should get a different error.
Mark

- Reply message -
Van: "'Dr. Boris Neubert' om...@online.de [firebird-support]" 

Aan: 
Onderwerp: [firebird-support] URGENT - Help
Datum: vr, dec. 19, 2014 20:52

 




 

The connection string
we are using
is:

2014-12-15
11:29:12,357
DEBUG DefaultQuartzScheduler_Worker-1
IN_ADT_A04 - Using source
connection URL: jdbc:firebirdsql:10.112.33.3/3050:work/banco/sghdados.718


















Looks to me as if it should be



jdbc:firebirdsql:10.112.33.3:3050/work/banco/sghdados.718



Cheers,

Boris

Re: [firebird-support] URGENT - Help

['Dr. Boris Neubert' om...@online.de [firebird-support]]

>  
>  
>
> Theconnection string we are using is:
> 2014-12-15 11:29:12,357 DEBUG DefaultQuartzScheduler_Worker-1
> IN_ADT_A04 - Using source connection URL:
> jdbc:firebirdsql:10.112.33.3/3050:work/banco/sghdados.718
> 
>
Looks to me as if it should be

jdbc:firebirdsql:10.112.33.3:3050/work/banco/sghdados.718

Cheers,
Boris

Re: [firebird-support] URGENT - Help

['m...@lawinegevaar.nl' m...@lawinegevaar.nl [firebird-support]]

Are you sure you're connecting to firebird, and not to Interbase? The error 
suggests that firebird is returning an incorrect version string.something that 
is highly unlikely.
Otherwise, post more details, including the stacktrace to the firebird-java 
mailing list.

I probably won't be able to respond earlier then tomorrow: I am sending this 
from the pub...

Mark

- Reply message -
Van: "William Renato Lopes williamrenatolo...@gmail.com [firebird-support]" 

Aan: 
Onderwerp: [firebird-support] URGENT - Help
Datum: vr, dec. 19, 2014 16:38

Good
afternoon.


 


We are trying to connect to a firebird classic server 2.5.2.26.540
64 bits, a
client through jaybird-full-2.2.2.jar driver, but
is returning the following error:


2014-12-15 11:30:08,777 ERROR DefaultQuartzScheduler_Worker-1
DBException - Error
getting Connection.


org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544339.
information type inappropriate for object specified


Version string does not match
expected format


Expected engine version format: -...



 


The connection string we are using
is:

2014-12-15
11:29:12,357 DEBUG DefaultQuartzScheduler_Worker-1 IN_ADT_A04 - Using source
connection URL: jdbc:firebirdsql:10.112.33.3/3050:work/banco/sghdados.718



Can you tell us what we should do to make it work?



Thank you.


 




 

 

William Lopes

Integration Consultant

[firebird-support] URGENT - Help

[William Renato Lopes williamrenatolo...@gmail.com [firebird-support]]

Good afternoon.






We are trying to connect to a firebird classic server 2.5.2.26.540 64 bits, a
client through *jaybird-full-2.2.2.jar* driver, but is returning the following
error:


2014-12-15 11:30:08,777 ERROR DefaultQuartzScheduler_Worker-1 DBException -
Error getting Connection.


org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544339. information
type inappropriate for object specified


Version string does not match expected format


Expected engine version format: -... 






The connection string we are using is:
2014-12-15 11:29:12,357 DEBUG DefaultQuartzScheduler_Worker-1 IN_ADT_A04 -
Using source connection URL: jdbc:firebirdsql:
10.112.33.3/3050:work/banco/sghdados.718


Can you tell us what we should do to make it work?


Thank you.












William Lopes
Integration Consultant

Re: Odp: [firebird-support] FB server installation a nd concurrent users limits on Windows Server

[af_12...@yahoo.com [firebird-support]]

Hi Mark
 it is possible to use and external usb drive to try a test?
  
 i were reading lot of documentats (if i am not wrong , also some official FB 
papers) where is specified to do not use for DB integrity in case of "disaster" 
any write cache options
  
 for now , on the server , obviusly , both disk have disabled that option
 just wondering wich server that is used only for DB pourposes does it , to 
have write cache enabled

Re: [firebird-support] UDF for linux 64 bit compiled with Freepascal 2.6.4

[Roland Turcan k...@rotursoft.sk [firebird-support]]