Eclipse Community Forums: BIRT » Derby database url, problem or BUG?

Home » Archived » BIRT » Derby database url, problem or BUG?

Derby database url, problem or BUG? [message #181911]

Wed, 02 August 2006 10:06

Eclipse User

Hi all

I have derby database running in server mode at localhost:1527

my database called "pb" is located at c:\program file\common
files\osmosis\paediatric\databases\pd

iIm able to connect to this database using hibernate successful using the
connection url

jdbc:derby://localhost:1527/C:\\Program Files\\Common
Files\\Osmosis\\Paediatric\\databases\\pd;

For some reason Birt's Data explorer does not allow me to create a new data
source using this connection url with the error message:

"The application server rejected establishment of the connection. An attempt
was made to access a database, C:\\Program, which was not found."

Making some test i have found that the problem is the white spaces in url.

When i try to connect to the same database using embedded driver instead of
clientdriver with connection url:

jdbc:derby:C:\\Program Files\\Common
Files\\Osmosis\\Paediatric\\databases\\pd;

I get NO ERRORS and everything works fine

It's a bug in BIRT or something else is happened here?

--
--
Stavros S. Kounis
Osmosis networks & consulting http://www.osmosis.gr
Read my weblog at http://tools.osmosis.gr/blog

Re: Derby database url, problem or BUG? [message #181990 is a reply to message #181911]

Wed, 02 August 2006 14:40

Eclipse User

This sounds like it may be a bug.
Can you log a bugzilla entry.

Jason

"Stavros Kounis" <gounis@clubmobil.com> wrote in message
news:eaqbh0$jrq$1@utils.eclipse.org...
> Hi all
>
>
>
> I have derby database running in server mode at localhost:1527
>
> my database called "pb" is located at c:\program file\common
> files\osmosis\paediatric\databases\pd
>
>
>
> iIm able to connect to this database using hibernate successful using the
> connection url
>
> jdbc:derby://localhost:1527/C:\\Program Files\\Common
> Files\\Osmosis\\Paediatric\\databases\\pd;
>
>
>
> For some reason Birt's Data explorer does not allow me to create a new
> data source using this connection url with the error message:
>
> "The application server rejected establishment of the connection. An
> attempt was made to access a database, C:\\Program, which was not found."
>
>
>
> Making some test i have found that the problem is the white spaces in url.
>
>
>
> When i try to connect to the same database using embedded driver instead
> of clientdriver with connection url:
>
> jdbc:derby:C:\\Program Files\\Common
> Files\\Osmosis\\Paediatric\\databases\\pd;
>
>
>
> I get NO ERRORS and everything works fine
>
>
>
> It's a bug in BIRT or something else is happened here?
>
>
>
> --
> --
> Stavros S. Kounis
> Osmosis networks & consulting http://www.osmosis.gr
> Read my weblog at http://tools.osmosis.gr/blog
>

Re: Derby database url, problem or BUG? [message #182140 is a reply to message #181911]

Wed, 02 August 2006 18:48

Eclipse User

This is a multi-part message in MIME format.

------=_NextPart_000_00DE_01C6B64B.1786CAF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

This is probably a bug in the Derby client driver. You should report =
this to the Apache derby project.
I wonder if specifying the URL as =
"jdbc:derby://localhost:1527/C:\\Program%20Files\\..." will work.

--=20
Gary Xue
Actuate Corporation - Product Development
BIRT Committer

"Stavros Kounis" <gounis@clubmobil.com> wrote in message =
news:eaqbh0$jrq$1@utils.eclipse.org...
> Hi all
>=20
>=20
>=20
> I have derby database running in server mode at localhost:1527
>=20
> my database called "pb" is located at c:\program file\common=20
> files\osmosis\paediatric\databases\pd
>=20
>=20
>=20
> iIm able to connect to this database using hibernate successful using =
the=20
> connection url
>=20
> jdbc:derby://localhost:1527/C:\\Program Files\\Common=20
> Files\\Osmosis\\Paediatric\\databases\\pd;
>=20
>=20
>=20
> For some reason Birt's Data explorer does not allow me to create a new =
data=20
> source using this connection url with the error message:
>=20
> "The application server rejected establishment of the connection. An =
attempt=20
> was made to access a database, C:\\Program, which was not found."
>=20
>=20
>=20
> Making some test i have found that the problem is the white spaces in =
url.
>=20
>=20
>=20
> When i try to connect to the same database using embedded driver =
instead of=20
> clientdriver with connection url:
>=20
> jdbc:derby:C:\\Program Files\\Common=20
> Files\\Osmosis\\Paediatric\\databases\\pd;
>=20
>=20
>=20
> I get NO ERRORS and everything works fine
>=20
>=20
>=20
> It's a bug in BIRT or something else is happened here?
>=20
>=20
>=20
> --=20
> --=20
> Stavros S. Kounis
> Osmosis networks & consulting http://www.osmosis.gr
> Read my weblog at http://tools.osmosis.gr/blog=20
>=20
>
------=_NextPart_000_00DE_01C6B64B.1786CAF0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1555" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>This is probably a bug in the Derby =
client driver.=20
You should report this to the Apache derby project.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I wonder if specifying the URL as=20
"jdbc:derby://localhost:1527/C:\\Program<STRONG>%20</STRONG>Files\\..." =
will=20
work.</FONT></DIV>
<DIV><BR><FONT face=3DArial size=3D2>-- <BR>Gary Xue<BR>Actuate =
Corporation -=20
Product Development<BR>BIRT Committer</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"Stavros Kounis" <</FONT><A=20
href=3D"mailto:gounis@clubmobil.com"><FONT face=3DArial=20
size=3D2>gounis@clubmobil.com</FONT></A><FONT face=3DArial size=3D2>> =
wrote in=20
message </FONT><A href=3D"news:eaqbh0$jrq$1@utils.eclipse.org"><FONT =
face=3DArial=20
size=3D2>news:eaqbh0$jrq$1@utils.eclipse.org</FONT></A><FONT =
face=3DArial=20
size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> Hi all<BR>> =
<BR>>=20
<BR>> <BR>> I have derby database running in server mode at=20
localhost:1527<BR>> <BR>> my database called "pb" is located at =
c:\program=20
file\common <BR>> files\osmosis\paediatric\databases\pd<BR>> =
<BR>>=20
<BR>> <BR>> iIm able to connect to this database using hibernate=20
successful using the <BR>> connection url<BR>> <BR>>=20
jdbc:derby://localhost:1527/C:\\Program Files\\Common <BR>>=20
Files\\Osmosis\\Paediatric\\databases\\pd;<BR>> <BR>> <BR>> =
<BR>>=20
For some reason Birt's Data explorer does not allow me to create a new =
data=20
<BR>> source using this connection url with the error =
message:<BR>>=20
<BR>> "The application server rejected establishment of the =
connection. An=20
attempt <BR>> was made to access a database, C:\\Program, which was =
not=20
found."<BR>> <BR>> <BR>> <BR>> Making some test i have found =
that=20
the problem is the white spaces in url.<BR>> <BR>> <BR>> =
<BR>> When=20
i try to connect to the same database using embedded driver instead of =
<BR>>=20
clientdriver with connection url:<BR>> <BR>> =
jdbc:derby:C:\\Program=20
Files\\Common <BR>> =
Files\\Osmosis\\Paediatric\\databases\\pd;<BR>>=20
<BR>> <BR>> <BR>> I get NO ERRORS and everything works =
fine<BR>>=20
<BR>> <BR>> <BR>> It's a bug in BIRT or something else is =
happened=20
here?<BR>> <BR>> <BR>> <BR>> -- <BR>> -- <BR>> Stavros =
S.=20
Kounis<BR>> Osmosis networks & consulting   </FONT><A=20
href=3D"http://www.osmosis.gr"><FONT face=3DArial=20
size=3D2>http://www.osmosis.gr</FONT></A><BR><FONT face=3DArial =
size=3D2>> Read my=20
weblog=20
at     &nbs p;     &nbs p=
;  =20
</FONT><A href=3D"http://tools.osmosis.gr/blog"><FONT face=3DArial=20
size=3D2>http://tools.osmosis.gr/blog</FONT></A><FONT face=3DArial =
size=3D2> <BR>>=20
<BR>> </FONT></BODY></HTML>

------=_NextPart_000_00DE_01C6B64B.1786CAF0--

Re: Derby database url, problem or BUG? [message #182336 is a reply to message #182140]

Thu, 03 August 2006 03:57

Eclipse User

This is a multi-part message in MIME format.

------=_NextPart_000_000E_01C6B6EB.906D2680
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I dont think it's Derby client driver's bug. My application use this =
connection url through hibernate and work fine. Only under BIRT i have =
faced this problem.

Yes i have try to use %20 instead whitespaces in connection url with no =
success.

--
Stavros

"Gary Xue" <gxue@actuate.com> wrote in message =
news:eara0i$gnl$1@utils.eclipse.org...
This is probably a bug in the Derby client driver. You should report =
this to the Apache derby project.
I wonder if specifying the URL as =
"jdbc:derby://localhost:1527/C:\\Program%20Files\\..." will work.

--=20
Gary Xue
Actuate Corporation - Product Development
BIRT Committer

"Stavros Kounis" <gounis@clubmobil.com> wrote in message =
news:eaqbh0$jrq$1@utils.eclipse.org...
> Hi all
>=20
>=20
>=20
> I have derby database running in server mode at localhost:1527
>=20
> my database called "pb" is located at c:\program file\common=20
> files\osmosis\paediatric\databases\pd
>=20
>=20
>=20
> iIm able to connect to this database using hibernate successful =
using the=20
> connection url
>=20
> jdbc:derby://localhost:1527/C:\\Program Files\\Common=20
> Files\\Osmosis\\Paediatric\\databases\\pd;
>=20
>=20
>=20
> For some reason Birt's Data explorer does not allow me to create a =
new data=20
> source using this connection url with the error message:
>=20
> "The application server rejected establishment of the connection. An =
attempt=20
> was made to access a database, C:\\Program, which was not found."
>=20
>=20
>=20
> Making some test i have found that the problem is the white spaces =
in url.
>=20
>=20
>=20
> When i try to connect to the same database using embedded driver =
instead of=20
> clientdriver with connection url:
>=20
> jdbc:derby:C:\\Program Files\\Common=20
> Files\\Osmosis\\Paediatric\\databases\\pd;
>=20
>=20
>=20
> I get NO ERRORS and everything works fine
>=20
>=20
>=20
> It's a bug in BIRT or something else is happened here?
>=20
>=20
>=20
> --=20
> --=20
> Stavros S. Kounis
> Osmosis networks & consulting http://www.osmosis.gr
> Read my weblog at http://tools.osmosis.gr/blog=20
>=20
>
------=_NextPart_000_000E_01C6B6EB.906D2680
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2912" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I dont think it's Derby client =
driver's bug.=20
My application use this connection url through hibernate and work fine. =
Only=20
under BIRT i have faced this problem.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Yes i have try to use %20 instead =
whitespaces in=20
connection url with no success.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>--</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Stavros</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Gary Xue" <<A =
href=3D"mailto:gxue@actuate.com">gxue@actuate.com</A>>=20
wrote in message <A=20
=
href=3D"news:eara0i$gnl$1@utils.eclipse.org">news:eara0i$gnl$1@utils.ecli=
pse.org</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>This is probably a bug in the Derby =
client=20
driver. You should report this to the Apache derby =
project.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I wonder if specifying the URL as=20
=
"jdbc:derby://localhost:1527/C:\\Program<STRONG>%20</STRONG>Files\\..." =
will=20
work.</FONT></DIV>
<DIV><BR><FONT face=3DArial size=3D2>-- <BR>Gary Xue<BR>Actuate =
Corporation -=20
Product Development<BR>BIRT Committer</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"Stavros Kounis" <</FONT><A=20
href=3D"mailto:gounis@clubmobil.com"><FONT face=3DArial=20
size=3D2>gounis@clubmobil.com</FONT></A><FONT face=3DArial =
size=3D2>> wrote in=20
message </FONT><A href=3D"news:eaqbh0$jrq$1@utils.eclipse.org"><FONT =
face=3DArial=20
size=3D2>news:eaqbh0$jrq$1@utils.eclipse.org</FONT></A><FONT =
face=3DArial=20
size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> Hi =
all<BR>> <BR>>=20
<BR>> <BR>> I have derby database running in server mode at=20
localhost:1527<BR>> <BR>> my database called "pb" is located at=20
c:\program file\common <BR>> =
files\osmosis\paediatric\databases\pd<BR>>=20
<BR>> <BR>> <BR>> iIm able to connect to this database using=20
hibernate successful using the <BR>> connection url<BR>> =
<BR>>=20
jdbc:derby://localhost:1527/C:\\Program Files\\Common <BR>>=20
Files\\Osmosis\\Paediatric\\databases\\pd;<BR>> <BR>> <BR>> =
<BR>>=20
For some reason Birt's Data explorer does not allow me to create a new =
data=20
<BR>> source using this connection url with the error =
message:<BR>>=20
<BR>> "The application server rejected establishment of the =
connection. An=20
attempt <BR>> was made to access a database, C:\\Program, which was =
not=20
found."<BR>> <BR>> <BR>> <BR>> Making some test i have =
found that=20
the problem is the white spaces in url.<BR>> <BR>> <BR>> =
<BR>>=20
When i try to connect to the same database using embedded driver =
instead of=20
<BR>> clientdriver with connection url:<BR>> <BR>>=20
jdbc:derby:C:\\Program Files\\Common <BR>>=20
Files\\Osmosis\\Paediatric\\databases\\pd;<BR>> <BR>> <BR>> =
<BR>>=20
I get NO ERRORS and everything works fine<BR>> <BR>> <BR>> =
<BR>>=20
It's a bug in BIRT or something else is happened here?<BR>> =
<BR>>=20
<BR>> <BR>> -- <BR>> -- <BR>> Stavros S. Kounis<BR>> =
Osmosis=20
networks & consulting   </FONT><A=20
href=3D"http://www.osmosis.gr"><FONT face=3DArial=20
size=3D2>http://www.osmosis.gr</FONT></A><BR><FONT face=3DArial =
size=3D2>> Read=20
my weblog=20
=
at     &nbs p;     &nbs p=
;  =20
</FONT><A href=3D"http://tools.osmosis.gr/blog"><FONT face=3DArial=20
size=3D2>http://tools.osmosis.gr/blog</FONT></A><FONT face=3DArial =
size=3D2>=20
<BR>> <BR>> </FONT></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_000E_01C6B6EB.906D2680--

Re: Derby database url, problem or BUG? [message #182353 is a reply to message #181990]

Thu, 03 August 2006 04:00

Eclipse User

"Jason Weathersby" <jweathersby@actuate.com> wrote in message
news:eaqrjq$7i7$1@utils.eclipse.org...
> This sounds like it may be a bug.
> Can you log a bugzilla entry.
I'll make some more test and i'll create a bugzilla entry.

But, for the moment, has anyone any idea how to by-pass this problem? We are
close to release first our first BETA.

Thanks in advanced

Stavros

>
> Jason
>
> "Stavros Kounis" <gounis@clubmobil.com> wrote in message
> news:eaqbh0$jrq$1@utils.eclipse.org...
>> Hi all
>>
>>
>>
>> I have derby database running in server mode at localhost:1527
>>
>> my database called "pb" is located at c:\program file\common
>> files\osmosis\paediatric\databases\pd
>>
>>
>>
>> iIm able to connect to this database using hibernate successful using the
>> connection url
>>
>> jdbc:derby://localhost:1527/C:\\Program Files\\Common
>> Files\\Osmosis\\Paediatric\\databases\\pd;
>>
>>
>>
>> For some reason Birt's Data explorer does not allow me to create a new
>> data source using this connection url with the error message:
>>
>> "The application server rejected establishment of the connection. An
>> attempt was made to access a database, C:\\Program, which was not found."
>>
>>
>>
>> Making some test i have found that the problem is the white spaces in
>> url.
>>
>>
>>
>> When i try to connect to the same database using embedded driver instead
>> of clientdriver with connection url:
>>
>> jdbc:derby:C:\\Program Files\\Common
>> Files\\Osmosis\\Paediatric\\databases\\pd;
>>
>>
>>
>> I get NO ERRORS and everything works fine
>>
>>
>>
>> It's a bug in BIRT or something else is happened here?
>>
>>
>>
>> --
>> --
>> Stavros S. Kounis
>> Osmosis networks & consulting http://www.osmosis.gr
>> Read my weblog at http://tools.osmosis.gr/blog
>>
>
>

Re: Derby database url, problem or BUG? [message #182573 is a reply to message #182336]

Thu, 03 August 2006 13:44

Eclipse User

This is a multi-part message in MIME format.

------=_NextPart_000_01AB_01C6B6E9.CAF1B070
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Please file a Bugzilla report for the BIRT team to look into this issue.

thanks,

--=20
Gary Xue
Actuate Corporation - Product Development
BIRT Committer
"Stavros Kounis" <gounis@clubmobil.com> wrote in message =
news:easa8k$d4i$1@utils.eclipse.org...
I dont think it's Derby client driver's bug. My application use this =
connection url through hibernate and work fine. Only under BIRT i have =
faced this problem.

Yes i have try to use %20 instead whitespaces in connection url with =
no success.

--
Stavros

"Gary Xue" <gxue@actuate.com> wrote in message =
news:eara0i$gnl$1@utils.eclipse.org...
This is probably a bug in the Derby client driver. You should report =
this to the Apache derby project.
I wonder if specifying the URL as =
"jdbc:derby://localhost:1527/C:\\Program%20Files\\..." will work.

--=20
Gary Xue
Actuate Corporation - Product Development
BIRT Committer

"Stavros Kounis" <gounis@clubmobil.com> wrote in message =
news:eaqbh0$jrq$1@utils.eclipse.org...
> Hi all
>=20
>=20
>=20
> I have derby database running in server mode at localhost:1527
>=20
> my database called "pb" is located at c:\program file\common=20
> files\osmosis\paediatric\databases\pd
>=20
>=20
>=20
> iIm able to connect to this database using hibernate successful =
using the=20
> connection url
>=20
> jdbc:derby://localhost:1527/C:\\Program Files\\Common=20
> Files\\Osmosis\\Paediatric\\databases\\pd;
>=20
>=20
>=20
> For some reason Birt's Data explorer does not allow me to create a =
new data=20
> source using this connection url with the error message:
>=20
> "The application server rejected establishment of the connection. =
An attempt=20
> was made to access a database, C:\\Program, which was not found."
>=20
>=20
>=20
> Making some test i have found that the problem is the white spaces =
in url.
>=20
>=20
>=20
> When i try to connect to the same database using embedded driver =
instead of=20
> clientdriver with connection url:
>=20
> jdbc:derby:C:\\Program Files\\Common=20
> Files\\Osmosis\\Paediatric\\databases\\pd;
>=20
>=20
>=20
> I get NO ERRORS and everything works fine
>=20
>=20
>=20
> It's a bug in BIRT or something else is happened here?
>=20
>=20
>=20
> --=20
> --=20
> Stavros S. Kounis
> Osmosis networks & consulting http://www.osmosis.gr
> Read my weblog at http://tools.osmosis.gr/blog=20
>=20
>
------=_NextPart_000_01AB_01C6B6E9.CAF1B070
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1555" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Please file a Bugzilla report for the =
BIRT team to=20
look into this issue.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>thanks,</FONT></DIV>
<DIV><BR>-- <BR>Gary Xue<BR>Actuate Corporation - Product =
Development<BR>BIRT=20
Committer</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Stavros Kounis" <<A=20
href=3D"mailto:gounis@clubmobil.com">gounis@clubmobil.com</A>> =
wrote in=20
message <A=20
=
href=3D"news:easa8k$d4i$1@utils.eclipse.org">news:easa8k$d4i$1@utils.ecli=
pse.org</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>I dont think it's Derby client =
driver's bug.=20
My application use this connection url through hibernate and work =
fine. Only=20
under BIRT i have faced this problem.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Yes i have try to use %20 instead =
whitespaces in=20
connection url with no success.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>--</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Stavros</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Gary Xue" <<A=20
href=3D"mailto:gxue@actuate.com">gxue@actuate.com</A>> wrote in =
message <A=20
=
href=3D"news:eara0i$gnl$1@utils.eclipse.org">news:eara0i$gnl$1@utils.ecli=
pse.org</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>This is probably a bug in the Derby =
client=20
driver. You should report this to the Apache derby =
project.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I wonder if specifying the URL as=20
=
"jdbc:derby://localhost:1527/C:\\Program<STRONG>%20</STRONG>Files\\..." =
will=20
work.</FONT></DIV>
<DIV><BR><FONT face=3DArial size=3D2>-- <BR>Gary Xue<BR>Actuate =
Corporation -=20
Product Development<BR>BIRT Committer</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"Stavros Kounis" <</FONT><A=20
href=3D"mailto:gounis@clubmobil.com"><FONT face=3DArial=20
size=3D2>gounis@clubmobil.com</FONT></A><FONT face=3DArial =
size=3D2>> wrote in=20
message </FONT><A href=3D"news:eaqbh0$jrq$1@utils.eclipse.org"><FONT =

face=3DArial =
size=3D2>news:eaqbh0$jrq$1@utils.eclipse.org</FONT></A><FONT=20
face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial =
size=3D2>> Hi=20
all<BR>> <BR>> <BR>> <BR>> I have derby database running =
in=20
server mode at localhost:1527<BR>> <BR>> my database called =
"pb" is=20
located at c:\program file\common <BR>>=20
files\osmosis\paediatric\databases\pd<BR>> <BR>> <BR>> =
<BR>> iIm=20
able to connect to this database using hibernate successful using =
the=20
<BR>> connection url<BR>> <BR>>=20
jdbc:derby://localhost:1527/C:\\Program Files\\Common <BR>>=20
Files\\Osmosis\\Paediatric\\databases\\pd;<BR>> <BR>> <BR>> =

<BR>> For some reason Birt's Data explorer does not allow me to =
create a=20
new data <BR>> source using this connection url with the error=20
message:<BR>> <BR>> "The application server rejected =
establishment of=20
the connection. An attempt <BR>> was made to access a database,=20
C:\\Program, which was not found."<BR>> <BR>> <BR>> =
<BR>> Making=20
some test i have found that the problem is the white spaces in =
url.<BR>>=20
<BR>> <BR>> <BR>> When i try to connect to the same =
database using=20
embedded driver instead of <BR>> clientdriver with connection=20
url:<BR>> <BR>> jdbc:derby:C:\\Program Files\\Common <BR>>=20
Files\\Osmosis\\Paediatric\\databases\\pd;<BR>> <BR>> <BR>> =

<BR>> I get NO ERRORS and everything works fine<BR>> <BR>> =
<BR>>=20
<BR>> It's a bug in BIRT or something else is happened =
here?<BR>>=20
<BR>> <BR>> <BR>> -- <BR>> -- <BR>> Stavros S. =
Kounis<BR>>=20
Osmosis networks & consulting   </FONT><A=20
href=3D"http://www.osmosis.gr"><FONT face=3DArial=20
size=3D2>http://www.osmosis.gr</FONT></A><BR><FONT face=3DArial =
size=3D2>> Read=20
my weblog=20
=
at     &nbs p;     &nbs p=
;  =20
</FONT><A href=3D"http://tools.osmosis.gr/blog"><FONT face=3DArial=20
size=3D2>http://tools.osmosis.gr/blog</FONT></A><FONT face=3DArial =
size=3D2>=20
<BR>> <BR>> </FONT></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_01AB_01C6B6E9.CAF1B070--

Re: Derby database url, problem or BUG? [message #183348 is a reply to message #181911]

Tue, 08 August 2006 07:16

Eclipse User

This issue has to do with a derbyclient.jar bug that was fixed in 10.1.3
version and a BIRT's bug that use only the derby's plugin driver
All the story and a way to fixed temporary is described in a bugzilla entry
[1] called "Derdy DB - Connection url with whitespaces"

[1] https://bugs.eclipse.org/bugs/show_bug.cgi?id=152709

--
stavros

"Stavros Kounis" <gounis@clubmobil.com> wrote in message
news:eaqbh0$jrq$1@utils.eclipse.org...
> Hi all
>
>
>
> I have derby database running in server mode at localhost:1527
>
> my database called "pb" is located at c:\program file\common
> files\osmosis\paediatric\databases\pd
>
>
>
> iIm able to connect to this database using hibernate successful using the
> connection url
>
> jdbc:derby://localhost:1527/C:\\Program Files\\Common
> Files\\Osmosis\\Paediatric\\databases\\pd;
>
>
>
> For some reason Birt's Data explorer does not allow me to create a new
> data source using this connection url with the error message:
>
> "The application server rejected establishment of the connection. An
> attempt was made to access a database, C:\\Program, which was not found."
>
>
>
> Making some test i have found that the problem is the white spaces in url.
>
>
>
> When i try to connect to the same database using embedded driver instead
> of clientdriver with connection url:
>
> jdbc:derby:C:\\Program Files\\Common
> Files\\Osmosis\\Paediatric\\databases\\pd;
>
>
>
> I get NO ERRORS and everything works fine
>
>
>
> It's a bug in BIRT or something else is happened here?
>
>
>
> --
> --
> Stavros S. Kounis
> Osmosis networks & consulting http://www.osmosis.gr
> Read my weblog at http://tools.osmosis.gr/blog
>

Previous Topic:	Zooming the Chart image
Next Topic:	Source code for BIRT example Reports

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 30 01:32:36 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter