Page 2 of 2

Re: WAR Deployment

PostPosted: Wed Feb 27, 2019 4:05 pm
by ryan.m.beasley
it's a completely empty database.

Re: WAR Deployment

PostPosted: Thu Feb 28, 2019 7:10 pm
by sean
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 ?

Re: WAR Deployment

PostPosted: Thu Feb 28, 2019 7:56 pm
by ryan.m.beasley
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

Re: WAR Deployment

PostPosted: Fri Mar 01, 2019 6:52 pm
by ryan.m.beasley
Got everything working now. The key was to replace the <empty> tag in schema and catalog properties with <none>

Re: WAR Deployment

PostPosted: Mon Mar 04, 2019 4:09 pm
by ryan.m.beasley
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)