Database connection ORA-00933 - SQL command not properly ended

0
Hello, In Mendix 10.6.5, Running an executeQuery component of the database connector, with a MariaDB connection, the component works correctly: executeQuery: jdbc:mariadb://XXXXXXXXXXXXXX:ZZZZZ/BBBBB, FFFFFF, SELECT NAME FROM TB_EMPLOYEE; Result list count: 1   But when using an Oracle connection string, an error occurs: Caused by: com.mendix.modules.microflowengine.MicroflowException: com.mendix.systemwideinterfaces.MendixRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00933 - SQL command not properly ended executeQuery: jdbc:oracle:thin:@//XXXXXXXXXXXXXX:YYYYY/AAAAAA, TTTTT, SELECT NAME FROM TB_EMPLOYEE;   I am using Oracle 19c.
asked
2 answers
1

It looks like you need either oracle19, or oracle 21c. I'm not sure it works properly with 19c. Getting the correct version might solve your issue.

answered
0

It says that your SQL command is not properly ended. I believe Oracle needs a more specific format than MariaDB. Try...

 

SELECT tbe.NAME FROM TB_EMPLOYEE tbe;

 

Good luck!

answered