Openfire (ARCHIVED)

Oracle can't handle default test SQL

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Blocker Blocker
  • Resolution: Fixed
  • Affects Version/s: None
  • Fix Version/s: 3.5.0
  • Component/s: None
  • Acceptance Test - Add?:
    No
  • 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?

Activity

Hide
Daniel Henninger added a comment - 02/11/08 06:01 PM

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

Show
Daniel Henninger added a comment - 02/11/08 06:01 PM SELECT 1 FROM dual works under oracle and mysql but not much else gotta love consistency
Hide
Erik Onnen added a comment - 02/18/08 11:53 PM

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.

Show
Erik Onnen added a comment - 02/18/08 11:53 PM 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.
Hide
Erik Onnen added a comment - 02/18/08 11:53 PM

Work-around for 3.4.5 that is.

Show
Erik Onnen added a comment - 02/18/08 11:53 PM Work-around for 3.4.5 that is.
Hide
Daryl Beattie added a comment - 04/09/08 06: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.

Show
Daryl Beattie added a comment - 04/09/08 06: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.
Hide
Daniel Henninger added a comment - 04/09/08 06: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

Show
Daniel Henninger added a comment - 04/09/08 06: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

People

Dates

  • Created:
    02/11/08 05:24 PM
    Updated:
    04/09/08 06:31 PM
    Resolved:
    02/12/08 06:41 AM