Skip to main content
C
cf_gautam
Participant
July 27, 2010
Question

Coldfusion application fails to conect database(JDBC connection)

  • July 27, 2010
  • 1 reply
  • 821 views

Hi,

I am facing some problem in my application producion box,

Problem details::

My Coldfusion application fails to conect database(JDBC connection) .After restarting cold fusion services it again work smoothly.

Below are the production coldusion details.

Server Product: ColdFusion MX.
Version: 6,1,0,83762
Edition: Enterprise.

Please suggest its urgent.

    This topic has been closed for replies.

    1 reply

    J
    JR__Bob__Dobbs
    Inspiring
    July 27, 2010

    Have you examined the ColdFusion, operating system, and database server log files for entries that are related to your connectivity problem?

    It is difficult to suggest a course of action based on the information you have posted.  Can you provide the OS, JVM, and database versions and any error messages or log entries relating to your problem.

    C
    cf_gautamAuthor
    Participant
    July 28, 2010

    Hi

    Yes I have examined all the code as well as all the log files but unable to find any issue there. I am giving its error massage.

    Error Massage:

    Java.SQL.sqlexception. No more available statements please create your package with a larger dynamic section value

    The application within that has reported to be a FAILURE.

    Some times has no error massage it displayed blank page.

    Below are the system details.

    1. Operating system: windows 2000.

    2. ColdFusion version: 6.1(6,1,0,83762)

    3. Webservices: IIS

    4. database: SqlServer 2000 and DB2.

    5.  Java VM Version : 1.4.2-b28

    Kindly update its urgent, because its a production issue.

    Let me know if you have any questions regarding my explanation.....

    Thanks.

    Gautam Kumar.

    J
    JR__Bob__Dobbs
    Inspiring
    July 28, 2010

    Things to try:

    1. The error message about a "package" makes me suspect that the error may be coming from a connection to your DB2 database. Does this error occuring when executing DB2 packages?

    Also see this forum post with a similar error: http://forums.adobe.com/message/2365303

    You might try a different JDBC driver to connect to DB2. You can use a third party JDBC driver with CF. This is from CF7 docs, but may also apply to CF6.

    http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=00001747.htm#1277913

    2. Update your JVM. I'm not sure it is related to your error, but it may correct daylight saving time related issues.

    http://go.adobe.com/kb/ts_d2ab4470_en-us

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices