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, 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, 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, 5:53 AM

Work-around for 3.4.5 that is.

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.

Daniel Henninger
February 12, 2008, 12:01 AM

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

Fixed
Your pinned fields
Click on the next to a field label to start pinning.

Assignee

Daniel Henninger

Reporter

Daniel Henninger