java.sql.SQLException: SQLite.Exception: error in prepare: no such table: USER_STORE ### inside RestServicesHelper.getStoredValues() secureToken= null ### inside RestServicesHelper.getStoredValues() JsessionID= null ### inside RestServicesHelper.getStoredValues() empID= null ### inside RestServicesHelper.getStoredValues() userName= null ### inside RestServicesHelper.init() secureToken= null ### inside RestServicesHelper.init() JsessionID= null ### inside RestServicesHelper.init() empID= null ### inside RestServicesHelper.init() userName= null ### RestServicesHelper.setRequestURI: Username= myUserName Password= mypassword ### inside getHeaders. headers= {} ### RestServicesHelper. starting to send request to restServiceAdapter [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getConnectionRefAndSetSecurity] Connection LoginConn: LoginConn [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getConnectionRefAndSetSecurity] in getConnectionRefAndSetSecurity LoginConn [INFO - oracle.adfmf.framework - RestServiceAdapterImpl - getConnection] Processing '' POST request. [INFO - oracle.adfmf.framework - RestServiceAdapterImpl - getConnection] Processing '' POST request. [FINE - oracle.adfmf.framework - HttpServiceConnection - HttpServiceConnection] Sync is not enabled; using standard HttpConnection [FINEST - oracle.adfmf.framework - RestTransportLayer - getConnection] Connection was created without security. request: http://api.astcorporation.com:8002/myast/restlogin/login?username=myUserName&password=myPassword , Sync Enabled:true [FINER - oracle.adfmf.framework - RestServiceAdapterImpl - getHttpConnection] Got a connection. [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getHttpConnection] Established the connection to http://api.astcorporation.com:8002/myast/restlogin/login?username=userName&password=password [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] credStoreKey=[null] [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (HTTP-Version:HTTP/1.1) -->shouldn't this be JSON? [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (Accept-Encoding:identity; q=1.0, gzip; q=0.5, *;q=0) [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (Cookie:null) [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (Accept-Encoding:identity; q=1.0, gzip; q=0.5, *;q=0) [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (HTTP-Version:HTTP/1.1) [FINE - oracle.adfmf.framework - RestTransportLayer - getHttpConnection] Setting custom headers complete [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getHttpConnection] Setting request method complete [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - sendRequestImpl] Checking to see if we need to send any data to the server. [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getInputStream] Process request response [FINE - oracle.adfmf.framework - RestTransportLayer - getInputStream] Response code is 400 [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getInputStream] Request= [ http://api.astcorporation.com:8002/myast/restlogin/login?username=userName&password=password ] returned a status of 400 <---this exact URI returns a 200 response in my REST Client [INFO - oracle.adfmf.framework - RestServiceAdapterImpl - getInputStream] Web service returned a status of: 400 [SEVERE - oracle.adfmf.framework - RestServiceAdapterImpl - readResponse] Exception while reading response: ERROR [oracle.adfmf.framework.exception.AdfInvocationRuntimeException] - HTTP Status Code 400 Bad Request: The request could not be understood by the server due to malformed syntax. The client SHOULD NOT repeat the request without modifications. [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - readResponse] Response: Code: 400; Message: null; Number of bytes read: 0; Total bytes available: 0; [WARNING - oracle.adfmf.framework - RestServiceAdapterImpl - sendReceiveBytes] ERROR: REST Transport - ERROR [oracle.adfmf.framework.exception.AdfInvocationRuntimeException] - HTTP Status Code 400 Bad Request: The request could not be understood by the server due to malformed syntax. The client SHOULD NOT repeat the request without modifications. ERROR [oracle.adfmf.framework.exception.AdfInvocationRuntimeException] - HTTP Status Code 400 Bad Request: The request could not be understood by the server due to malformed syntax. The client SHOULD NOT repeat the request without modifications.

