The DBAbstract jdbc Driver is used to establish a permanent connection to a DBAbstract database server.
The Driver is partially compliant with the java.sql package interfaces.
In order to use the Driver, the "jabs.jar" driver file needs to be located in the classpath or loaded by some other method by the JVM.
The usage is intuitive and a code sample follows:
//load the jabs Driver from the jabs jar.
Class.forName("ro.raducora.utils.jdbc.Driver");
//get a connection from the DriverManager
Connection conn = DriverManager.getConnection("jdbc:jabs://localhost/dbname" , username, pass);
//get the statement
Statement statement = conn.createStatement();
//execute a query
statement.executeQuery("SELECT 1");
//close statement
statement.close();
The complete connection string syntax is:
"jdbc:jabs://HOSTNAME[:PORT]/DBNAME" .
If the PORT is missing, the default connection PORT (11111) will be implied.
Complete samples of using the driver for connections can be found in the "src/ro/raducora/samples" directory.
Warning! The Driver is not fully jdbc complient.
To find the set of supported functions look
in the API Documentation for the ro.raducora.jdbc and the ro.raducora.utils.protocol packages.
The DBAbstract jdbc Backup Driver is used to establish 2 permanent connections to a DBAbstract
database server.
The Driver connects to2 distinct databases. The first one is used to solve "SELECT" type queries but update
or insert queries are executed on both databases, so that the same data exists in both databases.
The Driver is partially compliant with the java.sql package interfaces.
In order to use the Driver, the "jabsr.jar" driver file needs to be located in the classpath or loaded by some other method by the JVM.
The usage is intuitive and a code sample follows:
//load the jabs Driver from the jabs jar.
Class.forName("ro.raducora.utils.jdbcr.Driver");
//get a connection from the DriverManager
Connection conn = DriverManager.getConnection("jdbc:jabsr://localhost/dbname" , username, pass);
//get the statement
Statement statement = conn.createStatement();
//execute a query
statement.executeQuery("SELECT 1");
//close statement
statement.close();
The complete connection string syntax is:
"jdbc:jabsr://HOSTNAME[:PORT]/DBNAME" .
If the PORT is missing, the default connection PORT (11111) will be implied.
In order for this redundant connection to be established, on the server side in the ClientDB.xml properties file
there need to be references to the "dbname" database and to the "dbname_repl" database that will be
used as a replica database.
Both databases connections will be realised with the same username and password
(so they must have the same privilege rights for the used username and password) , but the databases can be
have different vendor implementations.
Warning! The Driver is not fully jdbc complient.
To find the set of supported functions look
in the API Documentation for the ro.raducora.jdbcr and the ro.raducora.utils.protocol packages.