Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 09:10 Go to next message
marco giudici is currently offline marco giudiciFriend
Messages: 204
Registered: February 2013
Location: Italy
Senior Member
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 Go to previous message
Beat Schwarzentrub is currently offline Beat SchwarzentrubFriend
Messages: 114
Registered: November 2010
Senior Member
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: Wed Dec 11 20:35:25 GMT 2019

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

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

Back to the top