Servoy Forum

Discuss Servoy here!

Skip to content

hxtt DBF SQLException Can't find column

Discuss all problems you have with Servoy here. It might help to mention the Servoy version and Operating System version you are using
Post a reply

hxtt DBF SQLException Can't find column

Postby deezzub » Fri Jan 31, 2014 12:42 pm

We get a strange error on our test application server, but we don't why, because the table is not used. Also strange is, the error message contains the column name table client_stats, but in FoxPro DBF it only is total_clie and in the Servoy DBI file it is total_clien.

Code: Select all
java.sql.SQLException: Can't find column: total_clients_running in table client_stats
       at com.hxtt.global.SQLState.SQLException(Unknown Source)
       at com.hxtt.sql.d3.a(Unknown Source)
       at com.hxtt.sql.de.a(Unknown Source)
       at com.hxtt.sql.bz.a(Unknown Source)
       at com.hxtt.sql.am.a(Unknown Source)
       at com.hxtt.sql.d5.executeUpdate(Unknown Source)
       at sun.reflect.GeneratedMethodAccessor171.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
       at java.lang.reflect.Method.invoke(Unknown Source)
       at com.servoy.j2db.datasource.Zg.invoke(Zg.java:13)
       at $Proxy0.executeUpdate(Unknown Source)
       at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
       at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
       at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
       at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
       at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:35)
       at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:17)
       at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:384)
       at com.servoy.j2db.dataprocessing.Zg.run(Zg.java:1)
       at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
       at java.lang.Thread.run(Unknown Source)


2014-01-31_11_15_56-FoxPro_Table_Designer_-_client_stats.dbf_structure.png
client_stats.dbf structure
2014-01-31_11_15_56-FoxPro_Table_Designer_-_client_stats.dbf_structure.png (26.67 KiB) Viewed 2657 times


client_stats.dbi.txt
client_stats.dbi
(804 Bytes) Downloaded 198 times


2014-01-31_11_29_44-Servoy_Developer_search_client_stats.png
client_stats search in Servoy Developer
2014-01-31_11_29_44-Servoy_Developer_search_client_stats.png (24.29 KiB) Viewed 2657 times


What causes this error?
Last edited by deezzub on Fri Jan 31, 2014 12:46 pm, edited 1 time in total.
deezzub
 
Posts: 328
Joined: Tue May 28, 2013 3:02 pm
Location: Oldenburg, Germany
Top

Re: hxtt DBF SQLException Can't find column

Postby deezzub » Fri Jan 31, 2014 12:43 pm

2014-01-31_11_32_22-Servoy_Developer_search_total_clients_running.png
total_clients_running search in Servoy Developer
2014-01-31_11_32_22-Servoy_Developer_search_total_clients_running.png (20.69 KiB) Viewed 2656 times


2014-01-31_11_45_05-Servoy_Developer_search_total_clien.png
total_clien search in Servoy Developer
2014-01-31_11_45_05-Servoy_Developer_search_total_clien.png (18.74 KiB) Viewed 2656 times
deezzub
 
Posts: 328
Joined: Tue May 28, 2013 3:02 pm
Location: Oldenburg, Germany
Top

Re: hxtt DBF SQLException Can't find column

Postby deezzub » Fri Jan 31, 2014 2:47 pm

I have deleted all client_stats DBF and DBI files in the developement environment and the client_stats DBF on our test application server. Also I have deleted all solutions on the server. Then I have exported the solution in developer and uploaded it to the server. After that I get the following error in the server log.

Code: Select all
2014-01-31 13:18:33,912 ERROR [pre-import hook: svy_pre_import] com.servoy.j2db.util.Debug - Throwable [ ]
com.servoy.j2db.persistence.RepositoryException: could not update columninfo from column 'total_clien' in table 'client_stats', column has none
   at com.servoy.j2db.server.Za.Zs.Za(Zs.java:8)
   at com.servoy.j2db.server.Za.Zs.Za(Zs.java:83)
   at com.servoy.j2db.server.Za.Zs.updateAllColumnInfo(Zs.java:235)
   at com.servoy.j2db.server.Za.Zo.updateAllColumnInfo(Zo.java:1081)
   at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1679)
   at com.servoy.j2db.server.Za.Zo.syncTableObjWithDB(Zo.java:1460)
   at com.servoy.j2db.server.Za.Zo.createClientStatsTable(Zo.java:1495)
   at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:34)
   at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:60)
   at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:349)
   at com.servoy.j2db.dataprocessing.Za.register(Za.java:5)
   at com.servoy.j2db.ClientState.registerClient(ClientState.java:625)
   at com.servoy.j2db.server.headlessclient.SessionClient.registerClient(SessionClient.java:341)
   at com.servoy.j2db.ClientState.applicationServerInit(ClientState.java:317)
   at com.servoy.j2db.server.headlessclient.SessionClient.<init>(SessionClient.java:208)
   at com.servoy.j2db.server.headlessclient.SessionClient.<init>(SessionClient.java:162)
   at com.servoy.j2db.server.headlessclient.HeadlessClientFactoryInternal$2.<init>(HeadlessClientFactoryInternal.java:125)
   at com.servoy.j2db.server.headlessclient.HeadlessClientFactoryInternal.createImportHookClient(HeadlessClientFactoryInternal.java:125)
   at com.servoy.j2db.server.Zc.Zhb.run(Zhb.java:5)
   at java.lang.Thread.run(Unknown Source)
