Re: Connecting to AS/400 Database Question

'ey Mike...

The <sql:*> series of tags are part of the JSP Standard Taglib Library (JSTL), the reference implementation for which was created by the good folks at Apache's Jakarta project. In order for these tags to work, you need to download the appropriate .jar files for the JSTL, configure them in your web application, and declare their use on any pages which use them. There's lots of information out there about how to use them, and most IDE that have webapp support will include tools for including tag libraries in your own applications.

There's nothing iSeries specific about working with the SQL JSTL tags -- it's just another JDBC datasource.

The Apache site has some good information about the Jakarta JSTL implementation; the "Getting Started" guide to the is located at:

http://jakarta.apache.org/taglibs/doc/standard-doc/standard/ GettingStarted.html

Java also has a page about the JSTL:

http://java.sun.com/products/jsp/jstl/

Both of these have links to other articles and resources...

take care.
tamas.

On Thursday, February 13, 2003, at 11:22 AM, Mike Herman wrote:

Hi everyone,

I am new to running a web server on the 400. I am a IIS and Cold Fusion
guy but due to the licensing costs we have decided to utilize our 400.

We have a I-series 9406-730 running V5R1. Also running and configured
ar Apache and Tomcat.

I have it running and can run .jsp pages with simple statements like:
<%@ include file="include/nav.jsp" %> and they work fine.

Now I need to connect to the 400 database to run queries over it. I
tried simple queries like:
<sql:query var="bday">
select * from name
</sql:query>

But nothing happens. I do not know where to define the datasource.

I have O'Reilly's book and others but they all talk Unix. They do not
reference the 400 at all.

Does anyone know of a reference for me to use to guide a "non-400" guy
through this?

Any help will be greatly appreciated.

Thanks,
Mike

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.