You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Scott Abfalter <ab...@airnetcom.com> on 2005/11/21 22:42:53 UTC
Database query tool with API for use with Derby in embedded mode
I am looking for advice on any open-source or products out there that may
help solve a problem.
We are replacing our aged Informix database with the much better Apache
Derby database. We are running in an embedded mode.
What we are looking for is a database browser tool that will allow us to
query and perform operations on the database (sort of like dbaccess for
Informix, or any number of the JDBC aware database browsing tools out
there). Except that we want to be able to run this within the JVM that is
maintaining the connection to the embedded database.
We do not wish to run in a client-server mode. If we were, then we could
use any JDBC based tool. But in this case our preference is to run in an
embedded mode and so any tool would have to be invokable from our
application. I understand that I will have to write come code to make this
happen.
If anyone knows of a 3rd party tool that would be easy to integrate then I
would be interested in hearing about it. The alternative is to the
command-line interface (or a nicer browser tool) only when our application
is offline, and that would not be preferable.
Scott Allen Abfalter
AirNet Communications, Inc.
THIS E-MAIL MAY CONTAIN PRIVILEGED, CONFIDENTIAL, COPYRIGHTED, OR OTHER
LEGALLY PROTECTED INFORMATION. IF YOU ARE NOT THE INTENDED RECIPIENT
(EVEN IF THE E-MAIL ADDRESS ABOVE IS YOURS), YOU MAY NOT USE, COPY
OR RETRANSMIT IT. IF YOU HAVE RECEIVED THIS BY MISTAKE, OR WISH TO BE
REMOVED FROM A MAILING LIST, PLEASE NOTIFY US BY RETURN E-MAIL AT
POSTMASTER@AIRNETCOM.COM, THEN DELETE. THANK YOU.
Re: Database query tool with API for use with Derby in embedded mode
Posted by Francois Orsini <fr...@gmail.com>.
Have you looked at SQuirreL?
It is ( 2.0RC1 minimum) supposed to work with Derby and it is written in
Java.
http://squirrel-sql.sourceforge.net/
More instructions on how to set-it up to work with Embedded Derby here:
http://www-128.ibm.com/developerworks/forums/dw_thread.jsp?forum=370&message=13742269&thread=89920&cat=19
On 11/21/05, Imran Hussain <im...@imranweb.com> wrote:
>
> Try JaySQL from http://synametrics.com.
>
> Scott Abfalter wrote:
>
> >I am looking for advice on any open-source or products out there that may
> >help solve a problem.
> >
> >We are replacing our aged Informix database with the much better Apache
> >Derby database. We are running in an embedded mode.
> >
> >What we are looking for is a database browser tool that will allow us to
> >query and perform operations on the database (sort of like dbaccess for
> >Informix, or any number of the JDBC aware database browsing tools out
> >there). Except that we want to be able to run this within the JVM that is
> >maintaining the connection to the embedded database.
> >
> >We do not wish to run in a client-server mode. If we were, then we could
> >use any JDBC based tool. But in this case our preference is to run in an
> >embedded mode and so any tool would have to be invokable from our
> >application. I understand that I will have to write come code to make
> this
> >happen.
> >
> >If anyone knows of a 3rd party tool that would be easy to integrate then
> I
> >would be interested in hearing about it. The alternative is to the
> >command-line interface (or a nicer browser tool) only when our
> application
> >is offline, and that would not be preferable.
> >
> >Scott Allen Abfalter
> >AirNet Communications, Inc.
> >
> >
> >
> >
> >
> >THIS E-MAIL MAY CONTAIN PRIVILEGED, CONFIDENTIAL, COPYRIGHTED, OR OTHER
> >LEGALLY PROTECTED INFORMATION. IF YOU ARE NOT THE INTENDED RECIPIENT
> >(EVEN IF THE E-MAIL ADDRESS ABOVE IS YOURS), YOU MAY NOT USE, COPY
> >OR RETRANSMIT IT. IF YOU HAVE RECEIVED THIS BY MISTAKE, OR WISH TO BE
> >REMOVED FROM A MAILING LIST, PLEASE NOTIFY US BY RETURN E-MAIL AT
> > POSTMASTER@AIRNETCOM.COM, THEN DELETE. THANK YOU.
> >
> >
> >
>
Re: Database query tool with API for use with Derby in embedded mode
Posted by Imran Hussain <im...@imranweb.com>.
Try JaySQL from http://synametrics.com.
Scott Abfalter wrote:
>I am looking for advice on any open-source or products out there that may
>help solve a problem.
>
>We are replacing our aged Informix database with the much better Apache
>Derby database. We are running in an embedded mode.
>
>What we are looking for is a database browser tool that will allow us to
>query and perform operations on the database (sort of like dbaccess for
>Informix, or any number of the JDBC aware database browsing tools out
>there). Except that we want to be able to run this within the JVM that is
>maintaining the connection to the embedded database.
>
>We do not wish to run in a client-server mode. If we were, then we could
>use any JDBC based tool. But in this case our preference is to run in an
>embedded mode and so any tool would have to be invokable from our
>application. I understand that I will have to write come code to make this
>happen.
>
>If anyone knows of a 3rd party tool that would be easy to integrate then I
>would be interested in hearing about it. The alternative is to the
>command-line interface (or a nicer browser tool) only when our application
>is offline, and that would not be preferable.
>
>Scott Allen Abfalter
>AirNet Communications, Inc.
>
>
>
>
>
>THIS E-MAIL MAY CONTAIN PRIVILEGED, CONFIDENTIAL, COPYRIGHTED, OR OTHER
>LEGALLY PROTECTED INFORMATION. IF YOU ARE NOT THE INTENDED RECIPIENT
>(EVEN IF THE E-MAIL ADDRESS ABOVE IS YOURS), YOU MAY NOT USE, COPY
>OR RETRANSMIT IT. IF YOU HAVE RECEIVED THIS BY MISTAKE, OR WISH TO BE
>REMOVED FROM A MAILING LIST, PLEASE NOTIFY US BY RETURN E-MAIL AT
> POSTMASTER@AIRNETCOM.COM, THEN DELETE. THANK YOU.
>
>
>