Oracle Sql Error 932 Sqlstate 42000
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies ora-00932: inconsistent datatypes: expected - got clob of this site About Us Learn more about Stack Overflow the company Business ora-00932: inconsistent datatypes: expected number got binary Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask sql error 1064 sqlstate 42000 hibernate Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign sql error 932 sqlstate 42000 hibernate up Grails 1.3.7 GORM integration to Oracle 10g DB reults in “SQL Error: 932, SQLState: 42000” for domain class attribute mapping to Orable CLOB type up vote 1 down vote favorite I get exactly the problem described in: http://www.bedework.org/trac/bedework/ticket/58 The issue occurrs when a service class invokes save() on a doamin class which has an attribute ("String contentText") setup to be persisted
Ora-00932: Inconsistent Datatypes: Expected Timestamp Got Binary
as a CLOB datatype in the Oracle 10g database (CLOB is chosen since I want to store texts longer than 4000 characters, Varchar2 don't support 4000+ chars). (The text content I'm trying to store is HTML code) My question is: How do I store text content (like HTML code) in a CLOB typed field in a Oracle 10g DB using GORM in Grails 1.3.7? Thanks a lot for helping me out! /Herman Excerpt from the log: 2011-12-14 15:06:53,564 DEBUG JDBCExceptionReporter:92 - could not execute query [select this_.id as id4_0_, this_.version as version4_0_, this_.activation_price as activation3_4_0_, this_.active as active4_0_, this_.content_text as content5_4_0_, this_.country_code as country6_4_0_, this_.customer_type as customer7_4_0_, this_.danish_db_id as danish8_4_0_, this_.data_cap_type as data9_4_0_, this_.expiry_date as expiry10_4_0_, this_.group_name as group11_4_0_, this_.is_minimum_commitment as is12_4_0_, this_.is_pott as is13_4_0_, this_.launch_date as launch14_4_0_, this_.main_image as main15_4_0_, this_.monthly_price as monthly16_4_0_, this_.name as name4_0_, this_.pdf as pdf4_0_, this_.product_id as product19_4_0_, this_.time_of_notice as time20_4_0_, this_.type as type4_0_, this_.usp1 as usp22_4_0_, this_.usp2 as usp23_4_0_, this_.usp3 as usp24_4_0_, this_.version_comment as version25_4_0_ from price_plan this_ where (this_.activation_price=? and this_.active=? and this_.content_text=? and lower(this_.country_code)=? and lower(this_.customer_type)=? and this_.danish_db_id=? and lower(this_.expiry_date)=? and lower(this_.group_name)=? and this_.is_minimum_commitment=? and this_.is_pott=? and lower(this_.lau
not work correctly without it enabled. Please turn JavaScript back on and reload this page. All Places > Hibernate > Hibernate Envers > Discussions Please enter a title. You can not post a
Ora-00904
blank message. Please type your message and try again. 2 Replies ora-01031 Latest reply on Aug 6, 2009 11:55 AM by Suchong Sit Oracle 932 Error with ora-01722 invalid number AuditQuery.forRevisionsOfEntity Stephan Oudmaijer Jul 29, 2009 10:23 AM Hi there,I have a problem on Oracle 10g with the AuditQuery.forRevisionsOfEntity();If I set the param selectDeletedEntities to false, http://stackoverflow.com/questions/8506639/grails-1-3-7-gorm-integration-to-oracle-10g-db-reults-in-sql-error-932-sqlsta then an error on Oracle occurs.AuditQuery query = reader.createQuery().forRevisionsOfEntity(Contract.class, true, false);I get the following error: Hibernate: select contract_a0_.ID as ID11_, contract_a0_.REV as REV11_, contract_a0_.REVTYPE as REVTYPE11_, contract_a0_.AANTAL_PLAATSEN as AANTAL4_11_, contract_a0_.MUTATIE_STATUS as MUTATIE5_11_, contract_a0_.OVERDRACHT_CPT_BEHEER as OVERDRACHT6_11_, contract_a0_.DATUM_AANVANG as DATUM7_11_, contract_a0_.DATUM_EINDE as DATUM8_11_, contract_a0_.SOORT as SOORT11_ from CPT_CONTRACTEN_AUD contract_a0_ where (contract_a0_.REVTYPE<>? ) order https://developer.jboss.org/thread/1903 by contract_a0_.REV asc [WARN] org.hibernate.util.JDBCExceptionReporter - [SQL Error: 932, SQLState: 42000] [ERROR] org.hibernate.util.JDBCExceptionReporter - [ORA-00932: inconsistent datatypes: expected NUMBER got BINARY It has something to do with the param: contract_a0_.REVTYPE<>? My configuration: [INFO] org.hibernate.cfg.annotations.Version - [Hibernate Annotations 3.4.0.GA][INFO] org.hibernate.cfg.Environment - [Hibernate 3.3.2.GA][INFO] org.hibernate.cfg.Environment - [hibernate.properties not found][INFO] org.hibernate.cfg.Environment - [Bytecode provider name : javassist][INFO] org.hibernate.cfg.Environment - [using JDK 1.4 java.sql.Timestamp handling][INFO] org.hibernate.annotations.common.Version - [Hibernate Commons Annotations 3.1.0.GA][INFO] org.hibernate.ejb.Version - [Hibernate EntityManager 3.4.0.GA][INFO] org.hibernate.cfg.SettingsFactory - [RDBMS: Oracle, version: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - ProductionWith the Partitioning, OLAP and Data Mining options][INFO] org.hibernate.cfg.SettingsFactory - [JDBC driver: Oracle JDBC driver, version: 10.2.0.1.0]I am using Envers 1.2.1.GA 4987Views Tags: none (add) This content has been marked as final. Show 2 replies 1. Re: Oracle 932 Error with AuditQuery.forRevisionsOfEntity Adam Warski Jul 30, 2009 1:03 PM (in response to Stephan Oudmaijer) No idea, sorry. I don't have an Oracle DB to test ;)Adam Like Sh
Sign in Pricing Blog Support Search GitHub https://github.com/BroadleafCommerce/BroadleafCommerce/issues/686 This repository Watch 218 Star 821 Fork 788 http://docs.oracle.com/cd/B10501_01/server.920/a96525/e900.htm BroadleafCommerce/BroadleafCommerce Code Issues 132 Pull requests 5 Projects 0 Wiki Pulse Graphs New issue Use of select DISTINCT sql can cause an exception in Oracle when a CLOB field is in play #686 Closed sql error jefffischer opened this Issue Feb 7, 2014 · 0 comments Projects None yet Labels difficulty-medium module-core severity-major type-bug Milestone 3.1.0-GA Assignees jefffischer 1 participant Broadleaf Commerce member jefffischer commented Feb 7, 2014 Oracle will return this exception: [ WARN] ora-00932: inconsistent datatypes: 09:42:57 SqlExceptionHelper - SQL Error: 932, SQLState: 42000 [ERROR] 09:42:57 SqlExceptionHelper - ORA-00932: inconsistent datatypes: expected - got CLOB jefffischer self-assigned this Feb 7, 2014 jefffischer added difficulty-medium module-core severity-major type-bug labels Feb 7, 2014 jefffischer added a commit that referenced this issue Feb 7, 2014 jefffischer #686 … …ieving products d395928 jefffischer closed this Feb 7, 2014 jefffischer added a commit that referenced this issue Feb 7, 2014 jefffischer