I can't get a connection to an Oracle Databae thing....using the JDBC extension...

[lniska]

not using https....where do I go from here to troubleshoot this???

28-Nov-2016 02:01:34.456 SEVERE [ajp-nio-8009-exec-9] org.apache.coyote.ajp.AjpMessage.processHeader Invalid message received with signature 18245

28-Nov-2016 02:01:50.255 SEVERE [ajp-nio-8009-exec-10] org.apache.coyote.ajp.AjpMessage.processHeader Invalid message received with signature 18245

28-Nov-2016 03:05:34.982 SEVERE [ajp-nio-8009-exec-1] org.apache.coyote.ajp.AjpMessage.processHeader Invalid message received with signature 18245

28-Nov-2016 03:05:45.857 INFO [http-nio-80-exec-13] org.apache.coyote.http11.AbstractHttp11Processor.process Error parsing HTTP request header

Note: further occurrences of HTTP header parsing errors will be logged at DEBUG level.

java.lang.IllegalArgumentException: Invalid character (CR or LF) found in method name

at org.apache.coyote.http11.AbstractNioInputBuffer.parseRequestLine(AbstractNioInputBuffer.java:228)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1009)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source

[lniska]

This is the error...[context: com.thingworx.webservices.context.HttpExecutionContext@3501d59b][message: Unable to Invoke Service TestEDMSJDBCConnection on EDMSJDBCConnectorThing : Cannot get a connection, pool error Unable to validate object]

[PaiChung]

Please share your configuration settings (obscure the server name) please.

[ankigupta]

Hi Len Niska​,

For Oracle try using https://marketplace.thingworx.com/Items/Relational-databases-connectors

If you still face any issue; share the screenshot of the configuration page.

I hope it helps.

Thanks,

Ankit Gupta