Hi!

I currently test the Smarttrigger-Feature.
Tested at  DB-VERSION=14.10.FC3, JDBC-VERSION=4.50.JC3.

I use the following  code:
IfxSmartTrigger trigger = new IfxSmartTrigger(triggerURL, properties);
trigger.addTrigger("tablexy", "informix", database, "SELECT id FROM tablexy", new SmartTriggerNotify());
trigger.watch();

When i use the testdatabase as "triggerURL", I get:
java.sql.SQLException: Routine (task) can not be resolved.

When I use the sysadmin-Database as "triggerURL", I get:
SQLException: Error executing task pushdata register: Cannot open database testdb, error code -1 sql error -23197 isam error 0

• JavaDoc is no information (IfxSmartTrigger - jdbc 4.10.12 javadoc)
  
• Here it´s (more or less) the sysadmin-DB: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.jdbc_pg.doc/ids_jdbc_st_01.htm
• At this example it´s not the sysadmin-Database (and not the triggered database): Informix Data Streaming Overview

Thanks for your answers!

Hi!

I currently test the Smarttrigger-Feature.
Tested at  DB-VERSION=14.10.FC3, JDBC-VERSION=4.50.JC3.

I use the following  code:
IfxSmartTrigger trigger = new IfxSmartTrigger(triggerURL, properties);
trigger.addTrigger("tablexy", "informix", database, "SELECT id FROM tablexy", new SmartTriggerNotify());
trigger.watch();

When i use the testdatabase as "triggerURL", I get:
java.sql.SQLException: Routine (task) can not be resolved.

When I use the sysadmin-Database as "triggerURL", I get:
SQLException: Error executing task pushdata register: Cannot open database testdb, error code -1 sql error -23197 isam error 0

• JavaDoc is no information (IfxSmartTrigger - jdbc 4.10.12 javadoc)
  
• Here it´s (more or less) the sysadmin-DB: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.jdbc_pg.doc/ids_jdbc_st_01.htm
• At this example it´s not the sysadmin-Database (and not the triggered database): Informix Data Streaming Overview

Thanks for your answers!

• sysadmin: Default-Locale (en_US.819)
• Our databases: Always utf8 (en_US.57372)

• sysadmin: Default-Locale (en_US.819)
• Our databases: Always utf8 (en_US.57372)

Hi!

When this really doesn´t work with other Locales, I can stop my test.
All our databases have utf8-Encoding.

For me this is generally a strange think, that I have to connect to the sysadmin-database.
When it´s a task, I understand it, but I don´t like it, because all users (where I want to use the smarttriggers) need access to the sysadmin-database.

Hopefully someone has a solution.

• sysadmin: Default-Locale (en_US.819)
• Our databases: Always utf8 (en_US.57372)

Hi!

I currently test the Smarttrigger-Feature.
Tested at  DB-VERSION=14.10.FC3, JDBC-VERSION=4.50.JC3.

I use the following  code:
IfxSmartTrigger trigger = new IfxSmartTrigger(triggerURL, properties);
trigger.addTrigger("tablexy", "informix", database, "SELECT id FROM tablexy", new SmartTriggerNotify());
trigger.watch();

When i use the testdatabase as "triggerURL", I get:
java.sql.SQLException: Routine (task) can not be resolved.

When I use the sysadmin-Database as "triggerURL", I get:
SQLException: Error executing task pushdata register: Cannot open database testdb, error code -1 sql error -23197 isam error 0

• JavaDoc is no information (IfxSmartTrigger - jdbc 4.10.12 javadoc)
  
• Here it´s (more or less) the sysadmin-DB: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.jdbc_pg.doc/ids_jdbc_st_01.htm
• At this example it´s not the sysadmin-Database (and not the triggered database): Informix Data Streaming Overview

Thanks for your answers!

