I upgraded Roller 3.1 to Roller 4.1 (oracle 10g, Tomcat 5.25, Windoes xp)
roller-custom.properties:
installation.type=manual
database.configurationType=jdbc
database.jdbc.driverClass=oracle.jdbc.driver.OracleDriver
database.jdbc.connectionURL=jdbc:oracle:thin:@irisint.com:1521:ROMA
database.jdbc.username=bmil
database.jdbc.password=bmil
mail.configurationType=properties
mail.hostName=smtp.mf
1) There is a lot of bugs in oracle/dbscripts.sql
SQL> insert into roller_permission
(id,username,actions,objectid,objecttype,pending,datecreated)
2 select w.id||u.username, u.username, 'edit_draft', w.handle, 'Weblog',
0, current_timestamp
3 from rolleruser as u, website as w, roller_user_permissions as p
4 where p.user_id = u.id and p.website_id = w.id and permission_mask =
1;
from rolleruser as u, website as w, roller_user_permissions as p
*
ERROR at line 3:
ORA-00933: SQL command not properly ended
SQL> ed
Wrote file afiedt.buf
1 insert into roller_permission
(id,username,actions,objectid,objecttype,pending,datecreated)
2 select w.id||u.username, u.username, 'edit_draft', w.handle, 'Weblog',
0, current_timestamp
3 from rolleruser u, website w, roller_user_permissions p
4* where p.user_id = u.id and p.website_id = w.id and permission_mask =
1
SQL> /
0 rows created.
2) Roller didn't find any user in DB, that exists in 3.1
ID
----------------------------------
USERNAME
----------------------------------
PASSPHRASE
----------------------------------
8a82f0e61763560d01176399cb1a0001
admin
----
3) I can't insert new user
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-01400: cannot
insert NULL into ("BMIL"."USERROLE"."USERID")
{prepstmnt 14838503 INSERT INTO userrole (id, rolename, username) VALUES (?,
?, ?) [params=(String) 47cc40d6-aeb7-4a5b-8d8a-f808c3806b01, (String) editor,
(String) bmil]} [code=1400, state=23000]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:191)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$800(LoggingConnectionDecorator.java:56)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:857)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1363)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:95)
... 189 more
