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!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...