[MonetDB-users] Connecting to MonetDB servers using JDBC

9 Aug 2007

      Hi,
I'm trying to connect to the Monetdb using Java on Linux (Ubuntu 7.04/i386).

I used the example java program given on the MonetDB site.
$ javac -cp jdbcclient-1.6.jar:. MJDBCTest.java
$ java -cp jdbcclient-1.6.jar:. MJDBCTest

I'm getting a persistent error:.
Exception in thread "main" java.sql.SQLException:
java.net.URISyntaxException: Expected scheme name at index 0:
:monetdb://127.0.0.1:50002/mytest2?lang=sql&user=monetdb
        at nl.cwi.monetdb.jdbc.MonetConnection.<init>(MonetConnection.java:217)
        at nl.cwi.monetdb.jdbc.MonetDriver.connect(MonetDriver.java:157)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at MJDBCTest.main(MJDBCTest.java:14)

The Java code is attached below for reference:

import java.sql.*;^M
public class MJDBCTest {^M
        public static void main(String[] args) throws Exception {^M
                // make sure the driver is loaded^M
                Class.forName("nl.cwi.monetdb.jdbc.MonetDriver");^M
                Connection con =
DriverManager.getConnection("jdbc:monetdb://localhost/mytest2",
"monetdb", "monetdb");^M
                Statement st = con.createStatement();^M
                ResultSet rs;^M
^M
                rs = st.executeQuery("SELECT * from foobar");^M
                // get meta data and print columns with their type^M
                ResultSetMetaData md = rs.getMetaData();^M
                for (int i = 1; i <= md.getColumnCount(); i++) {^M
                        System.out.print(md.getColumnName(i) + ":" +^M
                                md.getColumnTypeName(i) + "\t");^M
                }^M
                System.out.println("");^M
                // print the data: only the first 5 rows, while there
probably are^M
                // a lot more. This shouldn't cause any problems
afterwards since the^M
                // result should get properly discarded on the next query^M
                for (int i = 0; rs.next() && i < 5; i++) {^M
                        for (int j = 1; j <= md.getColumnCount(); j++) {^M
                                System.out.print(rs.getString(j) + "\t");^M
                        }^M
                        System.out.println("");^M
                }^M
^M
                // tell the driver to only return 5 rows, it can
optimize on this^M
                // value, and will not fetch any more than 5 rows.^M
                //st.setMaxRows(5);^M
                // we ask the database for 22 rows, while we set the
JDBC driver to^M
                // 5 rows, this shouldn't be a problem at all...^M
                rs = st.executeQuery("select * from foobar  limit 2");^M
                // read till the driver says there are no rows left^M
                for (int i = 0; rs.next(); i++) {^M
                        System.out.print("[" + rs.getString(1) + "]");^M
                        System.out.print("[" + rs.getString(2) + "]\n");^M
                        ^M
                }^M
                con.close();^M
        }^M
}

-- 
Home: http://btbytes.com
Heart: http://sampada.net

[MonetDB-users] Connecting to MonetDB servers using JDBC

Pradeep Gowda