A couple of observations.

1. You shouldn't be establishing db connections for every request like the code in DatabaseCon .You need to use a db connection pool

2. Why don't you look into a framework like spring to better organise your application. You can use the JDBC interface provided there and this will even manage db connections for you

3. When you say you want to be able to connect to different branches and make blance enquiry etc. Will you be doing this within the organisation . i.e the bank or will you be accessing from outside say as a customer?

4. If you are doing webservice i will advice like logica to use CXF. Look into using CXF with Maven via the CXF plugin and all the boilerplate code, wsdl etc will be auto-generated for you.

5. What do you need the Trigger for. A trigger that fires on Insert of every record will seriously slow down the Flexcube banking app. you probably don't wanna do this

Dude, Spring is not ONLY for developing web applications. The whole shebang can run within the Spring context - TrxInterface, WebSphere MQ (it's no longer referred to as MQ Series), et cetera. You can even use Spring Integration in this instance.

@webmonkey

Is it compulsory that you most deploy the app in a J2EE container and use MQ( i know some companies force these kinds of things down developer's throats ).

If you have more leeway on the architecture of the system. Start looking at Spring integration ASAP as suggested by logica.

You will be ready with a working application within a couple of hours combining the JDBC adapter with a JMS or Webservice Gateway

candylips:

@webmonkey

Is it compulsory that you most deploy the app in a J2EE container and use MQ( i know some companies force these kinds of things down developer's throats ).

If you have more leeway on the architecture of the system. Start looking at Spring integration ASAP as suggested by logica.

You will be ready with a working application within a couple of hours combining the JDBC adapter with a JMS or Webservice Gateway

It seems that anywhere j2ee is mentioned,the experts talk spring.Okay ooo! I am a newbie and I tried learning ejb but the annotation driven framework,akin to secret societies signs didn't make it easy so I stumbled on a blog that had so many spring advocates and I decided to go a learning spring.From what I was able to consume before I had a system crash,spring seems to give you that sense of control and makes you feel part of the whole development(I prefer XML configuration to java 5 annotations) of which I think every developer wants(I stand to be corrected);although being inexperience I do not know if this is a false sense of control and integration.However,it was easier for me to understand the parts of the reference documentation I have read so far-Ioc container,DI,Spring AOP,was reading DAO's and support for ORM before I went down.

This period I have not being playing with my eclipse,I have spent most of the time reading and trying to come to terms with the spring concepts and I seem to have no trouble appreciating ithe fact that it is easier to learn than ejb although as a beginner,you will struggle a little to understand the initial concepts like IoC and DI.

I hope to get myself a new system and finish up and become like you guys and begin to talk spring,get a job and get a life.God dey

looks like you didn't see my post

@webmonkey

If you had gone with C# and the .net framework from when you started this thread you would have completed this project by now. Since you have started with Java, then you should try and finish it with Java but if you do get stock then I will suggest you do it with C# and the .net framework. Keep us posted on how you get on.

webmonkey

Nice to know you are still open to using C# for the web service, I will recommend C# as the codes are very similar to Java. To start with you'll need to install a copy of visual studio 2003 or above, but from 2005 is better as it comes with it's own IIS. To create a web service after instalation:

Click on File - New Project you will get a new window

From the new window above select - ASP.Net Web Service Application, give it the name and the location you want, click ok and you have created a web service.

In the code window begin to create your database connection and the WebMethod that will be consumed. I will go deeper into this if you are happy to use C#.

After the above compile the ASP.Net Web Service Application and you can now create the application that will consume the web service by creating a new web or windows application from the file menu.

From this web or windows application you have created above you just need to add the web reference which will be the address of the web service you have created above, then create the object that will use the web methods, compile and run your web or windows application and the application is ready for deployment on a windows server, to deploy it on any platform the you'll need Mono visit this website for more details:
http://www.mono-project.com/Main_Page

Let me know if this is of interest to you, if it is then I can go into more details on creating the database connection and the web methods.

webmonkey

webmonkey

Nice to know you are still open to using C# for the web service, I will recommend C# as the codes are very similar to Java. To start with you'll need to install a copy of visual studio 2003 or above, but from 2005 is better as it comes with it's own IIS. To create a web service after installation:

Click on File - New Project you will get a new window

From the new window above select - ASP.Net Web Service Application, give it the name and the location you want, click ok and you have created a web service.

In the code window begin to create your database connection and the WebMethod that will be consumed. I will go deeper into this if you are happy to use C#.

After the above compile the ASP.Net Web Service Application and you can now create the application that will consume the web service by creating a new web or windows application from the file menu.

From this web or windows application you have created above you just need to add the web reference which will be the address of the web service you have created above, then create the object that will use the web methods, compile and run your web or windows application and the application is ready for deployment on a windows server, to deploy it on any platform then you'll need Mono Sponsored by Novell visit this website for more details:
http://www.mono-project.com/Main_Page

Let me know if this is of interest to you, if it is then I can go into more details on creating the database connection and the web methods.

webmonkey
Please ignore
[s]I've had to use a new name as nairaland has bared me for sending the post below, I think they are angry because I have recommended Microsoft C#. leave me your email address in case I'm bared again
Nice to know you are still open to using C# for the web service, I will recommend C# as the codes are very similar to Java. To start with you'll need to install a copy of visual studio 2003 or above, but from 2005 is better as it comes with it's own IIS. To create a web service after installation:

Click on File - New Project you will get a new window

From the new window above select - ASP.Net Web Service Application, give it the name and the location you want, click ok and you have created a web service.

In the code window begin to create your database connection and the WebMethod that will be consumed. I will go deeper into this if you are happy to use C#.

After the above compile the ASP.Net Web Service Application and you can now create the application that will consume the web service by creating a new web or windows application from the file menu.

From this web or windows application you have created above you just need to add the web reference which will be the address of the web service you created before, then create the object that will use the web methods, compile and run your web or windows application and the application is ready for deployment on a windows server, to deploy it on any platform the you'll need Mono visit this website for more details:
http://www.mono-project.com/Main_Page

Let me know if this is of interest to you, if it is then I can go into more details on creating the database connection and the web methods.[/s]

Who is barring you and why? It is very frustrating that one’s idea is not deliberated and probably encouraged. Whoever is barring should please consider moderating the forum rather than banning potential users that has meaningful suggestion to contribute toward technological achievements.

However, cshrpjava1 I am recommending several design architecture in my PID (Project Initiation Document). I hope I will have time to go through all these technologies so that I will have a technical background before I present it to the steering committee meeting that I am adopting this technology.

These are the technologies I am considering using:

1. Meridian Tool Kit (Off the Shelve)
2. JAX-WS (Java Web Service)
3. ReST (Representational State Transfer)
4. .NET (C#, VB/VB.NET web service)

IT CERTIFICATION EXAMS AT APTECH SURULERE
1 TESLIM BALOGUN STREET,
SURULERE
LAGOS STATE.


REGISTER FOR IT CERTIFICATION EXAMS AT AFFORDABLE RATES.

I will still say go for Spring. The learning curve is not that steep for any one with more than a beginner background on Java. And I believe that is a major consideration for a project manager. How fast can you team integrate a new technology.

One thing that is an advantage for spring is the way stuffs are broken in to modules. You can integrate as need arises. So you can break up to the team along the lines of WS and Security and other module.

A Chief Architect who does not know that sticking to the framework most competent in is the best way to go?? hmm . . . .

Again @Webmonkey, if you are best in Java, stick with Java. There is no such thing as one language being better than the other in all this. What you can do with one, you can mostly do with the other. the key is going with what you know best and getting the work done.

The simple service you have above is going to deliver what you need. You may need to tweak it for performance, scalability and adaptability etc. Apart from that, simple is NOT EVIL. Matter of fact, what using a BUSINESS framework does is adding more lines of code and potential trading performance for structure or something else. you need to start simple(where you know you can), and build on it as you discover the need to.

Kobojunkie:

A Chief Architect who does not know that sticking to the framework most competent in is the best way to go?? hmm . . . .

Again @Webmonkey, if you are best in Java, stick with Java. There is no such thing as one language being better than the other in all this. What you can do with one, you can mostly do with the other. the key is going with what you know best and getting the work done.

The simple service you have above is going to deliver what you need. You may need to tweak it for performance, scalability and adaptability etc. Apart from that, simple is NOT EVIL. Matter of fact, what using a BUSINESS framework does is adding more lines of code and potential trading performance for structure or something else. you need to start simple(where you know you can), and build on it as you discover the need to.

I totally agree with you. What is lacking amongst Nigerian programmers is in-depth knowledge and expertise needed to deliver high performance and robust softwares.No language is better than the other. What we have is fundamental computing implemented in different languagues.Although some are good in certain areas than others (like implementing AMQP in Erlang ,spring supports it in java via spring AMQP).In terms of enterprise application which is what is needed here, java has proven to be doing very well in it especially with spring. I get pissed at all these apostles who are here defending what they don’t know. What contributions have they made to those languages they defend?

I agree that the solution you posted earlier should work for you.  Like Kobojunkie said, tweak for performance and scalability. 

You've solved most of your problem as far as calling a webservice to do account checks, balance enquiry and limit checks.

The remaining issue is posting to remote databases which I believe you want to do in real time. In case you were thinking of adding a webservice call in the triggers, DO NOT.

Kobojunkie:

Apart from that, simple is NOT EVIL. Matter of fact, what using a BUSINESS framework does is adding more lines of code and potential trading performance for structure or something else. you need to start simple(where you know you can), and build on it as you discover the need to.

Well stated.

jubatus

I get pissed at all these apostles who are here defending what they don’t know. What contributions have they made to those languages they defend?

Many of us have not contributed to the making of TVs, Computers, cars, aeroplanes, cloths, shoes etc but we still use them and most people and countries use them to show off, this makes me more pissed off by your comment.

Businesses are here to make money, why should a business use Java and other open source software that will cause problems that there is little or no support for when there is an upgrade to their IT system. Open source software is good but is for those who have all the time in the world to write and debug codes and for hackers as well, but for businesses time is money!!!!

Programming uses a universal language and what makes a language better than the other is the market and the winner is the one users find easy to use. No disrespect to Java programmers but the truth is that C#, Visual Studio.Net and all the other .Net languages are the future of software development as it makes the life of programmers much easier compared to Java. I see Java fanatics now just like Novell network administrators some years back who were saying they hate Windows NT, but now where are they, nobody hears of Novell Networking anymore. What is Novell doing now they are supporting Microsoft C#, VB.Net and all the other .Net languages to run on any platform. The only disadvantage of .Net languages before was that they could only work on a windows platform but now with Mono they can run on any platform. I will only recommend Java to those who are just starting programming so that they can learn programming from the ground up.

Have a look at this link: https://www.dreamspark.com/default.aspx Microsoft have been giving out full versions of all their programming software to student of Universities and schools that sign up. So tell me what future is there for open source and Java.

Kobojunkie:


The simple service you have above is going to deliver what you need. You may need to tweak it for performance, scalability and adaptability etc. Apart from that, simple is NOT EVIL. Matter of fact, what using a BUSINESS framework does is adding more lines of code and potential trading performance for structure or something else. you need to start simple(where you know you can), and build on it as you discover the need to.

Therein lies my reasoning. If he is asking how best to implement web services, don't you think he is going to come back asking for how to implement security if he goes ahead implementing it "simply". I am not a this language is the best or this framework rocks person, but his problem domain for me falls in to one for using a framework. Yes?

Using a framework applies for when you don't already have an effective way of tackling many of the USUAL, in my experience. I have worked on critical projects where no frameworks are used at all, and we are talking mission critical software. It is possible there are FRAMEWORKS out that that handle much of what you need and so help save you time and effort, but you can never really go wrong if you do things simply the way you know how to, because when it comes to maintaining all that code, and debugging, you will have to make sure you have broad understand of what does what and how to do that successfully.

Adding additional layers of complexity does not necessarily imply you are getting better quality of service, or that you are engineering for performance. Again, there are trade-offs with using each and every framework and knowing what those are, is a good place to start. During my work, there have been cases were we plug in certain third party framework just so we can get one feature or another, only to pull it later cause we discover the cost(resource) is not worth it.
You need to know how much bulk the Framework potentially adds to your layer, what alternatives exist and have solid reasons for why you are better off using said framework rather than implementing basic code to do exactly the same thing using already provided libraries.

In this case, the @poster probably wants a simple messaging service, and has been able to implement that, from what I see. If he needs to add security, he can build that on top of what he has now, not instead of. In my opinion, him coming back to ask how to add security to what he already has is not a problem at all.

I just wish Nairaland was always like this. Nice point Kobo and good luck to you @webmonkey.

Now can the admin close this post.

I am looking for a .NET developer who can help me establish an XML connection to a remote server through send queries and then returning result?

The background to this is that I own a website which was Integrated via XML to fetch certain data for us when a query is sent to the remote server. The server operators changed certain mapping criteria and and gave us new login criteria so now we have to re-map as our current XML connection is failing every time we try to establish a connection to the remote server.

Can anyone please whelp?

My number is 0702 601 4484 or email, leslexx@yahoo.com

.