Server connection problems in 4

Ron · July 28, 2008, 7:02am

I am having quite a few problems with connection to the server the last couple of days resulting in: checkoutproblems and a refusal to load forms.
I tried to reboot XP and sometimes this helps, sometimes it won’t help.

2008-07-28 08:14:34,406 ERROR [TaskExecuter[1]] com.servoy.j2db.persistence.Server - Final get connection failure for server bug_db in 1 times
2008-07-28 08:14:34,406 WARN [TaskExecuter[1]] 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.as.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
2008-07-28 08:14:35,406 ERROR [TaskExecuter[1]] com.servoy.j2db.persistence.Server - Final get connection failure for server ronbase in 1 times
2008-07-28 08:14:35,406 WARN [TaskExecuter[1]] 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.as.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
2008-07-28 08:21:47,015 ERROR [Thread-7] com.servoy.j2db.util.Debug - Client closes abnormally, trying to unbind the client from the server'
2008-07-28 08:37:54,078 ERROR [Thread-7] com.servoy.j2db.util.Debug - Client closes abnormally, trying to unbind the client from the server'

Regards,
Ron

Servoy 4.0.0
Windows XP SP3
Latest Java

Gabi_Boros · July 28, 2008, 12:27pm

check if your local repository database is up and running

Ron · July 28, 2008, 2:23pm

I’ll check that next time, things are running well now.
BTW I noticed that App.S. sometimes refuses to start when
double clicked on the bat-file. It looks like Developer has the same
difficulty.

Thanks Gabi.

Regards,
Ron

Ron · July 29, 2008, 7:41am

This morning I got the same connection isssue (JZ006).
The servers in developer all had a red cross.

The AS could’nt be opened via my browser so it was not up and running.

Then I checked if I could op AS with the bat file, which I could not.
The bat file window shows 3 lines of text and then closes so the AS is not
started.

Couple of reboots later and the server is online again.
The (nasty) problem does occur 2 times out of 10 approximately.

Regards,
Ron

pbakker · July 29, 2008, 8:14am

When you experience the issue, are you sure the database server is up and running?

Note: When just running the Servoy Application Server, YOU are responsible for starting the database server. When you start Servoy Developer, it automatically starts (by default) the Sybase database engine and the database engine will keep running after you close down Servoy Devveloper.

Paul

Ron · July 29, 2008, 9:13am

pbakker:
When you experience the issue, are you sure the database server is up and running?

No about Sybase DS I don’t know.
How do I check this and how do I start Sybase?

"pbakker’':
Note: When just running the Servoy Application Server, YOU are responsible for starting the database server.

OK, I know how to start AS, but thought it would start Sybase also.
Again dunno how to start Sybase.

pbakker:
When you start Servoy Developer, it automatically starts (by default) the Sybase database engine and the database engine will keep running after you close down Servoy Devveloper.

I guess Sybase did’nt start (red crosses), but again I am not sure.

I am not sure if I understand correctly.
Q1:
If just closed Developer and opened AS and could see that
the Sybase servers were online. How is this possible if they were closed by Developer as you said.
Q2:
What about the AS batfile refusing to start?
Is this related to the Sybase database which has to be started first?

pbakker · July 29, 2008, 9:28am

Yes, If you try to start the Application Server when the required databases are not running, the console window of the AS will close itself.

As I wrote, the Developer starts the databases automatically, but does NOT close them when you close developer.

Please read the Server manuals how to start the databases manually of run them as a service.

Regards,

Paul

Ron · July 29, 2008, 4:35pm

Thanks for your replies Paul but I am still finding out what went wrong.

I am sure I am not the only one who wants to understand what is going on
and wants to be able do some basic error finding.

This is what I have learned (the hard way) so far (plse correct me if I am mistaken):

Developer starts >> AS and Sybase Server start
2 Developer closes >> AS closes
AS starts only when Sybase is up and running. The console window closes if not.
Theoretically Sybase could be online while AS refuses to start.
In Developer you still can access data but can not access the repository (checkout).
There is no way then for (real) Client-Server simulation (without Developer) right?
AS shows what Sybase Servers are on- or offline but Developer shows this as well
in the Server node.
So if AS has a problem Sybase can still be alive.
Developer and AS can be used to start Sybase Server.
How can I start Sybase manualy, can’t find info on that.

Regards,
Ron

pbakker · July 29, 2008, 5:06pm

If you want to see if your database is up and running, check Windows task manager or look for the iAnywhere icon in the System tray in windows.

If you want to test Client-Server without using Developer, make sure the database is started and then start the Servoy Application Server, but you can also just test the Smart and Web Client directly from Developer: same thing.

Paul

Topic		Replies	Views
Server no start Classic Servoy	2	2508	August 1, 2008
after Win XP crash, can't reconnect to Sybase ASA Classic Servoy	5	3002	May 26, 2006
Cannot Create Form error Classic Servoy	7	3859	November 6, 2007
Can't Start Servoy Server Classic Servoy	7	6337	July 25, 2006
Error with my sybase server Classic Servoy	5	3540	June 11, 2010

Server connection problems in 4

Related topics