[Hibernate-JIRA] Commented: (HHH-1813) 2nd level cached collections are locked causing a cache miss
by Assaf Berg (JIRA)
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1813?page=c... ]
Assaf Berg commented on HHH-1813:
---------------------------------
I think "freshTimestamp < txTimestamp" makes sense. A transaction can only see stuff put in the cache before it was started.
> 2nd level cached collections are locked causing a cache miss
> ------------------------------------------------------------
>
> Key: HHH-1813
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1813
> Project: Hibernate3
> Type: Bug
> Versions: 3.1
> Environment: Hibernate 3.1, Oracle 10g, Linux
> Reporter: Assaf Berg
> Priority: Critical
> Attachments: testcase.tar.gz
>
>
> Using the second level cache, collections are fetched from the database due to the cached item being locked.
> This happens in the most simple use case:
> 1. Insert an entity with a collection
> 2. Commit.
> 3. Fetch the entity
> I've written a simple test case and see the following in the log file:
> 11:52:47,159 DEBUG [ReadWriteCache] Invalidating: domain.Cat.kittens#539957
> 11:52:47,177 DEBUG [ReadWriteCache] Inserting: domain.Cat#539957
> 11:52:47,179 DEBUG [ReadWriteCache] Inserted: domain.Cat#539957
> 11:52:47,180 DEBUG [ReadWriteCache] Inserting: domain.Kitten#540214
> 11:52:47,180 DEBUG [ReadWriteCache] Inserted: domain.Kitten#540214
> 11:52:47,181 DEBUG [ReadWriteCache] Releasing: domain.Cat.kittens#539957
> 11:52:49,221 DEBUG [ReadWriteCache] Caching: domain.Cat#539957
> 11:52:49,221 DEBUG [ReadWriteCache] Item was already cached: domain.Cat#539957
> 11:52:49,223 DEBUG [ReadWriteCache] Cache lookup: domain.Cat.kittens#539957
> 11:52:49,223 DEBUG [ReadWriteCache] Cached item was locked: domain.Cat.kittens#539957
> 11:52:49,229 DEBUG [ReadWriteCache] Caching: domain.Kitten#540214
> 11:52:49,229 DEBUG [ReadWriteCache] Item was already cached: domain.Kitten#540214
> 11:52:49,230 DEBUG [ReadWriteCache] Caching: domain.Cat.kittens#539957
> 11:52:49,231 DEBUG [ReadWriteCache] Cached: domain.Cat.kittens#539957
> domain.Cat.kittens [C/H/M/P]: 1/0/1/1
> domain.Cat [C/H/M/P]: 1/0/0/1
> domain.Kitten [C/H/M/P]: 1/0/0/1
> This happens whether the collection is mapped as inverse or not.
> I've attached the test case source and hbms (although it might need to be tweaked for the proper DB before running, and I didn't include the dependencies JARs).
> Here's a code excerpt of the interesting part (tx is TransactionTemplate using HibnerateTransactionManager and hibernate is HibernateTemplate from the spring framework):
> tx.execute(new TransactionCallback() {
> public Object doInTransaction(TransactionStatus status) {
> // create a Cat with one Kitten
> Cat cat = new Cat();
> Kitten kitten = new Kitten();
> cat.addKitten(kitten);
>
> hibernate.save(cat);
>
> return null;
> }
> });
>
> Thread.sleep(2000L);
>
> tx.execute(new TransactionCallback() {
> public Object doInTransaction(TransactionStatus status) {
> // load all cats
> List<Cat> allCats = hibernate.loadAll(Cat.class);
> return null;
> }
> });
> I can supply further information if needed.
--
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
17 years, 7 months
[Hibernate-JIRA] Commented: (HHH-468) MysqlDialect incorrectly maps java.lang.Boolean to SQL BIT
by Scott Marlow (JIRA)
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-468?page=co... ]
Scott Marlow commented on HHH-468:
----------------------------------
Added MySQL5InnoDBDialect to resolve HHH-1891, so we could probably address HHH-468 with the new dialect.
> MysqlDialect incorrectly maps java.lang.Boolean to SQL BIT
> ----------------------------------------------------------
>
> Key: HHH-468
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-468
> Project: Hibernate3
> Type: Bug
> Versions: 3.0.3
> Environment: Hibernate 3.0, MySQL.
> Reporter: Mark Matthews
> Assignee: Scott Marlow
>
>
> I didn't track down how java.lang.Boolean gets mapped to Types.BIT in hibernate, but you probably _don't_ want to map to "bit" like you do in MysqlDialect.
> "bit", according to SQL99 (it's not in the core standard, and the type was actually dropped for sql2k3) is a bitfield, not a boolean value. You can of course define a bit(1), but it is technically more correct for java.lang.Boolean to map to a SQL BOOLEAN for MySQL since we support a BOOLEAN and a BIT.
> It looks like the JDBC-3.0 guys ignored what the standard said, because in reality you'd want BIT to map to something like byte[], or java.util.BitSet if you were tracking how the SQL standard defines BIT.
> I'm guessing you probably want to map to "boolean", which the JDBC driver will automagically convert for you, as it silently maps to TINYINT(1) on the server side.
--
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
17 years, 7 months
[Hibernate-JIRA] Resolved: (HHH-1891) Since rc3 deprecation Warning: The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 5.2.
by Scott Marlow (JIRA)
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1891?page=all ]
Scott Marlow resolved HHH-1891:
-------------------------------
Resolution: Fixed
added dialect for MySQL 5 InnoDB that uses the new syntax.
> Since rc3 deprecation Warning: The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 5.2.
> ---------------------------------------------------------------------------------------------------------------
>
> Key: HHH-1891
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1891
> Project: Hibernate3
> Type: Bug
> Versions: 3.2.0.cr3
> Environment: I use MySQL 5.1.11-bata on Windows XP.
> mysql-connector-java-3.1.13-bin.jar
> My settings:
> hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect
> hibernate.connection.driver_class com.mysql.jdbc.Driver
> Reporter: Stefan Bühlmann
> Assignee: Scott Marlow
> Priority: Minor
> Fix For: 3.2.0.ga
> Attachments: MySQL5InnoDBDialect.patch
>
>
> Since cr3 I get the following warning (cr2 goes without it):
> 09.07.2006 11:10:11 org.hibernate.tool.hbm2ddl.SchemaExport execute
> INFO: exporting generated schema to database
> 09.07.2006 11:10:14 org.hibernate.util.JDBCExceptionReporter logWarnings
> WARNUNG: SQL Warning: 1541, SQLState: HY000
> 09.07.2006 11:10:14 org.hibernate.util.JDBCExceptionReporter logWarnings
> WARNUNG: The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 5.2. Please use 'ENGINE=storage_engine' instead.
> 09.07.2006 11:10:14 org.hibernate.util.JDBCExceptionReporter logWarnings
> WARNUNG: SQL Warning: 1541, SQLState: HY000
--
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
17 years, 7 months
[Hibernate-JIRA] Assigned: (HHH-468) MysqlDialect incorrectly maps java.lang.Boolean to SQL BIT
by Scott Marlow (JIRA)
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-468?page=all ]
Scott Marlow reassigned HHH-468:
--------------------------------
Assign To: Scott Marlow
> MysqlDialect incorrectly maps java.lang.Boolean to SQL BIT
> ----------------------------------------------------------
>
> Key: HHH-468
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-468
> Project: Hibernate3
> Type: Bug
> Versions: 3.0.3
> Environment: Hibernate 3.0, MySQL.
> Reporter: Mark Matthews
> Assignee: Scott Marlow
>
>
> I didn't track down how java.lang.Boolean gets mapped to Types.BIT in hibernate, but you probably _don't_ want to map to "bit" like you do in MysqlDialect.
> "bit", according to SQL99 (it's not in the core standard, and the type was actually dropped for sql2k3) is a bitfield, not a boolean value. You can of course define a bit(1), but it is technically more correct for java.lang.Boolean to map to a SQL BOOLEAN for MySQL since we support a BOOLEAN and a BIT.
> It looks like the JDBC-3.0 guys ignored what the standard said, because in reality you'd want BIT to map to something like byte[], or java.util.BitSet if you were tracking how the SQL standard defines BIT.
> I'm guessing you probably want to map to "boolean", which the JDBC driver will automagically convert for you, as it silently maps to TINYINT(1) on the server side.
--
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
17 years, 7 months
[Hibernate-JIRA] Commented: (HHH-1258) startup time improvements
by Max Rydahl Andersen (JIRA)
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1258?page=c... ]
Max Rydahl Andersen commented on HHH-1258:
------------------------------------------
The implementation should not affect the sessionfactory normal runtime behavior and i'm not sure hbm-dyn-mod apporach is ok for this.
> startup time improvements
> -------------------------
>
> Key: HHH-1258
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1258
> Project: Hibernate3
> Type: Improvement
> Components: core
> Versions: 3.1 rc3
> Reporter: Max Rydahl Andersen
> Assignee: Max Rydahl Andersen
>
>
> while doing some basic startup perf testing the following were found - this issue is mainly to track what I find, and then fix it:
> Initial tests where 100 classes, 30 sec for buildSessionFactory
> setting hibernate.cglib.use_reflection_optimizer false and it is 10 sec for buildSessionFactory.
> (maybe we should autodetect which jdk we are running on and disable it per default for 1.4/1.5 - needs to validate runtime impact)
> Another (22%) time stealer is the discovery of getter/setters - in worst case it iterates over all declared methods per property.
> (alternatively we could cache/sort this list or make a more efficient implementation if a class only contain default property accessors)
> Other 20% of the time is done in net.sf.cglib related classes for build time enhancement.
> The rest of the time is Configuration creation (can be cached) and other iteration code.
> (p.s. don't take the % numbers as hard values - these are definitly affected by how many methods/classes you have; this underlying tests
> is done on pojos with a "high" method count (approx 100)
--
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
17 years, 7 months
[Hibernate-JIRA] Updated: (HHH-1891) Since rc3 deprecation Warning: The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 5.2.
by Scott Marlow (JIRA)
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1891?page=all ]
Scott Marlow updated HHH-1891:
------------------------------
Attachment: MySQL5InnoDBDialect.patch
You can try this patch if you like, I haven't tested yet (I will before checkin).
> Since rc3 deprecation Warning: The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 5.2.
> ---------------------------------------------------------------------------------------------------------------
>
> Key: HHH-1891
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1891
> Project: Hibernate3
> Type: Bug
> Versions: 3.2.0.cr3
> Environment: I use MySQL 5.1.11-bata on Windows XP.
> mysql-connector-java-3.1.13-bin.jar
> My settings:
> hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect
> hibernate.connection.driver_class com.mysql.jdbc.Driver
> Reporter: Stefan Bühlmann
> Assignee: Scott Marlow
> Priority: Minor
> Fix For: 3.2.0.ga
> Attachments: MySQL5InnoDBDialect.patch
>
>
> Since cr3 I get the following warning (cr2 goes without it):
> 09.07.2006 11:10:11 org.hibernate.tool.hbm2ddl.SchemaExport execute
> INFO: exporting generated schema to database
> 09.07.2006 11:10:14 org.hibernate.util.JDBCExceptionReporter logWarnings
> WARNUNG: SQL Warning: 1541, SQLState: HY000
> 09.07.2006 11:10:14 org.hibernate.util.JDBCExceptionReporter logWarnings
> WARNUNG: The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 5.2. Please use 'ENGINE=storage_engine' instead.
> 09.07.2006 11:10:14 org.hibernate.util.JDBCExceptionReporter logWarnings
> WARNUNG: SQL Warning: 1541, SQLState: HY000
--
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
17 years, 7 months
[Hibernate-JIRA] Updated: (HHH-1891) Since rc3 deprecation Warning: The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 5.2.
by Scott Marlow (JIRA)
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1891?page=all ]
Scott Marlow updated HHH-1891:
------------------------------
Fix Version: 3.2.0.ga
Looks like we need a MySQL5InnoDBDialect, I'll add that using "ENGINE=InnoDB".
> Since rc3 deprecation Warning: The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 5.2.
> ---------------------------------------------------------------------------------------------------------------
>
> Key: HHH-1891
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1891
> Project: Hibernate3
> Type: Bug
> Versions: 3.2.0.cr3
> Environment: I use MySQL 5.1.11-bata on Windows XP.
> mysql-connector-java-3.1.13-bin.jar
> My settings:
> hibernate.dialect org.hibernate.dialect.MySQLInnoDBDialect
> hibernate.connection.driver_class com.mysql.jdbc.Driver
> Reporter: Stefan Bühlmann
> Assignee: Scott Marlow
> Priority: Minor
> Fix For: 3.2.0.ga
>
>
> Since cr3 I get the following warning (cr2 goes without it):
> 09.07.2006 11:10:11 org.hibernate.tool.hbm2ddl.SchemaExport execute
> INFO: exporting generated schema to database
> 09.07.2006 11:10:14 org.hibernate.util.JDBCExceptionReporter logWarnings
> WARNUNG: SQL Warning: 1541, SQLState: HY000
> 09.07.2006 11:10:14 org.hibernate.util.JDBCExceptionReporter logWarnings
> WARNUNG: The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 5.2. Please use 'ENGINE=storage_engine' instead.
> 09.07.2006 11:10:14 org.hibernate.util.JDBCExceptionReporter logWarnings
> WARNUNG: SQL Warning: 1541, SQLState: HY000
--
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
17 years, 7 months
[Hibernate-JIRA] Commented: (HHH-1258) startup time improvements
by Tyler Van Gorder (JIRA)
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1258?page=c... ]
Tyler Van Gorder commented on HHH-1258:
---------------------------------------
Having the Configuration object around is not as big a concern for us in the development environment. Most of our machines have 2G of memory. And this is an option that would ONLY be used in a development scenero.
So If I am hearing you correctly, the module would need to be made thread-safe and could be ported to the 3.x code base (assuming we are not concerned with keeping the Configuration object hanging out.)?
Perhaps if I have more time in the coming months I might try doing this properly. Max, if you have time I sure would appreciate to pick your brain about which entry points into the session factory implementation would require hooks to dynamically load the configuration.
Thanks.
> startup time improvements
> -------------------------
>
> Key: HHH-1258
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1258
> Project: Hibernate3
> Type: Improvement
> Components: core
> Versions: 3.1 rc3
> Reporter: Max Rydahl Andersen
> Assignee: Max Rydahl Andersen
>
>
> while doing some basic startup perf testing the following were found - this issue is mainly to track what I find, and then fix it:
> Initial tests where 100 classes, 30 sec for buildSessionFactory
> setting hibernate.cglib.use_reflection_optimizer false and it is 10 sec for buildSessionFactory.
> (maybe we should autodetect which jdk we are running on and disable it per default for 1.4/1.5 - needs to validate runtime impact)
> Another (22%) time stealer is the discovery of getter/setters - in worst case it iterates over all declared methods per property.
> (alternatively we could cache/sort this list or make a more efficient implementation if a class only contain default property accessors)
> Other 20% of the time is done in net.sf.cglib related classes for build time enhancement.
> The rest of the time is Configuration creation (can be cached) and other iteration code.
> (p.s. don't take the % numbers as hard values - these are definitly affected by how many methods/classes you have; this underlying tests
> is done on pojos with a "high" method count (approx 100)
--
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
17 years, 7 months
[Hibernate-JIRA] Commented: (HHH-1258) startup time improvements
by Max Rydahl Andersen (JIRA)
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1258?page=c... ]
Max Rydahl Andersen commented on HHH-1258:
------------------------------------------
hbn-dyn-mode implementation is not thread safe and it requires to keep the Configuration object around....bad.
I'm surprised serialization of hbm.xml does not help you - it doesn't make sense if it does not.
surprised that one xml file makes so big a diff.....but good to hear 3.2 tunings have helped (probably because of reflection optimizer is now disabled by default)
> startup time improvements
> -------------------------
>
> Key: HHH-1258
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1258
> Project: Hibernate3
> Type: Improvement
> Components: core
> Versions: 3.1 rc3
> Reporter: Max Rydahl Andersen
> Assignee: Max Rydahl Andersen
>
>
> while doing some basic startup perf testing the following were found - this issue is mainly to track what I find, and then fix it:
> Initial tests where 100 classes, 30 sec for buildSessionFactory
> setting hibernate.cglib.use_reflection_optimizer false and it is 10 sec for buildSessionFactory.
> (maybe we should autodetect which jdk we are running on and disable it per default for 1.4/1.5 - needs to validate runtime impact)
> Another (22%) time stealer is the discovery of getter/setters - in worst case it iterates over all declared methods per property.
> (alternatively we could cache/sort this list or make a more efficient implementation if a class only contain default property accessors)
> Other 20% of the time is done in net.sf.cglib related classes for build time enhancement.
> The rest of the time is Configuration creation (can be cached) and other iteration code.
> (p.s. don't take the % numbers as hard values - these are definitly affected by how many methods/classes you have; this underlying tests
> is done on pojos with a "high" method count (approx 100)
--
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
17 years, 7 months
[Hibernate-JIRA] Created: (HHH-2121) composite-id master-detail doesn't bound correctly variables
by German de la Cruz (JIRA)
composite-id master-detail doesn't bound correctly variables
------------------------------------------------------------
Key: HHH-2121
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2121
Project: Hibernate3
Type: Bug
Components: query-hql
Versions: 3.2.0.cr4
Environment: hibernate-3.2.CR4, oracle 9i
Reporter: German de la Cruz
Priority: Blocker
Attachments: CompositeIdTest.java
After issue HHH-2120, we decided to migrate from Hibernate 3.0.5 to 3.2.CR4. But, after have made the migration, we receive another error related to the variables bound.
When I run the attached code (You can see it is the same class in tests in distribution file, but with a new method called testQuery2 that can reproduce the bug) Hibernate generate the following query.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
16:18:19,492 DEBUG AST:266 - --- HQL AST ---
\-[QUERY] 'query'
+-[SELECT_FROM] 'SELECT_FROM'
| \-[FROM] 'from'
| \-[RANGE] 'RANGE'
| +-[DOT] '.'
| | +-[DOT] '.'
| | | +-[DOT] '.'
| | | | +-[DOT] '.'
| | | | | +-[IDENT] 'org'
| | | | | \-[IDENT] 'hibernate'
| | | | \-[IDENT] 'test'
| | | \-[IDENT] 'cid'
| | \-[IDENT] 'LineItem'
| \-[ALIAS] 'ol'
\-[WHERE] 'where'
\-[AND] 'and'
+-[EQ] '='
| +-[DOT] '.'
| | +-[IDENT] 'ol'
| | \-[IDENT] 'order'
| \-[COLON] ':'
| \-[WEIRD_IDENT] 'order'
\-[EQ] '='
+-[IDENT] 'quantity'
\-[COLON] ':'
\-[IDENT] 'quantity'
16:18:19,532 DEBUG AST:232 - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (LineItem)
+-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
| +-[SELECT_EXPR] SelectExpressionImpl: 'lineitem0_.customerId as customerId2_, lineitem0_.orderNumber as orderNum2_2_, lineitem0_.productId as productId2_' {FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=ol,role=null,tableName=LineItem,tableAlias=lineitem0_,origin=null,colums={,className=org.hibernate.test.cid.LineItem}}}
| \-[SQL_TOKEN] SqlFragment: 'lineitem0_.quantity as quantity2_'
+-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[ol], fromElementByTableAlias=[lineitem0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'LineItem lineitem0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=ol,role=null,tableName=LineItem,tableAlias=lineitem0_,origin=null,colums={,className=org.hibernate.test.cid.LineItem}}
\-[WHERE] SqlNode: 'where'
\-[AND] SqlNode: 'and'
+-[AND] BinaryLogicOperatorNode: 'AND'
| +-[EQ] BinaryLogicOperatorNode: '='
| | +-[SQL_TOKEN] SqlFragment: 'lineitem0_.customerId'
| | \-[SQL_TOKEN] SqlFragment: '?'
| \-[EQ] BinaryLogicOperatorNode: '='
| +-[SQL_TOKEN] SqlFragment: 'lineitem0_.orderNumber'
| \-[SQL_TOKEN] SqlFragment: '?'
\-[EQ] BinaryLogicOperatorNode: '='
+-[DOT] DotNode: 'lineitem0_.quantity' {propertyName=quantity,dereferenceType=4,propertyPath=quantity,path={synthetic-alias}.quantity,tableAlias=lineitem0_,className=org.hibernate.test.cid.LineItem,classAlias=ol}
| +-[IDENT] IdentNode: '{synthetic-alias}' {originalText={synthetic-alias}}
| \-[IDENT] IdentNode: 'quantity' {originalText=quantity}
\-[NAMED_PARAM] ParameterNode: '?' {name=quantity, expectedType=org.hibernate.type.IntegerType@d81b4}
16:18:21,968 DEBUG SQL:393 -
select
lineitem0_.customerId as customerId2_,
lineitem0_.orderNumber as orderNum2_2_,
lineitem0_.productId as productId2_,
lineitem0_.quantity as quantity2_
from
LineItem lineitem0_
where
lineitem0_.customerId=?
and lineitem0_.orderNumber=?
and lineitem0_.quantity=?
16:18:21,988 DEBUG StringType:80 - binding 'C111' to parameter: 1
16:18:21,993 DEBUG IntegerType:80 - binding '0' to parameter: 2
16:18:21,997 DEBUG IntegerType:80 - binding '2' to parameter: 2
16:18:22,019 WARN JDBCExceptionReporter:71 - SQL Error: 1008, SQLState: 72000
16:18:22,024 ERROR JDBCExceptionReporter:72 - ORA-01008: not all variables bound
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
As you can see, two variables are binded to parameter 2.
--
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
17 years, 7 months