History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: UP-1742
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Eric Dalquist
Reporter: Andrew Petro
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
uPortal

CUserManager DefaultDataHandlerImpl.setUserPassword() doesn't work under Oracle

Created: 18/Jun/07 05:49 PM   Updated: 29/Aug/07 05:31 PM
Component/s: Administration
Affects Version/s: 2.6.0 RC1, 2.6.0 RC2
Fix Version/s: 2.6.0 GA

Original Estimate: Unknown Remaining Estimate: Unknown Time Spent: Unknown


 Description  « Hide
In general it seems like this code would be happier using Spring JDBC and / or prepared statements. This issue probably afflicts earlier uPortals as well.

java.sql.SQLException: ORA-01843: not a valid month

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:261)
at org.jasig.portal.channels.cusermanager.provider.DefaultDataHandlerImpl.setUserPassword(DefaultDataHandlerImpl.java:208)
at org.jasig.portal.channels.cusermanager.CUserManager.renderXML(CUserManager.java:240)

 All   Comments   Work Log   Change History      Sort Order:
Eric Dalquist [06/Aug/07 12:29 PM]
It looks like the code needs to be changed to use the timestamp formatting functionality of the IDatabaseMetaData interface from RDBMServices.

Eric Dalquist [06/Aug/07 12:59 PM]
Fixed by switching to database meta data for timestamp formatting.