The correct SQL syntax should be the following:

set schema schema1;

I am not familiar with JDBC, but you can try to just execute this query instead of using the setSchema shortcut.

Regards,
Robin

On 14-10-15 08:39, Vijay Krishna wrote:

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.
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list