Hello everyone,
I was wondering if anyone has run into the same problem I am currently
having when using jiql to run simple database commands. I have posted
a section of my code below (which is as far as I can tell just like
the examples posted on the website). The initial connection to
jiqlservlet appears to be fine (using the connect method), however the
problem occurs when I attempt to execute a SQL statement. I've shown
the code below that gives the problems. When the execute method is
called on the Statement object, a long sequence of method calls lead
into the Apache Commons classes. The sequence of events leading up to
the error is:
java.net.Socket.tryAllAddresses
java.net.InetAddress.getAllByName
java.net.InetAddress.getAllByNameImpl
java.net.InetAddress.lookupHostByName
At which point an UnknownHostException is generated, which has
something to do with trying to get the IP of the host. Anyone have
any idea what I might be doing incorrectly?
Thanks
String loc = "jdbc:jiql:
https://anxietynetdatabase.appspot.com/
jiqlservlet";
Properties props = new Properties();
props.put("user","admin");
props.put("password", "jiql");
Class c = Class.forName("org.jiql.jdbc.Driver");
Driver driver = (Driver)c.newInstance();
Connection conn = null;
conn = driver.connect(loc,props);
Statement Stmt = conn.createStatement();
Stmt.execute("CREATE table users (username varchar(20),password
varchar(20),email varchar(20))");