Report - Form Services
MySQL 8 SSL
Issue Admin is making a database connection to a MySQL 8 database. When clicking the Ping button on the DB Connection object, the following error is presented: WARN: Establishing SSL connection without server's identity verification is not ...
Building an Employee Phonebook system
Building a Mini Application Post #20 Can it really be that simple to create a little application with Report and Form Builder? This tutorial shows you that it is - and actually helps you make a useful application at the same time as learning how to ...
Working with Binary Data in Report Services
Quick Start Guide - Binary Data This tutorial is designed as a quick "How Do I Work With Binary Data" tutorial. It walks through the steps necessary to upload an image to a database. Every webNetwork 6.0 installation ships with a database called ...
Move SQL Databases to a new SQL Server
Issue Customer would like to move their UW SQL Databases from older hardware to new hardware. Solution The easiest method is to use the same SQL database type, as this only requires exporting/importing the existing database from the old server to the ...
Restore Audit Services HSQL database to shipping state
Prerequisite: Unified Workspace is still configured to use the shipping "demo" HSQL database for Audit Services. Issue: webNetwork service will not finish starting. The /stoneware/config/webNetworkTrace.log startup log file shows UW is getting stuck ...
Database Pooling
Issue The way UW connects to a Database to run queries, it uses a single connection for each DB object created. Thus if you have multiple queries that are run against that connection, they are processed in order, one at a time. A very long query ...
Error using Report Services on headless server
When we click on the "insert database field" icon in Report Builder, we see a red X next to the field name. The following error is also generated: java.lang.NoClassDefFoundError at java.lang.Class.forName0(Native Method) at ...
Connection is busy with results for another hstmt
I wrote a JSP page to connect to a SQL database. I have about 3 connections for each result set. I receive the error "Connection is busy" with results for another hstmt. Sometimes I receive the error, sometimes I do not. I also would like to know if ...
Unable to see database connection in Report Builder
You must add each uers/group to have access to those database connections. WebNetwork 5 has added security to see the database connections.
Pivot Tables
While we dont’ have any special handlers for pivot tables, you should be able to accomplish the same thing doing a query like this in the report builder: SELECT SUM(CASE WHEN MONTH(OrderDate) = 1 THEN 1 END) AS ’January’ ,SUM(CASE WHEN ...
Conditional Output
Conditional Formatting on Rows You can use our row choose.. right click on the table row to see it to do alternating colors. If you want conditional formatting based on values, you can use the JavaScript block (drag it down from the menu at the top) ...
Where does the JDBC driver get installed in webNetwork
The JDBC .jar files go in /stoneware/jre/lib/ext/. ** *** Even though the JDBC drivers are only used on the webNetwork ACS (loader) it is recommended that you copy them to all physical Stoneware servers (loaders and relays). The debug messages in the ...
Javascript to help control refreshing data in a different frame.
Javascript to help control refreshing data in a different frame. parent.frames['frame name here'].location.reload(); Refresh a specific frame on a split pane report after an add / update / delete on a form. Example for this will be you may have a ...
MS SQL Transaction Logs full
MS SQL defaults to only truncating the transaction logs once the database and transaction log have been properly backed up. At that point the server will clean truncate and compact the log files. Obviously, this requires having a backup system in ...
What does webNetwork send to the SQL server to purge logging data each night?
Each night at midnight the loader sends a SQL command to the SQL server to purge old log information. That command is as follows : DELETE FROM LogTable WHERE LogTime < 'some date'; 'some date' is formatted like this: yyyy-MM-dd HH:mm:ss If your ...
Configure Analytics features in webNetwork 6.1+
Basic Steps: Create new database called "swaudit" Run the appropriate script file located in /stoneware/hsql/dbscripts directory Give access to the appropriate DB user accounts Create DB connection object OR reuse existing webNetworkAuditDB object ...
HSQL database driver updated in Unified Workspace
As of Unified Workspace 6.3.1.x, the driver used to communicate with the built-in HSQL databases is being updated. This update changes the delimiter used when storing the information. If you are using HSQL for anything other than webStore (which ...