[jira] [Commented] (AMQ-4644) informix Routine (empty_blob) can not be resolved

["Claus Ibsen (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AMQ-4644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13808896#comment-13808896 ] 

Claus Ibsen commented on AMQ-4644:
----------------------------------

Can you find the valid SQL That informix can use?

It is possible to define custom SQL configurations for different database vendors. So we can have an informix, but would need to valid SQL to use.



> informix Routine (empty_blob) can not be resolved
> -------------------------------------------------
>
>                 Key: AMQ-4644
>                 URL: https://issues.apache.org/jira/browse/AMQ-4644
>             Project: ActiveMQ
>          Issue Type: Bug
>    Affects Versions: 5.8.0
>         Environment: Solaris
>            Reporter: Stefan
>             Fix For: NEEDS_REVIEWED
>
>
> Using the following Setup:
> Solaris x64  / Informix: 11.70FC7DE
> broker configuration:
> <amq:broker  
>    useJmx="true" 
>    brokerName="jdbcBroker" 
>    persistent="true" 
>    xmlns="http://activemq.apache.org/schema/core">
> 	<amq:destinations>
> 	      <queue physicalName="jms/myque" />
> 	</amq:destinations>
>     <amq:persistenceAdapter>
>     	<amq:jdbcPersistenceAdapter 
>            adapter="#informixAdapter" 
>            dataDirectory="${activemq.data}" 
>            dataSource="#informix-ds" 
>            lockKeepAlivePeriod="10000" 
>            createTablesOnStartup="true">
>     	     <amq:locker>
>     	        <amq:database-locker lockAcquireSleepInterval="5000"/>
>     	     </amq:locker>
>     	 </amq:jdbcPersistenceAdapter>
> 	</amq:persistenceAdapter>
>     <amq:transportConnectors>
>        <amq:transportConnector name="default" uri="tcp://0.0.0.0:61616"/>
>     </amq:transportConnectors>
> </amq:broker>
> <bean id="informixAdapter" 
>       class="org.apache.activemq.store.jdbc.adapter.InformixJDBCAdapter"/>
> If a message is sent to the broker, I get the following error:
> Routine (empty_blob) can not be resolved.
> InformixJDBCAdapter extends BlobJDBCAdapter
> -->
> In org.apache.activemq.store.jdbc.adapter.BlobJDBCAdapter, I saw the following code that issues the error:
>     @Override
>     public void setStatements(Statements statements) {
>         String addMessageStatement = "INSERT INTO "
>             + statements.getFullMessageTableName()
>             + "(ID, MSGID_PROD, MSGID_SEQ, CONTAINER, EXPIRATION, PRIORITY, MSG, XID) VALUES (?, ?, ?, ?, ?, ?, empty_blob(), empty_blob())";



--
This message was sent by Atlassian JIRA
(v6.1#6144)