You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomee.apache.org by Stefaan Somers <st...@gmail.com> on 2023/08/15 08:35:34 UTC

Question about data-sources defined directly in tomee.xml

I've defined a data-source in the tomee.xml, and put the jar-file in the
lib folder of TomEE (see hereunder). Nevertheless I always get the
following message when starting the server :
14-Aug-2023 10:25:04.452 SEVERE [main]
org.apache.tomee.catalina.ServerListener.lifecycleEvent TomEE Listener
can't start OpenEJB
        org.apache.openejb.OpenEJBException:
org.apache.xbean.propertyeditor.PropertyEditorException: Unable to resolve
class "net.sourceforge.jtds.jdbc.Driver": Unable to resolve class
"net.sourceforge.jtds.jdbc.Driver"

Any idea what I am doing wrong?




















*<tomee>  <!--
see https://tomee.apache.org/latest/docs/admin/configuration/containers.html
<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://x.x.x./XXXXX;instanceName=MSSQLSERVER"    UserName =
"XXXX"    Password = "XXXXX"    JtaManaged = true    MaxActive = "100"
MinIdle = "10"    MaxWaitTime = "5"    ValidationQuery = "select
1"</Resource>*

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

Posted by Stefaan Somers <st...@gmail.com>.
Hi Richard,

thnks this seems to resolve the issue.

Op di 15 aug 2023 om 15:08 schreef Richard Zowalla <rz...@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 <rz...@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>
> > > > >
> > >
> > >
>
>

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

Posted by Richard Zowalla <rz...@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 <rz...@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>
> > > > 
> > 
> > 


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

Posted by Stefaan Somers <st...@gmail.com>.
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 <rz...@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>
> > >
>
>

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

Posted by Richard Zowalla <rz...@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>
> > 


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

Posted by Stefaan Somers <st...@gmail.com>.
>
>
> 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>
>

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

Posted by Richard Zowalla <rz...@apache.org>.
How does your tomee.xml look like?

Am Dienstag, dem 15.08.2023 um 10:35 +0200 schrieb Stefaan Somers:
> I've defined a data-source in the tomee.xml, and put the jar-file in
> the
> lib folder of TomEE (see hereunder). Nevertheless I always get the
> following message when starting the server :
> 14-Aug-2023 10:25:04.452 SEVERE [main]
> org.apache.tomee.catalina.ServerListener.lifecycleEvent TomEE
> Listener
> can't start OpenEJB
>         org.apache.openejb.OpenEJBException:
> org.apache.xbean.propertyeditor.PropertyEditorException: Unable to
> resolve
> class "net.sourceforge.jtds.jdbc.Driver": Unable to resolve class
> "net.sourceforge.jtds.jdbc.Driver"
> 
> Any idea what I am doing wrong?
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> *<tomee>  <!--
> see
> https://tomee.apache.org/latest/docs/admin/configuration/containers.html
> <
> https://tomee.apache.org/latest/docs/admin/configuration/containers.ht
> ml> -->
> <!-- 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://x.x.x./XXXXX;instanceName=MSSQLSERVER"   
> UserName =
> "XXXX"    Password = "XXXXX"    JtaManaged = true    MaxActive =
> "100"
> MinIdle = "10"    MaxWaitTime = "5"    ValidationQuery = "select
> 1"</Resource>*