Skip to content

Instantly share code, notes, and snippets.

@mranzorbey
mranzorbey / Pivit Global Synchronize (13).EXCEL.yaml
Created September 13, 2021 20:17
Create a new snippet to synchronize data
name: Pivit Global Synchronize (13)
description: Create a new snippet to synchronize data
host: EXCEL
api_set: {}
script:
content: |
(function() {
var cache = new Map();
var headers;
var rowHeaderInteger;
@mranzorbey
mranzorbey / Blank snippet.EXCEL.yaml
Created August 18, 2021 10:48
Create a new snippet from a blank template.
name: Blank snippet
description: Create a new snippet from a blank template.
host: EXCEL
api_set: {}
script:
content: |
(function() {
var headers;
var components = components || {};
var messageBanner;

Keybase proof

I hereby claim:

  • I am mranzorbey on github.
  • I am mranzor (https://keybase.io/mranzor) on keybase.
  • I have a public key ASDh5JJGKeLsCtAjHIQwigs5d8CV7d4Eqvz9lu-pT6IbGgo

To claim this, I am signing this object:

@mranzorbey
mranzorbey / MatViewTimed
Created May 11, 2014 13:22
MatView with refresh force
CREATE MATERIALIZED VIEW xxx_orders_mv
PARALLEL
BUILD IMMEDIATE
REFRESH force WITH PRIMARY KEY
START WITH sysdate
NEXT sysdate + 1/24/60/6
AS SELECT ORDERS_ID, MSISDN, ACTDATE, LCSTATES_ID FROM ORDERS;
@mranzorbey
mranzorbey / MatViewLog
Last active August 29, 2015 14:01
Create MATVIEW log
CREATE MATERIALIZED VIEW LOG
ON ORDERS
WITH PRIMARY KEY INCLUDING NEW VALUES;
import org.vectomatic.file.FileUploadExt;
import com.example.dropmobile.client.ImageUtil;
import com.example.dropmobile.client.ImageUtil.ImageDataCallback;
import com.google.gwt.core.client.Scheduler;
import com.google.gwt.core.client.Scheduler.ScheduledCommand;
import com.google.gwt.event.dom.client.ChangeEvent;
import com.google.gwt.event.dom.client.ChangeHandler;
import com.google.gwt.user.client.ui.RootPanel;
import com.vaadin.client.ui.VCssLayout;
@mranzorbey
mranzorbey / gist:6059791
Last active December 20, 2015 02:58
JMS message producer
acknowledgeMode = Session.AUTO_ACKNOWLEDGE;
deliveryMode = DeliveryMode.NON_PERSISTENT;
Properties jndiParameters = new Properties();
jndiParameters.put("java.naming.factory.initial", "org.jnp.interfaces.NamingContextFactory");
jndiParameters.put("java.naming.factory.url.pkgs=", "org.jboss.naming:org.jnp.interfaces");
jndiParameters.put(javax.naming.Context.PROVIDER_URL, "jnp://remotehost:1199");
InitialContext initialContext = new InitialContext(jndiParameters);
@mranzorbey
mranzorbey / gist:6059780
Last active December 20, 2015 02:58
JMS Message Consumer
acknowledgeMode = Session.AUTO_ACKNOWLEDGE;
deliveryMode = DeliveryMode.NON_PERSISTENT;
Properties jndiParameters = new Properties();
jndiParameters.put("java.naming.factory.initial", "org.jnp.interfaces.NamingContextFactory"); jndiParameters.put("java.naming.factory.url.pkgs=", "org.jboss.naming:org.jnp.interfaces"); jndiParameters.put(javax.naming.Context.PROVIDER_URL, "jnp://remotehost:1199");
InitialContext initialContext = new InitialContext(jndiParameters);
connectionFactory = (ConnectionFactory)initialContext.lookup("/ConnectionFactory");
@mranzorbey
mranzorbey / gist:6059777
Last active December 20, 2015 02:58
MDB Configuration JBoss 5.x, 4.x
@MessageDriven (
activationConfig =
{
@ActivationConfigProperty( propertyName="destinationType", propertyValue="javax.jms.Queue" ),
@ActivationConfigProperty( propertyName="destination", propertyValue="queue/myNewQueue" ),
@ActivationConfigProperty( propertyName = "maxSession", propertyValue = "50" ),
@ActivationConfigProperty( propertyName = "minSession", propertyValue = "10" ) }
)
@Clustered
@PoolClass(value=StrictMaxPool.class, maxSize=50, timeout=20000) //for Jboss 4.3, <=4.2.3, for 5.1 use @Pool, maxSize should correspond to maxSession
@mranzorbey
mranzorbey / gist:6059766
Last active December 20, 2015 02:58
Inject JMS Queue, Factory Jboss 5.1
@Resource(mappedName="/ConnectionFactory")
ConnectionFactory connectionFactory;
@Resource(mappedName="queue/NotifQueue")
Queue msgQ;