Skip to main content



      Home
Home » Eclipse Projects » Eclipse Scout » oracle.jdbc.OracleDriver : How to use in Scout Photon(clipse IDE for Scout Developers Version: 2018-09 (4.9.0) Build id: 20180917-1800)
oracle.jdbc.OracleDriver : How to use in Scout Photon [message #1816220] Thu, 24 October 2019 05:10 Go to next message
Eclipse UserFriend
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 14:23 Go to previous message
Eclipse UserFriend
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
Previous Topic:Job Manager - Showing all scheduled jobs
Next Topic:Outline personalization - Scout Photon
Goto Forum:
  


Current Time: Tue Jul 08 03:54:25 EDT 2025

Powered by FUDForum. Page generated in 0.03451 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top