Subject RE: [Firebird-Java] Problems with type2 driver
Author Ryan Baldwin
Hi Carsten

>if i use connection string
>jdbc:firebirdsql:native:d:/database/ruebig.gdb (this is for local
databases, normal
>Firebird-Installation, right ?)
>i get the following exception
>org.firebirdsql.jdbc.FBSQLException: Resource Exception. Unable to complete
network
>request to host "d".
>Failed to locate host machine.
>The specified name was not found in the hosts file or Domain Name Services.
>Reason: Unable to complete network request to host "d".
>Failed to locate host machine.
>The specified name was not found in the hosts file or Domain Name Services.
> at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:106)
> at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:218)

This URL looks OK according too the FAQ - this I guess is a bug. If you try
specifying host and port even if they are just loopback and 3050 this should
then work. I will look into this.

>I also tried the embedded Version with a connection string like this:
>jdbc:firebirdsql:embedded:d:/database/ruebig.gdb
>i get the following exception org.firebirdsql.jdbc.FBSQLException: Resource
Exception. >bad parameters on attach or create database
>CHARACTER SET WIN1252 is not defined
>Reason: bad parameters on attach or create database
>CHARACTER SET WIN1252 is not defined
> at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:106)
> at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:218)

I beleive that the problem here is most likley that fbembed.dll is unable to
load
fbintl.dll. At the bottom is some text from a previous post regarding this
issue.


>if i don't specify a character set i get a reproducable crash of the jvm
after some
>time.
>i have attached the error-pid.

Ive looked at the log file and I would say initially that this looks most
likley due
too a problem in fbembed.dll rather then jaybird. I would venture a guess
that it is
related too fbintl.dll not being loaded - I would guess that not many people
end up testing the server without this dll loaded.

So finally - I hope this is of some help - and I will look into the
connection string problem.



>>>>>>>>>>>>>>>>>>FROM PRVIOUS
POST>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>I've made an UDF function. When i put the \UDF directory in the root
>path of my application, it doesn't works. I'm forced to put the UDF
>directory in the \bin of my java installation (C:\Program
>Files\Java\j2re1.4.2_01\bin). Same thing with firebird.msg.

I need too look into some issues regarding this - I'm not entirly sure which
sequence of directories
fbembed.dll runs through and appends '/UDF' too when loading a UDF dll...

You should find though that if the 'launcher' exe is in what you consider
too be the your root directory
then it should work - so for example if you copy java.exe or javaw.exe into
your app's root directory(the same
directory that contains the UDF directory) - and ensure you execute the exe
from that location - it should work.

One might imagine that setting the working directory
should work - but I havent seen this work - the problem presumably down too
where fbembed.dll checks obtains a
list of directories too search.

I'm not sure if simply requiring that the 'laucher' for the java application
be in the root of the fb embedded
directory structure is an acceptable solution - its certainly the simplest
from my perspective and I dont see
a problem with this - But what do you think ?

ps. You should also find a similar problem when fbembed.dll needs to load
the intl dll(s). And this has a similar
solution.
>>>>>>>>>>>>>>>>>>END: FROM PRVIOUS
POST>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Ryan
-----Original Message-----
From: Carsten Schäfer [mailto:ca_schaefer@...]
Sent: 21 January 2004 09:12
To: Java-Firebird
Subject: [Firebird-Java] Problems with type2 driver


Hi,
I want to do some tests with type2 Version of Jaybird, (new CVS-Build,
Firebird 1.5RC8, JDK1.4.2_03,WinXP)
but do not get it working:
if i use connection string
jdbc:firebirdsql:native:d:/database/ruebig.gdb (this is for local databases,
normal Firebird-Installation, right ?)
i get the following exception
org.firebirdsql.jdbc.FBSQLException: Resource Exception. Unable to complete
network request to host "d".
Failed to locate host machine.
The specified name was not found in the hosts file or Domain Name Services.
Reason: Unable to complete network request to host "d".
Failed to locate host machine.
The specified name was not found in the hosts file or Domain Name Services.
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:106)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:218)

I also tried the embedded Version with a connection string like this:
jdbc:firebirdsql:embedded:d:/database/ruebig.gdb
i get the following exception org.firebirdsql.jdbc.FBSQLException: Resource
Exception. bad parameters on attach or create database
CHARACTER SET WIN1252 is not defined
Reason: bad parameters on attach or create database
CHARACTER SET WIN1252 is not defined
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:106)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:218)

How to specify the character-ser for my connections ?
I used lc_ctype=WIN1252 as a property.
if i don't specify a character set i get a reproducable crash of the jvm
after some time.
i have attached the error-pid.

mfg
Carsten Schäfer


Yahoo! Groups Sponsor
ADVERTISEMENT






Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/Firebird-Java/

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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.