Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

Activity

Show:

Daniel Henninger 
April 9, 2008 at 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

Daryl Beattie 
April 9, 2008 at 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.

Erik Onnen 
February 19, 2008 at 5:53 AM

Work-around for 3.4.5 that is.

Erik Onnen 
February 19, 2008 at 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.

Daniel Henninger 
February 12, 2008 at 12:01 AM

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

Fixed

Details

Assignee

Reporter

Fix versions

Priority

Created February 11, 2008 at 11:24 PM
Updated April 9, 2008 at 11:31 PM
Resolved February 12, 2008 at 12:41 PM