All geek questions in one place

Is it now possible to use derby from apache in Eclipse when they stopped developing the derby plugin for Eclipse?

I would like to use Derby from apache to enable database management in the desktop application that I am currently developing.

Unfortunately, I realized that they stopped developing this plugin, and all the training materials that I read on the Internet relate to this plugin.

So my question is: how can I use the latest Derby on eclipse? What steps should I follow? I would like my application to be standalone and easily portable.

early

+1
source share
3 answers

Apache Derby is similar to other databases that provide an interface through JDBC. You do not need a special plugin to connect to Derby. Just use regular JDBC routines.

The main steps:

  • If you want to use the latest version of Derby, you first need to download it from here
  • You need to include the jar in your class path.
  • You just need to connect and execute queries using JDBC, as best explained in the Oracle JDBC Tutorial .
+3
source

Ditto pram.

I am using Derby in a Java application that I am developing using Eclipse and I did not know that there is a plugin. I connect to Derby, like to any other database. I am using Derby command line interface to manage tables. \

(One feature of another db that I would like to see in Derby is the presence of SQL extensions for displaying db metadata, such as show and describe MySql commands. Derby has them in the command line interface, usually implemented there, rather than in the SQL processor itself, so you cannot use them outside the CLI. Bummer. When I do development, I often create a special query screen in the application that allows me to enter and execute arbitrary queries. (And no, I don’t post it on the public websites.) But I'm distracted.)

I do not know what the plugin does for you. I have never used the Eclipse plugin for any database.

+1
source

The plugin is still available in its original form, and instructions for creating it are available on the Derby website: http://svn.apache.org/viewvc/db/derby/code/trunk/plugins/eclipse/Readme.txt?view = markup

From time to time instructions for creating a plugin change; you can check the status of this problem for further updates: https://issues.apache.org/jira/browse/DERBY-5272

0
source

Source: https://habr.com/ru/post/920059/

More articles:


All Articles