Help 2.2 Can not Insert Records

Hi Guys:

Trying to get things going with my “real” test server.

Installation went fine. I am trying to use Sybase as the data repository and Oracle for my database.

I setup my “solution”, so far just one table a few fields and a calc, to use my “test_oracle” dataprovider. I was able to define the fields OK.

Made a form, but when I try to save a record I get the following error:

com.servoy.j2db.persistence.RepositoryException: couldn’t save oracle blob/clob, lob handler not found: java.lang.ClassNotFoundException: com.servoy.r2.oraclefix.OracleLobHandler couldn’t save oracle blob/clob, lob handler not found: java.lang.ClassNotFoundException: com.servoy.r2.oraclefix.OracleLobHandler

The “oraclefix” file seems to be in the Drivers folder.

I’m trying this from a Mac as well this time, and on the Mac I get a different error

“java.lang.ClassCastException.null”.

Maybe Servoy does not allow/like having the Repositor and databases mixed?

Not sure what to do. Any help is appreciated.

Thanks,
Lee

leesnover:
Hi Guys:

Trying to get things going with my “real” test server.

Installation went fine. I am trying to use Sybase as the data repository and Oracle for my database.

I setup my “solution”, so far just one table a few fields and a calc, to use my “test_oracle” dataprovider. I was able to define the fields OK.

Made a form, but when I try to save a record I get the following error:

com.servoy.j2db.persistence.RepositoryException: couldn’t save oracle blob/clob, lob handler not found: java.lang.ClassNotFoundException: com.servoy.r2.oraclefix.OracleLobHandler couldn’t save oracle blob/clob, lob handler not found: java.lang.ClassNotFoundException: com.servoy.r2.oraclefix.OracleLobHandler

The “oraclefix” file seems to be in the Drivers folder.

I’m trying this from a Mac as well this time, and on the Mac I get a different error

“java.lang.ClassCastException.null”.

Maybe Servoy does not allow/like having the Repositor and databases mixed?

Not sure what to do. Any help is appreciated.

Thanks,
Lee

I should note, I’m using the Oracle 10g “Instant Client” JDBC Classes on both the Server and the Mac Client. Also, I’ve now tried changing the Repository Server to use my Oracle database and got the same error.

My original workstation installation works fine with Oracle, but has the full blown Oracle Client installed. I was trying to get by with the minimal Client Install on the Macs and the real server to keep the overhead down.

Look here: Couldn't save oracle blob/clob, lob handler not found - Classic Servoy - Servoy Community

patrick:
Look here: Couldn't save oracle blob/clob, lob handler not found - Classic Servoy - Servoy Community

Patrick:

This is a “fresh” install of version 2.2 and the blobfix.jar file seems to be installed by default in the drivers folder, so I don’t think that is the issue.

Thanks!
Lee SNover

Just read that post: you have the jar, but it doesn’t work as expected. Download the jar from the link that Johan gave in this thread and put it in your drivers dir (replacing the one that came with a fresh install).

patrick:
Just read that post: you have the jar, but it doesn’t work as expected. Download the jar from the link that Johan gave in this thread and put it in your drivers dir (replacing the one that came with a fresh install).

Patrick:

Thanks, that solved the problem on the PC. I downloaded this during the beta, but thought the “final” version would have the fixed version. Guess not.

I’m still having a problem on my Mac though. Getting

“java.lang.ClassCastException null” when I try to save.

Thanks,
Lee