1 package org.simantics.jdbc;
3 import org.simantics.databoard.Bindings;
4 import org.simantics.db.Resource;
5 import org.simantics.db.WriteGraph;
6 import org.simantics.db.exception.DatabaseException;
7 import org.simantics.db.layer0.util.Layer0Utils;
8 import org.simantics.db.layer0.variable.Variable;
9 import org.simantics.db.layer0.variable.Variables;
10 import org.simantics.layer0.Layer0;
13 * Simantics JDBC facade.
15 * @author Jani Simomaa
17 public class SimanticsJDBC {
19 public static final String PROP_SIMANTICS_JDBC_PROPERTYFILE = "simantics.jdbc.propertyfile";
20 public static final String PROP_SIMANTICS_JDBC_HOST = "simantics.jdbc.host";
21 public static final String PROP_SIMANTICS_JDBC_PORT = "simantics.jdbc.port";
22 public static final String PROP_SIMANTICS_JDBC_USER = "simantics.jdbc.user";
23 public static final String PROP_SIMANTICS_JDBC_PASSWORD = "simantics.jdbc.password";
24 public static final String PROP_SIMANTICS_JDBC_DATABASE = "simantics.jdbc.database";
26 public static String createJDBCSession(WriteGraph graph, String sessionGUID) throws DatabaseException {
27 Resource projects = graph.getResource("http://Projects");
28 Resource documentSessions = Layer0Utils.getPossibleChild(graph, projects, "DocumentSessions");
29 Layer0 L0 = Layer0.getInstance(graph);
30 Resource documentSession = Layer0Utils.getPossibleChild(graph, documentSessions, sessionGUID);
32 String sessionId = "http://Projects/DocumentSessions/" + sessionGUID + "/__jdbc__";
34 JDBCResource JDBC = JDBCResource.getInstance(graph);
35 Resource jdbcSession = graph.newResource();
36 graph.claim(jdbcSession, L0.InstanceOf, JDBC.Session);
37 graph.claimLiteral(jdbcSession, L0.HasName, L0.NameOf, L0.String, "__jdbc__", Bindings.STRING);
38 graph.claim(documentSession, L0.ConsistsOf, jdbcSession);
40 @SuppressWarnings("unused")
41 Variable jdbcState = Variables.getVariable(graph, jdbcSession);