Softwares and Drivers for Specific Models

Dell Mini
Lenovo IdeaPad
Acer Aspire
Samsung N

ASUS Eee PC Specific

Dell Mini Specific

Lenovo Specific

Acer Aspire Specific

Samsung N Specific

Toshiba Specific

Gigabyte Specific

iiView Specific

MSI Wind Specific

HP Mini
HP Mini
Sony Vaio W
LG Netbook
Windows XP Downloads
Ad Space for Rent
Rss Subscribe
Facebook Fan Page
Follow us at Twitter

HP Mini Specific

Fujitsu Specific

Sony Vaio Specific


Windows XP Softwares

Advertise Here!

Rss Subscribe

Facebook Page

Follow us @Twitter

Tablet PC Software Downloads

Pojo-sp 3.1

Ultrabook / Netbook Software Downloads » Developer Tools » Pojo-sp 3.1
Bookmark and Share Subscribe

Date Added:

Nov 17, 2014 01:46 AM

Publisher's Description:

If you have to call stored procedures on your applications you have to use the standard JDBC API working with CallableStatement objects. But now you can use a more simple and efficient solution that use annotated POJO classes and a ProcedureManager instance. Designed from scratch the pojo-sp library is offering the best object oriented solution to use stored procedures on your applications by hiding the JDBC SQL programming artifacts. For each stored procedure or function call you have to design an annotated POJO class, a Java Bean class with annotations. The POJO class must be decorated with a @StoredProcedure annotation and you have to specify the name of the stored procedure or function that is mapped by your class. If the procedure or the function is from an Oracle package you have to specify also the name of the package: .

Next you have to specify if the entity you are calling is a procedure or a function. This attribute is by default true for stored procedures and must be set to false if the entity you are calling is a function. The difference between a procedure and a function is that the function always has a return value. Inside your POJO class you have to define the stored procedure parameters call and to decorate the fields with @StoredProcedureParameter annotation. You have to specify the index of the parameter starting with 1 for the first parameter. The names of the parameters are not important because the parameters are accessed by index not by names. If the entity is a function the first parameter (index = 1) is always the return value. The next attribute is the SQL type of the parameter. Here you have to be carefully because you are just did a mapping of a SQL type to a Java type and this mapping must match. The last parameter is the direction attribute for this parameter which can be IN, OUT or INOUT. For a function result parameter you must specify always OUT as a direction attribute.

The next step is to create a ProcedureManager instance, set the input parameters on your POJO class and finally call the stored procedure. The ProcedureManager instance is created using the ProcedureManagerFactory.createInstance() method using a JBC Connection object as parameter or a class decorated with @JDBC annotation. If you need to use transactions a TransactionManager interface is available to use. Also all checked exceptions are converted to unchecked exceptions and its not mandatory to use a try catch block on your code.


Last Download:

Dec 03, 2023 02:20 PM






(0 Ratings)  Must Register to Post Rating


Please Register to Post Comments

Pojo-sp 3.1

Report Broken Download Link

Some of our Latest and Top Downloads

Recent Downloads

1. Iperius Backup 4.3.3 (Added on 9/6/2015)
2. Unreal Commander 2.02.1098 (Added on 9/6/2015)
3. Far Manager 3.0.4413 Beta / 3.0.4400 Stable (Added on 9/6/2015)
4. PhonerLite 2.27 (Added on 9/6/2015)
5. Eraser (Added on 9/6/2015)
6. Phoner 3.0 (Added on 9/6/2015)
7. Pocket Radio Player 090415 (Added on 9/6/2015)
8. Notepad++ Portable 6.8.3 (Added on 9/6/2015)
9. Notepad++ 6.8.3 (Added on 9/6/2015)
10. Miranda IM Portable 0.10.35 (Added on 9/6/2015)

Latest Recommendations

1. Gesture 2Launch Full Version {Free for Limited Time} (Added on 2/27/2013)
2. Classic Shell v3.6.5 - Windows 8 Start Menu like Windows 7 (Added on 2/16/2013)
3. Opera 12.11 (Added on 12/9/2012)
4. Metro UI Tweaker for Windows 8 (Added on 11/30/2012)
5. WinSetupFromUSB 1.0 Beta8 (Added on 4/30/2012)
6. SpeedyFox 2.0 (Added on 3/25/2012)
7. My CPU Monitor 1.00 (Added on 3/12/2012)
8. Yahoo! Messenger (Added on 3/3/2012)
9. Mozilla Firefox 10.0 Final (Added on 2/7/2012)
10. BasicMouse and BasicBoard (Added on 2/1/2012)

Most Downloaded

1. WinSetupFromUSB. 0.2.3 (70288 Downloads)
2. Netbook Resolution Customizer Version 1.0 Beta2 (69160 Downloads)
3. Acer Aspire One D255 Wireless LAN Driver Win7 (63954 Downloads)
4. BasicMouse and BasicBoard (50235 Downloads)
5. Acer Aspire One D270 Wireless LAN Driver Windows 7 32bit (47696 Downloads)
6. Samsung N150 Wireless LAN,REALTEK Windows 7(32bit) 1676.12.1113.2009 (40197 Downloads)
7. Acer Aspire One D270 WebCam Application Windows 7 32bit 1.5.2108.00 (38064 Downloads)
8. AsTray Plus 1.4.0 BETA1 (37201 Downloads)
9. Toshiba Mini NB505 Realtek Wireless LAN Driver Windows 7 (32bit) 2.00.0013.L_101021 (34708 Downloads)
10. Acer Aspire One D255 VGA Driver Win7 (33249 Downloads)

Alexa Rank

RSS Subscribers

Rss Subscribe
Contact Us

Submit your Software