Datatable on Web server

You are leaving many details.
Usually the glow is you have a Java servlet on to cat that needs access to data from a database using a stored procedure.
Which database is in use? Does your server have the jdbc driver to access it.

With that said, does your Java servlet in testing able to communicate with the database?

Thanks, will check this brb

Java servlet on to cat that needs access to data from a database using a stored procedure.
Which database is in use? Does your server have the jdbc driver to access it.

Yes, we have access to all.
We have sql db and yes, we have jdbc


With that said, does your Java servlet in testing able to communicate with the database?
Yes

Check whether the web server is authorized to access the database server. Try from the database to connect to the database server using telnet dbserver 1433.
Are you using dbserver or X.x.x.x as the ip for the dbserver connection?

Will check that...Arnold thanks I am new to this domain so learning ...Thanks

Arnold,
It is dbserver
sql dbserver

The same connection directive that works in the test env shoukd work. Are you getting any errors on the web server when accessing the data.

Are you using worker processes on the Apache http to interact with Apache tomcat, or do you externally access the tomcat?

Http://www.yourdomain.com/application (Apache web server)
Or
Http:/www.yourdomain.com:8080/.  (Tomcat)


Make sure your app logs what it is doing, on the production server so you can see what ir where an issue comes up.

We use frevvo to connect to apache.

Need to write a code in this folder:
W:\frevvo\tomcat\webapps\ROOT\index
Any suggestions?

I do not understand what it is you are asking.

often it might be better to setup workers on http apache based on proxying requests to tomcat ....

We are using Frevvo which uses apache webserver.
Need  to connect to stored procedure and get the datatable by using tomcat .
Is there any way I can save a file (with written program) which I can place in the root folder as stated above.

no, lookm at a worker process setup
https://httpd.apache.org/docs/2.4/mod/worker.html
your apache httpd will be the front end while the workers when a specific request is made will access the tomcat instance and return results.

Will discuss in the work place and get back