@RemoteProxy and DB design

简介: @RemoteProxy and DB design

# Created by Wang, Jerry on Nov 13, 2015


DWR Annotations

DWR annotations can be used as a replacement as well as in conjunction with dwr.xml.

Annotation support was written by Maik Schreiber.


Setup

To use DWR with annotations you need to specify a different DWR controller servlet in yourweb.xmlimage.png

Remote Class Access

To make a simple class available for remote access, use the @RemoteProxy and@RemoteMethod annotations:image.pngimage.pnglink: http://hsqldb.org/doc/guide/ch01.html

read from script file

Launch demo database

lock just a file, you have to delete this file manually to work on the db.

launch DB tool -

Failed to load preferences. Proceeding with defaults:


java.sql.SQLException: The database is already in use by another process: lockFile: org.hsqldb.persist.LockFile@8c306d86[file =/root/DemoDB/demoDB.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2015-11-13 09:25:38.001 heartbeat - read: -4168 ms.

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:664)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at org.hsqldb.util.ConnectionDialogSwing.createConnection(Unknown Source)

at org.hsqldb.util.DatabaseManagerSwing.main(Unknown Source)image.png



相关文章
GM6 pageset - DB get scenario
Created by Wang, Jerry, last modified on Apr 21, 2015
GM6 pageset - DB get scenario
|
SQL Go 数据库
Microsoft SQL Server Product Samples:Database
原文:Microsoft SQL Server Product Samples:Database 从SQL Server 2005 之后示例数据都为AdventureWorks,需要的通过codeplex网站下载。
949 0
|
Oracle 关系型数据库
Mandatory Patching Requirement for Database Versions 11.2.0.3 or Earlier, Using DB Links (DOC ID 2335265.1)
Mandatory Patching Requirement for Database Versions 11.2.0.3 or Earlier, Using DB Links (DOC ID 2335265.
2778 0
|
SQL Oracle 关系型数据库
|
负载均衡 Oracle 关系型数据库