Kbase P126616: Problems getting a SQL connection to a database in Architect
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/05/2009 |
|
Status: Verified
SYMPTOM(s):
Problems getting a SQL connection to a database in Architect
java.lang.ClassNotFoundException: com.ddtek.jdbc.openedge.OpenEdgeDriver
FACT(s) (Environment):
OpenEdge 10.2A
Windows
CAUSE:
This can happen if the database you are connecting to is allowing both ABL and SQL connections to the database using the same broker. If the ABL connections take up all of the available connections then SQL is unable to obtain a connection. It is important to understand that each open project in Architect will take up connections if they are defined (i.e. if three projects are opened and all three are defined to connect to the same database then there will be database connections on a per project basis rather than a single connection for Architect itself).
FIX:
Increase the number of available connections for the database or define a secondary login broker for SQL connections