Unexpected DBServer error

Classic Servoy
1

I’m re-installing Servoy from scratch on my Mac. Ran the uninstaller and deleted the old Servoy directory. Downloaded servoy_installer.jar from Servoy’s Developer site. Ran it. Brings up CRM properly.

Now I attemped to create the same database server setup as is current on my Windows machine. I modified the sybase.config file to the same setting and brought over the database and log files from Windows. Next I went into Servoy Preferences to create the new database. Got this error:

JDBC Driver ‘com.sybase.jdbcx.SybDriver’ not found in classpath or drivers directory : java.lang.InstantiationException: com.sybase.jdbcx.SybDriver com.sybase.jdbcx.SybDriver

Thinking it might matter that the DBServer should be setup before modifying sybase.config and bringing in the databases I retraced my steps and did it that way. Got this error:

java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

What’s going on here?

2

Hi Morley,

JDBC Driver ‘com.sybase.jdbcx.SybDriver’ not found in classpath or drivers directory : java.lang.InstantiationException: com.sybase.jdbcx.SybDriver com.sybase.jdbcx.SybDriver

Seems you have a typo in the Driver field.
It should be ‘com.sybase.jdbc2.jdbc.SybDriver’.

3

ROCLASI:
JDBC Driver ‘com.sybase.jdbcx.SybDriver’ not found in classpath or drivers directory : java.lang.InstantiationException: com.sybase.jdbcx.SybDriver com.sybase.jdbcx.SybDriver

Seems you have a typo in the Driver field.
It should be ‘com.sybase.jdbc2.jdbc.SybDriver’.

Very, very strange. I have 21 Java files on this Mac with com.sybase.jdbcx included in the text. And a similar number with com.sybase.jdbc2, some with the same file name but most not.

How do I rectify this? What files to yank or revise? All I did was use the Servoy installer.

4

Don’t yank anything, just change the driver setting in Servoy’s Preferences.

5

ROCLASI:
Don’t yank anything, just change the driver setting in Servoy’s Preferences.

Nothing wrong with Servoy’s Preferences. See attachment.

As noted earlier the driver error message was on the first go round, the error message showing in the attachment has turned up every time since.

This flailing around in the dark is so frustrating. :!:

DBServerFailure.gif
DBServerFailure.gif832×405 35.5 KB

6

Hi Morley

Could it be that your Mac & Windows computers are running different versions of Sybase?

Try creating a new DB on the Mac then, after establishing the Connection, import your solution with data.

Graham Greensall
Worxinfo Ltd

7

grahamg:
Could it be that your Mac & Windows computers are running different versions of Sybase?

Try creating a new DB on the Mac then, after establishing the Connection, import your solution with data.

Haven’t gotten that far. Right after a virgin install and launching the CRM demo I tried to create a new database. That’s when the errors began. This virgin install won’t let me create a new Database Server.

Here’s what Servoy is telling me on both machines.

The Mac
Servoy Developer
Version R2 2.2.3-build 335
Java version 1.4.2-54 (Mac OS X)

The Windows machine
Servoy Developer
Version R2 2.2.3-build 335
Java version 1.5.0_06-b05 (Windows XP)

Noting the differences in Java versions I checked out the Java installation on the Mac.

System/Library/Frameworks/JavaVM.framework/Versions has the following:

*1.3
1.3.1
*1.4
1.4.2
*1.5
1.5.0
A
*Current
*CurrentJDK

*Asterisks indicating aliases.

Just to be sure this Mac is up to date I downloaded from Apple and installed J2SE50Release3.dmg. No difference. Servoy Developer continues to launch under Java 1.4.2-54.

Something is conflicting with something but I have no idea what.