Christopher Schultz wrote:
>> Either way, it's
>> typically a disconnect between the <Resource .../> and it's use in the
>> jsp/servlet code.
>
> He didn't post his code. It would be good to see what is on line 208 in
> com.wirefast.wsam.service.WMSSubmissionService.getConnection.
Oops. I meant to include that.
private static final String CONTEXT_NAME = "java:/comp/env";
private static final String DB_NAME = "jdbc/InterceptDatabase";
...
private static Connection getConnection ()
throws Exception, SQLException
{
if( DATA_SOURCE == null )
{
// Get the data source (from context.xml)
try
{
Class.forName("oracle.jdbc.OracleDriver");
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup(CONTEXT_NAME);
DATA_SOURCE = (DataSource)envContext.lookup(DB_NAME);
}
catch (Exception ex)
{
System.err.println( ex );
ex.printStackTrace();
throw ex;
}
}
return DATA_SOURCE.getConnection(); // line 208
}
Neil Youngman
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
