Pointbase Database Learning

Data | Database Pointbase is a 100% Java-only small database, because of its small size (database server engine only 1M), the client files add up to less than 1M, so often can be used as a project demo, plus is written in Java, so platform support is very strong, Recommended for learning and project demonstrations, the following is the basic configuration and learning of Pointbase:
Pointbase basic files have three: (Can be downloaded on the official website of Pointbase, there are assessed copies for free download: http://www.pointbase.com/
I use the Pointbase server 4.4 main files only three: Pbserver44.jar,pbclient44.jar,pbtools44.jar.
1 Pbserver44.jar (1200k only, I was a little surprised when I first contacted) is a database engine file that can be run separately as a database server, starting method Java Com.pointbase.net.netServer
2 Pbclient44.jar provides JDBC driver and client related files, Pbtools44.jar is the client's setup and operation, if you want to run the window configuration program: Java com.pointbase.tools.toolsConsole
Details are as follows:
1 server-side settings:
1, set the environment variable classpath, the Pbserver44.jar file path included.
2, set up the database configuration file Pointbase.ini file, the main set up the database storage path (create a Pointbase.ini file, add the following content:
Database.home=e:\pointbase\databases
3, start the server:
Java com.pointbase.net.netserver/port:9092/d:3/pointbase.ini= "E:\pointbase\tools\pointbase.ini"
(Note: Port parameters represent ports, D is the priority, Poinbase.ini file represents the path of the configuration file, you can write a script, the above content is completed, strongly recommended to write a footstep)
Detailed help can be found on the official website or run Java com.pointbase.net.netserver/help to view parameter usage
2 Customer Application Segment configuration:
1, the setting of environment variable classpath, add Pbclient44.jar and Pbtools44.jar path.
2, start the client: Java com.pointbase.tools.toolsConsole
(You can also write a script < strongly recommend writing a script to facilitate later operations, such as Windows can write a bat file, the specific wording can be used to find information, extremely simple)
3 Some important parameter content:
Universal JDBC Driver: Com.pointbase.jdbc.jdbcUniversalDriver (in Package Pbclient44.jar)
URL database connection:jdbc:pointbase:server://<machine_name><:p ort>/database name
such as: Jdbc:pointbase:server://localhost:9092/sample
(Pay attention to the colon, I just did not notice, the result of an afternoon, this is my defeat of the lesson, I hope you will note)

About the content of the Pointbase simply said here, I hope everyone succeeds, as for other database connections such as: Oracle,ms sql,db 2,mysql, such as the people can learn from themselves, very simple things. However, in peacetime exercise when it is recommended that you use Pointbase, which will not consume system resources (or you want to run on your machine eclipse< plan to write an introductory article, but think about it, the network of textbooks too much, do not write, and at the same time running a MySQL, And then to run tomcat< fortunately not weblogic&gt, and for the average person is a kind of pain), as for the database connection Jndi in Tomcat settings problem can be seen in my another article: Tomcat under the configuration of Jndi.
In this article there are any questions you can contact me, or message:
qq:56416938