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