Hi, I am using SuSE linux 72, and have jdk1.1.3 installed.
My main reason to try hsqldb is to enable http://www.melati.org/ to work with it. I have run into a number of problems: Running with Melati: I created a simple driver for hsql, similar to http://melati.org/cgi-bin/cvsweb.cgi/~checkout~/org/melati/poem/dbms/MySQL.java however I ran into problems with BOOLEAN values, as org/hsqldb/jdbcPreparedStatement has public void setBoolean(int parameterIndex, boolean x) throws SQLException { if (Trace.TRACE) { Trace.trace(); } setParameter(parameterIndex, x ? "TRUE" : "FALSE"); } but TRUE and FALSE are not allowable types ? org.hsqldb.jdbcPreparedStatement@17eded Error reported by jdbc driver Wrong data type: 37000 Wrong data type: TRUE in statement [INSERT INTO "tableinfo" ("id", "name", "displayname", "description", "displayorder", "defaultcanread", "defaultcanwrite", "defaultcandelete", "cancreate", "cachelimit", "seqcached", "category") VALUES (0, 'user', 'User', 'A registered user of the database', 2010, NULL, NULL, NULL, NULL, 100, TRUE, 0)] --- java.sql.SQLException: Wrong data type: 37000 Wrong data type: TRUE in statement [INSERT INTO "tableinfo" ("id", "name", "displayname", "description", "displayorder", "defaultcanread", "defaultcanwrite", "defaultcandelete", "cancreate", "cachelimit", "seqcached", "category") VALUES (0, 'user', 'User', 'A registered user of the database', 2010, NULL, NULL, NULL, NULL, 100, TRUE, 0)] at org.hsqldb.Trace.getError(Trace.java:222) at org.hsqldb.jdbcResultSet.(jdbcResultSet.java:6584) at org.hsqldb.jdbcConnection.executeStandalone(jdbcConnection.java:2939) at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:2528) at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:1795) at org.hsqldb.jdbcStatement.executeUpdate(jdbcStatement.java:227) at org.hsqldb.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.java:419) at org.melati.poem.Table.insert(Table.java:688) When I tried hsqldb/demo/servletdemo.html in konqueror the applet didn't load. I then tried in Netscape 4.7 and got the following error: Netscape Communications Corporation -- Java 1.1.5 Type '?' for options. driver =org.hsqldb.jdbcDriver url =jdbc:hsqldb: database=http://localhost:8081/examples/servlet/hsqlServlet user =sa password= test =true log =true java.lang.NoSuchMethodError: java.sql.DriverManager: method setLogWriter (Ljava/io/PrintWriter;)V not found at org.hsqldb.util.jdbcSystem.setLogToSystem(jdbcSystem.java:85) at org.hsqldb.util.QueryTool.init(QueryTool.java:184) * at netscape.applet.DerivedAppletFrame$InitAppletEvent.dispatch(DerivedAppletFrame.java:553) at java.awt.EventDispatchThread$EventPump.dispatchEvents(EventDispatchThread.java:81) at java.awt.EventDispatchThread.run(EventDispatchThread.java:135) at netscape.applet.DerivedAppletFrame$AppletEventDispatchThread.run(DerivedAppletFrame.java:911) The server also seems to have a problem, I copied runWebServer.bat to runWebServer.sh, changed the OS specific things and ran it but got: ./runWebServer.sh Opening database: test HSQLDB server 1.7.0 is running Press [Ctrl]+[C] to abort WebServer.run/init: java.net.BindException: Address already in use Finally, when I unzipped the distributon it didn't have a top level directory, so I had to delete the src folder, create a hsqldb directopry and unzip in that. What I would really like is for someone who understands hsqldb to join the Melati project, download the CVS tree, and make Melati work with hsqldb - any takers? Thanks for your time and for what looks like a cool product. cheers timp _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
