Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Unanswered: Informix JDBC - System or internal error

    Dear All,

    My java developers are trying to connect to my DB & are getting the error "java.sql.SQLException: System or internal error". What could be the problem. This error happens occassionally.

    Below are the settings in the property file -

    XXX.SQLConnectionPool.MinimumReadyConnections=50
    XXX.SQLConnectionPool.MaximumReadyConnections=100
    XXX.SQLConnectionPool.MaximumConnections=100
    XXX.SQLConnectionPool.MaximumConnectionAge=3600000
    XXX.SQLConnectionPool.MaximumConnectionWait=30000
    XXX.SQLConnectionPool.MaximumWaiters=0

    But i can connect to my DB using other 3rd party tools like Winsql.
    Do i need to tune any of the above parameters or configure Informix Configuration parameters. Please advice.

    Best Regards,

    Lloyd

  2. #2
    Join Date
    Oct 2003
    Posts
    29
    Llyod ,

    Can you gather more diagnostic information
    about this ?

    You can generate SQLI protocol trace and function trace and see
    if you get any clue from that

    1) Here is how you generate SQLI protocol trace
    set these properties in connection URL

    PROTOCOLTRACE=99;PROTOCOLTRACEFILE=c://tmp//ptrace
    or you can use following methods
    on an IfxDataSource object to set these properties
    IfxDataSource::setIfxPROTOCOLTRACE();
    IfxDataSource::setIfxPROTOCOLTRACEFILE()

    or add these properties to your datasource properties file.


    2) To generate function trace
    set these properties.
    TRACE=99;TRACEFILE=c://tmp//ftrace

    or you can call
    IfxDataSource::setIfxTRACE()
    IfxDataSource::setIfxTRACEFILE()


    or add these properties to your datasource properties file.

    Make sure that you have ifxjdbc-g.jar and ifxjdbcx-g.jar in
    your classpath . put them before other jdbc jars in CLASSPATH.

  3. #3
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    Originally posted by Amit Dandekar
    Llyod ,

    Can you gather more diagnostic information
    about this ?

    You can generate SQLI protocol trace and function trace and see
    if you get any clue from that

    1) Here is how you generate SQLI protocol trace
    set these properties in connection URL

    PROTOCOLTRACE=99;PROTOCOLTRACEFILE=c://tmp//ptrace
    or you can use following methods
    on an IfxDataSource object to set these properties
    IfxDataSource::setIfxPROTOCOLTRACE();
    IfxDataSource::setIfxPROTOCOLTRACEFILE()

    or add these properties to your datasource properties file.


    2) To generate function trace
    set these properties.
    TRACE=99;TRACEFILE=c://tmp//ftrace

    or you can call
    IfxDataSource::setIfxTRACE()
    IfxDataSource::setIfxTRACEFILE()


    or add these properties to your datasource properties file.

    Make sure that you have ifxjdbc-g.jar and ifxjdbcx-g.jar in
    your classpath . put them before other jdbc jars in CLASSPATH.
    Hi Amit,

    Thanks for your feedback, i will work on the changes.

    Regards,

    Lloyd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •