October 2010 - hibernate-issues - Jboss List Archives

[Hibernate-JIRA] Created: (HHH-2697) Can't use := for variable assignment within a SQL-Statement

by Benjamin Gniza (JIRA)

Can't use := for variable assignment within a SQL-Statement ----------------------------------------------------------- Key: HHH-2697 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2697 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.4.sp1 Environment: MySQL Datasource, Hibernate 3.2.4.sp1 Reporter: Benjamin Gniza Priority: Minor i found a kind of bug in org.hibernate.engine.query.ParameterParser.java: I have an exotic mysql-statement where I want to use mysql variables. VERY SIMPLE example: SET @pos=0; SELECT @pos:=@pos+1 FROM TABLE; Steps to reproduce: Session s = sessionFactory.openSession(); s.createSQLQuery("SET @pos=0").executeUpdate(); SQLQuery qry = s.createSQLQuery("select @pos:=@pos from SomeTable"); List lst = qry.list(); Exception: org.hibernate.QueryException: Space is not allowed after parameter prefix ':' 'SELECT @pos:=@pos+1 FROM TABLE' at org.hibernate.engine.query.ParameterParser.parse(ParameterParser.java:68) ... ... Suggested fix: ParameterParser Lines 62 to 73: if (c == ':' && (indx + 1 >= stringLength || sqlString.charAt(indx + 1) != '=')) { // named parameter int right = StringHelper.firstIndexOfChar( sqlString, ParserHelper.HQL_SEPARATORS, indx + 1 ); int chopLocation = right < 0 ? sqlString.length() : right; String param = sqlString.substring( indx + 1, chopLocation ); if ( StringHelper.isEmpty( param ) ) { throw new QueryException("Space is not allowed after parameter prefix ':' '" + sqlString + "'"); } recognizer.namedParameter( param, indx ); indx = chopLocation - 1; } -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years

15
22
0 / 0

[Hibernate-JIRA] Created: (HHH-2165) Change logging level in TableMetadata from INFO to DEBUG or TRACE

by Igor A Tarasov (JIRA)

