GOOD GOSH!!!
I don't believe it! It's now friggin' working!
Thank you all: Chuck, Chris, Andre, Mark, Gregor, et al.
I had one little bad validation attribute in the context.xml file, and that was
throwing it off.
That, of course, after all that other junk, and the other junk being the
tomcat-dbcp.jar file located myriad places!
Thanks so much for your patience and help!!
Regards,
Barry
-----Original Message-----
From: Propes, Barry L [GCG-NAOT]
Sent: Friday, March 19, 2010 4:03 PM
To: 'Tomcat Users List'
Subject: RE: DB connection error -Tomcat 6 config
Alright, done....removed every instance of tomcat-dbcp.jar I could find (save
for the instance that SHOULD be there) and I do finally get a different error,
this one seeming more SQL, and specifically ORACLE-related, in nature.
Now the Oracle driver is initially called (and found) to pull back a tabled
page of data, no problem.
Clicking thru subsequently to a simple JSP with the Context in it produces the
following errors:
org.apache.jasper.JasperException: An exception occurred processing JSP page
/chgctrl_details.jsp at line 83
80: DataSource ds = (DataSource) envCtx.lookup("jdbc/myoracle");
81: */
82: // Allocate and use a connection from the pool
83: connection = ds.getConnection();
<------------------------------------------------- here, but then
javax.servlet.ServletException: org.apache.tomcat.dbcp.dbcp.SQLNestedException:
Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found
where expected
)
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (ORA-00923: FROM keyword not found where expected
)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
java.sql.SQLException: ORA-00923: FROM keyword not found where expected
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
Just provided snippets from each of these errors, not the entire set of
references on down.
The logs - basically the same.
Java.sql.SQLException: ORA-00923: FROM keyword not found where expected
Any ideas from this? I'm not yet inclined to think it's fully an Oracle error
yet. But I could be wrong about that. : )
-----Original Message-----
From: Caldarale, Charles R [mailto:[email protected]]
Sent: Friday, March 19, 2010 1:58 PM
To: Tomcat Users List
Subject: RE: DB connection error -Tomcat 6 config
> From: Propes, Barry L [mailto:[email protected]]
> Subject: RE: DB connection error -Tomcat 6 config
>
> There is another copy of the tomcat-dbcp.jar in my JRE lib directory.
That must be removed - it could be the source of all the problems.
> Tomcat doesn't copy files there, too does it?
No; Tomcat does not modify the JRE in any way.
- Chuck
THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY
MATERIAL and is thus for use only by the intended recipient. If you received
this in error, please contact the sender and delete the e-mail and its
attachments from all computers.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
