Access HSQLDB

Hello,

I am a junior developer of wildfire sever (The sever which we are using runs on a LAN).

I am trying to connect a java application to the HSQLDB, but failed to create a socket

(SQL Exception: error with the creation of socket).

We have created two users using ‘‘wildfire’’ as an administrator.

These ongoing are the codes which i ran in platform.

import java.sql.*;

public class collegamento {

private static String id = “SA”;

private static String ps = “”;

private static String url=null;

public static void main(String args[]){

try{

Class.forName(“org.hsqldb.jdbcDriver”);

System.out.println(“Driver loaded”);

Connection c = DriverManager.getConnection"jdbc:hsqldb:hsql://localhost/wildfire", “sa”, “”);

System.out.println(“Connected”);

}catch(SQLException se){

System.out.println("SQL exception: "+se.getMessage());

}catch(Exception e){

System.out.println("Exception: "+e.getMessage() + " - " +e.getClass());

}

}

}

Thanks for any information!

Hey Vito,

The HSQLDB is being used as an embedded DB. That means that other processes are not allowed to connect to the database. If you need to access to the DB wihle the server is running to perform some (read-only) queries then I would recommend using a stand-alone database like mysql, postgres, oracle, etc… Queries that modify db data while Wildfire is running are highly discouraged since Wildfire caches information.

Regards,

– Gato

Hi Gato,

Thank you for attention and responding!

Best regards!