Date: 2011-12-06 21:43:49 +0100
From: Shantanu Kumar <<shantanu_k06>>
To: clients devs <>
Version: 11.9.7 (Apr2012-SP2) [obsolete]

Last updated: 2012-07-17 15:34:13 +0200

Comment 16605

Date: 2011-12-06 21:43:49 +0100
From: Shantanu Kumar <<shantanu_k06>>

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_2) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.121 Safari/535.2
Build Identifier:

MonetDB being Open Source database doesn't have the the JDBC drivers uploaded to a Maven repository. This causes hassle for projects that fetch dependencies from the Internet.

Please consider uploading JDBC drivers to Maven Central (or suitable repository) as and when they are released.

Reproducible: Always

Steps to Reproduce:

1. Try to use MonetDB JDBC driver as a Maven dependency.

Actual Results:

JDBC driver not found on any Maven repository.

Expected Results:

JDBC driver should be available on Maven Central (or an appropriate Maven repo.)

Comment 16606

Date: 2011-12-06 21:57:37 +0100
From: @grobian

can you give an example?

Comment 16609

Date: 2011-12-07 08:57:02 +0100
From: Shantanu Kumar <<shantanu_k06>>

(In reply to comment 1)

can you give an example?

Examples below:

The Maven coordinates for various versions of MySQL can be found here:
http://mvnrepository.com/artifact/mysql/mysql-connector-java

Similarly, Maven coordinates for MckoiDDB v1.0.2 are here:
http://mvnrepository.com/artifact/mckoi/mckoi/1.0.2

Typically Maven Central http://search.maven.org/ is the place where all Open Source projects upload their project JARs. However, uploading artifacts to Maven Central can be fairly involved. Hence, another simpler option is to upload to Clojars http://clojars.org/ -- that is what the Open Source CUBRID database uses too:
http://www.cubrid.org/cubrid_java_programming
http://clojars.org/cubrid/cubrid-jdbc

Fabian Groffen: Does that answer your question?

Comment 16614

Date: 2011-12-07 14:41:05 +0100
From: @grobian

(In reply to comment 2)

Fabian Groffen: Does that answer your question?

Yes it does. Thank you. We're completely unknown with this system. I looked at clojars, but it doesn't really look like a place to upload anything to, but rather a database system of itself?

Comment 16619

Date: 2011-12-07 15:51:04 +0100
From: Shantanu Kumar <<shantanu_k06>>

(In reply to comment 3)

(In reply to comment 2)

Fabian Groffen: Does that answer your question?

Yes it does. Thank you. We're completely unknown with this system. I looked
at clojars, but it doesn't really look like a place to upload anything to, but
rather a database system of itself?

Okay, I will be happy to help. I am explaining the steps below to upload artifacts to Clojars. I am going to assume you are using some variant of UNIX. (If you are on Windows you may like to use TortoiseGit's built-in SSH and SCP commands instead of the OpenSSH package.) The example below is for MonetDB JDBC version 1.19 -- please use appropriate version number as necessary in your case.

1. First, you should have your SSH public key created and handy (one-time activity):
   http://rcsg-gsir.imsb-dsgi.nrc-cnrc.gc.ca/documents/internet/node31.html

2. Then you will need to register on Clojars (one-time activity):
   http://clojars.org/register

3. You will have to create a pom.xml file for the JDBC JAR file, which should look as follows (one-time activity):

(When doing it for the first time, you may like to consider renaming the file to monetdb-jdbc-1.19.jar as a standard practice, and edit the artifactId as monetdb-jdbc and version as 1.19 instead of 1.19-jdbc. This is the style that Maven recommends though it allows other styles too.)

4.0.0
monetdb
monetdb
1.19-jdbc
monetdb
MonetDB JDBC driver


central
http://repo1.maven.org/maven2


clojars
http://clojars.org/repo/

3a. You should update the version of the JDBC driver in pom.xml file every time you want to upload a new version of the JAR.

4. To upload the JDBC driver JAR to Clojars, run the shell command below:
   $ scp pom.xml monetdb-1.19-jdbc.jar clojars@clojars.org:

(Note that there is a colon after clojars.org hostname.)

I hope this was clear. Should you need more details or explanation please let me know.

Comment 16620

Date: 2011-12-07 16:55:24 +0100
From: @grobian

ok, thank you very much!

I'll look if we can make this update part of our release process.

Comment 16632

Date: 2011-12-08 15:01:28 +0100
From: @grobian

Changeset fa7a8c7e896b made by Fabian Groffen fabian@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=fa7a8c7e896b

Changeset description:

JDBC: change naming scheme to something more standard

As noted in bug #2943, we use a rather unusal naming scheme for our JDBC
driver.  It was based on what the PostgreSQL folks did.

With the change from a JDBCv3 to a JDBCv4 driver, we bumped the major
version, and also take the opportunity to change the naming scheme into
something more common: monetdb-jdbc-2.0.jar.

Comment 16633

Date: 2011-12-08 15:28:07 +0100
From: @grobian

Aparently it is as simple as it looks:
https://clojars.org/monetdb/monetdb-jdbc

Comment 16642

Date: 2011-12-08 20:19:13 +0100
From: Shantanu Kumar <<shantanu_k06>>

(In reply to comment 7)

Aparently it is as simple as it looks:
https://clojars.org/monetdb/monetdb-jdbc

That's awesome - thanks! You may like to put up the Clojars link (mentioning "Maven Dependency") on the Downloads page for everybody to know:
http://www.monetdb.org/Downloads

Comment 16643

Date: 2011-12-08 20:21:26 +0100
From: @grobian

yup, I'll keep this bug open until we sorted that out

Comment 17493

Date: 2012-07-17 15:34:13 +0200
From: @grobian

It's now on http://dev.monetdb.org/downloads/Java/Latest/