1. Check database locale[informix@db2 skjeong]$ echo "select * from sysdbslocale where dbs_dbsname in ('sysadmin','bank')" | dbaccess sysmasterDatabase selected.dbs_dbsname  sysadmindbs_collate  en_US.819dbs_dbsname  bankdbs_collate  en_US.573722 row(s) retrieved.2. Running java program without locale environment variables[informix@db2 skjeong]$ head -10 SmartTrigger.java...                              try(IfxSmartTrigger trigger = new IfxSmartTrigger("jdbc:informix-sqli://xxx.xx.xx.xx:53331/sysadmin:user=informix;password=password");) {[informix@db2 skjeong]$ export CLASSPATH=/work1/informix/1210FC10/jdbc/lib/ifxjdbc.jar:/work1/informix/ids1410fc3/skjeong/gson-2.8.2.jar:.[informix@db2 skjeong]$ javac SmartTrigger.java[informix@db2 skjeong]$ java SmartTriggerException in thread "main" java.sql.SQLException: Error executing table registration        at com.informix.smartTrigger.IfxSmartTrigger.watch(IfxSmartTrigger.java:539)        at SmartTrigger.main(SmartTrigger.java:13)Caused by: java.sql.SQLException: Error executing task pushdata register: Cannot open database bank, error code -1 sql error -23197 isam error 0        at com.informix.smartTrigger.IfxSmartTrigger.registerTriggers(IfxSmartTrigger.java:482)        at com.informix.smartTrigger.IfxSmartTrigger.watch(IfxSmartTrigger.java:536)        ... 1 more3. Running java program after setting locale environment variable[informix@db2 skjeong]$ head -10 SmartTrigger.java...                              try(IfxSmartTrigger trigger = new IfxSmartTrigger("jdbc:informix-sqli://xxx.xx.xx.xx:53331/sysadmin:user=informix;password=password;DB_LOCALE=en_us.utf8;CLIENT_LOCALE=en_us.utf8");) {[informix@db2 skjeong]$ /work1/informix/ids1410fc3/jvm/jre/bin/java SmartTriggerBank Account Ping!-- No balance issuesBank Account Ping!-- No balance issuesBank Account Ping!-- Bank Account Alert detected!   {"operation":"delete","table":"account","owner":"informix","database":"bank","label":"bank_alert_1","txnid":1421638541952,"operation_owner_id":1001,"operation_session_id":544,"commit_time":1587602769,"op_num":1,"restart_logid":331,"restart_logpos":4211028,"rowdata":{"id":22,"name":"John Doe","balance":-23.4499999999999990}}​

Hi!

I currently test the Smarttrigger-Feature.
Tested at  DB-VERSION=14.10.FC3, JDBC-VERSION=4.50.JC3.

I use the following  code:
IfxSmartTrigger trigger = new IfxSmartTrigger(triggerURL, properties);
trigger.addTrigger("tablexy", "informix", database, "SELECT id FROM tablexy", new SmartTriggerNotify());
trigger.watch();

When i use the testdatabase as "triggerURL", I get:
java.sql.SQLException: Routine (task) can not be resolved.

When I use the sysadmin-Database as "triggerURL", I get:
SQLException: Error executing task pushdata register: Cannot open database testdb, error code -1 sql error -23197 isam error 0

• JavaDoc is no information (IfxSmartTrigger - jdbc 4.10.12 javadoc)
  
• Here it´s (more or less) the sysadmin-DB: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.jdbc_pg.doc/ids_jdbc_st_01.htm
• At this example it´s not the sysadmin-Database (and not the triggered database): Informix Data Streaming Overview

Thanks for your answers!

Hi!

Many Thanks. Now it works.

There´s only one problem with the encoding:
I get the wrong value for a String for special characters:
I´ve updated the value to "üOö" and the Result at the String is "üO".
I think this is double-encoded.

But this is not so important for me, because I only need the changed id´s.

1. Check database locale[informix@db2 skjeong]$ echo "select * from sysdbslocale where dbs_dbsname in ('sysadmin','bank')" | dbaccess sysmasterDatabase selected.dbs_dbsname  sysadmindbs_collate  en_US.819dbs_dbsname  bankdbs_collate  en_US.573722 row(s) retrieved.2. Running java program without locale environment variables[informix@db2 skjeong]$ head -10 SmartTrigger.java...                              try(IfxSmartTrigger trigger = new IfxSmartTrigger("jdbc:informix-sqli://xxx.xx.xx.xx:53331/sysadmin:user=informix;password=password");) {[informix@db2 skjeong]$ export CLASSPATH=/work1/informix/1210FC10/jdbc/lib/ifxjdbc.jar:/work1/informix/ids1410fc3/skjeong/gson-2.8.2.jar:.[informix@db2 skjeong]$ javac SmartTrigger.java[informix@db2 skjeong]$ java SmartTriggerException in thread "main" java.sql.SQLException: Error executing table registration        at com.informix.smartTrigger.IfxSmartTrigger.watch(IfxSmartTrigger.java:539)        at SmartTrigger.main(SmartTrigger.java:13)Caused by: java.sql.SQLException: Error executing task pushdata register: Cannot open database bank, error code -1 sql error -23197 isam error 0        at com.informix.smartTrigger.IfxSmartTrigger.registerTriggers(IfxSmartTrigger.java:482)        at com.informix.smartTrigger.IfxSmartTrigger.watch(IfxSmartTrigger.java:536)        ... 1 more3. Running java program after setting locale environment variable[informix@db2 skjeong]$ head -10 SmartTrigger.java...                              try(IfxSmartTrigger trigger = new IfxSmartTrigger("jdbc:informix-sqli://xxx.xx.xx.xx:53331/sysadmin:user=informix;password=password;DB_LOCALE=en_us.utf8;CLIENT_LOCALE=en_us.utf8");) {[informix@db2 skjeong]$ /work1/informix/ids1410fc3/jvm/jre/bin/java SmartTriggerBank Account Ping!-- No balance issuesBank Account Ping!-- No balance issuesBank Account Ping!-- Bank Account Alert detected!   {"operation":"delete","table":"account","owner":"informix","database":"bank","label":"bank_alert_1","txnid":1421638541952,"operation_owner_id":1001,"operation_session_id":544,"commit_time":1587602769,"op_num":1,"restart_logid":331,"restart_logpos":4211028,"rowdata":{"id":22,"name":"John Doe","balance":-23.4499999999999990}}​

Hi!

I currently test the Smarttrigger-Feature.
Tested at  DB-VERSION=14.10.FC3, JDBC-VERSION=4.50.JC3.

I use the following  code:
IfxSmartTrigger trigger = new IfxSmartTrigger(triggerURL, properties);
trigger.addTrigger("tablexy", "informix", database, "SELECT id FROM tablexy", new SmartTriggerNotify());
trigger.watch();

When i use the testdatabase as "triggerURL", I get:
java.sql.SQLException: Routine (task) can not be resolved.

When I use the sysadmin-Database as "triggerURL", I get:
SQLException: Error executing task pushdata register: Cannot open database testdb, error code -1 sql error -23197 isam error 0

• JavaDoc is no information (IfxSmartTrigger - jdbc 4.10.12 javadoc)
  
• Here it´s (more or less) the sysadmin-DB: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.jdbc_pg.doc/ids_jdbc_st_01.htm
• At this example it´s not the sysadmin-Database (and not the triggered database): Informix Data Streaming Overview

Thanks for your answers!

Hi!

Many Thanks. Now it works.

There´s only one problem with the encoding:
I get the wrong value for a String for special characters:
I´ve updated the value to "üOö" and the Result at the String is "üO".
I think this is double-encoded.

But this is not so important for me, because I only need the changed id´s.

1. Check database locale[informix@db2 skjeong]$ echo "select * from sysdbslocale where dbs_dbsname in ('sysadmin','bank')" | dbaccess sysmasterDatabase selected.dbs_dbsname  sysadmindbs_collate  en_US.819dbs_dbsname  bankdbs_collate  en_US.573722 row(s) retrieved.2. Running java program without locale environment variables[informix@db2 skjeong]$ head -10 SmartTrigger.java...                              try(IfxSmartTrigger trigger = new IfxSmartTrigger("jdbc:informix-sqli://xxx.xx.xx.xx:53331/sysadmin:user=informix;password=password");) {[informix@db2 skjeong]$ export CLASSPATH=/work1/informix/1210FC10/jdbc/lib/ifxjdbc.jar:/work1/informix/ids1410fc3/skjeong/gson-2.8.2.jar:.[informix@db2 skjeong]$ javac SmartTrigger.java[informix@db2 skjeong]$ java SmartTriggerException in thread "main" java.sql.SQLException: Error executing table registration        at com.informix.smartTrigger.IfxSmartTrigger.watch(IfxSmartTrigger.java:539)        at SmartTrigger.main(SmartTrigger.java:13)Caused by: java.sql.SQLException: Error executing task pushdata register: Cannot open database bank, error code -1 sql error -23197 isam error 0        at com.informix.smartTrigger.IfxSmartTrigger.registerTriggers(IfxSmartTrigger.java:482)        at com.informix.smartTrigger.IfxSmartTrigger.watch(IfxSmartTrigger.java:536)        ... 1 more3. Running java program after setting locale environment variable[informix@db2 skjeong]$ head -10 SmartTrigger.java...                              try(IfxSmartTrigger trigger = new IfxSmartTrigger("jdbc:informix-sqli://xxx.xx.xx.xx:53331/sysadmin:user=informix;password=password;DB_LOCALE=en_us.utf8;CLIENT_LOCALE=en_us.utf8");) {[informix@db2 skjeong]$ /work1/informix/ids1410fc3/jvm/jre/bin/java SmartTriggerBank Account Ping!-- No balance issuesBank Account Ping!-- No balance issuesBank Account Ping!-- Bank Account Alert detected!   {"operation":"delete","table":"account","owner":"informix","database":"bank","label":"bank_alert_1","txnid":1421638541952,"operation_owner_id":1001,"operation_session_id":544,"commit_time":1587602769,"op_num":1,"restart_logid":331,"restart_logpos":4211028,"rowdata":{"id":22,"name":"John Doe","balance":-23.4499999999999990}}​

Hi!

I currently test the Smarttrigger-Feature.
Tested at  DB-VERSION=14.10.FC3, JDBC-VERSION=4.50.JC3.

I use the following  code:
IfxSmartTrigger trigger = new IfxSmartTrigger(triggerURL, properties);
trigger.addTrigger("tablexy", "informix", database, "SELECT id FROM tablexy", new SmartTriggerNotify());
trigger.watch();

When i use the testdatabase as "triggerURL", I get:
java.sql.SQLException: Routine (task) can not be resolved.

When I use the sysadmin-Database as "triggerURL", I get:
SQLException: Error executing task pushdata register: Cannot open database testdb, error code -1 sql error -23197 isam error 0

• JavaDoc is no information (IfxSmartTrigger - jdbc 4.10.12 javadoc)
  
• Here it´s (more or less) the sysadmin-DB: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.jdbc_pg.doc/ids_jdbc_st_01.htm
• At this example it´s not the sysadmin-Database (and not the triggered database): Informix Data Streaming Overview

Thanks for your answers!