Hi
We have been using ABL and we have some Java applications that will be accessing using JDBC to access OE DB.
I would like to hear the experiences from the experts that have been using JDBC.
Anything regarding
1. performances
2. transactions
etc..
any help will be appreciated.
rgds
Smi
did you have already read the documentation ?
The problem is that the database access do not solve the problem of integration because you don't know how the business works,
only with an simple DB access. Take a look to JAVA-OpenClient and to WebServices (Better ideea!)
http://documentation.progress.com/output/OpenEdge102b/oe102bhtml/wwhelp/wwhimpl/js/html/wwhelp.htm#href=dvjav/01dvjavtitle.html
http://documentation.progress.com/output/OpenEdge102b/oe102bhtml/wwhelp/wwhimpl/common/html/wwhelp.htm?context=dvwsv&file=01dvwsvtitle.html
When I worked for Progress, we built the OpenEdge Architect Catalog to use JDBC. As far as I know, it has been relatively stable doing that.
I have also worked with JDBC through Hibernate to OpenEdge. It was hard to get it working, but it does work. There are a couple of Progress users that have had success with that architecture.
Performance-wise, I have not seen any significant issues, but then my use-cases have been limited to fairly simple SQL. Transaction-wise it is as solid as any other Progress transaction.