Change logging level in TableMetadata from INFO to DEBUG or TRACE ----------------------------------------------------------------- Key: HHH-2165 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2165 Project: Hibernate3 Type: Improvement Components: metamodel Versions: 3.2.0.ga Reporter: Igor A Tarasov TableMetadata produce too many output to INFO log level. It good thing if it output be at DEBUG level to not hide other impotant information as service start/stop and other. 20.10.06 18:01:58 INFO [main]: SchemaUpdate - updating schema 20.10.06 18:01:58 INFO [main]: TableMetadata - table found: isp.ChageDO 20.10.06 18:01:58 INFO [main]: TableMetadata - columns: [id, _version, chagedate, created, service, sum, restbalance, comment, customer_id] 20.10.06 18:01:58 INFO [main]: TableMetadata - foreign keys: [] 20.10.06 18:01:58 INFO [main]: TableMetadata - indexes: [id, fk8f40c06527214c11, chagedate, primary] 20.10.06 18:01:58 INFO [main]: TableMetadata - table found: isp.CustomerDO 20.10.06 18:01:58 INFO [main]: TableMetadata - columns: [phone, firm, group_id, deleted, fio, id, balance, created, updated, address, email, name, comment] 20.10.06 18:01:58 INFO [main]: TableMetadata - foreign keys: [] 20.10.06 18:01:58 INFO [main]: TableMetadata - indexes: [id, primary, fk1892e50924b4a799, deleted] 20.10.06 18:01:58 INFO [main]: TableMetadata - table found: isp.GroupDO 20.10.06 18:01:58 INFO [main]: TableMetadata - columns: [id, updated, created, name, comment, deleted] 20.10.06 18:01:58 INFO [main]: TableMetadata - foreign keys: [] 20.10.06 18:01:58 INFO [main]: TableMetadata - indexes: [id, primary, deleted] 20.10.06 18:01:58 INFO [main]: TableMetadata - table found: isp.HostDO 20.10.06 18:01:58 INFO [main]: TableMetadata - columns: [tarif_id, server_id, ips, mac, deleted, id, created, updated, name, lastactive, comment, disabled, customer_id] 20.10.06 18:01:58 INFO [main]: TableMetadata - foreign keys: [] 20.10.06 18:01:58 INFO [main]: TableMetadata - indexes: [ips, name, primary, fk812f2053f280a3b1, mac, deleted, fk812f205327214c11, fk812f20537f1e2ff9] 20.10.06 18:01:58 INFO [main]: TableMetadata - table found: isp.HostSessionDO 20.10.06 18:01:58 INFO [main]: TableMetadata - columns: [id, host_id, starttime, chage, speedou, updatetime, speedin, bytesin, stoptime, bytesou, version] 20.10.06 18:01:58 INFO [main]: TableMetadata - foreign keys: [] 20.10.06 18:01:58 INFO [main]: TableMetadata - indexes: [fk9a9074b995d39b51, id, primary] 20.10.06 18:01:58 INFO [main]: TableMetadata - table found: isp.LoginDO 20.10.06 18:01:58 INFO [main]: TableMetadata - columns: [id, nickname, updated, created, name, comment, password, deleted, customer_id, disabled] 20.10.06 18:01:58 INFO [main]: TableMetadata - foreign keys: [] 20.10.06 18:01:58 INFO [main]: TableMetadata - indexes: [id, name, primary, fk77a0599427214c11, deleted] 20.10.06 18:01:58 INFO [main]: TableMetadata - table found: isp.PPPAccountDO 20.10.06 18:01:58 INFO [main]: TableMetadata - columns: [tarif_id, login_id, id, server_id, updated, created, comment, deleted, disabled, ip] 20.10.06 18:01:58 INFO [main]: TableMetadata - foreign keys: [] 20.10.06 18:01:58 INFO [main]: TableMetadata - indexes: [id, fk507abf087f1e2ff9, primary, fk507abf08f280a3b1, fk507abf08820174d9, deleted] 20.10.06 18:01:58 INFO [main]: TableMetadata - table found: isp.PPPSessionDO 20.10.06 18:01:58 INFO [main]: TableMetadata - columns: [callerid, starttime, account_id, updatetime, speedou, chage, speedin, stoptime, bytesou, version, ip, id, ident, bytesin] 20.10.06 18:01:58 INFO [main]: TableMetadata - foreign keys: [] 20.10.06 18:01:58 INFO [main]: TableMetadata - indexes: [id, fke19b413144f3fa61, starttime, ident, updatetime, primary, stoptime] 20.10.06 18:01:58 INFO [main]: TableMetadata - table found: isp.PaymentDO 20.10.06 18:01:58 INFO [main]: TableMetadata - columns: [id, _version, created, nalichka, sum, paydate, comment, newbalance, customer_id] 20.10.06 18:01:58 INFO [main]: TableMetadata - foreign keys: [] 20.10.06 18:01:58 INFO [main]: TableMetadata - indexes: [id, fk7249f0f127214c11, primary, paydate] 20.10.06 18:01:58 INFO [main]: TableMetadata - table found: isp.ServerDO 20.10.06 18:01:58 INFO [main]: TableMetadata - columns: [id, updated, created, name, comment, deleted, ip] 20.10.06 18:01:58 INFO [main]: TableMetadata - foreign keys: [] 20.10.06 18:01:58 INFO [main]: TableMetadata - indexes: [id, name, primary, deleted, ip] 20.10.06 18:01:58 INFO [main]: TableMetadata - table found: isp.TarifDO 20.10.06 18:01:58 INFO [main]: TableMetadata - columns: [costsizein, resetprepaidsize, prepaidsizerest, moncost, resetprepaidusages, costusage, resetprepaidtime, deleted, prepaidtimemonthly, costtime, prepaidsizemonthly, id, prepaidusagesrest, monthenddate, costsizeou, created, updated, name, prepaidtimerest, prepaidusagesmonthly, comment, customer_id] 20.10.06 18:01:58 INFO [main]: TableMetadata - foreign keys: [] 20.10.06 18:01:58 INFO [main]: TableMetadata - indexes: [id, primary, fk7893f6d27214c11, deleted] 20.10.06 18:01:58 INFO [main]: SchemaUpdate - schema update complete -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years

2
1
0 / 0

[Hibernate-JIRA] Created: (HHH-3835) ORA-00932 when executing a HQL with "distinct" on an entity with a Blob

by Martin Zeltner (JIRA)

ORA-00932 when executing a HQL with "distinct" on an entity with a Blob ----------------------------------------------------------------------- Key: HHH-3835 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3835 Project: Hibernate Core Issue Type: Bug Components: query-hql Affects Versions: 3.2.6 Environment: Oracle 10 Reporter: Martin Zeltner Hi I get an Oracle exception "ORA-00932: inconsistent datatypes: expected - got BLOB" when I execute a HQL on an entity that has a blob and the HQL contains the "distinct". When I remove the "distinct" then it works. HQL: "select distinct ci from CircuitInstruction ci ..." Entity "CircuitInstruction" has the following property: /** * @return Returns the CI PDF. */ @Lob @Basic(fetch = FetchType.LAZY) public Blob getCiPdf() { return m_ciPdf; } Cheers Martin -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years

2
1
0 / 0

[Hibernate-JIRA] Created: (ANN-677) Blob is null with Postgresql

by Aaron Luchko (JIRA)

Blob is null with Postgresql ---------------------------- Key: ANN-677 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-677 Project: Hibernate Annotations Issue Type: Bug Affects Versions: 3.2.1 Environment: hibernate-3.2.1, hibernate-annotations-3.2.1, postgresql-8.2.5-1.fc7, postgresql-jdbc-8.2.504-1jpp.fc7 and postgresql-8.2-506.jdbc4.jar Reporter: Aaron Luchko Attachments: hibPostgresbug.zip I've found that after a sequence of queries, starting new transactions and clearing the session, a Blob will not be successfully from the database and null will be returned by the InputStream instead. Using the debugger I've followed this into the jdbc code and from what I can tell some message is sent to load the blob but the database replies with an empty set of data which naturally causes the InputStream to read null. I've attached a test case (sorry, no makefile or pom.xml, I just ran it using eclipse) which, for me, replicates the bug. Note I've also used hsqldb and mysql and didn't see the bug with them, only postgresql. thanks, Aaron -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years

4
4
0 / 0

[Hibernate-JIRA] Created: (JPA-8) JPA Blob feature severely lacking! It does not support java.sql.Blob interface! Any fix in Hibernate JPA?

by Colbert Philippe (JIRA)

JPA Blob feature severely lacking! It does not support java.sql.Blob interface! Any fix in Hibernate JPA? ------------------------------------------------------------------------------------------------------------ Key: JPA-8 URL: http://opensource.atlassian.com/projects/hibernate/browse/JPA-8 Project: Java Persistence API Issue Type: Improvement Reporter: Colbert Philippe My issue has to do with the Blob feature under JPA. The JPA standard documentation says that : (I quote) "The Java types mappled to BLOB columns are byte[], Byte[], Serializable type, while char[], Character[] and String are mapped to CLOB". There is an important function missing in this statement. This feature is given by JDBC and made available in Hibernate Persistence. Why is it missing in JPA? The way JPA is implemented all BLOB objects are either not-loaded into memory or completely loaded into memory. What happens when an application only wants to work with only part of the BLOB object, not the entire BLOB object? THE MISSING FEATURE: JDBC and Hibernate, allow for declaration of fields of type java.sql.Blob (interface). This interface has special functionality that allows an application to load only part of a BLOB object (not the entire Blob object, which can be very big) . Similarly, the Blob interface allows an application to write to only part of BLOB object (not the entire BLOB object). These two important functions are lost in JPA! That's a severe drawback! My question is: Is there a way of going around the JPA standard and allow support for java.sql.Blob columns? Colbert -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years

3
5
0 / 0

[Hibernate-JIRA] Created: (HHH-4635) Oracle ORA-24816 inserting and updating data for entities containg LOB attributes

by Clay Atkins (JIRA)

Oracle ORA-24816 inserting and updating data for entities containg LOB attributes --------------------------------------------------------------------------------- Key: HHH-4635 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4635 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.3.1 Reporter: Clay Atkins Priority: Critical Inserting or updating an entity with LOB results in the following error from oracle: {noformat} Caused by: java.sql.SQLException: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column {noformat} Fairly confident that the ordering of the LOB attributes is not putting them at the end of the insert or the update. Oracle requires all LOB columns to be the last in the statement. -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years

9
23
0 / 0

[Hibernate-JIRA] Created: (HBX-978) unique=true attribute of primary key in generated class prevents the schema to be regenerated

by Ali Sadik Kumlali (JIRA)

