I think I found solution of this problem. It seems that this is a bug of older version of eclipse WTP.
I removed the endorsed directory argument from the debug configuration and it works now. Thanks, Jenny On Wed, Jun 14, 2023 at 9:43 AM Ying Jin <jiny4...@gmail.com> wrote: > The tomcat server can’t be started in Eclipse due to following error when > JDK 11 is used: > > -Djava.endorsed.dirs=C:\ApacheTomcat 9.0.75\apache-tomcat-9.0.75\endorsed > is not supported. Endorsed standards and standalone APIs > > in modular form will be supported via the concept of upgradeable modules. > > > Thanks, > > Jenny > > On Wed, Jun 14, 2023 at 3:28 AM Mark Thomas <ma...@apache.org> wrote: > >> On 14/06/2023 00:20, Ying Jin wrote: >> > Mark, >> > >> > Thanks for the tip. I've resolved this error by using the way you >> > suggested along with the newer version of jdbc driver ojdbc8.jar and >> > modified the connection url in the right format. >> > >> > However, I encountered another problem trying to run the application in >> > Eclipse with JDK 11. Please see below for the error message. >> > I didn't have any problem running the application with JDK 8. >> > Any suggestions? >> >> None, since we can't see the error message. >> >> Embedded images don't work. Please paste the full stack trace and/or >> post it online somewhere we can read it. >> >> Mark >> >> >> > image.png >> > >> > Many thanks! >> > Jenny >> > >> > >> > On Mon, Jun 12, 2023 at 11:21 AM Mark Thomas <ma...@apache.org >> > <mailto:ma...@apache.org>> wrote: >> > >> > On 12/06/2023 16:52, Ying Jin wrote: >> > > BTW, the ojdbc6_g.jar has been put in the Tomcat9.0.75/lib >> folder as >> > > well as in the project's WEB-INF/lib folder. >> > >> > Don't do that. Put it *only* in $CATALINA_BASE/lib >> > >> > >> > > On Mon, Jun 12, 2023 at 10:41 AM Ying Jin <jiny4...@gmail.com >> > <mailto:jiny4...@gmail.com> >> > > <mailto:jiny4...@gmail.com <mailto:jiny4...@gmail.com>>> wrote: >> > > >> > > Mark, >> > > >> > > Thanks for your reply! Please see below for the details. >> BTW, I >> > > removed the database connection info. for security reasons. >> > The same >> > > data source configuration and jdbc driver "ojdbc6_g" works >> in the >> > > Weblogic 14 server. >> > > >> > > web.xml: >> > > <resource-ref> >> > > <description>project datasource</description> >> > > <res-ref-name>jdbc/ariesDS</res-ref-name> >> > > <res-type>javax.sql.DataSource</res-type> >> > > <res-auth>Container</res-auth> >> > > >> > > Tomcat 9.0.75 conf/context.xml: >> > >> > Putting it there means you have created one instance of the resource >> > for >> > each deployed web application. You probably want to put it in: >> > >> > $CATALINA_BASE/conf/<engine-name>/<host-name>/<context-name>.xml >> > >> > But maybe wait until you have it working before fixing that. >> > >> > > <Resource auth="Container" >> > > driverClassName="oracle.jdbc.OracleDriver" maxIdle="10" >> > > maxTotal="20" maxWaitMillis="-1" name="jdbc/ariesDS" >> > password="PW" >> > > type="javax.sql.DataSource" >> > > url="jdbc:oracle:thin@hostname:portNumber/servic name" >> > > username="userName"/> >> > > >> > > Datasource lookup code: >> > > >> > > Context initContext = new InitialContext(); >> > > Context envContext = >> > > (Context)initContext.lookup("java:/comp/env"); >> > > DataSource ods = >> > (DataSource)envContext.lookup("jdbc/ariesDS"); >> > > if (ods==null) >> > > { >> > > System.out.println("ods = (OracleDataSource) >> > > envCtx.lookup('jdbc/ariesDS') is null"); >> > > throw new Exception ("the data souce is null, error >> > throwed."); >> > > }else{ >> > > conn = ods.getConnection(); >> > > } >> > > >> > > The database version is Oracle 19C and I found out the Oracle >> > jdbc >> > > driver should be ojdbc8.jar. If using this version of jar >> > file, any >> > > code changes need to be done for the data source lookup code? >> > >> > No. The lookup code should be fine. >> > >> > > The complete stacktrace: >> > > image.png >> > >> > Embedded images don't work. Please paste the full stack trace and/or >> > post it online somewhere we can read it. >> > >> > Mark >> > >> > >> > > >> > > Your help is greatly appreciated! >> > > >> > > Thanks, >> > > Jenny >> > > >> > > On Mon, Jun 12, 2023 at 3:26 AM Mark Thomas < >> ma...@apache.org >> > <mailto:ma...@apache.org> >> > > <mailto:ma...@apache.org <mailto:ma...@apache.org>>> wrote: >> > > >> > > On 11/06/2023 19:33, Ying Jin wrote: >> > > > Hello, >> > > > >> > > > We have an old java servlet web application which >> uses the >> > > "ojdbc6_g" jar >> > > > as Oracle jdbc driver and it works in Weblogic 14 >> server. >> > > Recently, we need >> > > > to try to see if this application can be deployed to >> > Tomcat >> > > or not. >> > > > >> > > > The JDBC data source has been configured in Tomcat >> 9.0.75 >> > > server according >> > > > to instructions below, >> > > > >> > > > >> > > >> > https://tomcat.apache.org/tomcat-9.0-doc/jndi-resources-howto.html >> > <https://tomcat.apache.org/tomcat-9.0-doc/jndi-resources-howto.html >> > >> > <https://tomcat.apache.org/tomcat-9.0-doc/jndi-resources-howto.html >> > <https://tomcat.apache.org/tomcat-9.0-doc/jndi-resources-howto.html >> >> >> > > > >> > > > Please see below for the error we encountered in the >> > Tomcat 9 >> > > deployment >> > > > and help shed some light on this problem. The Oracle >> > database >> > > version is >> > > > 19c. >> > > > >> > > > Error: Cannot create JDBC driver of class >> > > 'oracle.jdbc.OracleDriver' for >> > > > connect URL 'jdbc:oracle:thin@xxx >> > > > >> > > > java.sql.SQLException: Cannot create JDBC driver of >> class >> > > > 'oracle.jdbc.OracleDriver' for connect URL >> > 'jdbc:oracle:thin@ >> > > > >> > > >> > < >> http://jdbc:oracle%3at...@vdb04ld.hs.it.vumc.io:10920/ARDEV.vumc.vanderbilt >> < >> http://jdbc:oracle%3at...@vdb04ld.hs.it.vumc.io:10920/ARDEV.vumc.vanderbilt> >> < >> http://jdbc:oracle%3at...@vdb04ld.hs.it.vumc.io:10920/ARDEV.vumc.vanderbilt >> < >> http://jdbc:oracle%3at...@vdb04ld.hs.it.vumc.io:10920/ARDEV.vumc.vanderbilt >> >>> >> > > > xxxx' >> > > > at >> > > > >> > > >> > >> >> org.apache.tomcat.dbcp.dbcp2.DriverFactory.createDriver(DriverFactory.java:74) >> > > > at >> > > > >> > > >> > >> >> org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:465) >> > > > at >> > > > >> > > >> > >> >> org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:529) >> > > > at >> > > > >> > > >> > >> >> org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:710) >> > > >> > > And the rest of the stack trace is? >> > > >> > > ojdbc6_g.jar has been placed where in the file system? >> > > >> > > That is a *very* old Oracle JDBC driver. It is also the >> debug >> > > version of >> > > the JAR. You might want to think about using the latest >> > one for >> > > Oracle 19c. >> > > >> > > The changes to the configuration are? (Yes, I know you >> > said you >> > > followed >> > > the docs but we still need to know what you actually >> > changed. Not >> > > everyone follows the docs correctly.) >> > > >> > > Mark >> > > >> > > >> > >> --------------------------------------------------------------------- >> > > To unsubscribe, e-mail: >> > users-unsubscr...@tomcat.apache.org >> > <mailto:users-unsubscr...@tomcat.apache.org> >> > > <mailto:users-unsubscr...@tomcat.apache.org >> > <mailto:users-unsubscr...@tomcat.apache.org>> >> > > For additional commands, e-mail: >> > users-h...@tomcat.apache.org <mailto:users-h...@tomcat.apache.org> >> > > <mailto:users-h...@tomcat.apache.org >> > <mailto:users-h...@tomcat.apache.org>> >> > > >> > >> > >> --------------------------------------------------------------------- >> > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> > <mailto:users-unsubscr...@tomcat.apache.org> >> > For additional commands, e-mail: users-h...@tomcat.apache.org >> > <mailto:users-h...@tomcat.apache.org> >> > >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> For additional commands, e-mail: users-h...@tomcat.apache.org >> >>
