Re: Question about data-sources defined directly in tomee.xml

Richard Zowalla <[email protected]> Tue, 15 Aug 2023 11:45:40 +0200
Newsgroups	gmane.comp.java.openejb.user
Message-ID	<9c1bcfd3435658448af42a8709d1fd94fde0170c.camel__18628.7464153551$1692092752$gmane$org@apache.org>
Looks ok to me.

"net.sourceforge.jtds.jdbc.Driver" is available in TomEE's lib folder?

If yes, we might need a small reproducer on GitHub to check.

Gruß
Richard


Am Dienstag, dem 15.08.2023 um 10:57 +0200 schrieb Stefaan Somers:
> > 
> > 
> > Hi,
> > 
> > <?xml version="1.0" encoding="UTF-8"?>
> > <!--
> >     Licensed to the Apache Software Foundation (ASF) under one or
> > more
> >     contributor license agreements.  See the NOTICE file
> > distributed with
> >     this work for additional information regarding copyright
> > ownership.
> >     The ASF licenses this file to You under the Apache License,
> > Version 2.0
> >     (the "License"); you may not use this file except in compliance
> > with
> >     the License.  You may obtain a copy of the License at
> > 
> >        http://www.apache.org/licenses/LICENSE-2.0
> > 
> >     Unless required by applicable law or agreed to in writing,
> > software
> >     distributed under the License is distributed on an "AS IS"
> > BASIS,
> >     WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
> > implied.
> >     See the License for the specific language governing permissions
> > and
> >     limitations under the License.
> > -->
> > <tomee>
> >   <!-- see
> > https://tomee.apache.org/latest/docs/admin/configuration/containers.html
> > -->
> > 
> >   <!-- activate next line to be able to deploy applications in apps
> > -->
> >   <!-- <Deployments dir="apps" /> -->
> > 
> > 
> >   <!-- jdbc_salesforceApp_base datasource -->
> > <Resource id="jdbc_salesforceApp_base" type="DataSource">
> >      JdbcDriver = "net.sourceforge.jtds.jdbc.Driver"
> >     JdbcUrl = "jdbc:jtds:sqlserver://
> > 10.10.10.10/USERNAME_ACC_LPBE;instanceName=MSSQLSERVER"
> >     UserName = "USERNAME"
> >     Password = "PWD"
> >     JtaManaged = true
> >     MaxActive = "100"
> >     MinIdle = "10"
> >     MaxWaitTime = "5"
> >     ValidationQuery = "select 1"
> > 
> > </Resource>
> > 
> > <!-- jdbc_2_salesforceApp_base datasource -->
> > <Resource id="jdbc_2_salesforceApp_base" type="DataSource">
> >     JdbcDriver = "net.sourceforge.jtds.jdbc.Driver"
> >     JdbcUrl = "jdbc:jtds:sqlserver://
> > 10.10.10.10/USERNAME_ACC_LPBE;instanceName=MSSQLSERVER"
> >     UserName = "USERNAME"
> >     Password = "PWD"
> >     JtaManaged = true
> >     MaxActive = "100"
> >     MinIdle = "10"
> >     MaxWaitTime = "5"
> >     ValidationQuery = "select 1"
> > 
> > </Resource> -->
> > 
> > <!-- jdbc_salesforceApp_salesforceComp datasource -->
> > <Resource id="jdbc_salesforceApp_salesforceComp" type="DataSource">
> >     JdbcDriver = "com.ibm.as400.access.AS400JDBCDriver"
> >     JdbcUrl = "jdbc:as400://ISERIES;transaction
> > isolation=none;decimal
> > separator=comma;date format=iso"
> >     UserName = "USERNAME"
> >     Password = "PASSWORD"
> >     JtaManaged = true
> >     MaxActive = "100"
> >     MinIdle = "10"
> >     MaxWaitTime = "5"
> >     ValidationQuery = "values 1"
> > 
> > </Resource>
> > 
> > <!-- jdbc_2_salesforceApp_salesforceComp datasource -->
> > <Resource id="jdbc_2_salesforceApp_salesforceComp"
> > type="DataSource">
> >     JdbcDriver = "com.ibm.as400.access.AS400JDBCDriver"
> >     JdbcUrl = "jdbc:as400://ISERIES;transaction
> > isolation=none;decimal
> > separator=comma;date format=iso"
> >     UserName = "USERNAME"
> >     Password = "PASSWORD"
> >     JtaManaged = true
> >     MaxActive = "100"
> >     MinIdle = "10"
> >     MaxWaitTime = "5"
> >     ValidationQuery = "values 1"
> > 
> > </Resource>
> > 
> > 
> > 
> > </tomee>
> >
signature.asc (application/pgp-signature, 833 B)