Skip to content

pgauthier/AuxiliaryDBPlugin

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 

Repository files navigation

This is the simpliest play! plugin possible.
This allow to connect to an additional auxialiary datasource via jdbc.

Just declare this module in the application.conf, like that

	module.AuxiliaryDBPlugin=${play.path}/modules/AuxiliaryDBPlugin

Then using the same syntaxe as the main db connection, declare the jdbc paramaters like:

	auxiliaryDB.url=jdbc:oracle:thin:@db.host.com:1564:SID
	auxiliaryDB.driver=oracle.jdbc.driver.OracleDriver
	auxiliaryDB.user=P
	auxiliaryDB.pass=P

Finally, you'll be able to use is in java, like this :

	ResultSet res = AuxiliaryDB.executeQuery(sqlStringRequest);
	while(res.next()){
		//TO-DO handle results
	}
	
Tech notes :
This is a simple refactoring of the play.db.DBPlugin and play.db.DB but without any JPA stufs
http://bazaar.launchpad.net/~play-developers/play/1.0/annotate/head%3A/framework/src/play/db/DBPlugin.java

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published