So, I have successfully connected to an internal MySQL database after installing the driver however, I am getting errors when trying to pull data.
Here is my XML adapter:
<?xml version="1.0" encoding="UTF-8"?>
<data_source_type xmlns="http://www.hyperformix.com/DataManager" version="4.5">
<name>bcssi_san_data_db_v5</name>
<author>Seth Taylor</author>
<copyright>© 2009 Hyperformix, Inc.</copyright>
<description><![CDATA[This DGE supports gathering SAN data from the UNIX BCSSI MySQL database.]]></description>
<!-- Omitting the package name from the engine implies com.hyperformix.DataGatherEngine.DataIntf.Engine. -->
<data_aquisition_class name="ITM_DB_Engine"/>
<server_list_query>select distinct hostname from hba_data</server_list_query>
<map id="clariionLunMetricsMap">
<source>
<select>select hostname, emcpseudo, lunsize, type, arrayid, lunid, resourcename, totalsize, current_timestamp from hba_data where hostname IN (DGE_SERVERS_LIST) AND type="CLARiion" </select>
<column name="hostname" type="string"/>
<column name="emcpseudo" type="string"/>
<column name="lunsize" type="string"/>
<column name="type" type="string"/>
<column name="arrayid" type="string"/>
<column name="lunid" type="string"/>
<column name="resourcename" type="string"/>
<column name="totalsize" type="integer"/>
<column name="timestamp" type="date" date_format="yyyy-MM-dd HH:mm:ss" optional="false"/>
</source>
<destinations>
<entity_metrics>
<required_fields>
<entity_id source="lunid"/>
<entity_name source="resourcename"/>
<entity_type source="type"/>
<metric_time source="timestamp"/>
<gmt_offset source="DGE_GMT_OFFSET"/>
</required_fields>
<optional_fields>
</optional_fields>
<metrics>
<metric name="LUN_TOTAL_SIZE_MB" unit="string" type="string" source="lunsize * 1024"/>
</metrics>
</entity_metrics>
</destinations>
</map>
</data_source_type>
And here is the error I'm recieving in catalina.out:
java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("CCCUSER"."ENTITY_METRICS_STAGING"."METRIC_TIME")
The table I am trying to pull information from doesn't have a date, time, timestamp or anything of that nature so I was trying to get the CURRENT_TIMESTAMP as if I was running the MySQL command NOW(). I am by no means a sql expert and will gladly take criticism if it means it will help solve the problem.