Skip to Content
0
Former Member
Nov 29, 2006 at 11:00 AM

how to make an webapplication database independent.

25 Views

Dear All SDN's,

I have developed an EJB appliction to call into portal.

Calling into portal is the other part of this.

But here what i want to be clear is, i have designed an webapplication which is database independent.

i.e., like, to connect to any database in SAP J2ee Engine we need to configure the JDBC Connector of Visual administrator.

I had configure the same in the visual administrator by adding an alias to the existing (System) datasource.

when i try to access the datasource from the jsp using the following line,

<b><sql:query dataSource="jdbc/ONLINE_SR_POOL" var="srtype">SELECT * FROM TMP_SR_TYPE</sql:query></b>

it returns errors. Please advise what it goes wrong. All my web pages run ok from Oracle Application Service or Sun Application Server

What do you suggest me to establish a database connection so that the JSP can query the data from the data tables? Should I use JavaBean instead of using<sql:query dataSource="jdbc/ONLINE_SR_POOL" var="srtype"> inside the jsp page?

Tell me where i am going wrong.

Your inputs will be appreciated,

Regards,

Sireesha.B