[Dart] problem with Dart2 and PostgreSQL (long)

Ted Berg tberg at vivox.com
Wed Oct 24 13:42:20 EDT 2007


How solid is the Postgres support in Dart2?  I'm running into problems 
setting up a Postgres based project and would like to know if they are 
self inflicted or not.

First the Schema.sql file generated for my project seems to have a 
number of tables created with duplicate primary keys.

For example:
=====
   create table clientproperty (
     ClientPropertyId bigserial primary key primary key,
   ...
=====

I've gone through the file and removed all of these duplicates, and the 
database now initializes correctly.  When I attempt to start the 
dartboard project I get the following error:
=====
<24 Oct 2007 13:33:04,523> [main] ERROR dart.server.Server
   Error starting project pgsdk
java.lang.NullPointerException
   at 
org.postgresql.jdbc2.DatabaseMetaData.getTables(DatabaseMetaData.java:1707)
   at dart.server.Project.verifyDatabaseVersion(Project.java:292)
   at dart.server.Server.start(Server.java:352)
   at dart.server.Server.start(Server.java:228)
   at dart.DartServer.main(DartServer.java:159)
<24 Oct 2007 13:33:04,523> [main] FATAL dart.DartServer
   Failed to start DartServer see previous messages
=====

The database and tables do appear to exist:
=====
13:38:48 tberg at glamdring ~/tmp/Dart1.0.9
$ psql -l
         List of databases
    Name    |  Owner   | Encoding
-----------+----------+----------
  pgsdk     | root     | UTF8
  postgres  | postgres | UTF8
  template0 | postgres | UTF8
  template1 | postgres | UTF8
  vivox     | root     | UTF8
(5 rows)

13:39:23 tberg at glamdring ~/tmp/Dart1.0.9
$ psql pgsdk
Welcome to psql 8.1.10, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
        \h for help with SQL commands
        \? for help with psql commands
        \g or terminate with semicolon to execute query
        \q to quit

pgsdk=# \dt;
             List of relations
  Schema |      Name      | Type  | Owner
--------+----------------+-------+-------
  public | client         | table | tberg
  public | clientproperty | table | tberg
  public | completedtask  | table | tberg
  public | note           | table | tberg
  public | relatedtest    | table | tberg
  public | result         | table | tberg
  public | submission     | table | tberg
  public | taskqueue      | table | tberg
  public | test           | table | tberg
  public | track          | table | tberg
  public | version        | table | tberg
(11 rows)

pgsdk=# \q
13:39:40 tberg at glamdring ~/tmp/Dart1.0.9
$
=====


More information about the Dart mailing list