We have a winner!
The Windows file system is one of the few (the only one I can think of)
that's not case sensitive. Unix, linux, bsd, macos, etc. , ... are all
case sensitive. You should change the file name 'Context.xml' to
'context.xml' and check to be sure it stays that way as you build your
.war file. After that you won't need to have testapp.xml in
conf/Catalina/localhost. Also you might want to check all the places in
your webapp that references a file and be sure the names match in case
to what's on disk.
--David
Ziggy O wrote:
Hi,
The tomcat version on my Desktop is 5.5.27 and the Tomcat version on the
Unix environment is 5.5.23. Could the above minor version difference cause
it?
One thing i have noticed is that if i take the /META-INF/Context.xml file
and copy it into $CATALINA_HOME/conf/Catalina/localhost/testapp.xml it does
work.
i.e. why does it require the context file in that directory and why does it
have to be renamed to my applications context. On the Windows environment i
dont have to rename and copy the context file to
$CATALINA_HOME/conf/Catalina/localhost
Thanks
On Thu, Oct 2, 2008 at 12:55 PM, David Smith <[EMAIL PROTECTED]> wrote:
Ok...
1) I don't see a tomcat version, could you post that?
2) Are you sure the tomcat version on the production environment the same
as your dev system?
3) This is probably not causing the immediate problem, but <res-type> ...
</res-type> in your web.xml should be javax.sql.Datasource, not
oracle.jdbc.pool.OracleDataSource.
--David
Ziggy O wrote:
No mate that was the full stack trace.
Thanks
On Wed, Oct 1, 2008 at 7:02 PM, David Smith <[EMAIL PROTECTED]> wrote:
Seems like such a generic error would have a root cause. Was there
anything more to the stack trace?
--David
Ziggy O wrote:
Hi,
I am trying to connect to an oracle database but cant seem to get the
jdbc
connection to work. I am developing the application on a Windows desktop
and
transferring it onto a Unix box.
When i test it on the Windows environmnet it does manage to connect but
if
i
test it on unix then i get an error. My gut feeling is that the
installation
on the unix environment is missing a library but i cant figure out what
it
is.
Here is how i am trying to get the jndi connection.
[code]
String fullname;
if (jndiPrefix != null && jndiPrefix.length() > 0)
fullname = jndiPrefix + datasource;
else
fullname = datasource;
// JNDI
Context ctx = null;
DataSource ds = null;
Connection conn = null;
try
{
ctx = new InitialContext();
Context envContext = (Context)ctx.lookup("java:/comp/env");
if (ctx != null)
{
ds = (DataSource)envContext.lookup(fullname);
if (ds != null)
{
conn = ds.getConnection();
}
}
}
[/code]
And here is the Configuration.
Context.xml (User and password modified)
[code]
<Resource name="jdbc/theDb" auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:webdev"
username="webuser" password="webuser" maxActive="20"
maxIdle="10"
maxWait="-1"/>
[/code]
web.xml
[code]
<resource-ref>
<description>Oracle Datasource</description>
<res-ref-name>jdbc/theDb</res-ref-name>
<res-type>oracle.jdbc.pool.OracleDataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
[/code]
And here is the stack trace of the error
[code]
javax.naming.NamingException: Cannot create resource instance
at
org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:143)
at javax.naming.spi.NamingManager.getObjectInstance(Unknown
Source)
at org.apache.naming.NamingContext.lookup(NamingContext.java:793)
at org.apache.naming.NamingContext.lookup(NamingContext.java:140)
at org.apache.naming.NamingContext.lookup(NamingContext.java:781)
at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
at
com.bt.ccs21.util.DbConnection.getJNDIConnection(DbConnection.java:334)
at
com.bt.ccs21.util.DbConnection.getJNDIConnection(DbConnection.java:256)
at
com.bt.ccs21.util.DbConnection.getJRunConnection(DbConnection.java:286)
at
com.bt.ccs21.presentation.events.admin.LogonActionPost.preAction(LogonActionPost.java:118)
at
com.bt.ccs21.presentation.events.CCS21EventAction.execute(CCS21EventAction.java:29)
at
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
at
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
at
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
at
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
at
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
at
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Unknown Source)
"/tmp/crmsauth.log.20081001" 561 lines, 48080 characters
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Unknown Source)
[/code]
What i dont understand is why it works on the installation on the
windows
environment but not in the Unix environment. I check all the libraries
and
everything under common/lib is the same for both environments.
Thanks
Edited by: ziggy on Oct 1, 2008 3:48 PM
Edited by: ziggy on Oct 1, 2008 3:50 PM
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
