Use progress in Java

[sekero]

Hello, I want to know if is possible use progress in java code, for call to database in progress. This question is because I create connection with progress database in program in java, but when I execute a call to database with Java SQL, this not run. Please Help

 

[Casper]

Hi,

Sure it's possible to run a query from java through jdbc using sql92 to a progress database.
What version of Progress (or OpenEdge) do you have?

Maybe these KB articles can help you further:

KB 20600: http://tinyurl.com/bnyn3
KB 21245: http://tinyurl.com/a4wlq
KB 19986: http://tinyurl.com/7wdjm
And some sample code to make jdbc connection:
KB 21420: http://tinyurl.com/7ahed (well actually it's about code page conversion, but it shows how a connection is made....

HTH,

Casper

 

[sekero]

Thanks for your answer Casper.

My version of progress is 9.1C, thanks for the links. Now i see that in the progress SQL explorer tool the SQL call, for example select * from sports.Item; not run, but in the procedure editor run. The error in the explorer tool is the same that in java code.
In the explorer tool should run the code? is a single statement but not run.
I think that the problem is the same that java. Why can succes this?
Thanks for your time.

 

[Casper]

In the sql explorer the folowing should work:

select itemnum from PUB.item

Casper.