2014-01-31 13:18:33,912 ERROR [pre-import hook: svy_pre_import] com.servoy.j2db.util.Debug - client_stats table missing in log server, cannot save client statistics [ ]
2014-01-31 13:18:35,207 ERROR [pool-2-thread-2] com.servoy.j2db.dataprocessing.Zb - Error updating client stats [ ]
java.sql.SQLException: Can't find column: total_clients_running in table client_stats
   at com.hxtt.global.SQLState.SQLException(Unknown Source)
   at com.hxtt.sql.d3.a(Unknown Source)
   at com.hxtt.sql.de.a(Unknown Source)
   at com.hxtt.sql.bz.a(Unknown Source)
   at com.hxtt.sql.am.a(Unknown Source)
   at com.hxtt.sql.d5.executeUpdate(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at com.servoy.j2db.datasource.Zg.invoke(Zg.java:13)
   at $Proxy0.executeUpdate(Unknown Source)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:35)
   at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:17)
   at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:384)
   at com.servoy.j2db.dataprocessing.Zg.run(Zg.java:1)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)
2014-01-31 13:25:09,140 ERROR [post-import hook: svy_post_import] com.servoy.j2db.dataprocessing.Zb - Error updating client stats [ ]
java.sql.SQLException: Can't find column: total_clients_running in table client_stats
   at com.hxtt.global.SQLState.SQLException(Unknown Source)
   at com.hxtt.sql.d3.a(Unknown Source)
   at com.hxtt.sql.de.a(Unknown Source)
   at com.hxtt.sql.bz.a(Unknown Source)
   at com.hxtt.sql.am.a(Unknown Source)
   at com.hxtt.sql.d5.executeUpdate(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at com.servoy.j2db.datasource.Zg.invoke(Zg.java:13)
   at $Proxy0.executeUpdate(Unknown Source)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:35)
   at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:60)
   at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:349)
   at com.servoy.j2db.dataprocessing.Za.register(Za.java:5)
   at com.servoy.j2db.ClientState.registerClient(ClientState.java:625)
   at com.servoy.j2db.server.headlessclient.SessionClient.registerClient(SessionClient.java:341)
   at com.servoy.j2db.ClientState.applicationServerInit(ClientState.java:317)
   at com.servoy.j2db.server.headlessclient.SessionClient.<init>(SessionClient.java:208)
   at com.servoy.j2db.server.headlessclient.SessionClient.<init>(SessionClient.java:162)
   at com.servoy.j2db.server.headlessclient.HeadlessClientFactoryInternal$2.<init>(HeadlessClientFactoryInternal.java:125)
   at com.servoy.j2db.server.headlessclient.HeadlessClientFactoryInternal.createImportHookClient(HeadlessClientFactoryInternal.java:125)
   at com.servoy.j2db.server.Zc.Zhb.run(Zhb.java:5)
   at java.lang.Thread.run(Unknown Source)
2014-01-31 13:25:09,343 ERROR [pool-2-thread-2] com.servoy.j2db.dataprocessing.Zb - Error updating client stats [ ]
java.sql.SQLException: Can't find column: total_clients_running in table client_stats
   at com.hxtt.global.SQLState.SQLException(Unknown Source)
   at com.hxtt.sql.d3.a(Unknown Source)
   at com.hxtt.sql.de.a(Unknown Source)
   at com.hxtt.sql.bz.a(Unknown Source)
   at com.hxtt.sql.am.a(Unknown Source)
   at com.hxtt.sql.d5.executeUpdate(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at com.servoy.j2db.datasource.Zg.invoke(Zg.java:13)
   at $Proxy0.executeUpdate(Unknown Source)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:35)
   at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:17)
   at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:384)
   at com.servoy.j2db.dataprocessing.Zg.run(Zg.java:1)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)
2014-01-31 13:27:16,224 ERROR [RMI TCP Connection(2)-172.20.20.9] com.servoy.j2db.dataprocessing.Zb - Error updating client stats [ ]
java.sql.SQLException: Can't find column: total_clients_running in table client_stats
   at com.hxtt.global.SQLState.SQLException(Unknown Source)
   at com.hxtt.sql.d3.a(Unknown Source)
   at com.hxtt.sql.de.a(Unknown Source)
   at com.hxtt.sql.bz.a(Unknown Source)
   at com.hxtt.sql.am.a(Unknown Source)
   at com.hxtt.sql.d5.executeUpdate(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at com.servoy.j2db.datasource.Zg.invoke(Zg.java:13)
   at $Proxy0.executeUpdate(Unknown Source)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:35)
   at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:60)
   at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:349)
   at com.servoy.j2db.dataprocessing.Za.register(Za.java:5)
   at com.servoy.j2db.dataprocessing.Zu.register(Zu.java:1)
   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 sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
   at sun.rmi.transport.Transport$1.run(Unknown Source)
   at sun.rmi.transport.Transport$1.run(Unknown Source)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Unknown Source)
   at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Source)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)
2014-01-31 13:27:20,576 ERROR [RMI TCP Connection(2)-172.20.20.9] com.servoy.j2db.dataprocessing.Zb - Error updating client stats [ ]
java.sql.SQLException: Can't find column: total_clients_running in table client_stats
   at com.hxtt.global.SQLState.SQLException(Unknown Source)
   at com.hxtt.sql.d3.a(Unknown Source)
   at com.hxtt.sql.de.a(Unknown Source)
   at com.hxtt.sql.bz.a(Unknown Source)
   at com.hxtt.sql.am.a(Unknown Source)
   at com.hxtt.sql.d5.executeUpdate(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at com.servoy.j2db.datasource.Zg.invoke(Zg.java:13)
   at $Proxy0.executeUpdate(Unknown Source)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:35)
   at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:60)
   at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:349)
   at com.servoy.j2db.dataprocessing.Za.register(Za.java:5)
   at com.servoy.j2db.ClientState.registerClient(ClientState.java:625)
   at com.servoy.j2db.server.headlessclient.SessionClient.registerClient(SessionClient.java:341)
   at com.servoy.j2db.ClientState.applicationServerInit(ClientState.java:317)
   at com.servoy.j2db.server.headlessclient.SessionClient.<init>(SessionClient.java:208)
   at com.servoy.j2db.server.headlessclient.SessionClient.<init>(SessionClient.java:162)
   at com.servoy.j2db.server.main.Zd.<init>(Zd.java:5)
   at com.servoy.j2db.server.main.Zq.run(Zq.java:35)
   at com.servoy.j2db.server.main.Zm.login(Zm.java:4)
   at com.servoy.j2db.server.main.Zo.login(Zo.java:10)
   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 sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
   at sun.rmi.transport.Transport$1.run(Unknown Source)
   at sun.rmi.transport.Transport$1.run(Unknown Source)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Unknown Source)
   at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Source)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)
2014-01-31 13:27:21,700 ERROR [pool-2-thread-2] com.servoy.j2db.dataprocessing.Zb - Error updating client stats [ ]
java.sql.SQLException: Can't find column: total_clients_running in table client_stats
   at com.hxtt.global.SQLState.SQLException(Unknown Source)
   at com.hxtt.sql.d3.a(Unknown Source)
   at com.hxtt.sql.de.a(Unknown Source)
   at com.hxtt.sql.bz.a(Unknown Source)
   at com.hxtt.sql.am.a(Unknown Source)
   at com.hxtt.sql.d5.executeUpdate(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at com.servoy.j2db.datasource.Zg.invoke(Zg.java:13)
   at $Proxy0.executeUpdate(Unknown Source)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
   at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:35)
   at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:17)
   at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:384)
   at com.servoy.j2db.dataprocessing.Zg.run(Zg.java:1)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)


Also, really strange is, that the client_stats DBF file again there are on the server.
deezzub
 
Posts: 328
Joined: Tue May 28, 2013 3:02 pm
Location: Oldenburg, Germany
Top

Re: hxtt DBF SQLException Can't find column

Postby deezzub » Fri Jan 31, 2014 4:59 pm

Problem solved. The log server was mistakenly set to the DBF server.

But, why are the DBF column name and the DBI column name different?
deezzub
 
Posts: 328
Joined: Tue May 28, 2013 3:02 pm
Location: Oldenburg, Germany
Top
Post a reply

Return to Discuss possible Issues and Bugs

Who is online

Users browsing this forum: No registered users and 17 guests

Learn more about Servoy