Re: Using James 3.8.0 with Microsoft SQL Server
Hi Benoit, thanks, this is working now: java -javaagent:james-server-jpa-app.lib/openjpa-3.2.0.jar -Dworking.directory=. -Djdk.tls.ephemeralDHKeySize=2048 -Dlogback.configurationFile=conf/logback.xml -cp james-server-jpa-app.jar;james-server-jpa-app.lib/*;extensions-jars/* org.apache.james.JPAJamesServerMain Matt On Fri, 20 Oct 2023 at 15:48, Benoit TELLIER wrote: > Hello Matt > > Pointer to a working example relying on docker: > https://github.com/apache/james-project/tree/master/server/apps/jpa-app#using-alternative-jdbc-drivers > > > > > -- > > Best regards, > > Benoit TELLIER > > General manager of Linagora VIETNAM. > Product owner for Team-Mail product. > Chairman of the Apache James project. > > Mail: btell...@linagora.com > Tel: (0033) 6 77 26 04 58 (WhatsApp, Signal) > > > On Oct 20, 2023 9:13 PM, from Matt Pryor I have also tried editing my > startup command as follows but still getting > the same result: > > java -javaagent:james-server-jpa-app.lib\openjpa-3.2.0.jar > -Dworking.directory=. -Djdk.tls.ephemeralDHKeySize=2048 > -Dlogback.configurationFile=conf\logback.xml -cp > "james-server-jpa-app.jar:james-server-jpa-app.lib/*: > extension-jars/mssql-jdbc-7.4.1.jre8.jar" -jar james-server-jpa-app.jar > > Thanks > Matt > > > > On Fri, 20 Oct 2023 at 14:59, Matt Pryor > > wrote: > > > Hello > > > > I have the following in james-database.properties: > > > > database.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver > > > database.url=jdbc:sqlserver://sqlserver_host_name;DatabaseName=apache_james > > database.username=james > > database.password=x > > > > vendorAdapter.database=SQL_SERVER > > > > I'm getting ClassNotFoundException for SQLServerDriver. > > > > The driver jar is in /extension-jars > > > > I have also tried putting it in james-server-jpa-app.lib but still > getting > > the same error. > > > > Is there somewhere else I have to specify the jar location so it gets > > included in the classpath? > > > > Regards > > Matt > > > > > > > > -- > > Kind regards > > Matt Pryor > > Software Developer > > > > The International Presence Group of Companies > > EMAIL: pr...@presencebpm.com > > URL: International-presence.com > > > > > > > > -- > Kind regards > Matt Pryor > Software Developer > > The International Presence Group of Companies > EMAIL: pr...@presencebpm.com > URL: International-presence.com > > > -- Kind regards Matt Pryor Software Developer The International Presence Group of Companies EMAIL: pr...@presencebpm.com URL: www.International-presence.com
Re: Using James 3.8.0 with Microsoft SQL Server
Hello Matt Pointer to a working example relying on docker: https://github.com/apache/james-project/tree/master/server/apps/jpa-app#using-alternative-jdbc-drivers -- Best regards, Benoit TELLIER General manager of Linagora VIETNAM. Product owner for Team-Mail product. Chairman of the Apache James project. Mail: btell...@linagora.com Tel: (0033) 6 77 26 04 58 (WhatsApp, Signal) On Oct 20, 2023 9:13 PM, from Matt Pryor I have also tried editing my startup command as follows but still getting the same result: java -javaagent:james-server-jpa-app.lib\openjpa-3.2.0.jar -Dworking.directory=. -Djdk.tls.ephemeralDHKeySize=2048 -Dlogback.configurationFile=conf\logback.xml -cp "james-server-jpa-app.jar:james-server-jpa-app.lib/*: extension-jars/mssql-jdbc-7.4.1.jre8.jar" -jar james-server-jpa-app.jar Thanks Matt On Fri, 20 Oct 2023 at 14:59, Matt Pryor wrote: > Hello > > I have the following in james-database.properties: > > database.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver > database.url=jdbc:sqlserver://sqlserver_host_name;DatabaseName=apache_james > database.username=james > database.password=x > > vendorAdapter.database=SQL_SERVER > > I'm getting ClassNotFoundException for SQLServerDriver. > > The driver jar is in /extension-jars > > I have also tried putting it in james-server-jpa-app.lib but still getting > the same error. > > Is there somewhere else I have to specify the jar location so it gets > included in the classpath? > > Regards > Matt > > > > -- > Kind regards > Matt Pryor > Software Developer > > The International Presence Group of Companies > EMAIL: pr...@presencebpm.com > URL: International-presence.com > > > -- Kind regards Matt Pryor Software Developer The International Presence Group of Companies EMAIL: pr...@presencebpm.com URL: International-presence.com
Re: Using James 3.8.0 with Microsoft SQL Server
I have also tried editing my startup command as follows but still getting the same result: java -javaagent:james-server-jpa-app.lib\openjpa-3.2.0.jar -Dworking.directory=. -Djdk.tls.ephemeralDHKeySize=2048 -Dlogback.configurationFile=conf\logback.xml -cp "james-server-jpa-app.jar:james-server-jpa-app.lib/*: extension-jars/mssql-jdbc-7.4.1.jre8.jar" -jar james-server-jpa-app.jar Thanks Matt On Fri, 20 Oct 2023 at 14:59, Matt Pryor wrote: > Hello > > I have the following in james-database.properties: > > database.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver > database.url=jdbc:sqlserver://sqlserver_host_name;DatabaseName=apache_james > database.username=james > database.password=x > > vendorAdapter.database=SQL_SERVER > > I'm getting ClassNotFoundException for SQLServerDriver. > > The driver jar is in /extension-jars > > I have also tried putting it in james-server-jpa-app.lib but still getting > the same error. > > Is there somewhere else I have to specify the jar location so it gets > included in the classpath? > > Regards > Matt > > > > -- > Kind regards > Matt Pryor > Software Developer > > The International Presence Group of Companies > EMAIL: pr...@presencebpm.com > URL: www.International-presence.com > > > -- Kind regards Matt Pryor Software Developer The International Presence Group of Companies EMAIL: pr...@presencebpm.com URL: www.International-presence.com
