WAR Deployment

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

Re: WAR Deployment

Postby ryan.m.beasley » Wed Feb 27, 2019 4:05 pm

it's a completely empty database.
ryan.m.beasley
 
Posts: 61
Joined: Wed Oct 10, 2018 8:51 pm

Re: WAR Deployment

Postby sean » Thu Feb 28, 2019 7:10 pm

Hi Ryan,

Please share the schema and catalog properties from your repository server configuration.
It seems there are lots of hits on code forums about SQL Server and the error you get. I wonder if the schema or catalog is set to something strange
You would have set this in either of two places, It depends where you setup the repository connection during war file creation:

1. Did you create server connection properties through the export wizard ?

2. Or did you include a servoy.properties file template ?

You could also extract it from the war you generated:
/WEB-INF/servoy.properties

Can you attach it ?
Software Engineer
Servoy USA
sean
 
Posts: 370
Joined: Mon May 21, 2007 6:26 pm
Location: USA

Re: WAR Deployment

Postby ryan.m.beasley » Thu Feb 28, 2019 7:56 pm

I created it through the export wizard:

ServerManager.numberOfServers=5
SocketFactory.compress=true
SocketFactory.rmiServerFactory=com.servoy.j2db.server.rmi.tunnel.ServerTunnelRMISocketFactoryFactory
SocketFactory.tunnelConnectionMode=http&socket
SocketFactory.tunnelUseSSLForHttp=false
SocketFactory.useSSL=true
java.rmi.server.hostname=ipaddress
server.0.URL=jdbc\:jtds\:sqlserver\:###############
server.0.catalog=<none>
server.0.connectionValidationType=0
server.0.driver=net.sourceforge.jtds.jdbc.Driver
server.0.enabled=true
server.0.maxConnectionsActive=30
server.0.maxConnectionsIdle=10
server.0.maxPreparedStatementsIdle=100
server.0.password=encrypted\:##############
server.0.prefixTables=false
server.0.queryProcedures=false
server.0.schema=<none>
server.0.serverName=dbname
server.0.skipSysTables=false
server.0.userName=username
server.0.validationQuery=
server.1.URL=jdbc\:sqlserver\:##############;DatabaseName\=systemname;SelectMethod\=direct
server.1.catalog=<empty>
server.1.connectionValidationType=0
server.1.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
server.1.enabled=true
server.1.maxConnectionsActive=30
server.1.maxConnectionsIdle=10
server.1.maxPreparedStatementsIdle=100
server.1.password=encrypted\:##############
server.1.prefixTables=false
server.1.queryProcedures=false
server.1.schema=<empty>
server.1.serverName=dbname
server.1.skipSysTables=false
server.1.userName=username
server.1.validationQuery=
server.2.URL=##############
server.2.catalog=<none>
server.2.connectionValidationType=0
server.2.driver=com.sybase.jdbc3.jdbc.SybDriver
server.2.enabled=true
server.2.maxConnectionsActive=30
server.2.maxConnectionsIdle=10
server.2.maxPreparedStatementsIdle=100
server.2.password=encrypted\:##############
server.2.prefixTables=false
server.2.queryProcedures=false
server.2.schema=<none>
server.2.serverName=dbname
server.2.skipSysTables=false
server.2.userName=username
server.2.validationQuery=
server.3.URL=jdbc\:sqlserver\:##############;DatabaseName\=Servoy_Repository;SelectMethod\=direct
server.3.catalog=<empty>
server.3.connectionValidationType=0
server.3.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
server.3.enabled=true
server.3.maxConnectionsActive=30
server.3.maxConnectionsIdle=10
server.3.maxPreparedStatementsIdle=100
server.3.password=encrypted\:##############
server.3.prefixTables=false
server.3.queryProcedures=false
server.3.schema=<empty>
server.3.serverName=repository_server
server.3.skipSysTables=false
server.3.userName=username
server.3.validationQuery=
server.4.URL=jdbc\:sqlserver\:##############;DatabaseName\=dbname;SelectMethod\=direct
server.4.catalog=<empty>
server.4.connectionValidationType=0
server.4.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
server.4.enabled=true
server.4.maxConnectionsActive=30
server.4.maxConnectionsIdle=10
server.4.maxPreparedStatementsIdle=100
server.4.password=encrypted\:##############
server.4.prefixTables=false
server.4.queryProcedures=true
server.4.schema=<empty>
server.4.serverName=dbname
server.4.skipSysTables=false
server.4.userName=username
server.4.validationQuery=
servoy.rmiStartPort=1099
servoy.server.start.rmi=false
ryan.m.beasley
 
Posts: 61
Joined: Wed Oct 10, 2018 8:51 pm

Re: WAR Deployment

Postby ryan.m.beasley » Fri Mar 01, 2019 6:52 pm

Got everything working now. The key was to replace the <empty> tag in schema and catalog properties with <none>
ryan.m.beasley
 
Posts: 61
Joined: Wed Oct 10, 2018 8:51 pm

Re: WAR Deployment

Postby ryan.m.beasley » Mon Mar 04, 2019 4:09 pm

So everything works, but now when I upload the solution and try to run it I'm getting this error:

