DbPages version 1.0.5-10

Short instruction

SYSTEM VARIABLES:

Upload file to HTTP_DOCS table

Structure of HTTP_DOCS table

CREATE TABLE HTTP_DOCS (
  NAME         NVARCHAR(256) NOT NULL,
  MIME_TYPE    NVARCHAR(128),
  DOC_SIZE     NUMERIC,
  LAST_UPDATED DATETIME,
  CONTENT      VARBINARY(MAX)
)
/
ALTER TABLE HTTP_DOCS ADD CONSTRAINT HTTP_DOCS_PK
  PRIMARY KEY (NAME)
/

Download files from HTTP_DOCS table

Structure of HTTP_MAIL table

CREATE TABLE HTTP_MAIL(
  NMAL NUMBER NOT NULL,
  RECIPIENT NVARCHAR(4000) NOT NULL,
  MESSAGE NVARCHAR(MAX),
  SUBJECT NVARCHAR(1000),
  CREATED DATETIME DEFAULT (getdate()),
  UPDATED DATETIME,
  STATE NVARCHAR(1) DEFAULT 'N' NOT NULL,
   CONSTRAINT HTTP_MAIL_PK PRIMARY KEY (NMAL)
   )
/
CREATE INDEX HTTP_MAIL_STATE_I ON HTTP_MAIL (STATE)
/

Send email

Config file (config.properties in %PROJECT_DIR%/WEB-INF/classes directory):

# Configuration file of DBPAGES System
#connection - DB connection name configured for Application Context
connection = db
#useCompress - compress pages (true/false)
useCompress = false
#useSecureConnection - allow only
useSecureConnection = false
# startup - startup prodecure
startup = http_help.home
# beforePage - procedure fired before generating page
beforePage = 
# afterPage - procedure fired after generating page
afterPage =
# allowedProcedures - list of procedures that user can run
# * means all procedures accesible to database user application is logged in.
allowedProcedures = *
# procedures for download binary files
downloadProcs = http.process_download
# procedures to upload binary files
uploadProcs = http.process_upload
#packageName - name of dbpages package or schema. For Oracle, Microsoft SQLServer database http, for MySQL leave empty.
packageName = http
#namedParams - set to true if DB engine uses named parameters (eg. Oracle, Microsoft SQL Server)
namedParams = true
#charset - charset for output
charset = utf-8
#smtpHost - hostname of smtp server
smtpHost = smtp.server.pl
#smtpUser - username of smtp server
smtpUser = user@server.pl
#smtpPasswd - password of smtp server
smtpPasswd = password
# email address for sending emails
smtpFrom = user@server.pl
# turno on/off debug mode, extended info put into STDOUT log
#debug=true

Apache Tomcat 6.x context file (context.xml in %PROJECT_DIR%/META-INF directory):

Resource name="db" is the connection parameter name from config file

<?xml version='1.0' encoding='utf-8'?>
<Context>
  <Resource 
    name="db" 
    scope="Shareable" 
    type="javax.sql.DataSource"
    password="user"
    username="password"
    driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
    url="jdbc:jdbc:sqlserver://localhost\sqlexpress;database=dbpages"
  />
</Context>

Apache Tomcat 6.x access web file (web.xml in %PROJECT_DIR%/WEB-INF directory):

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
    "http://java.sun.com/dtd/web-app_2_3.dtd">

<web-app>

  <servlet>
    <servlet-name>DBPagesHttpServlet</servlet-name>
    <servlet-class>DBPagesHttpServlet</servlet-class>
    <load-on-startup>1</load-on-startup>
  </servlet>

  <servlet>
    <servlet-name>others</servlet-name>
    <servlet-class>
      org.apache.catalina.servlets.DefaultServlet
    </servlet-class>
    <init-param>
      <param-name>debug</param-name>
      <param-value>0</param-value>
    </init-param>
    <init-param>
      <param-name>listings</param-name>
      <param-value>false</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet>

  <servlet-mapping>
    <servlet-name>DBPagesHttpServlet</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>others</servlet-name>
    <url-pattern>*.gif</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>others</servlet-name>
    <url-pattern>*.jpg</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>others</servlet-name>
    <url-pattern>*.png</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>others</servlet-name>
    <url-pattern>*.css</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>others</servlet-name>
    <url-pattern>*.html</url-pattern>
  </servlet-mapping>

  <error-page>
    <error-code>500</error-code>
    <location>/docs/error/500.html</location>
  </error-page>

</web-app>

Charset Test

HTTP Schema