cancel
Showing results for 
Search instead for 
Did you mean: 

Connectivity between XI and 4D 2003.5 data base

Former Member
0 Kudos

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!!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

David:

Which doc you used to deploy jdbc drivers?

Give me more info I might help you out.

Former Member
0 Kudos

Hi greg, the doc used for deploy jdbc drivers is:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

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!!!

Former Member
0 Kudos

What is you J2EE version?

Former Member
0 Kudos

David:

Please provide your J2EE version and patch level.

Former Member
0 Kudos

Greg:

Server version: SAP J2EE Engine 6.40 PatchLevel 102141.313