on 08-09-2006 4:00 PM
Hi, I need to make a query to 4D 2003.5 data base (4th Dimension). I installed two drivers jdbc in XI, but when the message is sent to the data base I get error in RW: "Unable to execute statement for table or stored procedure. 'Pedido' (Structure 'Statement') due to org.storrow.jdbc4d.exceptions.SQL4DException: SleepingProcesErr"....."Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. 'Pedido' (structure 'Statement'): org.storrow.jdbc4d.exceptions.SQL4DException: SleepingProcesErr"
The Statement Select is correct in message type:
<?xml version="1.0" encoding="UTF-8"?>
<ns0:Prueba_consulta_KUPAY_destino_DT xmlns:ns0="urn:test:idoc">
<Statement>
<Pedido action="SELECT">
<table>Pedido</table>
<access>
<NumPedido>NumPedido</NumPedido>
<NumFicha>NumFicha</NumFicha>
<Fecha_entrega>Fecha_entrega</Fecha_entrega>
<Estado>Estado</Estado>
<Despacho>Despacho</Despacho>
<OrdenCompra> OrdenCompra</OrdenCompra>
<Embarcador> Embarcador</Embarcador>
</access>
<key>
<NumPedido>1234</NumPedido>
</key>
</Pedido>
</Statement>
</ns0:Prueba_consulta_KUPAY_destino_DT>
I don't know if it's a problem of drivers jdbc since XI get connect to BD, but the query to the table does not work.
Somebody knows any url where download jdbc drivers for 4D 2003.5??
Regards!!
David:
Which doc you used to deploy jdbc drivers?
Give me more info I might help you out.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi greg, the doc used for deploy jdbc drivers is:
The jdbc driver used was downloaded from:
http://www.4d.com/products/downloads_4d.html
In the communication channel the JDBC Driver parameter is:
"org.storrow.jdbc4d.jdbc.FourDDriver", and url connection format used: "jdbc:4d:<dataBaseName>:@<host/IP>:<port>"
Thanks!!!
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.