Skip to main content

Configure Oracle Connection Pool in Glassfish V3 for Jasper Reports Integration

Typically, after you have installed your  version of the JasperReportsIntegration toolkit on your Apache Tomcat J2EE server, the configuration files will be located in the directory
 $CATALINA_HOME/conf/Catalina/localhost/JasperReportsIntegration.xml, for example version 4.7.0 of JasperReports, where $CATALINA_HOME represents the path to your installation of Tomcat where all the dataSource configuration are. 

Similarly, after installation of your glassfish sever,  you would have to upload the .war file located in the toolkit version you download Eg.webapp\JasperReportsIntegration.war


Locate  lib/ojdbc14 and lib/orai18n in the  JasperReportsIntegration toolkit copy and  put them in {glassfish_installation}/glassfish/lib directory and restart glassfish (from {glassfish_installation}/glassfish/bin directory):

asadmin stop-domain domain1
asadmin start-domain domain1

or If it was set as a service, just restart it.


Navigate to the administrator application on the default 4848:
http://localhost:4848/
Open the 'Applications >Deploy>




Select New> upload the JasperReportsIntegration.war then OK.



 Please NB:
In the Context Root Located under [name of Domain]\applications\JasperReportsIntegration\META-INF\context.xml . modify it to your DataSource Eg.






 

Open the Applications>Edit the JasperReports and Change the path to the New Context path minus the .xml


Open the 'Resources' -> 'JDBC' -> 'Connection Pools' and select 'New'.
Fill in the Connection Pool 'Name' with a suitable name like Oracle.
Select 'Resource Type' : 'javax.sql.DataSource'.
Select 'Database Vendor' : 'Oracle'.
Select 'Next'.


At the next page go down at the additional Properties.
Find and edit the following properties :
Fill in property 'User' with the 'Value' : {db_user}
Fill in property 'Password' with the 'Value' : {db_user_pass}
Fill in property 'URL' with the 'Value' :
jdbc:mysql://[host]:[port]/[database name]
Select 'Finish'.






Open the 'Resources' -> 'JDBC' -> 'JDBC Resources' and select 'New.
Fill the JNDI Name like 'jdbc/myconnnection'.
Select from 'Pool Name' combo box the pool we just created.
And select 'OK'.



Click Ping to test that it is working. If it is not, it is probably because you have mistyped the connection credentials. Go to 'Additional Properties' tab of the connection pool detail page and correct any errors. Try ping again.


The Connection Pool is ready!Launch the JasperIntegration on the port specificed in your http Listener Port.
If you had any problems creating the pool, send me a message and I'll reply as soon as possible. 
Thanks.

Comments

  1. Nice post! This is a very nice blog that I will definitively come back to more times this year! Thanks for informative post. natural pool builder spicewood tx

    ReplyDelete
  2. Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts. custom pool builder spicewood tx

    ReplyDelete

Post a Comment

Popular posts from this blog

Using App Icons In Oracle Apex (Part1)

 Recently with the introduction of Apex 4.2 and later Apex 4.2.1 the default published  packaged applications comes with a sleek logo just at the left-hand corner of the the login screen. Fig 1 Fig 2 Fig 3 If u want to use these cool  sprites that come with the later releases as said in the the former. From the above diagram, looking into the css  inside the  i / or anywhere that your images are stored navigate to the cloud/app_theme/css/4_1.css You would find the img.appIcon.  class  which houses all the sprite launchpad logos in the Fig 1 Inside the css, locate ------App Icons Image-- img.appIcon.project_tracking{background-position:-256px 0}img.appIcon.solar{background-position:-320px 0}img.appIcon.website{background-position:-384px 0}img.appIcon.apex_service{background-position:-448px 0}img.appIcon.solar_red{background-position:-512px 0}img.appIcon.sales{background-position:-576px 0}img.appIcon.data_modeler{background-position:0 -64px}img.appIcon.group_calen

Disabling of Password Expiration in Oracle Apex(Internal Workspace Admin)

This post was inspired by a  question  on the OTN APEX forum, which contains how to  reset set the password of the  Oracle Internal Workspace Admin    and  Set the account never to expire  The first bullet has so many blogs  talk about how to reset the password of the Internal Workspace. However, i am more intrigued with the second . To start of with It is not advisable to never expire accounts since its rudimental for user to always renew their accounts  prior to expiration. The default expiration of an account is mostly 180 days so hey whats the point going to do this again after 180 days?? . There are two methods that can be used to achieve this  Generic Never expiration of all User accounts (This should never be practiced in a production Environment All database users are assigned to something called a PROFILE . The profile controls two aspects of the users database access – the system resources available to the user and th

How does one add a day/hour/minute/second to a date value?

DATE is the datatype that we are all familiar  with when we think about representing date and time values. It has the ability to store the month, day, year, century, hours, minutes, and seconds. It is typically good for representing data for when something has happened or should happen in the future.  The problem with the DATE datatype is its' granularity  when trying to determine a time interval between two events when the events happen within a second of each other. This issue is solved with the TIMESTAMP datatype. In order to represent the date stored in a more readable format, the TO_CHAR function has traditionally been wrapped around the date: SQL> SELECT  TO_CHAR(hiredate,'DD.MM.YYYY:HH24:MI:SS')  "hiredate"   FROM employees; hiredate ------------------- 17.12.1980:00:00:00 20.02.1981:00:00:00 The SYSDATE pseudo-column shows the current system date and time. Adding 1 to SYSDATE will advance the date by 1 day. Use fractions to add hours, minut