Skip to content

Instantly share code, notes, and snippets.

View mirat1618's full-sized avatar

Mirat Sayfullin mirat1618

  • Ufa, Russia
View GitHub Profile
https (one-way)
@RestController
public class HelloController {
@GetMapping("/")
public String index() {
return "Greetings";
}
}
@mirat1618
mirat1618 / KafkaEnqueue.java
Created October 29, 2021 09:42
Enqueuing the Song object (Kafka)
import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.ObjectMapper;
import oracle.AQ.*;
import org.apache.kafka.clients.consumer.ConsumerRecord;
import org.apache.kafka.clients.consumer.ConsumerRecords;
import org.apache.kafka.clients.consumer.KafkaConsumer;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
@mirat1618
mirat1618 / KafkaDequeue.java
Created October 29, 2021 09:41
Dequeuing the Song object (Kafka)
import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.ObjectMapper;
import oracle.AQ.*;
import org.apache.kafka.clients.producer.KafkaProducer;
import org.apache.kafka.clients.producer.Producer;
import org.apache.kafka.clients.producer.ProducerRecord;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
@mirat1618
mirat1618 / SongJsonSchema.json
Created October 29, 2021 09:38
JSON schema for the Song object
{
"title": "Song",
"type": "object",
"properties": {
"title": {
"type": "string",
"not": "null",
"minLength": 1
},
"duration": {
@mirat1618
mirat1618 / JsonValidator.java
Last active October 29, 2021 09:39
JSON validator for the Song object
import org.everit.json.schema.Schema;
import org.everit.json.schema.ValidationException;
import org.everit.json.schema.loader.SchemaLoader;
import org.json.JSONObject;
import org.json.JSONTokener;
public class JsonValidator {
public static ClassLoader classLoader = ClassLoader.getSystemClassLoader();
public static JSONObject jsonSchema = new JSONObject(new JSONTokener(classLoader.getResourceAsStream("SongJsonSchema.json")));
public static Schema schema = SchemaLoader.load(jsonSchema);
@mirat1618
mirat1618 / AQEnqueue.java
Created October 29, 2021 09:36
Enqueuing an object
import oracle.AQ.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Struct;
public class AQEnqueue {
public static void main(String[] args) throws SQLException, AQException, ClassNotFoundException {
String JDBC_URL = "jdbc:oracle:thin:@//localhost:1521/ORCLPDB1.localdomain";
@mirat1618
mirat1618 / AQDequeue.java
Last active October 30, 2021 05:28
Dequeuing an object
import oracle.AQ.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class AQDequeue {
public static void main(String[] args) throws SQLException, AQException, ClassNotFoundException {
String JDBC_URL = "jdbc:oracle:thin:@//localhost:1521/ORCLPDB1.localdomain";
@mirat1618
mirat1618 / Song.java
Last active October 29, 2021 11:14
An object class implementing SQLData
import com.fasterxml.jackson.annotation.JsonIgnore;
import java.sql.*;
public class Song implements SQLData {
private String sql_type;
private String title;
private int duration;
private String filePath;
public Song() {}
@mirat1618
mirat1618 / AQStop.java
Created October 29, 2021 09:31
Stopping an Oracle database queue
import oracle.AQ.AQDriverManager;
import oracle.AQ.AQException;
import oracle.AQ.AQQueue;
import oracle.AQ.AQSession;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class AQStop {
@mirat1618
mirat1618 / AQStart.java
Created October 29, 2021 09:30
Starting an Oracle database queue
import oracle.AQ.AQDriverManager;
import oracle.AQ.AQException;
import oracle.AQ.AQQueue;
import oracle.AQ.AQSession;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class AQStart {