Hi Team, has anyone faced issues with ​Oracle Exte...
# questions-and-troubleshooting
q
Hi Team, has anyone faced issues with ​Oracle External Catalogwhere`SELECT` queries fail on tables with ​lowercase column names? I'm unable to retrieve data from lowercase columns. Is there a configuration or workaround to support this? Thanks!
Copy code
CREATE EXTERNAL CATALOG oracle_catalog
PROPERTIES (
    "type" = "jdbc",
    "user" = "oracle", 
    "password" = "oraclepass", 
    "jdbc_uri" = "jdbc:oracle:thin:@//192.168.8.115:1521/XE",
    "driver_url" = "file:///data/drivers/ojdbc8-21.3.0.0.jar",
    "driver_class" = "oracle.jdbc.driver.OracleDriver",
    "case_sensitive" = "true"
);

SELECT student_name FROM oracle_catalog.ORACLE.works_at LIMIT 1;

Error Message:
SQL 错误 [1064] [42000]: open JDBCScanner failed, error: java.sql.SQLSyntaxErrorException: ORA-00904: "STUDENT_NAME": invalid identifier

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:152)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:937)
	at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1172)
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1101)
	at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1426)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1309)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3746)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3855)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1098)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
	at com.starrocks.jdbcbridge.JDBCScanner.open(JDBCScanner.java:96)
Caused by: Error : 904, Position : 22, Sql = SELECT * FROM (SELECT student_name FROM "ORACLE"."works_at") WHERE ROWNUM <= 1, OriginalSql = SELECT * FROM (SELECT student_name FROM "ORACLE"."works_at") WHERE ROWNUM <= 1, Error Msg = ORA-00904: "STUDENT_NAME": invalid identifier

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
	... 17 more
: BE:10004
#C02FACZSNJV