Worksitemp - connect database in jsp page

Hi,

In a jsp page e.g. issueEdit.jsp, I would like to connect to a MS SQL database, retrieved some data and then display on the page. Is there any way to do that?

Thanks and Regards,

Johnson

Find more posts tagged with

Comments

Migrateduser

I suggest you do that by calling WOM API, please refer to worksitemp SDK developler guide

Migrateduser

In a jsp page e.g. issueEdit.jsp, I would like to connect to a MS SQL database, retrieved some data and then display on the page. Is there any way to do that?

In an enterprise scalable webapp, it is not recommended to connect to backend databases directly from the presentation layer. Still, if you want to do this, please build a JDBC connection pool framework from the web app to the external database. You can initialize the connection pool at the web app startup or at the first invocation of the JSP page. You would have to do this with the standard java frameworks, WorkSite MP does not provide any libraries to do this.

WOM approach will work only for those tables that are part of the WorkSite MP library schema.

Again, if you write more about your use case, we can help you take the right direction.

JTNeville

In an enterprise scalable webapp, it is not recommended to connect to backend databases directly from the presentation layer.

Just curious, could you expand on that or link a more thorough FAQ on the subject? Thanks,

Migrateduser

Please start with these and then go deeper into the MVC pattern and JSP Model 2 architetcture.

http://en.wikipedia.org/wiki/Model_view_controller
http://www.javaworld.com/javaworld/jw-12-1999/jw-12-ssj-jspmvc.html
http://java.sun.com/developer/technicalArticles/javaserverpages/servlets_jsp/

Migrateduser

See next post (pasted code didn't appear, forum posting issue, had to repost)

Migrateduser

Are you looking for a code example?

See attached example - -

You'll have to change the Class.forName and the conn= statement to match the JDBC driver that you download. You can download Microsofts JDBC driver for free (If you are running on Windows) There should be instructions on what to put in those locations for the Microsoft driver.