servoy.properties.
java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused
Any idea about this error?
Trying to install on MacOS X a solution I created on windoze. Using iAnywhere.
Going to reinstall servoy. Think it’s a problem with servoy.properties copied from PC
Thanks!
Providence
Here’s the new error I get after reinstalling:
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
Is iAnywhere supposed to launch itself as on the PC?
JM
John,
The servoy.properties file is basically just a text file - so should be fine between Mac/Win/Linux.
Yes, Sybase is loaded automatically on launch (check the process monitor or Activity Monitor in Applications:Utilities)
You also want to make sure that databases are pointed to the correct place in DB Servers tab of Preferences.
What version are you trying to install on your Mac?
Did you download Sybase Central also?
Bob Cusick
Bob:
Thanks for the fast reply.
Yes, downloaded Sybase Cenrtal.
Version 2.0.4 on the Mac.
CONTACT_MGMT.DB in the database folder of Servoy.
Rebooted after installing Servoy. Initially not Sybase Central.
contact_mgmt
dba
sql
jdbc:sybase:Tds:localhost:2638?ServiceName=CONTACT_MGMT&CHARSET=utf8
com.sybase.jdbc2.jdbc.SybDriver
Can’t connect to any database!
Still getting this Fatal Init error:
java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused
Still getting this error on launch:
Fatal init, could not load/init the database servers from servoy.properties.
Still getting this error when trying to connect via Preferences:
java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused
Copied a new WORKING database from a WORKING windoze machine.
Copied a new WORKING sybase.config from a WORKING windoze machine.
Any ideas?
Providence
can sybase central find youre installation?
Is sybase started up??
DBLauncher launches.
what do you mean can sybase central find it?
Prov
On the PC side DBLauncher automatically launches…
On the Mac, here’s the log when I launch it…
Adaptive Server Anywhere Database Engine Version 9.0.1.1753
Copyright (c) 1989-2004 Sybase, Inc.
Portions Copyright (c) 2002-2004, iAnywhere Solutions, Inc.
All rights reserved. All unpublished rights reserved.
This software contains confidential and trade secret information of
iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and documentation
by the U.S. Government is subject to restrictions set forth in a license
agreement between the Government and iAnywhere Solutions, Inc. or
other written agreement specifying the Government’s rights to use the
software and any applicable FAR provisions, for example, FAR 52.227-19.
iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA 94568, USA
Developer edition, not licensed for deployment
8192K of memory used for caching
Minimum cache size: 8192K, maximum cache size: 26964K
Using a maximum page size of 2048 bytes
Starting database “CONTACT_MGMT” (/Applications/Servoy/database/CONTACT_MGMT.db) at Fri Aug 27 2004 20:53
Transaction log: CONTACT_MGMT.log
Starting checkpoint of “CONTACT_MGMT” (CONTACT_MGMT.db) at Fri Aug 27 2004 20:53
Finished checkpoint of “CONTACT_MGMT” (CONTACT_MGMT.db) at Fri Aug 27 2004 20:53
Database “CONTACT_MGMT” (CONTACT_MGMT.db) started at Fri Aug 27 2004 20:53
Database server started at Fri Aug 27 2004 20:53
Trying to start SharedMemory link …
SharedMemory link started successfully
Trying to start TDS (TCPIP) link …
Starting on port 2638
TDS (TCPIP) link started successfully
Now accepting requests
It should work, shouldn’t it?
JM
Yes, I can connect to the database via Sybase Central…
Now what do I do to get it to work?
Prov…
Still can’t get past this error:
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
And it’s been almost two weeks yet something like eighty people have looked at this post!
don’t know for sure but try capitals
DBA
SQL
I don’t get the error when I use caps on the CONTACT_MGMT database, but when I check the other preferences for, say, the repository database, it seems like all the caps are changed for the databases and their passwords.
Then I go to reboot and it gives me the same error above.
Also, DBLauncher does not auto launch, I have to do it manually.
Not to be sarcastic, but does this program work on Macs?
are you saying that you can connect to one sybase database just fine and not to another (the repository db?)
That is completely strange. What happens if you just make a new sybase database (through sybase central) add this one to the sybase config file. And point to that one as the repository?
There are a lot of mac users that are using sybase just fine.
I tried that! I tried wiping Servoy completely and reinstalling. I tried exporting from the PC and importing the solution from the Mac. Then the screen never redrew correctly, something I find on windows but not to the extent that all the dev button rows at the top disppear!
Nothing works!
I continue to get this error:
java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused
Can someone please tell me how you move your solutions from the PC to the Mac and vice versa?
I’m being told privately that the Mac is not a good development platform!
Is this true? It seems most people on the boards are on them!
Again, Can someone please tell me how you move your solutions from the PC to the Mac and vice versa?
John,
THIS ASSUMES YOU CAN CREATE A NEW SYBASE DATABASE and change the sybase.config file so that Servoy will start it up on launch. If you don’t know how to - see the other posts on how to do that FIRST.
Create a new database on whatever platform you want to develop on.
Create a new connection to that database (Edit → Preferences → DB Servers)
Create your solution
Export your solution to disk either WITH or WITHOUT data (File → Repository: click on your solution and the release number you want to export and click “Export to File”)
ON THE OTHER PLATFORM:
Create a new database - it can be either named the same or different than the one on your other platform.
Launch Servoy and make a new connection to that database (Edit → Preferences → DB Servers). This can be the SAME NAME as your other platform, or a different name.
Go to File → Repository and click the “Import” button to import your solution. IF you named the connection differently on this computer than you did on the other computer - you will be prompted to choose the connection you want to use - pick the one you created in step 2.
DONE.
PROCESS TO TRANSER SOLUTION BETWEEN THE COMPUTERS IN THE FUTURE:
FROM YOUR DEVELOPEMENT BOX: Export your solution to disk either WITH or WITHOUT data (File → Repository: click on your solution and the release number you want to export and click “Export to File”)
ON YOUR OTHER BOX: Go to File → Repository and click the “Import” button to import your solution. IF you named the connection differently on this computer than you did on the other computer - you will be prompted to choose the connection you want to use.
Hope this helps,
Bob Cusick
P.S. You can always check the “sybase_log.txt” file inside the “sybase_db” folder to see any errors that sybase had - INCLUDING the one that you mentioned.
Bob,
I can only get this far:
THIS ASSUMES YOU CAN CREATE A NEW SYBASE DATABASE and change the sybase.config file…
I keep getting this error:
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
I have installed and reinstalled this thing dozens of times over the past several weeks. I have followed the examples to the letter and made sure every time I reinstall I kill any files (Servoy or Sybase) in the home/library/preferences folder.
Why is this so hit or miss? Mostly miss.
John
you do get that error/sql warning in servoy yes?
But can you connect to the database with sybase central?
So create a new database in sybase central (add them to the config)
restart youre computer
restart sybase central, connect to that just made database.
Does that work?
(so not doing anything with servoy)
you do get that error/sql warning in servoy yes?
Yes!
But can you connect to the database with sybase central?
Yes!
So create a new database in sybase central (add them to the config)
restart youre computer restart sybase central, connect to that just made database. Does that work?
No, I cannot connect to the just made database in Sybase Central, in Servoy. That’s my problem. And of all the numerous times I’ve started and restared this process from scratch, I’ve only been able to connect to the database created in Sybase Central, in Servoy, once on the Mac.
However, I just went through the exact same process:
Install Servoy
Install Sybase Central
Create a Database called CONTACT_MGMT in Sybase Central
Add it to sybase.config
Connect to it in Servoy.
On fresh PC. It was the exact same process. I sat with the same manuals I did last night on my Mac, this morning on the PC.
AND IT WORKED! NO PROBLEMS!
Could there be a conflict on my Mac? I have the Process/Activity viewer running as I’m doing it. The only thing that I’m seeing that’s strange is the dbeng9 hangs (in red). And if something happens to the dbsrv9 process servoy will not restart it on startup!
Providence
What version of sybase db/sybase central ect are you using on the mac?
Sybase Central 4.3.0.2258
According to the About Box.