JDBC Driver

Help
rspty
2007-05-30
2013-04-16
  • rspty
    rspty
    2007-05-30

    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