This content has been marked as final. Show 5 replies
FDS does not connect to a database. Instead you have to use either HTTP, WebService, Java POJO, Java Spring, Java Hibernate, ColdFusion, or PHP. With that said, you will need an application server as well, FDS is installed on application server. You can use Tomcat (this is what I use), JBoss, JRun, etc.
RDBMS like MySQL, MS-SQL Server, Oracle, DB2 and so on.
Could some expert write code examples explaining the recovering data from RDBMS via an SQL query or how can i pass my query to the webservice and get the results data and finaly populate my gridline... and the other way... how can i send the content of the gridline to an update or insert query in the webservice...
Tanks for any help.
I'd recommend reading through the FDS sample applications. The samples apps demostrate data access with FDS using the JavaAdapter and custom assemblers as well as the Hibernate assembler.
In my Java world I use Hibernate combined with Spring classes to read data from the database and use it in my FDS custom assemblers.
I agree with Bill, using Spring with HIbernate is the way to go. Gives you more options and flexibility.