You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomee.apache.org by mauro2java2011 <ma...@gmail.com> on 2017/09/04 10:33:52 UTC
how con figure the datasource into tomee.xml using docker?
Hi all.
I found this https://docs.docker.com/samples/library/tomee/
<https://docs.docker.com/samples/library/tomee/>
Image of tomee .
Now i would use this image ofbtomee with a image of mysql.
I know is possible linking the 2 container.
But my question is :
how to configure the datasouce into tomee.xml or resource.xml using the
db setted into mysql container?
Ho i can alter the tomee.xml that came from imahpge above for set the
datasource mysql?
Please do you have a exampke of use tomee and mysql and con figure the
datasource using docker?
Tank you in Advance
MAURO
--
Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users-f979441.html
Re: how con figure the datasource into tomee.xml using docker?
Posted by Romain Manni-Bucau <rm...@gmail.com>.
If it helps (docker compose?) you can use environment variables in
tomee.xml:
<Resource id="..." type="DataSource">
JdbcUrl = ${MYSQL_URL}
</Resource>
Then all your config is in your docker compose file.
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> | Blog
<https://blog-rmannibucau.rhcloud.com> | Old Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>
2017-09-04 15:09 GMT+02:00 Paul Carter-Brown <
paul.carter-brown@smilecoms.com>:
> And remember to copy Mysql driver jar into tomee/lib
>
> On 4 September 2017 at 15:08, Paul Carter-Brown <
> paul.carter-brown@smilecoms.com> wrote:
>
> > Assuming you are using JPA, here is an example of a JTA persistence.xml
> in
> > your war/ear WEB-INF or META-INF:
> >
> > <?xml version="1.0" encoding="UTF-8"?>
> > <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence
> "
> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="
> > http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/
> > persistence/persistence_2_0.xsd">
> > <persistence-unit name="SOME_NAME" transaction-type="JTA">
> > <provider>org.apache.openjpa.persistence.
> PersistenceProviderImpl</
> > provider>
> > <jta-data-source>jdbc/ANOTHER_NAME</jta-data-source>
> > <exclude-unlisted-classes>false</exclude-unlisted-classes>
> > </persistence-unit>
> > </persistence>
> >
> >
> >
> > Then a connection pool in tomee.xml:
> >
> >
> > <?xml version="1.0" encoding="UTF-8"?>
> > <tomee>
> > <!-- see http://tomee.apache.org/containers-and-resources.html -->
> >
> > <!-- activate next line to be able to deploy applications in apps -->
> > <Deployments dir="apps" />
> >
> > <Resource id="jdbc/ANOTHER_NAME" type="javax.sql.DataSource"
> > jndi="jdbc/ANOTHER_NAME">
> >
> > JdbcDriver com.mysql.jdbc.Driver
> > JdbcUrl jdbc:mysql://_MYSQLHOST_/SchemaName
> > JtaManaged true
> > UserName _MYSQLUSER_
> > Password _MYSQLPASS_
> > DefaultAutoCommit false
> > DefaultTransactionIsolation 2
> > MaxActive 200
> > MaxWait 2500
> > MinIdle 20
> > MaxIdle 200
> > InitialSize 10
> > TestWhileIdle true
> > ValidationQuery select 1
> > TimeBetweenEvictionRunsMillis 10000
> > MinEvictableIdleTimeMillis 180000
> > ConnectionProperties useSSL=false;autoReconnect=
> > true;failOverReadOnly=false;connectTimeout=1000;socketTimeout=130000
> > </Resource>
> > </tomee>
> >
> >
> > In Docker you can run the containers using --network=host so that the
> > containers bind to your host IP. Then TomEE should be on your host Ip and
> > port 8080 and MySQL on your host IP and port 3306
> >
> > On 4 September 2017 at 12:33, mauro2java2011 <ma...@gmail.com>
> > wrote:
> >
> >> Hi all.
> >> I found this https://docs.docker.com/samples/library/tomee/
> >> <https://docs.docker.com/samples/library/tomee/>
> >>
> >> Image of tomee .
> >>
> >> Now i would use this image ofbtomee with a image of mysql.
> >>
> >> I know is possible linking the 2 container.
> >>
> >> But my question is :
> >>
> >> how to configure the datasouce into tomee.xml or resource.xml using
> the
> >> db setted into mysql container?
> >>
> >> Ho i can alter the tomee.xml that came from imahpge above for set the
> >> datasource mysql?
> >>
> >> Please do you have a exampke of use tomee and mysql and con figure the
> >> datasource using docker?
> >>
> >> Tank you in Advance
> >> MAURO
> >>
> >>
> >>
> >>
> >>
> >> --
> >> Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users-f97944
> >> 1.html
> >>
> >
> >
> >
> > --
> >
> > *Paul Carter-Brown*
> >
> > *Group Chief Information Officer*
> >
> > *Smile Communications Pty (Ltd) *
> > Smile +234 (0) 702 000 1234 <+234%20702%20000%201234>
> > Mobile +27 (0) 83 4427 179
> > Skype PaulC-B
> > paul.carter-brown@smilecoms.com
> > www.smilecoms.com
> >
>
>
>
> --
>
> *Paul Carter-Brown*
>
> *Group Chief Information Officer*
>
> *Smile Communications Pty (Ltd) *
> Smile +234 (0) 702 000 1234
> Mobile +27 (0) 83 4427 179
> Skype PaulC-B
> paul.carter-brown@smilecoms.com
> www.smilecoms.com
>
> --
>
>
> This email is subject to the disclaimer of Smile Communications at
> http://www.smilecoms.com/home/email-disclaimer/ <http://www.smilecoms.com/
> disclaimer>
>
>
Re: how con figure the datasource into tomee.xml using docker?
Posted by Paul Carter-Brown <pa...@smilecoms.com>.
And remember to copy Mysql driver jar into tomee/lib
On 4 September 2017 at 15:08, Paul Carter-Brown <
paul.carter-brown@smilecoms.com> wrote:
> Assuming you are using JPA, here is an example of a JTA persistence.xml in
> your war/ear WEB-INF or META-INF:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="
> http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/
> persistence/persistence_2_0.xsd">
> <persistence-unit name="SOME_NAME" transaction-type="JTA">
> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</
> provider>
> <jta-data-source>jdbc/ANOTHER_NAME</jta-data-source>
> <exclude-unlisted-classes>false</exclude-unlisted-classes>
> </persistence-unit>
> </persistence>
>
>
>
> Then a connection pool in tomee.xml:
>
>
> <?xml version="1.0" encoding="UTF-8"?>
> <tomee>
> <!-- see http://tomee.apache.org/containers-and-resources.html -->
>
> <!-- activate next line to be able to deploy applications in apps -->
> <Deployments dir="apps" />
>
> <Resource id="jdbc/ANOTHER_NAME" type="javax.sql.DataSource"
> jndi="jdbc/ANOTHER_NAME">
>
> JdbcDriver com.mysql.jdbc.Driver
> JdbcUrl jdbc:mysql://_MYSQLHOST_/SchemaName
> JtaManaged true
> UserName _MYSQLUSER_
> Password _MYSQLPASS_
> DefaultAutoCommit false
> DefaultTransactionIsolation 2
> MaxActive 200
> MaxWait 2500
> MinIdle 20
> MaxIdle 200
> InitialSize 10
> TestWhileIdle true
> ValidationQuery select 1
> TimeBetweenEvictionRunsMillis 10000
> MinEvictableIdleTimeMillis 180000
> ConnectionProperties useSSL=false;autoReconnect=
> true;failOverReadOnly=false;connectTimeout=1000;socketTimeout=130000
> </Resource>
> </tomee>
>
>
> In Docker you can run the containers using --network=host so that the
> containers bind to your host IP. Then TomEE should be on your host Ip and
> port 8080 and MySQL on your host IP and port 3306
>
> On 4 September 2017 at 12:33, mauro2java2011 <ma...@gmail.com>
> wrote:
>
>> Hi all.
>> I found this https://docs.docker.com/samples/library/tomee/
>> <https://docs.docker.com/samples/library/tomee/>
>>
>> Image of tomee .
>>
>> Now i would use this image ofbtomee with a image of mysql.
>>
>> I know is possible linking the 2 container.
>>
>> But my question is :
>>
>> how to configure the datasouce into tomee.xml or resource.xml using the
>> db setted into mysql container?
>>
>> Ho i can alter the tomee.xml that came from imahpge above for set the
>> datasource mysql?
>>
>> Please do you have a exampke of use tomee and mysql and con figure the
>> datasource using docker?
>>
>> Tank you in Advance
>> MAURO
>>
>>
>>
>>
>>
>> --
>> Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users-f97944
>> 1.html
>>
>
>
>
> --
>
> *Paul Carter-Brown*
>
> *Group Chief Information Officer*
>
> *Smile Communications Pty (Ltd) *
> Smile +234 (0) 702 000 1234 <+234%20702%20000%201234>
> Mobile +27 (0) 83 4427 179
> Skype PaulC-B
> paul.carter-brown@smilecoms.com
> www.smilecoms.com
>
--
*Paul Carter-Brown*
*Group Chief Information Officer*
*Smile Communications Pty (Ltd) *
Smile +234 (0) 702 000 1234
Mobile +27 (0) 83 4427 179
Skype PaulC-B
paul.carter-brown@smilecoms.com
www.smilecoms.com
--
This email is subject to the disclaimer of Smile Communications at http://www.smilecoms.com/home/email-disclaimer/ <http://www.smilecoms.com/disclaimer>
Re: how con figure the datasource into tomee.xml using docker?
Posted by Paul Carter-Brown <pa...@smilecoms.com>.
Assuming you are using JPA, here is an example of a JTA persistence.xml in
your war/ear WEB-INF or META-INF:
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="
http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
<persistence-unit name="SOME_NAME" transaction-type="JTA">
<provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
<jta-data-source>jdbc/ANOTHER_NAME</jta-data-source>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
</persistence-unit>
</persistence>
Then a connection pool in tomee.xml:
<?xml version="1.0" encoding="UTF-8"?>
<tomee>
<!-- see http://tomee.apache.org/containers-and-resources.html -->
<!-- activate next line to be able to deploy applications in apps -->
<Deployments dir="apps" />
<Resource id="jdbc/ANOTHER_NAME" type="javax.sql.DataSource"
jndi="jdbc/ANOTHER_NAME">
JdbcDriver com.mysql.jdbc.Driver
JdbcUrl jdbc:mysql://_MYSQLHOST_/SchemaName
JtaManaged true
UserName _MYSQLUSER_
Password _MYSQLPASS_
DefaultAutoCommit false
DefaultTransactionIsolation 2
MaxActive 200
MaxWait 2500
MinIdle 20
MaxIdle 200
InitialSize 10
TestWhileIdle true
ValidationQuery select 1
TimeBetweenEvictionRunsMillis 10000
MinEvictableIdleTimeMillis 180000
ConnectionProperties
useSSL=false;autoReconnect=true;failOverReadOnly=false;connectTimeout=1000;socketTimeout=130000
</Resource>
</tomee>
In Docker you can run the containers using --network=host so that the
containers bind to your host IP. Then TomEE should be on your host Ip and
port 8080 and MySQL on your host IP and port 3306
On 4 September 2017 at 12:33, mauro2java2011 <ma...@gmail.com>
wrote:
> Hi all.
> I found this https://docs.docker.com/samples/library/tomee/
> <https://docs.docker.com/samples/library/tomee/>
>
> Image of tomee .
>
> Now i would use this image ofbtomee with a image of mysql.
>
> I know is possible linking the 2 container.
>
> But my question is :
>
> how to configure the datasouce into tomee.xml or resource.xml using the
> db setted into mysql container?
>
> Ho i can alter the tomee.xml that came from imahpge above for set the
> datasource mysql?
>
> Please do you have a exampke of use tomee and mysql and con figure the
> datasource using docker?
>
> Tank you in Advance
> MAURO
>
>
>
>
>
> --
> Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users-
> f979441.html
>
--
*Paul Carter-Brown*
*Group Chief Information Officer*
*Smile Communications Pty (Ltd) *
Smile +234 (0) 702 000 1234
Mobile +27 (0) 83 4427 179
Skype PaulC-B
paul.carter-brown@smilecoms.com
www.smilecoms.com
--
This email is subject to the disclaimer of Smile Communications at http://www.smilecoms.com/home/email-disclaimer/ <http://www.smilecoms.com/disclaimer>
Re: how con figure the datasource into tomee.xml using docker?
Posted by mauro2java2011 <ma...@gmail.com>.
Yes i would create my dockerfile .
So please you can give me a link of a tomee mysql example with docker file
and how add the tomee.xml with datasource setres ?
And : hmi have to clear the tomee.xml that came from the image whrn it unzip
the downloaded tomee and next add the new tomee.xml?
--
Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users-f979441.html
Re: how con figure the datasource into tomee.xml using docker?
Posted by Paul Carter-Brown <pa...@smilecoms.com>.
Hi,
You must create your own Dockerfile that starts with the TomEE image and
then adds/updates files. Thereby you are creating your own layer with
changes to the default Docker.
As an example, here are our layers of Dockerfiles starting with Ubuntu and
then layering on top from there. You will see that we use curl and pull in
files over HTTP during the docker build process. The HTTP server is
basically serving out of a checkout of our build repository so it is
creating docker images out of our latest artifacts. We have a build script
that runs a full build and then creates all the docker images and pushes
them to our own docker repository.
######################################################################################################################
# Ubuntu
######################################################################################################################
FROM ubuntu:latest
# Needed packages
RUN echo "deb http://ppa.launchpad.net/webupd8team/java/ubuntu xenial main"
> /etc/apt/sources.list.d/webupd8team-java-xenial.list && \
echo oracle-java8-installer shared/accepted-oracle-license-v1-1 select true
| /usr/bin/debconf-set-selections && \
apt-get update && \
apt-get install -y --allow-unauthenticated curl unzip subversion zip vim
oracle-java8-installer && \
apt install -y oracle-java8-set-default
######################################################################################################################
# OracleJDK 8
######################################################################################################################
RUN cd /tmp && \
curl -L -O -H "Cookie: oraclelicense=accept-securebackup-cookie" -k "
http://download.oracle.com/otn-pub/java/jce/8/jce_policy-8.zip" && \
unzip jce_policy-8.zip && \
mv UnlimitedJCEPolicyJDK8/*.jar
/usr/lib/jvm/java-8-oracle/jre/lib/security/ && \
rm -rf jce_policy-8.zip UnlimitedJCEPolicyJDK8
ENV JAVA_HOME=/usr/lib/jvm/java-8-oracle
The above is built and pushed to our docker repo as jdk:latest
Then:
######################################################################################################################
# Start with JDK
######################################################################################################################
FROM docker.smilecoms.com/jdk:latest
######################################################################################################################
# TomEE
######################################################################################################################
ENV PATH /opt/tomee/bin:$PATH
RUN mkdir -p /opt/tomee
WORKDIR /opt/tomee
RUN set -x && PLUME_VER=7.0.3 && \
curl -fSL
http://mirror.ox.ac.uk/sites/rsync.apache.org/tomee/tomee-$PLUME_VER/apache-tomee-$PLUME_VER-plume.tar.gz
-o tomee.tar.gz && \
tar -zxf tomee.tar.gz && \
mv apache-tomee-plume-$PLUME_VER/* /opt/tomee && \
rm -Rf apache-tomee-plume-$PLUME_VER && \
rm bin/*.bat && \
rm tomee.tar.gz* && \
rm -rf /opt/tomee/webapps/* && \
apt-get update && \
apt-get install -y libapr1-dev libssl-dev build-essential && \
cd /opt/tomee/bin/ && \
tar -xvf tomcat-native.tar.gz && \
rm tomcat-native.tar.gz && \
cd tomcat-native-*/native/ && \
./configure && make && make install
The above is built and pushed to our docker repo as tomee:latest
Then:
######################################################################################################################
# Start with TomEE
######################################################################################################################
FROM docker.smilecoms.com/tomee:latest
######################################################################################################################
# Smile Portals
######################################################################################################################
RUN CURLOPT="-fSLO http://127.0.0.1" && \
cd /opt/tomee/webapps/ && \
curl $CURLOPT/javaroot/SCP.war && \
cd /opt/tomee/lib/ && \
curl $CURLOPT/javaroot/HOBIT/target/mysql-connector-java.jar && \
cd /opt/tomee/conf/ && \
curl $CURLOPT/install/scripts/docker/portals/tomee.xml && \
curl $CURLOPT/install/scripts/docker/portals/logging.properties && \
curl $CURLOPT/install/scripts/docker/portals/server.xml && \
curl $CURLOPT/install/scripts/docker/portals/jaas.config && \
curl $CURLOPT/install/scripts/docker/portals/context.xml && \
cd /opt/tomee/bin/ && \
curl $CURLOPT/install/scripts/docker/portals/setenv.sh && \
cd / && \
curl $CURLOPT/install/scripts/docker/portals/run.sh && chmod +x /run.sh
######################################################################################################################
# CMD
######################################################################################################################
CMD ["/run.sh"]
Our script run.sh starts tomee and then sleeps in a loop while tomee is
still running.
Hope this is a bit more clear. Its not a quick fix but is pretty
bulletproof.
Alternatively, if you want a quick fix then start your container and do
docker exec -it <Name> bash and vi the files inside the running container.
Then you can stop and start it without losing the changes.
On 4 September 2017 at 17:15, mauro2java2011 <ma...@gmail.com>
wrote:
> Tanks for response. But my questions is :
>
> From the tomee image https://docs.docker.com/samples/library/tomee/
>
> Inside the docker file i see that the tomee binaries are downloaded.
> So into the tomee/conf dir is already present a tomee.xml when from the
> image the tomee is downloaded.
> So i ask: how i can ads the configuration of darasource into the tomee.xml?
> I can pit a new tomee.xml using option -v of docker volume . But in this
> case i have to erase the already preaent tomee.xml downloaded into the
> image ?
>
> I hope i explained my problem.
> Mauro
>
>
>
>
> --
> Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users-
> f979441.html
>
--
*Paul Carter-Brown*
*Group Chief Information Officer*
*Smile Communications Pty (Ltd) *
Smile +234 (0) 702 000 1234
Mobile +27 (0) 83 4427 179
Skype PaulC-B
paul.carter-brown@smilecoms.com
www.smilecoms.com
--
This email is subject to the disclaimer of Smile Communications at http://www.smilecoms.com/home/email-disclaimer/ <http://www.smilecoms.com/disclaimer>
Re: how con figure the datasource into tomee.xml using docker?
Posted by Romain Manni-Bucau <rm...@gmail.com>.
Not ready to use and not using this parent image but it is as easy as
providing your file in the right folder with ADD and overriding the entry
point IIRC
Le 4 sept. 2017 19:23, "mauro2java2011" <ma...@gmail.com> a écrit :
> Hi Romain.
> Please do you have a sample with tomee and mysql with doker and a web app
> deployed into tomee ?
>
> tank you
> mauro
>
>
>
>
>
> --
> Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users-
> f979441.html
>
Re: how con figure the datasource into tomee.xml using docker?
Posted by mauro2java2011 <ma...@gmail.com>.
Hi Romain.
Please do you have a sample with tomee and mysql with doker and a web app
deployed into tomee ?
tank you
mauro
--
Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users-f979441.html
Re: how con figure the datasource into tomee.xml using docker?
Posted by Romain Manni-Bucau <rm...@gmail.com>.
if you override the CMD then you can add steps to the provisioning
including add tomee.xml
Romain Manni-Bucau
@rmannibucau <https://twitter.com/rmannibucau> | Blog
<https://blog-rmannibucau.rhcloud.com> | Old Blog
<http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> |
LinkedIn <https://www.linkedin.com/in/rmannibucau> | JavaEE Factory
<https://javaeefactory-rmannibucau.rhcloud.com>
2017-09-04 17:15 GMT+02:00 mauro2java2011 <ma...@gmail.com>:
> Tanks for response. But my questions is :
>
> From the tomee image https://docs.docker.com/samples/library/tomee/
>
> Inside the docker file i see that the tomee binaries are downloaded.
> So into the tomee/conf dir is already present a tomee.xml when from the
> image the tomee is downloaded.
> So i ask: how i can ads the configuration of darasource into the tomee.xml?
> I can pit a new tomee.xml using option -v of docker volume . But in this
> case i have to erase the already preaent tomee.xml downloaded into the
> image ?
>
> I hope i explained my problem.
> Mauro
>
>
>
>
> --
> Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users-
> f979441.html
>
Re: how con figure the datasource into tomee.xml using docker?
Posted by mauro2java2011 <ma...@gmail.com>.
Tanks for response. But my questions is :
From the tomee image https://docs.docker.com/samples/library/tomee/
Inside the docker file i see that the tomee binaries are downloaded.
So into the tomee/conf dir is already present a tomee.xml when from the
image the tomee is downloaded.
So i ask: how i can ads the configuration of darasource into the tomee.xml?
I can pit a new tomee.xml using option -v of docker volume . But in this
case i have to erase the already preaent tomee.xml downloaded into the
image ?
I hope i explained my problem.
Mauro
--
Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users-f979441.html
Re: how con figure the datasource into tomee.xml using docker?
Posted by Jonathan Gallimore <jo...@gmail.com>.
Hi
Have you tried the MySQL config on this page:
http://tomee.apache.org/common-datasource-configurations.html
You'll need to add the mysql JDBC jar to your lib/ folder on your TomEE
docker image - I imagine you'll want to create your own Dockerfile starting
with: "FROM tomee/<version>", so you can add the files and config you wish
to use.
Let me know if that doesn't answer your question, and I'll try and give a
fuller example.
Regards
Jon
On Mon, Sep 4, 2017 at 11:33 AM, mauro2java2011 <ma...@gmail.com>
wrote:
> Hi all.
> I found this https://docs.docker.com/samples/library/tomee/
> <https://docs.docker.com/samples/library/tomee/>
>
> Image of tomee .
>
> Now i would use this image ofbtomee with a image of mysql.
>
> I know is possible linking the 2 container.
>
> But my question is :
>
> how to configure the datasouce into tomee.xml or resource.xml using the
> db setted into mysql container?
>
> Ho i can alter the tomee.xml that came from imahpge above for set the
> datasource mysql?
>
> Please do you have a exampke of use tomee and mysql and con figure the
> datasource using docker?
>
> Tank you in Advance
> MAURO
>
>
>
>
>
> --
> Sent from: http://tomee-openejb.979440.n4.nabble.com/TomEE-Users-
> f979441.html
>