brainstorm: Remote JDBC driver in NextReports 4.0

Monday, March 28, 2011

Remote JDBC driver in NextReports 4.0

NextReports 4.0 has been released.

From this version, both designer and server will have the same major number. One of the new functionality from designer is the possibility to create a data source of type NextReports Server.

This means designer will use a driver found on the server. You do not need the driver on your computer. This JDBC driver is implemented using Web Services.

Driver's url has a special form jdbc:nextreports:@<server url>;<server data source>. When you edit the url you will have to select a NextReports Server and then you can browse the data sources tree on the server:

To be able to browse the data sources, the user and password entered for driver connection will be used.

This functionality is very important for companies which do not want to expose their databases.

No comments:

Post a Comment

About Me

Mihai Dinca-Panaitescu

Working with Java since 1998 with focus on both server back-end and UI.

In the late 90's till 2003 when not so much frameworks were present I was involved in proprietary server implementation (with all the technology from that time like RMI, JDBC, transactions, Servlets, XML, XSL), user interface with SWING and a lot of algorithms for agriculture business.

In middle 2000's I was involved in many custom development projects adding more flavor to my knowledge : JBoss and OC4J servers, J2EE, Hibernate, EHCache, Ant, JUnit, TestNG

From 2008 I was part of NextReports, starting with designer development in SWING. Then NextReports Server came to life and new technologies were adopted : Spring, JPA, JCR, Wicket, jQuery, Jersey, Maven, Ivy, Git, Android.

Since starting of 2014 I developed a HTML5 library called NextCharts which can be found on github.

I’m currently part of the NextReports developing team at Advantage Software Factory, a local leading provider of business software solutions. NextReports is a business reporting suite composed of reports designer, reporting engine and reporting server. Besides this product, ASF also developed a debt collection software and a CRM solution.