# Help 2.2 Can not Insert Records

**URL:** <https://forum.servoy.com/t/help-2-2-can-not-insert-records/4445>\
**Category:** Classic Servoy\
**Created:** [June 29, 2005, 2:51pm UTC](https://forum.servoy.com/t/help-2-2-can-not-insert-records/4445 "2005-06-29T14:51:54Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![bubba](https://avatars.discourse-cdn.com/v4/letter/b/e9a140/32.png) [@bubba](https://forum.servoy.com/u/bubba)\
**Post date:** [June 29, 2005, 2:51pm UTC](https://forum.servoy.com/t/help-2-2-can-not-insert-records/4445/1 "2005-06-29T14:51:54Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![bubba](https://avatars.discourse-cdn.com/v4/letter/b/e9a140/32.png) [@bubba](https://forum.servoy.com/u/bubba)\
**Post date:** [June 29, 2005, 2:57pm UTC](https://forum.servoy.com/t/help-2-2-can-not-insert-records/4445/2 "2005-06-29T14:57:50Z")

</div>

> 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.

---

<div class="post-metadata">

**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\
**Post date:** [June 29, 2005, 3:08pm UTC](https://forum.servoy.com/t/help-2-2-can-not-insert-records/4445/3 "2005-06-29T15:08:20Z")

</div>

Look here: [Couldn't save oracle blob/clob, lob handler not found - Classic Servoy - Servoy Community](http://forum.servoy.com/viewtopic.php?t=4700)

---

<div class="post-metadata">

**Author:** ![bubba](https://avatars.discourse-cdn.com/v4/letter/b/e9a140/32.png) [@bubba](https://forum.servoy.com/u/bubba)\
**Post date:** [June 29, 2005, 3:25pm UTC](https://forum.servoy.com/t/help-2-2-can-not-insert-records/4445/4 "2005-06-29T15:25:33Z")

</div>

> patrick:  
> Look here: [Couldn't save oracle blob/clob, lob handler not found - Classic Servoy - Servoy Community](http://forum.servoy.com/viewtopic.php?t=4700)

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

---

<div class="post-metadata">

**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\
**Post date:** [June 29, 2005, 3:34pm UTC](https://forum.servoy.com/t/help-2-2-can-not-insert-records/4445/5 "2005-06-29T15:34:16Z")

</div>

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).

---

<div class="post-metadata">

**Author:** ![bubba](https://avatars.discourse-cdn.com/v4/letter/b/e9a140/32.png) [@bubba](https://forum.servoy.com/u/bubba)\
**Post date:** [June 29, 2005, 3:43pm UTC](https://forum.servoy.com/t/help-2-2-can-not-insert-records/4445/6 "2005-06-29T15:43:59Z")

</div>

> 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
