solomax commented on PR #283: URL: https://github.com/apache/openjpa/pull/283#issuecomment-6707211980
@rzo1 here are testing results ### HSQL - GREEN! ### Testing this one with `mssql:2017-latest` and got: ``` | [ERROR] org.apache.openjpa.persistence.jpql.functions.TestEJBQLFunction.testSubstringBeyondString -- Time elapsed: 0.147 s <<< ERROR! | <openjpa-4.2.0-SNAPSHOT-r9910de6M fatal general error> org.apache.openjpa.persistence.PersistenceException: Invalid length parameter passed to the LEFT or SUBSTRING function. | FailedObject: SELECT SUBSTRING(u.name, 10) FROM CompUser AS u WHERE u.name = 'Seetha' [java.lang.String] | at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5938) | at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5898) | at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) | at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:115) ``` ### Oracle tests for whatever reason gave me: ``` | [INFO] Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.265 s -- in org.apache.openjpa.persistence.jdbc.query.TestNativeQueryParameterBinding | [INFO] Running org.apache.openjpa.persistence.jdbc.query.TestQueryParameterBinding | [ERROR] Tests run: 23, Failures: 0, Errors: 6, Skipped: 0, Time elapsed: 4.721 s <<< FAILURE! -- in org.apache.openjpa.persistence.jdbc.query.TestQueryParameterBinding | [ERROR] org.apache.openjpa.persistence.jdbc.query.TestQueryParameterBinding.testRepeatedNamedParameters -- Time elapsed: 0.153 s <<< ERROR! | <openjpa-4.2.0-SNAPSHOT-r9910de6M nonfatal general error> org.apache.openjpa.persistence.PersistenceException: ORA-12516: Cannot connect to database. Listener at host localhost port 1521 does not have a protocol handler for TCP ready or registered for service openjpatst. (CONNECTION_ID=oxmAHkT4R4qMIRU8V/i+HA==) | https://docs.oracle.com/error-help/db/ora-12516/ | at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:687) ``` while `docker ps` results: ``` 09966c49f755 catthehacker/ubuntu:act-latest "tail -f /dev/null" 16 minutes ago Up 16 minutes act-Databases-build-Java-21-test-oracle-docker-23-slim-48b9c76a501d82ee71039480798c00fee25138dfe751ff65af51cecc0f95c4ad 2518d030af23 gvenzl/oracle-free:23-slim "container-entrypoin…" 16 minutes ago Up 16 minutes (healthy) 0.0.0.0:1521->1521/tcp, [::]:1521->1521/tcp act-Databases-build-Java-21-test-oracle-docker-23-slim-48b9c76a-09efbcfd76289cf3581de8b423b7dd2da46699ffe49681dd4a506fbe6f9e65c8 ``` and `telnet localhost 1521` is able to connect The only difference for oracle what I can see is absent init.sql from `src/test/sql/oracle-docker/01-processes.sh` Not sure how to connect it in yaml ..... BTW why did you switch to `gvenzl/oracle-free` from `gvenzl/oracle-xe`. This new Oracle has only 1 version and requires some init script .... -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
