Null Pointer Exception on Opening Solution after Upgrading

Hello,

We have a solution that interfaces with SAP through an ODBC driver.

The solution worked fine (well, not fine, but it WAS working) using Servoy 3.0. We tried upgrading to Servoy 3.1 a while ago, but it caused problems with our navigation system. So we reverted to 3.0.

Just recently, we found a fix to the navigation issues, so we attempted to upgrade to Servoy 3.1.3. However, when we do so, we get a “Cannot load data - NullPointerException” error message when loading almost any form.

It therefore appears that because of the upgrade something with how Servoy was interacting with the ODBC SAP driver got broken.

Help…

Can you show us the stack trace in the log file?

Rob

Sorry for the long delay in replying…

Just to reiterate the problem:

We have a solution that works fine in 3.0.
However, attempting to access the same solution using 3.1.3 gives a nullpointerException.

That NullPointerException occurs after choosing the solution to load from the popup list.

The database configurations on the dbservers tab are correct - or at least match the configurations in the 3.0 Developer.

Any help in resolving this issue will be appreciated, since, as it stands, we have no upgrade path.

Thanks
Kion.

PS
Here is the output from the Servoy log file:

2007-04-05 14:47:50,771 ERROR [TaskExecuter[3]] com.servoy.j2db.util.Debug - Throwable
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
at java.net.URL.openStream(Unknown Source)
at com.servoy.j2db.develop.c.y.do(Unknown Source)
at com.servoy.j2db.develop.c.h$1.run(Unknown Source)
at com.servoy.j2db.util.al.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2007-04-05 14:47:53,771 ERROR [main] com.servoy.j2db.util.Debug - Throwable
java.rmi.server.ExportException: Port already in use: 1099; nested exception is:
java.net.BindException: Address already in use: JVM_Bind
at sun.rmi.transport.tcp.TCPTransport.listen(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.exportObject(Unknown Source)
at sun.rmi.transport.tcp.TCPEndpoint.exportObject(Unknown Source)
at sun.rmi.transport.LiveRef.exportObject(Unknown Source)
at sun.rmi.server.UnicastServerRef.exportObject(Unknown Source)
at sun.rmi.registry.RegistryImpl.setup(Unknown Source)
at sun.rmi.registry.RegistryImpl.(Unknown Source)
at java.rmi.registry.LocateRegistry.createRegistry(Unknown Source)
at com.servoy.j2db.server.ApplicationServer.a(Unknown Source)
at com.servoy.j2db.server.ApplicationServer.initFromDeveloper(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.dataBaseInit(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.for(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.main(Unknown Source)
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.servoy.j2db.startup.Bootstrap.main(Unknown Source)
at Servoy.main(Unknown Source)
Caused by: java.net.BindException: Address already in use: JVM_Bind
at java.net.PlainSocketImpl.socketBind(Native Method)
at java.net.PlainSocketImpl.bind(Unknown Source)
at java.net.ServerSocket.bind(Unknown Source)
at java.net.ServerSocket.(Unknown Source)
at java.net.ServerSocket.(Unknown Source)
at javax.net.ssl.SSLServerSocket.(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLServerSocketImpl.(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLServerSocketFactoryImpl.createServerSocket(Unknown Source)
at com.servoy.j2db.util.a.d.createServerSocket(Unknown Source)
at sun.rmi.transport.tcp.TCPEndpoint.newServerSocket(Unknown Source)
… 19 more
2007-04-05 14:47:57,224 ERROR [main] org.apache.coyote.http11.Http11Protocol - Error initializing endpoint
java.net.BindException: Address already in use: JVM_Bind:8080
at org.apache.tomcat.util.net.PoolTcpEndpoint.initEndpoint(PoolTcpEndpoint.java:297)
at org.apache.coyote.http11.Http11Protocol.init(Http11Protocol.java:142)
at org.apache.catalina.connector.Connector.initialize(Connector.java:928)
at org.apache.catalina.core.StandardService.initialize(StandardService.java:580)
at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:764)
at org.apache.catalina.startup.Catalina.load(Catalina.java:490)
at org.apache.catalina.startup.Catalina.start(Catalina.java:529)
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.servoy.j2db.server.WebServer.startWebServer(Unknown Source)
at com.servoy.j2db.server.ApplicationServer.startWebServer(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.try(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.for(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.main(Unknown Source)
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.servoy.j2db.startup.Bootstrap.main(Unknown Source)
at Servoy.main(Unknown Source)
2007-04-05 14:47:57,239 ERROR [main] org.apache.catalina.startup.Catalina - Catalina.start
LifecycleException: Protocol handler initialization failed: java.net.BindException: Address already in use: JVM_Bind:8080
at org.apache.catalina.connector.Connector.initialize(Connector.java:930)
at org.apache.catalina.core.StandardService.initialize(StandardService.java:580)
at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:764)
at org.apache.catalina.startup.Catalina.load(Catalina.java:490)
at org.apache.catalina.startup.Catalina.start(Catalina.java:529)
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.servoy.j2db.server.WebServer.startWebServer(Unknown Source)
at com.servoy.j2db.server.ApplicationServer.startWebServer(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.try(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.for(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.main(Unknown Source)
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.servoy.j2db.startup.Bootstrap.main(Unknown Source)
at Servoy.main(Unknown Source)
2007-04-05 14:47:59,833 ERROR [main] org.apache.coyote.http11.Http11Protocol - Error starting endpoint
java.net.BindException: Address already in use: JVM_Bind:8080
at org.apache.tomcat.util.net.PoolTcpEndpoint.initEndpoint(PoolTcpEndpoint.java:297)
at org.apache.tomcat.util.net.PoolTcpEndpoint.startEndpoint(PoolTcpEndpoint.java:312)
at org.apache.coyote.http11.Http11Protocol.start(Http11Protocol.java:182)
at org.apache.catalina.connector.Connector.start(Connector.java:1001)
at org.apache.catalina.core.StandardService.start(StandardService.java:459)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
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.servoy.j2db.server.WebServer.startWebServer(Unknown Source)
at com.servoy.j2db.server.ApplicationServer.startWebServer(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.try(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.for(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.main(Unknown Source)
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.servoy.j2db.startup.Bootstrap.main(Unknown Source)
at Servoy.main(Unknown Source)
2007-04-05 14:47:59,833 ERROR [main] org.apache.catalina.startup.Catalina - Catalina.start:
LifecycleException: Protocol handler start failed: java.net.BindException: Address already in use: JVM_Bind:8080
at org.apache.catalina.connector.Connector.start(Connector.java:1003)
at org.apache.catalina.core.StandardService.start(StandardService.java:459)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
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.servoy.j2db.server.WebServer.startWebServer(Unknown Source)
at com.servoy.j2db.server.ApplicationServer.startWebServer(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.try(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.for(Unknown Source)
at com.servoy.j2db.develop.J2DBDeveloper.main(Unknown Source)
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.servoy.j2db.startup.Bootstrap.main(Unknown Source)
at Servoy.main(Unknown Source)
2007-04-05 14:48:32,709 WARN [TaskExecuter[3]] com.servoy.j2db.persistence.Server - Table name Appraiser_Appraisee_Relationship from server clico_web is too long (>30 chars) – this is not supported by all databases
2007-04-05 14:48:40,678 ERROR [TaskExecuter[3]] com.servoy.j2db.persistence.Server - java.sql.SQLException: No data found
2007-04-05 14:48:40,678 ERROR [TaskExecuter[3]] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: No data found No data found
at com.servoy.j2db.persistence.Server.char(Unknown Source)
at com.servoy.j2db.persistence.Server.getTable(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.r.a(Unknown Source)
at com.servoy.j2db.persistence.r.if(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveRootObject(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveSolution(Unknown Source)
at com.servoy.j2db.ActiveSolutionHandler.loadActiveSolution(Unknown Source)
at com.servoy.j2db.J2DBClient$11.run(Unknown Source)
at com.servoy.j2db.util.al.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2007-04-05 14:48:40,756 ERROR [TaskExecuter[3]] com.servoy.j2db.persistence.Server - java.sql.SQLException: No data found
2007-04-05 14:48:40,756 ERROR [TaskExecuter[3]] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: No data found No data found
at com.servoy.j2db.persistence.Server.char(Unknown Source)
at com.servoy.j2db.persistence.Server.getTable(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.r.a(Unknown Source)
at com.servoy.j2db.persistence.r.if(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveRootObject(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveSolution(Unknown Source)
at com.servoy.j2db.ActiveSolutionHandler.loadActiveSolution(Unknown Source)
at com.servoy.j2db.J2DBClient$11.run(Unknown Source)
at com.servoy.j2db.util.al.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2007-04-05 14:48:41,178 ERROR [TaskExecuter[3]] com.servoy.j2db.persistence.Server - java.sql.SQLException: No data found
2007-04-05 14:48:41,178 ERROR [TaskExecuter[3]] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: No data found No data found
at com.servoy.j2db.persistence.Server.char(Unknown Source)
at com.servoy.j2db.persistence.Server.getTable(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.r.a(Unknown Source)
at com.servoy.j2db.persistence.r.if(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveRootObject(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveSolution(Unknown Source)
at com.servoy.j2db.ActiveSolutionHandler.loadActiveSolution(Unknown Source)
at com.servoy.j2db.J2DBClient$11.run(Unknown Source)
at com.servoy.j2db.util.al.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2007-04-05 14:48:41,225 ERROR [TaskExecuter[3]] com.servoy.j2db.persistence.Server - java.sql.SQLException: No data found
2007-04-05 14:48:41,225 ERROR [TaskExecuter[3]] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: No data found No data found
at com.servoy.j2db.persistence.Server.char(Unknown Source)
at com.servoy.j2db.persistence.Server.getTable(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.r.a(Unknown Source)
at com.servoy.j2db.persistence.r.if(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveRootObject(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveSolution(Unknown Source)
at com.servoy.j2db.ActiveSolutionHandler.loadActiveSolution(Unknown Source)
at com.servoy.j2db.J2DBClient$11.run(Unknown Source)
at com.servoy.j2db.util.al.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2007-04-05 14:48:42,678 ERROR [TaskExecuter[3]] com.servoy.j2db.persistence.Server - java.sql.SQLException: No data found
2007-04-05 14:48:42,678 ERROR [TaskExecuter[3]] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: No data found No data found
at com.servoy.j2db.persistence.Server.char(Unknown Source)
at com.servoy.j2db.persistence.Server.getTable(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.r.a(Unknown Source)
at com.servoy.j2db.persistence.r.if(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveRootObject(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveSolution(Unknown Source)
at com.servoy.j2db.ActiveSolutionHandler.loadActiveSolution(Unknown Source)
at com.servoy.j2db.J2DBClient$11.run(Unknown Source)
at com.servoy.j2db.util.al.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2007-04-05 14:48:42,740 ERROR [TaskExecuter[3]] com.servoy.j2db.persistence.Server - java.sql.SQLException: No data found
2007-04-05 14:48:42,740 ERROR [TaskExecuter[3]] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: No data found No data found
at com.servoy.j2db.persistence.Server.char(Unknown Source)
at com.servoy.j2db.persistence.Server.getTable(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.r.a(Unknown Source)
at com.servoy.j2db.persistence.r.if(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveRootObject(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveSolution(Unknown Source)
at com.servoy.j2db.ActiveSolutionHandler.loadActiveSolution(Unknown Source)
at com.servoy.j2db.J2DBClient$11.run(Unknown Source)
at com.servoy.j2db.util.al.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2007-04-05 14:48:43,459 ERROR [TaskExecuter[3]] com.servoy.j2db.persistence.Server - java.sql.SQLException: No data found
2007-04-05 14:48:43,459 ERROR [TaskExecuter[3]] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: No data found No data found
at com.servoy.j2db.persistence.Server.char(Unknown Source)
at com.servoy.j2db.persistence.Server.getTable(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.Repository.a(Unknown Source)
at com.servoy.j2db.persistence.r.a(Unknown Source)
at com.servoy.j2db.persistence.r.if(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveRootObject(Unknown Source)
at com.servoy.j2db.persistence.Repository.getActiveSolution(Unknown Source)
at com.servoy.j2db.ActiveSolutionHandler.loadActiveSolution(Unknown Source)
at com.servoy.j2db.J2DBClient$11.run(Unknown Source)
at com.servoy.j2db.util.al.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2007-04-05 14:50:21,680 ERROR [AWT-EventQueue-0] com.servoy.j2db.util.Debug - Throwable
java.lang.NullPointerException
at com.servoy.j2db.dataprocessing.t.a(Unknown Source)
at com.servoy.j2db.dataprocessing.t.a(Unknown Source)
at com.servoy.j2db.dataprocessing.t.a(Unknown Source)
at com.servoy.j2db.dataprocessing.t.if(Unknown Source)
at com.servoy.j2db.dataprocessing.i.a(Unknown Source)
at com.servoy.j2db.dataprocessing.t.a(Unknown Source)
at com.servoy.j2db.dataprocessing.t.a(Unknown Source)
at com.servoy.j2db.dataprocessing.t.if(Unknown Source)
at com.servoy.j2db.dataprocessing.i.a(Unknown Source)
at com.servoy.j2db.dataprocessing.t.a(Unknown Source)
at com.servoy.j2db.dataprocessing.t.a(Unknown Source)
at com.servoy.j2db.dataprocessing.t.if(Unknown Source)
at com.servoy.j2db.dataprocessing.i.a(Unknown Source)
at com.servoy.j2db.dataprocessing.t.a(Unknown Source)
at com.servoy.j2db.dataprocessing.t.a(Unknown Source)
at com.servoy.j2db.dataprocessing.t.if(Unknown Source)
at com.servoy.j2db.dataprocessing.ak.getSharedFoundSet(Unknown Source)
at com.servoy.j2db.dataprocessing.ak.do(Unknown Source)
at com.servoy.j2db.dataprocessing.ak.if(Unknown Source)
at com.servoy.j2db.FormController.long(Unknown Source)
at com.servoy.j2db.FormController.new(Unknown Source)
at com.servoy.j2db.FormManager.int(Unknown Source)
at com.servoy.j2db.FormManager.a(Unknown Source)
at com.servoy.j2db.FormManager.do(Unknown Source)
at com.servoy.j2db.develop.ad.do(Unknown Source)
at com.servoy.j2db.FormManager.do(Unknown Source)
at com.servoy.j2db.develop.ad.do(Unknown Source)
at com.servoy.j2db.FormManager$1.run(Unknown Source)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Try using another jdbc driver that connects to SAP.
It may be related to the jdbc-odbc bridge.

Rob

Are there any other possible solutions that I could try? The SAP driver currently in use works fine with 3.0… was there some fundamental change that occurred in terms of connectivity when 3.1 was developed?

The reason I seem reluctant to replace the driver is because we inherited the driver from a previous application. I’m not sure how easy it would be to obtain a new driver.

Of course, if this is the only possible solution, i’ll have no choice but to source another driver, but if it’s possible that there might be another solution to the problem, I’d prefer to try that before trying to source a new driver.

Thanks,
Kion

Kion,

The problem with the jdbc-odbc driver that it does not allow getting the same value from the resultset twice (i found that out just now) which is pretty strange behaviour for a jdbc driver.
We happened to do just that in the 3.1 release and it is no problem for any other jdbc driver we know.

Another possibility is moving the repository to another database, for instance sybase ianywhere which is bundled with servoy.
You can still use the SAP db for your application data.

Rob

Rob,

Actually our repository IS a sybase database, from the bundled iAnywhere DBMS. In addition, most of the application’s data is also stored in sybase. In fact, we don’t directly connect to the SAP database in Servoy… we instead have added the SAP tables we needed as proxy tables in the sybase application database.

Therefore, when i think about it, I may have given some mis-information - the only SAP jdbc driver we explicitly use is when interfacing with SAP via a custom plug-in that we created. In other words, there is no SAP jdbc driver in the /drivers directory of Servoy - only in the /plugins directory for use with the plugin.

Hey,

Are there any other suggestions to solve this problem? It’s somewhat of a show-stopper, since it doesn’t allow us to upgrade so we can’t take advantage of new bug fixes…

Kion,

You could try copying your sap driver from the plugins directory to the drivers directory and modify the jdbc url accordingly in the db servers tab.

Rob

Kion,

You may want to give todays released 3.1.5 version a try.
We have removed a duplicate call to the jdbc driver that may fix your problem.

Rob