E1 Application: Web or Client

An EnterpriseOne application[of type APPL], is decided to be a FAT only or web only or both is decided based on the SIANSIF value in the F9860- Object Librarian Master Table.Prior to 811Sp1(?), all the applications can be launched either from a FAT client or a web client.But from 811Sp1 onwards most of the applications are made web only.By tweaking this value you can make a web only application to run on FAT[for troubleshooting purpose].The following are the valid values for an APPL:
W - Web only Ex:-P0006
C - Client only Ex:-P92001
' '[Sinlge space]- Both Ex:-P01012
Note:This is an undocumented stuff and should be used at your own risk.

java.sql.SQLException: The application requester cannot establish the connection

Scenario
If you get the following exception when you try to establish a connection to the MachineName.Please check if you can ping the MachineName from the current machine.The most probable issue would be, that the domain name is not proparly resolved.
Exception Stack
java.sql.SQLException: The application requester cannot establish the connection.(MachineName) at com.ibm.as400.access.JDError.throwSQLException(JDError.java:336) at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:1988) at com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:752) at com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:642) at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:232) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:140)
Solution
Make sure your current machine can resolve the MachineName to MachineName with the proper domain.
There could be several reasons behind the failure in establishing a connection.Most of the time 'java.sql.SQLException: The application requester cannot establish the connection' will be followed by a reason,like:
1]Not able to pass connection to server
2]Connection refused: connect
3]Operation timed out: connect
4]No route to host: connect
5]A remote host refused an attempted connect operation
6]Timeout etc etc.,

But if the connection is not established, and the exception just displays the MachineName, then you might need to check if that machine can be accessed by pinging that machine or writing asample JDBC program that establishes a connection to that server.etc.,
Related Adding DNS Suffixes

JDBC Drivers

Oracle JDBC Drivers Download page




SQL Server 2005 JDBC Driver Documentation
SQL Server 2005 JDBC Driver FAQ
JDBC Getting Started

Oracle OpenWorld 2007 Presentations

Download the sessions presented at the recently concluded Open World 2007 for free.For this Click this link and navigate to 'content Catalog'.Start downloading the presentations with the user name and password provided in that page[cboracle/oraclec6].
Make best use of the stuff included.

JDE Customer Quick Reference Guide

The following link will be really useful to JDE EnterpriseOne and World Customers, that talks about Global Customer support contact information, Customer partner connection and how important it is in problem solving ,Opening and managing cases with Oracle etc.,
Bookmark this link.It will be really useful to all JDE Customers