- This might be caused by running to_char on a timestamp like this: to_char(dp.calc_date, ‘dd/Mon/yyyy hh:mi:s’).
- Try just returning the date without trying to convert it first.
- More about this error here.
Make sure the folder is a source folder in Eclipse project properties.
Problem: deployment failed and there is no indication what went wrong.
Basically you need to increase logging in the JBoss server config to get more details.
Make sure log4j is set up. The correct location for log4j.xml is in web-inf/classes.
Error with Oracle hanging on a stored procedure call or commit statement.
Does someone have an uncommitted session? SQL Developer will sometimes cause this (maybe a user doesn’t have autocommit on?).
to_char(s.logon_time,'DD/MON/YY HH24:MI:SS') logon_time
s.saddr = t.ses_addr
order by start_time;
Once you have a session id, use
Sql Developer Tools > Monitor Sessions to see the problem SQL
See also this link on StackOverflow.