Re: Connecting to AS/400 Database Question

[tamas perlaky <tamas@xxxxxxxxx>]

'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.