Need to develop a tool which can work with Java and VB both!

SlickSoul · 07-18-2003, 04:34 PM

Hi

I need to develop a tool which can work with Java and VB both!

Are there any ideas? What should I do?

Spookster · 07-18-2003, 06:07 PM

Your description and question are kind of vague. You might wish to elaborate a bit more.

SlickSoul · 07-18-2003, 06:25 PM

Quote:

Originally posted by Spookster
Your description and question are kind of vague. You might wish to elaborate a bit more.

Well there is this application running in VB and this application running on Web Logic in Java - there is a need to develop a tool which will be accessed by both the applications seperately to carry out a common task of doiing mathematical calculation and then storing the value in the database. Is there anyway to do this? Or does two tools have to be built - one in VB and the other one in Java? (I want to avoid the double work to be done and was wondering somehow if only one tool can be made to do this and then which can be accessed by both the applications seperately and this make the effort easy and make the work little lighter.)

Roy Sinclair · 07-18-2003, 06:33 PM

If you've got a smarter database you can put the logic for the calculation into the database itself. With SQL Server you'd use what is called a Stored Procedure, I'm not sure what Oracle or DB2 call it but they all provide a similar (but definitely not the same) capability.

SlickSoul · 07-21-2003, 04:35 PM

Quote:

Originally posted by Roy Sinclair
If you've got a smarter database you can put the logic for the calculation into the database itself. With SQL Server you'd use what is called a Stored Procedure, I'm not sure what Oracle or DB2 call it but they all provide a similar (but definitely not the same) capability.

Hmmm..I'm thinking will this affet the performance of the database in the production environment?? Also, is there any other way beside doing it in the database?

Roy Sinclair · 07-21-2003, 06:28 PM

You can code the same logic into two different languages. You were asking for solutions which avoided that. Unless you expect a massive amount of traffic using this I don't expect the load on your database server would be intolerable.

soccerdvy · 07-25-2003, 06:14 PM

you could always try developing in a language like C and having it access the outside programs with direct commands. You could build the support for both of these programs into a new C lib. That way you would be able to communicate with both of the two technologies and do math directly using the logical operators in C.