db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Francois Orsini" <francois.ors...@gmail.com>
Subject Re: SQuirrel SQl Client not connect my derby database
Date Mon, 07 May 2007 06:52:23 GMT
Has Derby been started in server mode? if not then you might want to connect
to an embedded Derby instance running in the same space as SQuirreL. You
would then need to use a different URL for that such as:
jdbc:derby:sample

Hope this helps

On 5/4/07, mfa <mfahimaamir@yahoo.com> wrote:
>
>
>
> sir i install the SQuirrel SQl Client
>
> but when i create connection and press test button then that give me this
> error
>
> Unexpected Error occured attempting to open an SQL connection.
>
> appachi derby client need this info
> jdbc:derby://<server>[:<port>]/<databaseName>[;<URL attribute>=<value>]
>
> appachi derby embedded need this info
> jdbc:derby:<database>[;create=true]
>
>
>
> and i provide this
>
> jdbc:derby://localhost:21527/sample
>
> userid=travel
> passward=travel
>
> but when i press test button then system give me this error
>
> Unexpected Error occured attempting to open an SQL connection.
>
>
>
> i not install appachi server is requir
>
> please give me idea
>
> thank
>
>
> aamir
>
>
> Imran Hussain wrote:
> >
> > Hi,
> >
> > I am not quite sure what you mean by "any tool". You will never be able
> > to open a Derby DB with Toad or SQLDeveloper because do not not work
> > with Derby. The only tools you will be open Derby with are the ones that
> > use JDBC. SquirrelSQL and JaySQL are one of them.
> >
> > What is your final goal? Perhaps if you can elaborate on that someone
> > will be able to give you a better suggestion.
> >
> > Imran.
> >
> > mfa wrote:
> >> thank you imran bhai for your reply
> >>
> >> but i wand open my derby travel database in any tool i intall winsql
> but
> >> odbc not provide derby name in database list
> >>
> >> pleae give me idea how i open  my derby travel database in any tool
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> Imran Hussain wrote:
> >>
> >>> Toad and SQL developer does not use JDBC and Derby is only available
> >>> through JDBC or ODBC. What is wrong with Squirrel SQL? You could also
> >>> try JaySQL at http://synametrics.com
> >>>
> >>> Imran.
> >>>
> >>> mfa wrote:
> >>>
> >>>> please send me derby graphic user interfase software such as toad and
> >>>> sqldevloper
> >>>>
> >>>> thank's
> >>>> aamir
> >>>>
> >>>>
> >>>>
> >>>> Dyre.Tjeldvoll wrote:
> >>>>
> >>>>
> >>>>> mfa <mfahimaamir@yahoo.com> writes:
> >>>>>
> >>>>>
> >>>>>
> >>>>>> thank you for your reply
> >>>>>>
> >>>>>> sir any derby graphic user interfase software such as toad and
> >>>>>> sqldevloper
> >>>>>>
> >>>>>> please send me link for download
> >>>>>>
> >>>>>>
> >>>>> So are you saying that the two links you just received were of no
> use
> >>>>> to you? If so, could you please explain why?
> >>>>>
> >>>>> --
> >>>>> dt
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/give-me-derby-gui-link-%28how-i-add-new-table-in-derby-tf3680375.html#a10322535
> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>
>

Mime
View raw message