1
edit
Changes
Created page with ' PostgreSQLAdapterTest (Revision 28) 2/03/2011 - 8 errors, 4 failures 1. testUpgrade - java.lang.RuntimeException: ERROR: syntax error at or near "varchar" Position: 4…'
PostgreSQLAdapterTest (Revision 28)
2/03/2011
- 8 errors, 4 failures
1. testUpgrade
- java.lang.RuntimeException: ERROR: syntax error at or near "varchar"
Position: 42
alter table test.A alter column lastName varchar(30) not null
at nexj.core.persistence.sql.SQLSchemaManager$SQLConnectionAppender.appendSQL(SQLSchemaManager.java:5456)
at nexj.core.persistence.sql.SQLSchemaManager.alterColumn(SQLSchemaManager.java:2272)
at nexj.core.persistence.sql.SQLSchemaManager.alterColumns(SQLSchemaManager.java:3721)
at nexj.core.persistence.sql.SQLSchemaManager.createColumn(SQLSchemaManager.java:3333)
at nexj.core.persistence.sql.SQLSchemaManager.upgrade(SQLSchemaManager.java:3045)
at nexj.core.persistence.sql.SQLAdapter.upgrade(SQLAdapter.java:2493)
- Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "varchar"
Position: 42
2. testRead
- nexj.core.persistence.PersistenceException: SQL error. (err.persistence.sql)
at nexj.core.persistence.sql.SQLAdapter.getException(SQLAdapter.java:3209)
at nexj.core.persistence.sql.SQLCursor.query(SQLCursor.java:186)
- Caused by: org.postgresql.util.PSQLException: The column index is out of range: 2, number of columns: 1.
3.testMatch
- nexj.core.persistence.PersistenceException: SQL error. (err.persistence.sql)
at nexj.core.persistence.sql.SQLAdapter.getException(SQLAdapter.java:3209)
at nexj.core.persistence.sql.SQLCursor.query(SQLCursor.java:186)
- Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: >= double precision
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 187
4. testNew (failure)
- junit.framework.ComparisonFailure: expected:<...> but was:<...Class>
5. testQueryTimeOutException
- nexj.core.persistence.PersistenceException: SQL error. (err.persistence.sql)
at nexj.core.persistence.sql.SQLAdapter.getException(SQLAdapter.java:3209)
at nexj.core.persistence.sql.SQLCursor.query(SQLCursor.java:186)
- Caused by: org.postgresql.util.PSQLException: Method org.postgresql.jdbc3.Jdbc3PreparedStatement.setQueryTimeout(int)
is not yet implemented.
at org.postgresql.Driver.notImplemented(Driver.java:753)
at org.postgresql.jdbc2.AbstractJdbc2Statement.setQueryTimeout(AbstractJdbc2Statement.java:656)
6. testUpdate (failure)
- junit.framework.AssertionFailedError: Test object does not match
the serialized representation at "file:/C:/workspace3.5/jan222011/core/bin/nexj/core/persistence/sql/data/updateNull.xml"
at junit.framework.Assert.fail(Assert.java:47)
at nexj.test.util.AssertUtil.assertEquals(AssertUtil.java:45)
at nexj.core.persistence.sql.SQLAdapterTest.testUpdate(SQLAdapterTest.java:1254)
7. testRanges (failure)
- junit.framework.AssertionFailedError: Unexpected exception java.lang.NullPointerException
at junit.framework.Assert.fail(Assert.java:47)
at nexj.core.persistence.sql.SQLAdapterTest.testRanges(SQLAdapterTest.java:1409)
8. testRulesEngine
- nexj.core.persistence.PersistenceException: SQL error. (err.persistence.sql)
at nexj.core.persistence.sql.SQLAdapter.getException(SQLAdapter.java:3209)
at nexj.core.persistence.sql.SQLCursor.getRawValue(SQLCursor.java:252)
- Caused by: org.postgresql.util.PSQLException: Bad value for type long : - (@ type type) "Company"
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toLong(AbstractJdbc2ResultSet.java:2796)
9. testUnicodeCharset
- nexj.core.persistence.PersistenceException: SQL error. (err.persistence.sql)
at nexj.core.persistence.sql.SQLAdapter.getException(SQLAdapter.java:3209)
at nexj.core.persistence.sql.SQLCursor.query(SQLCursor.java:186)
- Caused by: org.postgresql.util.PSQLException: ERROR: unterminated quoted string at or near "'\' /* 1 */"
Position: 91
10. testWorkflowLoop (failure)
- junit.framework.AssertionFailedError: expected:<Richmond Hill> but was:<Toronto>
11. testWorkflowTrigger
- nexj.core.persistence.PersistenceException: SQL error. (err.persistence.sql)
at nexj.core.persistence.sql.SQLAdapter.getException(SQLAdapter.java:3209)
at nexj.core.persistence.sql.SQLCursor.getRawValue(SQLCursor.java:252)
- Caused by: org.postgresql.util.PSQLException: Bad value for type long : - (@ type type) "Company"
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toLong(AbstractJdbc2ResultSet.java:2796)
12. testWorkflowTriggerException
- nexj.core.persistence.PersistenceException: SQL error. (err.persistence.sql)
at nexj.core.persistence.sql.SQLAdapter.getException(SQLAdapter.java:3209)
at nexj.core.persistence.sql.SQLCursor.getRawValue(SQLCursor.java:252)
at nexj.core.persistence.GenericCursor.getValue(GenericCursor.java:465)
- Caused by: org.postgresql.util.PSQLException: Bad value for type long : - (@ type type) "Company"
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toLong(AbstractJdbc2ResultSet.java:2796)