public final class MySqlDBRepository extends Object implements Repository
The basic setup at the code to get Database code to run is the same. The additional thing when using MySQL database is:
<property name="Transaction" value="fr.dyade.aaa.util.NTransaction"/> <property name="NTRepositoryImpl" value="fr.dyade.aaa.util.MySqlDBRepository"/> <property name="DBDriver" value="org.gjt.mm.mysql.Driver"/> <property name="ConnURL" value="jdbc:mysql://hostname:3306/instance"/> <property name="DBUser" value="dbUserName"/> <property name="DBPass" value="dbPassword"/>
CLASSPATH=$CLASSPATH:$VIATOR_LIB/mysql-connector-java-5.0.5-bin.jar CLASSPATH=$CLASSPATH:$VIATOR_LIB/commons-dbcp-1.2.1.jar CLASSPATH=$CLASSPATH:$VIATOR_LIB/commons-pool-1.3.jar
JAVA_ARGS=$JAVA_ARGS" -DNTRepositoryImpl=fr.dyade.aaa.util.MySqlDBRepository -DDBDriver=org.gjt.mm.mysql.Driver -DConnURL=jdbc:mysql://hostname:3306/instance -DDBUser=dbUserName -DDBPass=dbPassword"
CREATE TABLE JoramDB (name VARCHAR(256), content longblob, primary key(name));
NTransaction
,
Repository
Modifier and Type | Field and Description |
---|---|
private int |
baddeleted |
(package private) Connection |
conn |
(package private) String |
connurl |
(package private) PreparedStatement |
deleteStmt |
(package private) File |
dir |
(package private) String |
driver |
(package private) org.apache.commons.dbcp.BasicDataSource |
ds |
(package private) PreparedStatement |
insertStmt |
static org.objectweb.util.monolog.api.Logger |
logger |
private int |
nbdeleted |
private int |
nbloaded |
private int |
nbsaved |
(package private) String |
pass |
(package private) boolean |
reconnectLoop |
(package private) PreparedStatement |
updateStmt |
(package private) String |
user |
Constructor and Description |
---|
MySqlDBRepository() |
Modifier and Type | Method and Description |
---|---|
void |
close()
Closes the repository.
|
private void |
closeConnection() |
void |
commit()
Commits all changes to the repository.
|
void |
delete(String dirName,
String name)
Deletes the corresponding objects in repository.
|
private Connection |
getConnection() |
int |
getNbBadDeletedObjects()
Returns the number of useless delete operation on repository.
|
int |
getNbDeletedObjects()
Returns the number of delete operation on repository.
|
int |
getNbLoadedObjects()
Returns the number of load operation from repository.
|
int |
getNbSavedObjects()
Returns the number of save operation to repository.
|
void |
init(Transaction transaction,
File dir)
Initializes the repository.
|
String[] |
list(String prefix)
Gets a list of persistent objects that name corresponds to prefix.
|
byte[] |
load(String dirName,
String name)
Loads the byte array.
|
Object |
loadobj(String dirName,
String name)
Loads the object.
|
private void |
reconnection() |
void |
save(String dirName,
String name,
byte[] content)
Save the corresponding bytes array.
|
String driver
String connurl
String user
String pass
org.apache.commons.dbcp.BasicDataSource ds
boolean reconnectLoop
public static org.objectweb.util.monolog.api.Logger logger
File dir
private int nbsaved
private int nbdeleted
private int baddeleted
private int nbloaded
Connection conn
PreparedStatement insertStmt
PreparedStatement updateStmt
PreparedStatement deleteStmt
public int getNbSavedObjects()
getNbSavedObjects
in interface Repository
public int getNbDeletedObjects()
getNbDeletedObjects
in interface Repository
public int getNbBadDeletedObjects()
getNbBadDeletedObjects
in interface Repository
public int getNbLoadedObjects()
getNbLoadedObjects
in interface Repository
public void init(Transaction transaction, File dir) throws IOException
init
in interface Repository
IOException
public String[] list(String prefix) throws IOException
list
in interface Repository
IOException
public void save(String dirName, String name, byte[] content) throws IOException
save
in interface Repository
IOException
public Object loadobj(String dirName, String name) throws IOException, ClassNotFoundException
ClassNotFoundException
IOException
public byte[] load(String dirName, String name) throws IOException
load
in interface Repository
IOException
public void delete(String dirName, String name) throws IOException
delete
in interface Repository
IOException
public void commit() throws IOException
commit
in interface Repository
IOException
public void close() throws IOException
close
in interface Repository
IOException
private Connection getConnection() throws SQLException
SQLException
private void closeConnection()
private void reconnection() throws IOException
IOException
Copyright © 2013 ScalAgent D.T.. All Rights Reserved.