How to use JDBC Connector?

39 Views

Hello! Everyone,

I have a JDBC customer database application we built for our users. While using EP5 we developed some ASP pages to webenable that application. Now we are migrating to EP6 and it does not have it IIS. We don't want to use IIS for web enbling the database. In EP6 SP2 I know you can connect to a JDBC database and display the data using a SQL query. But our interest goes beyound simple display do database table.

1. We want to be able to update data to the table based on conditions,

2. We want to summarize the data and display the data. Simple example is showing a cumilative based on date as well as category.

How can we use this JDBC connection to do the same? Is there a simple development tool to develop similar content? Is there a tuturial/help doc to achive this?

Thanks in advance.

Regards,

Piyush Bhandari