java.lang.ClassNotFoundException: com.servoy.j2db.rmi.DefaultClientSocketFactoryFactory
at java.net.URLClassLoader.findClass(Unknown Source)
at com.sun.jnlp.JNLPClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at com.sun.jnlp.JNLPClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.servoy.j2db.smart.J2DBClient.initRMISocketFactory(J2DBClient.java:862)
at com.servoy.j2db.smart.J2DBClient.startupApplication(J2DBClient.java:801)
at com.servoy.j2db.smart.J2DBClient$4.run(J2DBClient.java:712)
at com.servoy.j2db.smart.J2DBClient.mainImpl(J2DBClient.java:736)
at com.servoy.j2db.smart.J2DBClient.main(J2DBClient.java:699)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.sun.javaws.Launcher.executeApplication(Unknown Source)
at com.sun.javaws.Launcher.executeMainClass(Unknown Source)
at com.sun.javaws.Launcher.doLaunchApp(Unknown Source)
at com.sun.javaws.Launcher.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

CacheEntry[https://dev-lmsecurity-midtier-wsv.us.lmco.com:443/spcentral/servoy_messages?lastmodified=-1&language=en_US]: updateAvailable=false,lastModified=Fri Mar 01 14:55:58 EST 2019,length=34
Mar 01, 2019 3:10:21 PM com.servoy.j2db.util.Debug error
SEVERE: Error getting the service com.servoy.j2db.server.shared.IApplicationServer from host dev-lmsecurity-midtier-wsv.us.lmco.com:1099
java.lang.NullPointerException
at com.servoy.j2db.smart.J2DBClient.connectApplicationServer(J2DBClient.java:1923)
at com.servoy.j2db.smart.J2DBClient.startApplicationServerConnection(J2DBClient.java:1904)
at com.servoy.j2db.ClientState.applicationServerInit(ClientState.java:316)
at com.servoy.j2db.smart.J2DBClient.startupApplication(J2DBClient.java:807)
at com.servoy.j2db.smart.J2DBClient$4.run(J2DBClient.java:712)
at com.servoy.j2db.smart.J2DBClient.mainImpl(J2DBClient.java:736)
at com.servoy.j2db.smart.J2DBClient.main(J2DBClient.java:699)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.sun.javaws.Launcher.executeApplication(Unknown Source)
at com.sun.javaws.Launcher.executeMainClass(Unknown Source)
at com.sun.javaws.Launcher.doLaunchApp(Unknown Source)
at com.sun.javaws.Launcher.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Mar 01, 2019 3:10:21 PM com.servoy.j2db.util.Debug error
SEVERE: Cannot find dataservice, it may not be running on server
java.lang.NullPointerException
at com.servoy.j2db.smart.J2DBClient.connectApplicationServer(J2DBClient.java:1923)
at com.servoy.j2db.smart.J2DBClient.startApplicationServerConnection(J2DBClient.java:1904)
at com.servoy.j2db.ClientState.applicationServerInit(ClientState.java:316)
at com.servoy.j2db.smart.J2DBClient.startupApplication(J2DBClient.java:807)
at com.servoy.j2db.smart.J2DBClient$4.run(J2DBClient.java:712)
at com.servoy.j2db.smart.J2DBClient.mainImpl(J2DBClient.java:736)
at com.servoy.j2db.smart.J2DBClient.main(J2DBClient.java:699)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.sun.javaws.Launcher.executeApplication(Unknown Source)
at com.sun.javaws.Launcher.executeMainClass(Unknown Source)
at com.sun.javaws.Launcher.doLaunchApp(Unknown Source)
at com.sun.javaws.Launcher.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Mar 01, 2019 3:10:30 PM com.servoy.j2db.util.Debug error
SEVERE: Couldnt export object with port from server, trying to do on anonym port
Mar 01, 2019 3:10:30 PM com.servoy.j2db.util.Debug error
SEVERE: Fatal Exception
Mar 01, 2019 3:10:30 PM com.servoy.j2db.util.Debug error
SEVERE: Throwable
java.lang.NullPointerException
at com.servoy.j2db.smart.J2DBClient.exportObject(J2DBClient.java:3437)
at com.servoy.j2db.smart.J2DBClient.bindUserClient(J2DBClient.java:3395)
at com.servoy.j2db.ClientState.applicationServerInit(ClientState.java:317)
at com.servoy.j2db.smart.J2DBClient.startupApplication(J2DBClient.java:807)
at com.servoy.j2db.smart.J2DBClient$4.run(J2DBClient.java:712)
at com.servoy.j2db.smart.J2DBClient.mainImpl(J2DBClient.java:736)
at com.servoy.j2db.smart.J2DBClient.main(J2DBClient.java:699)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.sun.javaws.Launcher.executeApplication(Unknown Source)
at com.sun.javaws.Launcher.executeMainClass(Unknown Source)
at com.sun.javaws.Launcher.doLaunchApp(Unknown Source)
at com.sun.javaws.Launcher.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
ryan.m.beasley
 
Posts: 61
Joined: Wed Oct 10, 2018 8:51 pm

Previous

Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 5 guests

cron