1. It seems the column type in your table is not BIT which we use for
BOOLEAN. The following statements all work in our DB Manager and have been
tested via JDBC as well (upper case use of TRUE and FALSE is also supported)
create table t(b bit);
insert into t(b) values(true);
insert into t(b) values('true');
insert into t(b) values(1);
insert into t(b) values(false);
insert into t(b) values('false');
insert into t(b) values(0);
2. SetLogWriter() is a JAVA2 method and is not available in Java 1.1.5 used
in Netscape. Should compile for JDK 1.1.8. Also you should be running the
servlet mode server using a application server such as Tomcat at the same
time.
3. You were running the web server on the default port which is being used
by another process in your computer.
4. That's a good point. We assume that the user extracts the archive in a
top level directory but he won't know until he has done it.
5. Anyone with some spare time ?
Fred Toussi
----- Original Message -----
From: "Tim Pizey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 23 May 2002 13:37
Subject: [Hsqldb-developers] Problems getting started
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.j
ava
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:41
9)
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(DerivedAppletFra
me.java:553)
at
java.awt.EventDispatchThread$EventPump.dispatchEvents(EventDispatchThread.ja
va:81)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:135)
at
netscape.applet.DerivedAppletFrame$AppletEventDispatchThread.run(DerivedAppl
etFrame.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
_______________________________________________________________
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
