Recent content by nukn

I have encountered the following problem: recursive call of java-stored procedure causes disconnect from the database. The depth of recursion is not big (1-2), but as long as I need cascade delete of objects in an hierarchy, it can not be avoided. Has anybody encountered such problem? Thank you...

I am trying to get several rows from my Progress database in a Java application via JDBC driver. The code I use in application goes as follows: Statement getImages = con.createStatement(); String mySql= new String ("SELECT Image.Id, Image.URL, Image.Commentary FROM Image, Object WHERE...

The answer was easy: insert into Object (Id, Name, ParentId, MailingAddress) values (pub.ObjectsSequence.nextval, 'myplace', 0, 'myplaceaddress');

One of possible causes for this error is that database is not started or url to it is written incorrectly.

Absolutely - I had some of the procedures run succesfully.

Hello, Can anybody advise me any tool to debug java stored procedures in Progress? I run my stored procedures in SQL Explorer, and they are compiled normally. But when I am trying to call them, I get a mistake: === SQL Exception 1 === SQLState=HY000 ErrorCode=-20142 [JDBC OpenEdge...

When I try to select from this table, I get an error "Table/View/Synonym not found" No, trying both of these didn't help.:confused:

I have created four sequences for my database, and they show in Data Dictionary. But when I am trying to get a number from thm in a query like this: insert into Object (Id, Name, ParentId, MailingAddress) values (ObjectsSequence.nextval, 'myplace', 0, 'myplaceaddress'); I get mistake ===...

Hello, I'm new to Progess and I am learning how to create stored procedures. After I write this in SQL Explorer: create table test_helloworld (text varchar (20)); create procedure hello_world () begin SQLIStatement Insert_HelloWorld = new SQLIStatement ("INSERT INTO test_helloworld (text) VALUES...