> For the complete documentation index, see [llms.txt](https://ciusji.gitbook.io/guinsoo/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://ciusji.gitbook.io/guinsoo/guides/tutorial/clients-for-guinsoo/java.md).

# Java

If you are using Guinsoo **`org.guinsoo.Driver`** and the URL starts with **`jdbc:gusinsoo:`** , we recommended using it directly in embedded mode. However, you can also use it in server mode with different dialogs, e.g. PostgreSQL, MySQL, DB2, Oracle, Derby, MSSQL,  and so on.

## The Embedded Mode

```java
Class.forName("org.guinsoo.Driver");
// Mem or file can be used.
Connection conn = DriverManager.getConnection("jdbc:guinsoo:mem:");
Statement stat = conn.createStatement();

stat.execute("select 1+2");

stat.close();
conn.close();
```

## The Server Mode

If you are using it in server mode, all the dialogs, such as PostgreSQL, MySQL, DB2, Oracle, Derby, and MSSQL, all clients of the dialogs can be used.