DataSource invalid

Hi,

I created a JDBC resource called "jdbc/gms" under SUN JSAS admin. I am trying SQL query using JSTL tag in a JSP page as follows.

<sql:query var="learning" dataSource="jdbc/gms">
Query
</sql:query>

I am getting the error as DataSource invalid: "java.sql.SQLException: No suitable driver".

Instead, If I use the following code it is working properly.
<%
Connection connection = null;
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("jdbc/gms");
connection=ds.getConnection();
Statement stmt = connection.createStatement();
String sqlquery="My Query";
ResultSet rs = stmt.executeQuery(sqlquery);
%>

I am not sure why JSTL SQL Query is not working. Please help.

Have you tried putting the jdbc driver in your ServletContext WEB-INF/lib directory? If its not there?, you might try putting it there. If it is there -- does the driver exist in the server configuration. If it exists in both your Context config and server config -- you might try removing it from your ServletContext.

I am not using any Servlet Context. I do have the JDBC driver files in WEB-INF/lib directory. I created 'JDBC' resource with JNDI name under the 'Sun JSAS Administrator'. I was able to use the JDBC resource (without any other extra settings) with the native Java code as I have mentioned in my previous thread. But, not with JSTL. JSTL is not recognizing the JDBC data source I have created on the Server.

I'm not following you... If your not using a servlet context -- where are you running JSP page that uses the JSP Standard Tag Library? I'm with you in that you configured your JDBC Resource through JNDI using Sun's Application Server Admin Console. It's been awhile since I fooled with JSAS so please bear with me.

Did you configure your Http Services to use the resource? Specifically - did you make sure your virtual server property allowLinking is set to true. It will be in your sun-web.xml file and will look something like this

Code:

---

<sun-web-app>
  <property name="allowLinking" value="true"/>
</sun-web-app>

---

You might also check to make sure the jsp your calling is in the same domain that you set your JDBC resource in. Other than that -- I don't know what to tell you.

I am confused. I thought if I set the data source on Server, I can use it without any other extra settings. Can you point to me of any examples using datasource (configured on server) in JSTL sql:query.

Sure, take a look at these for starters

JSAS - Configuring the Http Services
http://docs.sun.com/source/819-0076/httpservice.html

JSAS - More About JDBC Resources
http://docs.sun.com/source/819-0076/jdbc.html

JSAS - Application Server Configuration
http://docs.sun.com/source/819-0076/...html#wp1051891

I included the App Server Config link in this so you see how to reference the domain(s) you have set up. I hope this helps

Quote:

---

I am confused. I thought if I set the data source on Server, I can use it without any other extra settings.

---

You can generally speaking; however, that does not mean you still don't have more configuration to do. That is why you need to make sure your Http Service is properly set up and that the JSP page you are using the JSTL call for the datasource is infact running in the same instance as is the JDBC Resource. By default, allowLinking is set to true but you can turn that off. If you did not turn it off, then it could very well mean your not running the jsp in the right place... You can have more than one