unique=true attribute of primary key in generated class prevents the schema to be regenerated --------------------------------------------------------------------------------------------- Key: HBX-978 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-978 Project: Hibernate Tools Issue Type: Bug Environment: OS: Windows Vista 6.0,x86 Database: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production Java VM: Java HotSpot(TM) Server VM 1.5.0_11-b03,Sun Microsystems Inc. Eclipse Europa: Version: 3.3.0 Build id: I20070621-1340 HibernateTools-3.2.0.beta10 Reporter: Ali Sadik Kumlali Priority: Minor Hi, When I reverse engineer against Oracle, unique=true attribute is added to @Column annotation of primary key column. But, when I generate schema from these generated files, Oracle throws "ORA-02261: such unique or primary key already exists in the table" error. I first ran into this situation while trying Seam and posted the problem to Seam's forum: http://www.jboss.com/index.html?module=bb&op=viewtopic&t=116478. After I got the response, decided to try it without Seam. Then, downloaded the latest HibernateTools & Eclipse Europa and reverse engineered the schema. I saw that generated classes have unique=true attribute which clearly showed that the problem was related with HibernateTools, not with Seam. Here is the DDL of the table against which I made my test: CREATE TABLE PEOPLE ("ID" NUMBER NOT NULL, "SURNAME" VARCHAR2(50 BYTE), "NAME" VARCHAR2(25 BYTE), CONSTRAINT "PEOPLE_PK" PRIMARY KEY ("ID")); Regards, Ali Sadik Kumlali -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years

8
11
0 / 0

[Hibernate-JIRA] Created: (HHH-3135) SQL Server Dialect maps BIGINT to NUMERIC(19,0)

by Dominik Enkelmann (JIRA)

SQL Server Dialect maps BIGINT to NUMERIC(19,0) ----------------------------------------------- Key: HHH-3135 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3135 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.5 Environment: MS SQL Server Reporter: Dominik Enkelmann Priority: Trivial The SQLServerDialect.java maps the Hibernate BIGINT type to a NUMERIC(19,0) colum. The result is, that all Long fields in persisten classes map to hibernate-bigints which generate numeric(19,0) database column. Longs are typically used for surrogate primary keys and should be implemented as native SQL BIGINTs where possible. SQL Server supports SQL BIGINT since version 2000. There is a similar issue with the SQL BIT type that should be implemented as a native BIT column in SQL Server. A possible solution could be a pre-.SQL Server 2000 dialect and an updated SQL Server dialect. I filed a more detailed description with workaround in the user forum http://forum.hibernate.org/viewtopic.php?p=2377674#2377674 -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

2
2
0 / 0

[Hibernate-JIRA] Created: (HHH-2942) Improve support for PostgreSQL

by Diego Pires Plentz (JIRA)

Improve support for PostgreSQL ------------------------------ Key: HHH-2942 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2942 Project: Hibernate3 Issue Type: Improvement Components: metamodel Reporter: Diego Pires Plentz Assignee: Diego Pires Plentz Priority: Minor Improve support for features in PostgreSQL 7.x and 8.x. I will probably create a new one for 8.x series. I asked for help of postgresql hackers. http://archives.postgresql.org/pgsql-hackers/2007-11/threads.php#00462 Docs index: http://www.postgresql.org/docs/ -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

4
5
0 / 0

[Hibernate-JIRA] Created: (HHH-5585) SubDialect of PostgreSQLDialect to support (@Lob + byte[]) combination

by Justin Sands (JIRA)

SubDialect of PostgreSQLDialect to support (@Lob + byte[]) combination ---------------------------------------------------------------------- Key: HHH-5585 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5585 Project: Hibernate Core Issue Type: Patch Environment: 3.6.0.CR1, postgresql Reporter: Justin Sands Attachments: CustomPostgreSQLDialect.zip >From hibernate 3.5 to 3.6 the annotation combination @Lob + byte[] does not on postgresql work due to idiosyncrasies in the postgresql JDBC driver. To support this combination, the following dialect variant can be used along with a basic-type override, provided that the application consistently uses the same annotation style (@Lob + byte[]). A similar approach could be used to support using the OID blob type which postgresql provides, although this patch does not address it. The user must register the basic type override MateralizedVarBinaryBlobType at boot time. I am unsure exactly where in the distribution this would fit so I have kept it in one package (org.hibernate.dialect.variant). I have test cases which I could detach from my current project, if the maintainers think this patch is worth including. -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 1 month

3
4
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues October 2010