[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4863) Hibernate - ORA-01024: invalid datatype in OCI call

[Jan Michael (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4863?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=35389#action_35389 ] 

Jan Michael commented on HHH-4863:
----------------------------------

I forgot to say that I also tried different oracle drivers for java 1.4 and 1.3 but it's the result.

> Hibernate - ORA-01024: invalid datatype in OCI call
> ---------------------------------------------------
>
>                 Key: HHH-4863
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4863
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.3.2
>         Environment: Hibernate 3.3.2 GA, Oracle 8.0.5 Enterprise Edition
>            Reporter: Jan Michael
>
> Hi Hibernate,
> I recently tried hibernate in Oracle 9i and use the same in Oracle 8i, however when I tried the same settings I am getting a ORA-01024: invalid datatype in OCI call. 
> Bellow are my hbm settings:
>   <class name="SimpleVO"  table="REGISTRATION">
>      <id name="userId" type="string" column="USER_ID"  />   
> 	 <property name="userName" type="string" column="USER_NAME" />
> 	 <property name="regDate"  type="timestamp" column="REG_DATE" />
>   </class>
> Bellow is my VO class:
> import java.util.Date;
> public class SimpleVO {
> 	private String userId;
> 	private String userName;
> 	private Date regDate;
> 	
> 	public String getUserId() {
> 		return userId;
> 	}
> 	public void setUserId(String userId) {
> 		this.userId = userId;
> 	}
> 	public String getUserName() {
> 		return userName;
> 	}
> 	public void setUserName(String userName) {
> 		this.userName = userName;
> 	}
> 	public Date getRegDate() {
> 		return regDate;
> 	}
> 	public void setRegDate(Date regDate) {
> 		this.regDate = regDate;
> 	}
> }
> Below is my client class:
> manifest = new ManifestVO();
> manifest.setUserId("01ABC");
> manifest.setUserName("test_user");	  				         
> manifest.setRegDate(new Date());
> Session session = HibernateManager.getSession();
> session.save(manifest);
> session.getTransaction().commit();
> HibernateManager.closeSession(session);
> Here is the field Type in My Oracle 8i:
> Name:     Type:
> REG_DATE  DATE
> The following settings works in Oracle 9i but not in Oracle 8i. I tried to set the hbm type to = java.util.Date but I get the same error. I also tried to set the hbm type to string but it inserts an empty string in the database for the date field. Please help as this limits my capability to use hibernate in ORACLE 8 platform.
> Thank you.
> Cordially,
> Jan

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira