Cannot Create Form error

ellenmeserow · November 6, 2007, 7:25pm

I just asked Servoy Developer 3.5.2 on my brand new 64-bit 8 processor quad-core server to add a new form, and got the attached error dialog. Quit developer and relaunched, same error.

Help? Server log looks like this:

2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.util.Debug 	Throwable
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
     at com.servoy.j2db.persistence.datasource.n.createConnection(Unknown Source)
     at com.servoy.j2db.persistence.datasource.r.makeObject(Unknown Source)
     at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
     at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
     at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.testConnection(Unknown Source)
     at com.servoy.j2db.server.ApplicationServer$a.run(Unknown Source)
     at com.servoy.j2db.util.aq.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source)
    Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.login(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
     ... 10 more
2007-11-06 11:07 	TaskExecuter[0] 	ERROR 	com.servoy.j2db.persistence.Server 	Final get connection failure for server pdf_forms in 1 times
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.util.Debug 	Throwable
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
     at com.servoy.j2db.persistence.datasource.n.createConnection(Unknown Source)
     at com.servoy.j2db.persistence.datasource.r.makeObject(Unknown Source)
     at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
     at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
     at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.testConnection(Unknown Source)
     at com.servoy.j2db.server.ApplicationServer$a.run(Unknown Source)
     at com.servoy.j2db.util.aq.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source)
    Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.login(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
     ... 10 more
2007-11-06 11:07 	TaskExecuter[0] 	ERROR 	com.servoy.j2db.persistence.Server 	Final get connection failure for server udm in 1 times
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.util.Debug 	Throwable
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
     at com.servoy.j2db.persistence.datasource.n.createConnection(Unknown Source)
     at com.servoy.j2db.persistence.datasource.r.makeObject(Unknown Source)
     at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
     at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
     at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.testConnection(Unknown Source)
     at com.servoy.j2db.server.ApplicationServer$a.run(Unknown Source)
     at com.servoy.j2db.util.aq.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source)
    Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.login(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
     ... 10 more
2007-11-06 11:07 	TaskExecuter[0] 	ERROR 	com.servoy.j2db.persistence.Server 	Final get connection failure for server log_server in 1 times
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.util.Debug 	Throwable
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
     at com.servoy.j2db.persistence.datasource.n.createConnection(Unknown Source)
     at com.servoy.j2db.persistence.datasource.r.makeObject(Unknown Source)
     at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
     at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
     at com.servoy.j2db.persistence.datasource.i.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.getConnection(Unknown Source)
     at com.servoy.j2db.persistence.Server.testConnection(Unknown Source)
     at com.servoy.j2db.server.ApplicationServer$a.run(Unknown Source)
     at com.servoy.j2db.util.aq.run(Unknown Source)
     at java.lang.Thread.run(Unknown Source)
    Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
     at com.sybase.jdbc3.tds.Tds.login(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
     at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)
     at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
     ... 10 more
2007-11-06 11:07 	TaskExecuter[0] 	ERROR 	com.servoy.j2db.persistence.Server 	Final get connection failure for server example_data in 1 times
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.persistence.Server 	Table name xml_schema_component_placements from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.persistence.Server 	Table name system_internals_partition_columns from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.persistence.Server 	Table name system_internals_allocation_units from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.persistence.Server 	Table name system_components_surface_area_configuration from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.persistence.Server 	Table name service_contract_message_usages from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.persistence.Server 	Table name parameter_xml_schema_collection_usages from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.persistence.Server 	Table name message_type_xml_schema_collection_usages from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_tran_active_snapshot_database_transactions from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_exec_query_transformation_stats from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_exec_query_resource_semaphores from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_exec_background_job_queue_stats from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_db_missing_index_group_stats from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	TaskExecuter[0] 	WARN 	com.servoy.j2db.persistence.Server 	Table name column_xml_schema_collection_usages from server repository_server is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name xml_schema_component_placements from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name system_internals_partition_columns from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name system_internals_allocation_units from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name system_components_surface_area_configuration from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name service_contract_message_usages from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name parameter_xml_schema_collection_usages from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name message_type_xml_schema_collection_usages from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_tran_active_snapshot_database_transactions from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_exec_query_transformation_stats from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_exec_query_resource_semaphores from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_exec_background_job_queue_stats from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_db_missing_index_group_stats from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name column_xml_schema_collection_usages from server user_data is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name xml_schema_component_placements from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name system_internals_partition_columns from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name system_internals_allocation_units from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name system_components_surface_area_configuration from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name service_contract_message_usages from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name parameter_xml_schema_collection_usages from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name message_type_xml_schema_collection_usages from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_tran_active_snapshot_database_transactions from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_exec_query_transformation_stats from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_exec_query_resource_semaphores from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_exec_background_job_queue_stats from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name dm_db_missing_index_group_stats from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name column_xml_schema_collection_usages from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name TblLookup23PriorityConsequenceDetail from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name TblLookup22PriorityConsequences from server livewtd is too long (>30 chars) -- this is not supported by all databases
2007-11-06 11:07 	WrapperSimpleAppMain 	WARN 	com.servoy.j2db.persistence.Server 	Table name TblContractPlan05BaselineTarget from server livewtd is too long (>30 chars) -- this is not supported by all databases

Jan_Aleman · November 6, 2007, 7:55pm

Indicates there is no connection to that database.

ellenmeserow · November 6, 2007, 8:05pm

Got the error by saying “New Form” from the file menu. What database is it complaining about? I haven’t heard of JZ006…

Jan_Aleman · November 6, 2007, 8:12pm

Is sybase running? The stacktrace indicates it cannot connect to a couple of your sybase connections.

patrick · November 6, 2007, 8:13pm

This looks like it is MS SQL 2005. Are you sure it is accepting connections the way it should?

Jan_Aleman · November 6, 2007, 8:18pm

Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)

The stacktrace indicates that sybase is complaining about the connection. If you upgraded to ASA10 check your passwords, in 10 they are case sensitive.

ellenmeserow · November 6, 2007, 8:19pm

It is MS SQL 2005. The solution is named WTDPROD and the repository (also in MS SQL 2005) is called Servoy_Repository. Also connecting to a database called Servoy_UserData in MS SQL 2005. All three of those connections are fine. Successful for more than a week. Only having this prob when saying new form.

ellenmeserow · November 6, 2007, 8:24pm

Disabled all connections I’m not using (example data, log_data, etc) which still had driver strings to Sybase which I have turned off. That must be the problem. Now it lets me create a form (in my SQL Server repository just fine).

I do think that might be considered a bug – my repository was in SQL Server but dead connections to sybase stopped me from saying New Form?

Thanks Jan and Patrick!

Topic		Replies	Views
Developer on Vista Classic Servoy	7	4710	March 19, 2009
E: Can't connect to the repository server specified in ... Classic Servoy	24	21825	September 21, 2005
cannot setup new named server connection Classic Servoy	11	48421	April 22, 2005
Version: 4.1.1 - build 658 Classic Servoy	11	8255	October 6, 2009
Cannot setup server Classic Servoy	10	3732	July 1, 2005

Cannot Create Form error

Related topics