Bug 1035681

Summary:	Unexpected errors and warnings in server.log for quickstarts using H2 database
Product:	[JBoss] JBoss Enterprise Application Platform 6	Reporter:	Nikoleta Hlavickova <nziakova>
Component:	Quickstarts	Assignee:	sgilda
Status:	CLOSED CURRENTRELEASE	QA Contact:	Nikoleta Hlavickova <nziakova>
Severity:	medium	Docs Contact:	Russell Dickenson <rdickens>
Priority:	unspecified
Version:	6.2.0	CC:	bsutter, jkudrnac, pmuir
Target Milestone:	DR2
Target Release:	EAP 6.3.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2014-06-28 15:27:40 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description Nikoleta Hlavickova 2013-11-28 09:54:06 UTC

(1)
WARN  [org.hibernate.dialect.H2Dialect] (ServerService Thread Pool -- 73) HHH000431: Unable to determine H2 database version, certain features may not work

(2)
ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 73) HHH000389: Unsuccessful: drop sequence hibernate_sequence
ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 73) Sequence "HIBERNATE_SEQUENCE" not found; SQL statement:
drop sequence hibernate_sequence [90036-168]

(3)
WARN  [org.hibernate.hql.internal.ast.HqlSqlWalker] (http-/127.0.0.1:8080-1) [DEPRECATION] Encountered positional parameter near line 1, column 75.  Positional parameter are considered deprecated; use named parameters or JPA-style positional parameters instead.

See BZ #1028469
A note about (1) and (2) was added to tasks quickstart readme and (3) was fixed in tasks. However more quickstarts re affected:

bean-validation (1,2)
bmt (1)
cdi-interceptors (1,2)
cdi-stereotype (1,2)
cdi-veto (1)
cmt (1,2)
greeter (1,2)
h2-console (1,2)
hibernate4 (1)
jta-crash-rec (1,2)
kitchensink (1,2)
kitchensink-ear (1,2)
kitchensink-jsp (1,2)
kitchensink-ml (1,2)
kitchensink-ml-ear (1,2)
servlet-security (1)
tasks-jsf (1,2,3)
tasks-rs (1,2,3)
wicket-ear (1)
wicket-war (1)

Comment 1 sgilda 2013-12-03 19:58:42 UTC

Made the changes except for the following:

* cmt: I don't see [1] 'HHH000431' in the server log/

* h2console: I don't see 1 or 2 in the server log. Instead, I see:
        JBAS018568: Deployment "deployment.h2console.war" is using an unsupported module ("com.h2database.h2:main") which may be changed or removed in future versions without notice.

*jta-crash-rec: I only see message 1. I don't see 2.

* tasks-jsf: I don't see message 3.

* tasks-rs:  I don't see message 3.

Comment 2 sgilda 2013-12-03 20:01:43 UTC

Fixed in this commit: https://github.com/jboss-developer/jboss-eap-quickstarts/commit/a9f53c11b26c2abcf99cf6b4e58cf26be0b97d26

Comment 3 Nikoleta Hlavickova 2014-03-10 15:37:22 UTC

Verified with EAP 6.3.0 DR2. For remaining warnings there will be new BZs. One of them is already created, see BZ 1073925.