We're updating the issue view to help you get more done. 

Oracle can't handle default test SQL

Description

Apparently Oracle can't handle a simple SELECT 1. facepalm Need to figure out how best to handle this. Different statement that maybe works across the board? Special case for Oracle? Some other solution?

Environment

None

Acceptance Test - Entry

None

Activity

Show:
Daniel Henninger
February 12, 2008, 12:01 AM

SELECT 1 FROM dual
works under oracle
and mysql
but not much else
gotta love consistency

Erik Onnen
February 19, 2008, 5:53 AM

Daniel, do you have a work-around for this? I've manually installed the schema via SQL script but setup still won't let me pass.

Erik Onnen
February 19, 2008, 5:53 AM

Work-around for 3.4.5 that is.

Daryl Beattie
April 9, 2008, 11:27 PM

I just installed 3.5.0 and this problem is still around, even though the bug says it's fixed for 3.5.0.

Daniel Henninger
April 9, 2008, 11:31 PM

What's in your openfire.xml? is testSQL set to anything?
I tested it on our Oracle server and it's working great there

Assignee

Daniel Henninger

Reporter

Daniel Henninger

Labels

None

Expected Effort

None

Ignite Forum URL

None

Fix versions

Priority

Blocker
Configure