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

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