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

Richard Zowalla <[email protected]> Tue, 15 Aug 2023 15:06:59 +0200
Newsgroups	gmane.comp.java.openejb.user
Message-ID	<4f1fc7084427f235b6175fa41df6691b18f48404.camel__27571.8097038165$1692104909$gmane$org@apache.org>
Hi,

had a quick look because I was thinking about some excludes, but you
need to simply remove the quotes (") from the jdbc driver declaration. 

Otherwise it is looking for "net.sourceforge.jtds.jdbc.Driver" instead
of just net.sourceforge.jtds.jdbc.Driver (and " is removed from the log
output, so difficult to see).

Gruß
Richard

Am Dienstag, dem 15.08.2023 um 14:18 +0200 schrieb Stefaan Somers:
> Hi Richard,
> 
> it's indeed in the lib-folder....
> You can find my TomEE installation on the following link :
> https://github.com/somersst/TomEE
> Please tell me when copied, so I can remove it again...
> 
> Op di 15 aug 2023 om 11:45 schreef Richard Zowalla <[email protected]>:
> 
> > 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)