#22 Sql type of data

[William]

Hello guy,

I have a sql syntax error with my config. The data type not corresponding, i want an integer but a string was search.

I use psql (9.1.13) and Java Whois Server 0.4.1.1

My config :

db.objectlist=domain;nameserver;

db.domain.table=domain
db.domain.objectlookup=domain
db.domain.qfield=name
db.domain.key=id
db.domain.display=name
db.domain.whereaddition=

db.nameserver.table=dns_domain
db.nameserver.objectlookup=nameserver
db.nameserver.qfield=domain_id
db.nameserver.key=dns.id
db.nameserver.tablejoin=\ JOIN dns ON dns.id = dns_domain.dns_id
db.nameserver.display=nameserver

My tables :

domain :
id | integer
name | text

dns_domain :
domain_id | integer
dns_id | integer

dns :
id | integer
nameserver | text

The query generate by jwhoisserver for nameserver :
SELECT dns.id, nameserver FROM dns_domain JOIN dns ON dns.id = dns_domain.dns_id WHERE domain_id = $1

The error :
ERROR: operator does not exist: integer = character varying at character 98

Thx for help

[Klaus Zerwes zero-sys.net]

Seems a bug in the pg jdbc driver ...
Using the same cfg on mysql runs without error.
Will investigate some more time on it ...

[William]

Hello,

I have solve this bug with cast on var like this :

db.nameserver.qfield=domain_id::text