Actually when i set up the traccar project and i change the traccar.xml file with my connection uri,username and password then when i change the debug.xml that h2 connection to oracle connection then showing error like
2025-06-02 16:01:07 ERROR: Main method error - ORA-00923: FROM keyword not found where expected
- OracleDatabaseException (... < DatabaseModule:80 < <gener:-1 < *:-1 < ... < MainModule:141 < <gener:-1 < ...)
> Task :org.traccar.Main.main() FAILED
6 actionable tasks: 1 executed, 5 up-to-date
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':org.traccar.Main.main()'.
> Process 'command 'C:\Program Files\Java\jdk-17.0.12\bin\java.exe'' finished with non-zero exit value 1
* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --debug option to get more log output.
> Run with --scan to get full insights.
> Get more help at https://help.gradle.org.
BUILD FAILED in 7s
4:01:07 PM: Execution finished ':org.traccar.Main.main()'.
how to fix that
- Add to config:
<entry key='database.checkConnection'>SELECT 1 FROM DUAL</entry>
or use Oracle RDBMS 23i
- Try jdk 21
Thank You So Much, My Project is running successfully with oracle database
Actually when i set up the traccar project and i change the traccar.xml file with my connection uri,username and password then when i change the debug.xml that h2 connection to oracle connection then showing error like
how to fix that