Deployment Architecture

Getting error connecting to informix database db connect

mmohiuddin
Path Finder

I am getting the following error when connecting to informix database:

Encountered the following error while trying to save: In handler 'databases': Error connecting to database: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][4.13.80] Invalid database URL syntax: jdbc:informix-sqli://<IP address>/cms:INFORMIXSERVER=demo_on;user=axm1203;password=XXX. ERRORCODE=-4461, SQLSTATE=42815

I have properly placed the ifxjdbc.jar file under $SPLUNK_HOME/etc/apps/dbx/bin/lib location.

Is there someother configuration change that needs to be done on database_types config file to include the database URL syntax?

Please let me know.

Thanks,

Tags (1)
0 Karma
1 Solution

jimodonald
Contributor

the documentation specifies to add the 'informix.server=demo_on' as an additional parameter. That should be the name of the informix server connection, not exactly "demo_on" . the documentation could be more clear on that parameter.

Please award points if his helps solve your problem.

View solution in original post

0 Karma

jimodonald
Contributor

the documentation specifies to add the 'informix.server=demo_on' as an additional parameter. That should be the name of the informix server connection, not exactly "demo_on" . the documentation could be more clear on that parameter.

Please award points if his helps solve your problem.

0 Karma

mmohiuddin
Path Finder

Thanks Jim, I was able to establish the connection.

0 Karma
Get Updates on the Splunk Community!

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...

Splunkbase | Splunk Dashboard Examples App for SimpleXML End of Life

The Splunk Dashboard Examples App for SimpleXML will reach end of support on Dec 19, 2024, after which no new ...

Understanding Generative AI Techniques and Their Application in Cybersecurity

Watch On-Demand Artificial intelligence is the talk of the town nowadays, with industries of all kinds ...