Genexus

----- Original Message -----

From: Bianca Cáceres

To: java-l@gxtech.com.uy

Sent: Friday, July 29, 2011 8:03 AM

Subject: [java-l] Consulta sobre un Error al intentar eliminar un registro Generando con Java/AS400

Hola Foro! tengo el sgte error al ejecutar una aplicacion ej Java con Gx X , es al querer borrar un registro, se puede hacer bien el up y el add, pero no deja borrar, hay un sac que hace referencia a este error y pide usar el client access 51 minimamente, y aca tenemos el V5R2, no se que mas podria ser, si alguien tiene alguna idea o alguna vez le paso , agradecere comentarios

========== Run TGE23IDIO started ==========
Building changed objects list
========== Target Environment update started ==========
Target Environment update Success
No objects to Specify
========== Generation started ==========
Generating Resources...Success
Generating to JavaModel\GXcfg.java
Generating to JavaModel\client.cfg
Generating to JavaModel\crtjdbccalls.java
Generating to JavaModel\bld11.info
Generating to sm11_2.ari
Generating to JavaModel\devmenu.xml
Generation Success
========== TGE23IDIO Compilation started ==========
callmake.bat "C:\GxKbs\SysTape\Systape\JavaModel\GXJMake.exe" "C:\Program Files\Java\jdk1.6.0_26\bin\javac.exe" ntge23idio  options: -O
GeneXus Java Make v1.0
Build succeeded.
TGE23IDIO Compilation Success
========== Execution started ==========
"C:\Program Files\Java\jdk1.6.0_26\bin\java.exe"  ntge23idio
Exception in thread "main" org.eclipse.swt.SWTException: Failed to execute runnable (com.genexus.GXRuntimeException: java.sql.SQLException: [SQL0199] Palabra clave FETCH inesperada. Signos válidos: FOR WITH ORDER UNION OPTIMIZE.
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1506)
    at com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStatement.java:185)
    at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1903)
    at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java:1726)
    at com.genexus.db.driver.GXConnection.prepareStatement(Unknown Source)
    at com.genexus.db.driver.PreparedStatementCache.createStatement(Unknown Source)
    at com.genexus.db.driver.PreparedStatementCache.getStatement(Unknown Source)
    at com.genexus.db.driver.GXConnection.getStatement(Unknown Source)
    at com.genexus.db.driver.GXConnection.getStatement(Unknown Source)
    at com.genexus.db.SentenceProvider.getPreparedStatement(Unknown Source)
    at com.genexus.db.ForEachCursor.preExecute(Unknown Source)
    at com.genexus.db.DataStoreProvider.execute(Unknown Source)
    at com.genexus.db.DataStoreProvider.execute(Unknown Source)
    at ntge23idio.onDeleteControls1Y76(ntge23idio.java:1513)
    at ntge23idio.delete(ntge23idio.java:1456)
    at ntge23idio.btn_delete(ntge23idio.java:1154)
    at ntge23idio.actionEventDispatch(ntge23idio.java:472)
    at com.genexus.ui.GXWorkpanel$runEvent.run(Unknown Source)
    at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
    at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:106)
    at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:2750)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2435)
    at com.genexus.uifactory.swt.SWTUIFactory.loopEvents(Unknown Source)
    at com.genexus.uifactory.UIFactory.loopEvents(Unknown Source)
    at com.genexus.ui.GXTransaction.run(Unknown Source)
    at com.genexus.ui.GXWorkpanel.start(Unknown Source)
    at ntge23idio.execute_int(ntge23idio.java:214)
    at ntge23idio.execute(ntge23idio.java:207)
    at ntge23idio.executeCmdLine(ntge23idio.java:80)
    at ntge23idio.main(ntge23idio.java:65)
)
    at org.eclipse.swt.SWT.error(SWT.java:2691)
    at org.eclipse.swt.SWT.error(SWT.java:2616)
    at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:109)
    at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:2750)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2435)
    at com.genexus.uifactory.swt.SWTUIFactory.loopEvents(Unknown Source)
    at com.genexus.uifactory.UIFactory.loopEvents(Unknown Source)
    at com.genexus.ui.GXTransaction.run(Unknown Source)
    at com.genexus.ui.GXWorkpanel.start(Unknown Source)
    at ntge23idio.execute_int(ntge23idio.java:214)
    at ntge23idio.execute(ntge23idio.java:207)
    at ntge23idio.executeCmdLine(ntge23idio.java:80)
    at ntge23idio.main(ntge23idio.java:65)
Execution Failed
Run TGE23IDIO Failed