JBuilder 4 QDS problem - Mailing list pgsql-jdbc

From Anthony Kwok
Subject JBuilder 4 QDS problem
Date
Msg-id KOEBJDDFANBAFJMOHPIBMEJMDEAA.anthonykwok@writeme.com
Whole thread Raw
Responses Re: JBuilder 4 QDS problem
List pgsql-jdbc
Hi,

Anyone using the Query Dataset that JBuilder 4.0 provided? I am using PostgreSQL 7.2 with the latest JDBC driver, I
defineda table with some NUMERIC fields, e.g. NUMERIC(12,4). When I use the qds to get the data from database, it has
noproblem. But when I want to save the data using the qds, it cannot run with success. The qds will detect a wrong
fieldtype 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

pgsql-jdbc by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: strange error
Next
From: "Dave Cramer"
Date:
Subject: Re: JBuilder 4 QDS problem