JBuilder 4 QDS problem

Hi,

Anyone using the Query Dataset that JBuilder 4.0 provided? I am using PostgreSQL 7.2 with the latest JDBC driver, I defined a table with some NUMERIC fields, e.g. NUMERIC(12,4). When I use the qds to get the data from database, it has no problem. But when I want to save the data using the qds, it cannot run with success. The qds will detect a wrong field type for the numeric field and save fail. The program is working on DB2 with related JDBC driver. Anyone can help?

The exception:
com.borland.dx.sql.dataset.ResolutionException: An error occurred deleting a row in the "po_hdr" table, RmiDbOperation.java:449 (2002-02-03 12:01:58,310)
See com.borland.dx.sql.dataset.ResolutionException error code: BASE+2
com.borland.dx.sql.dataset.ResolutionException: An error occurred deleting a row in the "po_hdr" table
at com.borland.dx.sql.dataset.ResolutionException.a(Unknown Source)
at com.borland.dx.sql.dataset.ResolutionException.a(Unknown Source)
at com.borland.dx.sql.dataset.l.a(Unknown Source)
at com.borland.dx.sql.dataset.QueryResolver.deleteRow(Unknown Source)
at com.borland.dx.sql.dataset.ResolutionManager.a(Unknown Source)
at com.borland.dx.sql.dataset.ResolutionManager.d(Unknown Source)
at com.borland.dx.sql.dataset.ResolutionManager.c(Unknown Source)
at com.borland.dx.sql.dataset.ResolutionManager.saveChanges(Unknown Source)
at com.borland.dx.sql.dataset.ResolutionManager.saveChanges(Unknown Source)
at com.borland.dx.sql.dataset.Database.saveChanges(Unknown Source)
at PkgERP22.Rmi.RmiDbOperation.setVal(RmiDbOperation.java:444)
at PkgERP22.BusinessObject.ERPPurchaseOrderServer.updateDocument(ERPPurchaseOrderServer.java:660)
at java.lang.reflect.Method.invoke(Native Method)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
at sun.rmi.transport.Transport$1.run(Transport.java:142)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
at java.lang.Thread.run(Thread.java:484)
Chained exception:
java.sql.SQLException: ERROR: Unable to identify an operator '=' for types 'numeric' and 'double precision'
You will have to retype this query using an explicit cast

at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94)
at org.postgresql.Connection.ExecSQL(Connection.java:398)
at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
at org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java:113)
at com.borland.dx.sql.dataset.j.b(Unknown Source)
at com.borland.dx.sql.dataset.l.a(Unknown Source)
at com.borland.dx.sql.dataset.QueryResolver.deleteRow(Unknown Source)
at com.borland.dx.sql.dataset.ResolutionManager.a(Unknown Source)
at com.borland.dx.sql.dataset.ResolutionManager.d(Unknown Source)
at com.borland.dx.sql.dataset.ResolutionManager.c(Unknown Source)
at com.borland.dx.sql.dataset.ResolutionManager.saveChanges(Unknown Source)
at com.borland.dx.sql.dataset.ResolutionManager.saveChanges(Unknown Source)
at com.borland.dx.sql.dataset.Database.saveChanges(Unknown Source)
at PkgERP22.Rmi.RmiDbOperation.setVal(RmiDbOperation.java:444)
at PkgERP22.BusinessObject.ERPPurchaseOrderServer.updateDocument(ERPPurchaseOrderServer.java:660)
at java.lang.reflect.Method.invoke(Native Method)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:241)
at sun.rmi.transport.Transport$1.run(Transport.java:142)
at java.security.AccessController.doPrivileged(Native Method)[DEBUG] Value of rmiReturn Code in ERPPurchaesOrderServer :301,


[ERROR] setPurchaseOrderVal executeQuery Exception com.borland.dx.dataset.DataSetException: Execution of query failed., ERPPurchaseOrderServer.java:772 (2002-02-03 12:02:00,794)

at sun.rmi.transport.Transport.serviceCall(Transport.java:139)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:443)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:643)
at java.lang.Thread.run(Thread.java:484)
[ERROR] setPurchaseOrderVal() Excepiton:
com.borland.dx.dataset.DataSetException: Execution of query failed.,

Thanks!
Anthony