psql: FATAL: remaining connection slots are reserved for non-replication superuser connections
postgres 8336 0.0 0.2 220396 7828 ? Ss 02:34 0:00 postgres: username dbname 127.0.0.1(36112) idle
postgres 8337 0.0 0.3 220396 10292 ? Ss 02:34 0:00 postgres: username dbname 127.0.0.1(36113) idle
postgres 8339 0.0 0.1 219268 3484 ? Ss 02:34 0:00 postgres: username dbname 127.0.0.1(36115) idle
postgres 8359 0.0 0.1 219268 3484 ? Ss 02:34 0:00 postgres: username dbname 127.0.0.1(36120) idle
postgres 8364 0.0 0.1 219268 3484 ? Ss 02:34 0:00 postgres: username dbname 127.0.0.1(36121) idle
postgres 8410 0.0 1.2 220940 38620 ? Ss 02:35 0:00 postgres: username dbname 127.0.0.1(36125) idle
postgres 8415 0.0 0.3 220220 9736 ? Ss 02:35 0:00 postgres: username dbname 127.0.0.1(36127) idle
postgres 8428 0.0 0.1 219264 3500 ? Ss 02:35 0:00 postgres: username dbname 127.0.0.1(36130) idle
postgres 8446 0.2 2.0 220540 61960 ? Ss 02:36 0:04 postgres: username dbname 127.0.0.1(36132) idle
postgres 8457 0.0 0.1 219264 3508 ? Ss 02:37 0:00 postgres: username dbname 127.0.0.1(36136) idle
postgres 8539 0.3 2.7 220564 83256 ? Ss 02:42 0:04 postgres: username dbname 127.0.0.1(36145) idle
postgres 8628 0.4 2.7 220200 83288 ? Ss 02:47 0:04 postgres: username dbname 127.0.0.1(36158) idle
postgres 8664 0.5 2.7 221480 84672 ? Ss 02:49 0:04 postgres: username dbname 127.0.0.1(36163) idle
postgres 8674 0.0 0.5 220216 17320 ? Ss 02:49 0:00 postgres: username dbname 127.0.0.1(36165) idle
postgres 8677 0.0 0.2 220084 8756 ? Ss 02:49 0:00 postgres: username dbname 127.0.0.1(36168) idle
postgres 8744 0.0 0.1 219264 3512 ? Ss 02:52 0:00 postgres: username dbname 127.0.0.1(36176) idle
postgres 8750 0.6 2.0 220540 62004 ? Ss 02:52 0:03 postgres: username dbname 127.0.0.1(36178) idle
postgres 8752 0.1 0.5 220216 18372 ? Ss 02:52 0:00 postgres: username dbname 127.0.0.1(36179) idle
postgres 8759 0.1 1.5 221516 47096 ? Ss 02:52 0:00 postgres: username dbname 127.0.0.1(36180) idle
postgres 8760 0.6 2.0 220156 63316 ? Ss 02:52 0:04 postgres: username dbname 127.0.0.1(36181) idle
postgres 8785 0.0 0.1 219264 3512 ? Ss 02:53 0:00 postgres: username dbname 127.0.0.1(36183) idle
postgres 8789 0.0 0.3 220220 10172 ? Ss 02:53 0:00 postgres: username dbname 127.0.0.1(36185) idle
--
Love Lucee? Become a supporter and be part of the Lucee project today! - http://lucee.org/supporters/become-a-supporter.html
---
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/14bd52ad-3192-4402-a5ed-9bd9f68dfc8f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
deletedCases = ormExecuteQuery("update table1 set deleted = true,
datetimemodified = :datetimemodified
where mydate = :mydate
and location = :location
and id not in (:idsProcessed)", {mydate=workDT, location=siteName, idsProcessed=idsProcessed, datetimemodified=Now()});
public void function postInsert( any entity )
{
var id = this.getID();
var something = this.getSomething();
var surgdate = this.getSurgdate();
var sql = "INSERT INTO messages(type,target,creator,value,workdate) VALUES(:type,:target,:creator,:value,:workdate);";
var params = {type='messagetype1',
target='{"id":#id#, "something":#something#}',
creator='#Session.cfid#',
value="somevalue",
workdate={value = surgdate, cfsqltype="CF_SQL_DATE"}};
var message = queryExecute(
sql,
params,
{datasource="datasourcename"});
}
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/1977ab64-c30e-46f9-838b-89221527f70e%40googlegroups.com.
Database (Name/Version) | PostgreSQL 9.4.1 |
---|---|
Driver (Name/Version) | PostgreSQL Native Driver PostgreSQL 8.3 JDBC4 with SSL (build 607) (JDBC 4.0) |
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/eecb10f9-3aed-42df-bd27-4c03333717b4%40googlegroups.com.
this.name = "myappname";
this.ormEnabled = true;
this.ormsettings = {datasource = "datasourcename", cfclocation = "../models", eventhandling = true, logSQL = false};
public void function preInsert( any entity )
{
this.encryptProperties();
}
public void function preUpdate( any entity )
{
this.encryptProperties();
}
public void function postLoad( any entity )
{
this.decryptProperties();
}
public void function encryptProperties()
{
var props = getMetaData( this ).properties;
for (var prop in props){
if (structKeyExists( prop, "encrypted" ) AND prop.encrypted){
var n = prop.name;
if (!isNull(variables[n])){
variables[ n ] = encrypt( variables[ n ], Application.stcMagic.key, Application.stcMagic.type, Application.stcMagic.block );
}
}
}
}
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/edf8364d-73cb-4097-aa81-7c1c4a004790%40googlegroups.com.