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