Oracle Community | TreeStrepek | 11 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    MAF 2.3:&nbsp; web services return 400 response?

    Oracle Community | 11 months ago | TreeStrepek
    java.sql.SQLException: SQLite.Exception: error in prepare: no such table: USER_STORE ### inside RestServicesHelper.getStoredValues() secureToken= null ### inside RestServicesHelper.getStoredValues() JsessionID= null ### inside RestServicesHelper.getStoredValues() empID= null ### inside RestServicesHelper.getStoredValues() userName= null ### inside RestServicesHelper.init() secureToken= null ### inside RestServicesHelper.init() JsessionID= null ### inside RestServicesHelper.init() empID= null ### inside RestServicesHelper.init() userName= null ### RestServicesHelper.setRequestURI: Username= myUserName Password= mypassword ### inside getHeaders. headers= {} ### RestServicesHelper. starting to send request to restServiceAdapter [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getConnectionRefAndSetSecurity] Connection LoginConn: LoginConn [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getConnectionRefAndSetSecurity] in getConnectionRefAndSetSecurity LoginConn [INFO - oracle.adfmf.framework - RestServiceAdapterImpl - getConnection] Processing '' POST request. [INFO - oracle.adfmf.framework - RestServiceAdapterImpl - getConnection] Processing '' POST request. [FINE - oracle.adfmf.framework - HttpServiceConnection - HttpServiceConnection] Sync is not enabled; using standard HttpConnection [FINEST - oracle.adfmf.framework - RestTransportLayer - getConnection] Connection was created without security. request: http://api.astcorporation.com:8002/myast/restlogin/login?username=myUserName&password=myPassword , Sync Enabled:true [FINER - oracle.adfmf.framework - RestServiceAdapterImpl - getHttpConnection] Got a connection. [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getHttpConnection] Established the connection to http://api.astcorporation.com:8002/myast/restlogin/login?username=userName&password=password [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] credStoreKey=[null] [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (HTTP-Version:HTTP/1.1) -->shouldn't this be JSON? [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (Accept-Encoding:identity; q=1.0, gzip; q=0.5, *;q=0) [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (Cookie:null) [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (Accept-Encoding:identity; q=1.0, gzip; q=0.5, *;q=0) [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (HTTP-Version:HTTP/1.1) [FINE - oracle.adfmf.framework - RestTransportLayer - getHttpConnection] Setting custom headers complete [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getHttpConnection] Setting request method complete [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - sendRequestImpl] Checking to see if we need to send any data to the server. [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getInputStream] Process request response [FINE - oracle.adfmf.framework - RestTransportLayer - getInputStream] Response code is 400 [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getInputStream] Request= [ http://api.astcorporation.com:8002/myast/restlogin/login?username=userName&password=password ] returned a status of 400 <---this exact URI returns a 200 response in my REST Client [INFO - oracle.adfmf.framework - RestServiceAdapterImpl - getInputStream] Web service returned a status of: 400 [SEVERE - oracle.adfmf.framework - RestServiceAdapterImpl - readResponse] Exception while reading response: ERROR [oracle.adfmf.framework.exception.AdfInvocationRuntimeException] - HTTP Status Code 400 Bad Request: The request could not be understood by the server due to malformed syntax. The client SHOULD NOT repeat the request without modifications. [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - readResponse] Response: Code: 400; Message: null; Number of bytes read: 0; Total bytes available: 0; [WARNING - oracle.adfmf.framework - RestServiceAdapterImpl - sendReceiveBytes] ERROR: REST Transport - ERROR [oracle.adfmf.framework.exception.AdfInvocationRuntimeException] - HTTP Status Code 400 Bad Request: The request could not be understood by the server due to malformed syntax. The client SHOULD NOT repeat the request without modifications. ERROR [oracle.adfmf.framework.exception.AdfInvocationRuntimeException] - HTTP Status Code 400 Bad Request: The request could not be understood by the server due to malformed syntax. The client SHOULD NOT repeat the request without modifications.

    Root Cause Analysis

    1. java.sql.SQLException

      SQLite.Exception: error in prepare: no such table: USER_STORE ### inside RestServicesHelper.getStoredValues() secureToken= null ### inside RestServicesHelper.getStoredValues() JsessionID= null ### inside RestServicesHelper.getStoredValues() empID= null ### inside RestServicesHelper.getStoredValues() userName= null ### inside RestServicesHelper.init() secureToken= null ### inside RestServicesHelper.init() JsessionID= null ### inside RestServicesHelper.init() empID= null ### inside RestServicesHelper.init() userName= null ### RestServicesHelper.setRequestURI: Username= myUserName Password= mypassword ### inside getHeaders. headers= {} ### RestServicesHelper. starting to send request to restServiceAdapter [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getConnectionRefAndSetSecurity] Connection LoginConn: LoginConn [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getConnectionRefAndSetSecurity] in getConnectionRefAndSetSecurity LoginConn [INFO - oracle.adfmf.framework - RestServiceAdapterImpl - getConnection] Processing '' POST request. [INFO - oracle.adfmf.framework - RestServiceAdapterImpl - getConnection] Processing '' POST request. [FINE - oracle.adfmf.framework - HttpServiceConnection - HttpServiceConnection] Sync is not enabled; using standard HttpConnection [FINEST - oracle.adfmf.framework - RestTransportLayer - getConnection] Connection was created without security. request: http://api.astcorporation.com:8002/myast/restlogin/login?username=myUserName&password=myPassword , Sync Enabled:true [FINER - oracle.adfmf.framework - RestServiceAdapterImpl - getHttpConnection] Got a connection. [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getHttpConnection] Established the connection to http://api.astcorporation.com:8002/myast/restlogin/login?username=userName&password=password [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] credStoreKey=[null] [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (HTTP-Version:HTTP/1.1) -->shouldn't this be JSON? [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (Accept-Encoding:identity; q=1.0, gzip; q=0.5, *;q=0) [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (Cookie:null) [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (Accept-Encoding:identity; q=1.0, gzip; q=0.5, *;q=0) [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - setCustomHeaders] setting (HTTP-Version:HTTP/1.1) [FINE - oracle.adfmf.framework - RestTransportLayer - getHttpConnection] Setting custom headers complete [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getHttpConnection] Setting request method complete [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - sendRequestImpl] Checking to see if we need to send any data to the server. [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getInputStream] Process request response [FINE - oracle.adfmf.framework - RestTransportLayer - getInputStream] Response code is 400 [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - getInputStream] Request= [ http://api.astcorporation.com:8002/myast/restlogin/login?username=userName&password=password ] returned a status of 400 <---this exact URI returns a 200 response in my REST Client [INFO - oracle.adfmf.framework - RestServiceAdapterImpl - getInputStream] Web service returned a status of: 400 [SEVERE - oracle.adfmf.framework - RestServiceAdapterImpl - readResponse] Exception while reading response: ERROR [oracle.adfmf.framework.exception.AdfInvocationRuntimeException] - HTTP Status Code 400 Bad Request: The request could not be understood by the server due to malformed syntax. The client SHOULD NOT repeat the request without modifications. [FINE - oracle.adfmf.framework - RestServiceAdapterImpl - readResponse] Response: Code: 400; Message: null; Number of bytes read: 0; Total bytes available: 0; [WARNING - oracle.adfmf.framework - RestServiceAdapterImpl - sendReceiveBytes] ERROR: REST Transport - ERROR [oracle.adfmf.framework.exception.AdfInvocationRuntimeException] - HTTP Status Code 400 Bad Request: The request could not be understood by the server due to malformed syntax. The client SHOULD NOT repeat the request without modifications. ERROR [oracle.adfmf.framework.exception.AdfInvocationRuntimeException] - HTTP Status Code 400 Bad Request: The request could not be understood by the server due to malformed syntax. The client SHOULD NOT repeat the request without modifications.

      at oracle.adfmf.dc.ws.rest.RestTransportLayer.getInputStream()
    2. oracle.adfmf.dc
      RestServiceAdapterImpl.send
      1. oracle.adfmf.dc.ws.rest.RestTransportLayer.getInputStream(Unknown Source)
      2. oracle.adfmf.dc.ws.rest.RestTransportLayer.readResponse(Unknown Source)
      3. oracle.adfmf.dc.ws.rest.RestTransportLayer.sendReceiveBytes(Unknown Source)
      4. oracle.adfmf.dc.ws.rest.RestTransportLayer.sendReceive(Unknown Source)
      5. oracle.adfmf.dc.ws.rest.RestServiceAdapterImpl.sendReceive(Unknown Source)
      6. oracle.adfmf.dc.ws.rest.RestServiceAdapterImpl.send(Unknown Source)
      6 frames
    3. com.astcorporation.myAST
      LoginHelper.LoginAction
      1. com.astcorporation.myAST.mobile.RestServicesHelper.send(RestServicesHelper.java:157)
      2. com.astcorporation.myAST.mobile.LoginHelper.LoginAction(LoginHelper.java:55)
      2 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    5. JUEL
      TreeMethodExpression.invoke
      1. de.odysseus.el.tree.impl.ast.AstProperty.invoke(Unknown Source)
      2. de.odysseus.el.tree.impl.ast.AstEval.invoke(Unknown Source)
      3. de.odysseus.el.TreeMethodExpression.invoke(Unknown Source)
      3 frames
    6. oracle.adfmf.framework
      Model.evaluateMethodExpression
      1. oracle.adfmf.framework.api.Model.evaluateMethodExpression(Unknown Source)
      1 frame
    7. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    8. oracle.adfmf.framework
      AdfChannel.handle
      1. oracle.adfmf.framework.contract.adf.application.GenericInvokeRequestHandler.invoke(Unknown Source)
      2. oracle.adfmf.framework.contract.adf.application.EmbeddedGenericInvokeRequestHandler.invoke(Unknown Source)
      3. oracle.adfmf.framework.contract.adf.application.GenericInvokeRequestHandler.invoke(Unknown Source)
      4. oracle.adfmf.framework.contract.adf.application.GenericInvokeRequestHandler.process(Unknown Source)
      5. oracle.adfmf.framework.FeatureContext.handle(Unknown Source)
      6. oracle.adfmf.framework.AdfChannel.handle(Unknown Source)
      6 frames
    9. com.oracle.vm
      VMChannelImpl.run
      1. com.oracle.vm.channel.impl.VMChannelImpl.run(Unknown Source)
      1 frame
    10. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame