journal whith postgres db

[Santiago Begué]

When i try to do the journal whith the postgres i'm getting:
java.sql.SQLException: No suitable driver

My driver version is jdbc7.0-1.2.jar and it's installed at $JAVA_HOME/lib/ext/

resource/psql-journal.properties
   type=jdbc
   dbUser=babel
   dbPassword=babel
   dbUrl=jdbc://postgresql://192.168.1.2/babel_journal
   dbDriver=org.postgresql.Driver

journal/config.properties
   journalType=postgresql
   resourceName=psql-journal

[Santiago Begué]

There is a mistake in psql-journal.properties:
dbUrl ==> jdbc:postgresql://192.168.1.2/babel_journal is the correct one.
Once corrected this mistake I'm getting another error.
I've modified the sql for postgres and added de table_key table:
          Table "journal"
  Attribute   |  Type   | Modifier
--------------+---------+----------
jrn_log_id   | integer | not null
jrn_log_step | integer | not null
jrn_data     | bytea   |
Index: journal_pkey

       Table "journal_data"
  Attribute   |  Type   | Modifier
--------------+---------+----------
jda_log_id   | integer | not null
jda_log_step | integer | not null
jda_name     | text    | not null
jda_value    | text    |
Index: journal_data_pkey

             Table "log"
   Attribute    |  Type   | Modifier
----------------+---------+----------
log_id         | integer | not null
log_step       | integer | not null
log_operation  | text    | not null
log_datetime   | bigint  | not null
log_other_data | text    |
log_pipeline   | text    |
log_additional | text    |
Index: log_pkey

   Sequence "log_seq"
   Attribute   |  Type
---------------+---------
sequence_name | name
last_value    | integer
increment_by  | integer
max_value     | integer
min_value     | integer
cache_value   | integer
is_cycled     | char
is_called     | char

          Table "table_key"
   Attribute    |  Type   | Modifier
----------------+---------+----------
key_table_name | text    | not null
key_val        | integer | not null
Index: table_key_pkey

Now, my error is :
java.sql.SQLException: java.lang.NullPointerException
    at com.babeldoc.sql.journal.PostgreSqlJournal.writeDelta(Unknown Source)

[Michael Ansley]

Does the stage generating the error have a zero-size document, or a missing document?  It looks like a bug in the code, but if you can confirm that there is a null document, then it will make finding it faster.

[Santiago Begué]

It's not a problem whith the document. The key journalAddBlankDataRow-postgresql is null in sql/config/query.properties.
I've added this key whith the value: insert into journal values (?, ?, ?).
Now i'm getting this error:
java.sql.SQLException: ERROR:  Attribute 'jrn_data' is of type 'bytea' but expression is of type 'int4'
        You will need to rewrite or cast the expression

It's all.