How to connect to Sybase 12 ASA database server from iReport and JasperReports Server

In this article I want to describe the process that shows how to connect to Sybase 12 ASA database server

Developer edition from iReport and JasperReports Server.

The Sybase 12 ASA was installed in Windows 7 operating system.

The installation process of Sybase was pretty straightforward to provide it with the complete description.

I just want to say that I started it by clicking on the SA1201_Developer.exe file, and then I accepted all default

settings that were suggested by the installation program.

With the Sybase 12 ASA Developer edition is supplied the test database that has name "demo"

1. How to start, stop and connect to the Sybase demo database from the GUI tools that are supplied with Sybase distribution:

   After the installation process is completed in the windows menu should appear the tab related to Sybase:

   

   the next screen shot shows how to start the demo database

   

   

   

   

   

   Let's try to connect to the demo database from Sybase Central - Sybase database GUI administration tool

   

   

2. Configuring the connection to the Sybase demo database from iReport editor:

   With the Sybase 12 ASA is supplied jconn3.jar driver. We will use it to connect to the Sybase 12 ASA database server.

   

   Path to the jconn3.jar JDBC driver should be defined in iReport Editor

   

   

   

   

3. This paragraph describes how to connect to the Sybase 12 ASA database from the JasperReports Server.

   

   After jconn3.jar driver is placed in the lib folder, apache-tomcat should be restarted to make this driver available to it.

   Beneath is shown how to create the Sybase data source in JasperReports Server:

   

   

   After the Data Source is set and tested we can upload the test report from the iReport Editor to the JasperReports Server via Repository Navigator plugin.

   

   Let's navigate to this report in JasperReports Server and try to execute it

   

   

   As shown in the last screen shot the report was successfully executed that means that the connection to the Sybase from JasperReports Server also works fine.

4. Sybase command line tools.

   I am not a very experienced Sybase database administrator, but the first question that I've asked myself after I started Sybase database from the GUI tools was: Is it possible to start and stop Sybase database from the command line?
   Beneath I provide the very simple commands and only for your very first familiarization with it.
   Please refer to the Sybase brand documentation if you need more information related to the Sybase command line tools.

5. To start our practice with these tools we should navigate to the bin64 folder

   

   Let's try to check that Sybase demo database that we have started via GUI in the previous paragraphs is up and running

   

   

   

   

   We can also check that the database is working via the dbping command:

   

Please find in the attachments the sample of the report that was described in this article.

Thats all. Thank you for reviewing my article :)

case_30550_simple_sybase_report.jrxml

case_30550_sybase_rep_1.zip