Hi all, I'd like to add that I did not add EclipseLink cos I learnt that you cannot mix Hibernate with EclipseLink.
Tks & rgds, Karen --- On Sat, 9/23/17, Karen Goh <karenwo...@yahoo.com> wrote: > From: Karen Goh <karenwo...@yahoo.com> > Subject: Re: Help needed - JPA probem - No connection specified with project > To: "Tomcat Users List" <users@tomcat.apache.org>, knst.koli...@gmail.com > Date: Saturday, September 23, 2017, 1:03 PM > Hi all, > > My apologies, my Tomcat server version > is Apache Tomcat 8.0.29 Server. > The JDK is 1.8 > > Hope to get some advice what went wrong > in regards to the No connection specified with project. > > Tks & rgds, > Karen > -------------------------------------------- > On Fri, 9/22/17, Konstantin Kolinko > <knst.koli...@gmail.com> > wrote: > > Subject: Re: Help needed - JPA probem > - No connection specified with project > To: "Tomcat Users List" <users@tomcat.apache.org>, > "Karen Goh" <karenwo...@yahoo.com> > Date: Friday, September 22, 2017, > 10:00 PM > > 2017-09-22 13:35 GMT+03:00 Karen > Goh <karenwo...@yahoo.com.invalid>: > > Hi expert, > > > > I have been trying very hard to > nail the > above problem including asking various > forums like > CodeRanch, dream in code etc but to no > avail. > > > > As such, I am hoping > to get help from the Apache Tomcat > user support. > > > > Tools and setting : > Eclipse Mars, Tomcat 1.8, MySQL, OS : > Windows 7, Maven, Java > JPA with Hibernate framework 5.1.0 > > There is no such version as "Tomcat > 1.8". I assume that you meant some > version of Tomcat 8.0.x. > > > > The MySQL setting is > confirmed correct, as I have managed > to insert the data via > single JDBC connection. > > > > Project summary : J2ee servlet > with JSP, > Java JPA in Hibernate framework. > (Hibernate is for pure > insertion of data - many to many > relationship) > > > > My purpose is to get > the JNDI datasource working but till > now I can't just > get it work. > > > > > Here's my context.xml : > > > > <?xml version="1.0" > encoding="UTF-8"?> > > > <Context path="/Hi5S" > docBase="Hi5S" > crossContext="true" reloadable="true" > antiResourceLocking="true" > debug="1"> > > > <ResourceLink global="jdbc/hi5" > name="jdbc/hi5" > type="javax.sql.DataSource"/> > > <Resource> > > > name="jdbc/hi5" > > > auth="Container" > > > type="javax.sql.DataSource" > > > maxTotal="8" > > > maxActive="100" > > > maxIdle="30" > > > maxWait="-1" > > > username="root" > > > singleton="true" > > > override="true" > > > > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" > > password="password" > > > alternateUsernameAllowed="true" > > > > driverClassName="com.mysql.jdbc.Driver" > > > url="jdbc:mysql://localhost:3306/hi5" > /> > > </Resource> > > </Context> > > The META-INF/context.xml file of a > web > application must have only one > of > <Resource, ResourceLink> > elements with the same value > of "name" > attribute. > > > If you have a > ResourceLink in context.xml, it means > that your Resource > element must go into > GlobalNamingResources > element of conf/server.xml > file. > http://tomcat.apache.org/tomcat-8.5-doc/config/globalresources.html > > > BTW, you > should not modify conf/context.xml > file. It is the > defaults > file shared by all web > applications. (Modifying it is a > common > configuration mistake). > > > Best regards, > Konstantin Kolinko > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org