I recently discovered your project, and I find it very well, alas I cannot use it because we do not
work with the bases HSQLDB and PostgresSQL.
I tried to add adequate drivers JDBC and to modify the files “properties”, but without success…
I in particular used driver JDBC for mssqlserver 2000 following:
Hi, to use other provider like MSSQLSERVER 2000 and MYSQL you must create the jar that implements some java interface.
At moment i have make 2 interface for hsqldb AND Postgresql.
If you download the source you can look the folder:
/dbinterface_hsqldb
/dinterface_postgresql
And create /dinterface_mssqlserver (with my help).
You can use hsqldb (for small data) it don't need installation.
Or use Postgresql (for me best of mssqlserver) the installation is easy.
However the table create with dataweb, into db are named like Table1, Table2 .... and the column are named like Column1, Column2 ... therefore if you want access on the db table from other software you must create the webservice with dataweb.
Thanks
Danilo Limatola
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I recently discovered your project, and I find it very well, alas I cannot use it because we do not
work with the bases HSQLDB and PostgresSQL.
I tried to add adequate drivers JDBC and to modify the files “properties”, but without success…
I in particular used driver JDBC for mssqlserver 2000 following:
- jfds (jtds-1.2.jar)
- mssqlserver (mssqlserver.jar)
Service “dataweb” at summer of course started again with each modification…
Here an extract of the log:
INFO | jvm 1 | 2007/05/30 08:27: 46 | Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved.
INFO | jvm 1 | 2007/05/30 08:27: 46 |
INFO | jvm 1 | 2007/05/30 08:27: 48 | Loading dbManager hsqldb…
INFO | jvm 1 | 2007/05/30 08:27: 48 | Loaded dbManager hsqldb.
INFO | jvm 1 | 2007/05/30 08:27: 48 | Loading dbManager mssqlserver…
INFO | jvm 1 | 2007/05/30 08:27: 48 | Error load dbManager mssqlserver: ClassNotFoundException
INFO | jvm 1 | 2007/05/30 08:27: 48 | Loading dbManager postgresql74…
INFO | jvm 1 | 2007/05/30 08:27: 48 | Loaded dbManager postgresql74.
INFO | jvm 1 | 2007/05/30 08:27: 48 | Loading dbManager postgresql82…
INFO | jvm 1 | 2007/05/30 08:27: 48 | Loaded dbManager postgresql82.
INFO | jvm 1 | 2007/05/30 08:27: 48 | Server attivo known carried: 7720
Can - you to help me to install required driver JDBC, we usually use a base of data MSSQLSERVER 2000 & MYSQL.
Thank you in advance
Kind regards,
Roland Schaeffer
(roland.schaeffer@free.fr)
Hi, to use other provider like MSSQLSERVER 2000 and MYSQL you must create the jar that implements some java interface.
At moment i have make 2 interface for hsqldb AND Postgresql.
If you download the source you can look the folder:
/dbinterface_hsqldb
/dinterface_postgresql
And create /dinterface_mssqlserver (with my help).
You can use hsqldb (for small data) it don't need installation.
Or use Postgresql (for me best of mssqlserver) the installation is easy.
However the table create with dataweb, into db are named like Table1, Table2 .... and the column are named like Column1, Column2 ... therefore if you want access on the db table from other software you must create the webservice with dataweb.
Thanks
Danilo Limatola