oracle.jdbc.OracleDriver : How to use in Scout Photon [message #1816220] |
Thu, 24 October 2019 09:10 |
|
Hi,
I see in another post how configure MySql in Scout Photon, but I need to use oracle.jdbc.OracleDriver in my project.
In my old version of Scout 3.8 I define the use of this driver in the following way
public class PippoSqlService extends AbstractSqlService implements IService2 {
@Override
protected String getConfiguredJdbcMappingName() {
return "jdbc:oracle:thin:@pippo.org:1535:ipr";
}
@Override
protected String getConfiguredPassword() {
return "$pippo";
}
@Override
protected String getConfiguredUsername() {
return "pippo";
}
}
In the post of MySql, I understand that it's necessary add the dependencies on POM and update the Maven
<dependency>
<artifactId>org.eclipse.scout.rt.server.jdbc</artifactId>
<groupId>org.eclipse.scout.rt</groupId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.17</version>
</dependency>
My question is: what is the correct dependency to add in POM for Oracle Thin JDBC driver?
Thanks in advance for each suggestions
|
|
|
Re: oracle.jdbc.OracleDriver : How to use in Scout Photon [message #1816255 is a reply to message #1816220] |
Thu, 24 October 2019 18:23 |
|
Marco
I think you need a matching "ojdbc" dependency (Oracle JDBC driver). There are several versions available on Maven central, choose the one that matches your setup. Note that this is plain JDBC and has nothing to do with Scout. You should be able to find plenty of descriptions online on how to connect a Java application to Oracle.
You still need the additional dependency to org.eclipse.scout.rt.server.jdbc in your pom.xml, since this module provides the ISqlService and bindings to several databases, including Oracle (AbstractOracleSqlService).
Regards,
Beat
|
|
|
Powered by
FUDForum. Page generated in 0.03347 seconds