I'm new to Java and even newer to WebSphere so please pardon my newbiness. I
s it <i>wrong</i> to call a datasource you've created in WAS directly from a
 portlet?
Also, in this following snippet of code what does "comp" and "env" represent
 in the string?

<code>
Context initialContext = new InitialContext();
javax.sql.DataSource myDS =
(javax.sql.DataSource) initialContext.lookup(
"java:comp/env/jdbc/DB2DataSource");

// create a connection from the Data Source
Connection connection = myDS.getConnection();

// create a query from the connection
java.sql.Statement query =
connection.createStatement();
<code>

Thanks for reading.

[ Post a follow-up to this message ]

It's not wrong per se, but it's a lot more common to separate JDBC code into
 another layer that sits behind your portlet.  Do you know much about persis
tence or the MVC pattern?  This tutorial has my bible for a loooong time:

http://java.sun.com/j2ee/1.4/docs/tutorial/doc/

The sun site also has a good tutorial on JDBC, but what you use as a jndi na
me (that string with /comp/env) is arbitrary.  As for WAS, there is an infoc
enter, just like there is in Portal, and this link has a "How Do I?" section
 which includes "How do I p
rovide access to relational databases (JDBC resources) with the console?"

http://publib.boulder.ibm.com/infoc...owdoi_tadm.html

Good luck,
Jaye

[ Post a follow-up to this message ]

Thank you so much - you rock! 

[ Post a follow-up to this message ]

teehee Excellent, thanks - a lovely compliment, even if it is from a Gator.

Jaye "Nole" Garcia-Glennie

[ Post a follow-up to this message ]