Hi,

I am trying to connect a schema within a database directly through JDBC with the following Java code. 

Connection con = DriverManager.getConnection("jdbc:monetdb://localhost/testUser", "monetdb", "monetdb");
con.setSchema("schema1");

But this throws the following exception. 
Exception in thread "main" java.sql.SQLException: syntax error, unexpected '=' in: "set schema ="
at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2525)
at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:2273)
at nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.java:497)
at nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:338)
at nl.cwi.monetdb.jdbc.MonetStatement.executeUpdate(MonetStatement.java:533)
at nl.cwi.monetdb.jdbc.MonetConnection.setSchema(MonetConnection.java:1267)
at batcave.Monet.main(Monet.java:11)

Is it really possible to connect to a specific schema? Or the only option is to query as "schemaName.tableName" ??? 



Thanks & Regards,

Vijayakrishna.P.
Mobile : (+91) 9500402305.