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

Hi Richard,

thnks this seems to resolve the issue.

Op di 15 aug 2023 om 15:08 schreef Richard Zowalla <[email protected]>:

> 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>
> > > > >
> > >
> > >
>
>