Internal Exception: java.sql.SQLSyntaxErrorException

[Unleash]

Hi !
Here's the code i use to start a javadb server and connect to my database:

NetworkServerControl s;
try {
s= new NetworkServerControl();
s.start(null);

}catch (Exception ex){
System.out.println(ex.getMessage());
}


try{
Connection con = DriverManager.getConnection("jdbc:derby:CRHDatabase", "CRH", "crh");

launch(CRHDatabaseApp.class, args);
}catch (Exception ex){
System.out.println("Erro na execução: " + ex.getMessage());
}


And i got the message:
Internal Exception: java.sql.SQLSyntaxErrorException: O esquema 'CRH' não existe

It means that the schema 'CRH' does'nt exist.
My user name is the same of the schema name, so what can be happenning ?

[benoit_rouleau]

I am not familiar with Derby but using postgres you need to provide a host and a port to the connection string like so:

jdbc:postgresql://localhost:5432/main

Hope this helps

[Unleash]

According to derby's documentation, when using the embedded driver, the connection doesn't need neither host or port !
But thanks anyway !!