Skip to main content

jOOQ: code generation in Eclipse

jOOQ allows code generation from a database schema through ANT tasks, Maven and shell command tools. But if you're working with Eclipse it's easier to create a new Run Configuration to perform this operation.
First of all you have to write the usual XML configuration file for the code generation starting from the database:


<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<configuration xmlns="http://www.jooq.org/xsd/jooq-codegen-2.0.4.xsd">
  <jdbc>
    <driver>oracle.jdbc.driver.OracleDriver</driver>
    <url>jdbc:oracle:thin:@dbhost:1700:DBSID</url>
    <user>DB_FTRS</user>
    <password>password</password>
  </jdbc>

   <generator>
    <name>org.jooq.util.DefaultGenerator</name>

     <database>
      <name>org.jooq.util.oracle.OracleDatabase</name>

       <inputSchema>DB_FTRS</inputSchema>

       <includes>.*</includes>

       <excludes></excludes>
    </database>

     <generate>
      <relations>true</relations>
      <deprecated>false</deprecated>
      
 <pojos>true</pojos>
 
 <daos>true</daos>
    </generate>

     <target>
      <packageName>jooqbench.generated</packageName>

       <directory>src</directory>
    </target>
  </generator>
</configuration>


Then you have to be sure to have in your project classpath the following libraries:

  • jooq-2.6.1.jar
  • jooq-codegen-2.6.1.jar
  • jooq-meta-2.6.1.jar
  • log4j-1.2.16.jar
  • slf4j-log4j12-1.7.2.jar
the log4j.xml configuration file and your database JDBC driver. Then create a new Run Configuration. Select your application project and the jOOQ generation class as main class:



Move to the Arguments tab and add as Program argument your jOOQ configuration file for code generation putting a slash before its name:



Click on the Run button and the generation will start. Each time you need to refresh your code, just run this configuration.
Labels:

Comments

Post a Comment

Popular posts from this blog

Exporting InfluxDB data to a CVS file

Sometimes you would need to export a sample of the data from an InfluxDB table to a CSV file (for example to allow a data scientist to do some offline analysis using a tool like Jupyter, Zeppelin or Spark Notebook). It is possible to perform this operation through the influx command line client. This is the general syntax: sudo /usr/bin/influx -database '<database_name>' -host '<hostname>' -username '<username>'  -password '<password>' -execute 'select_statement' -format '<format>' > <file_path>/<file_name>.csv where the format could be csv , json or column . Example: sudo /usr/bin/influx -database 'telegraf' -host 'localhost' -username 'admin'  -password '123456789' -execute 'select * from mem' -format 'csv' > /home/googlielmo/influxdb-export/mem-export.csv
6 comments
Read more

Using Rapids cuDF in a Colab notebook

During last Spark+AI Summit Europe 2019 I had a chance to attend a talk from Miguel Martinez  who was presenting Rapids , the new Open Source framework from NVIDIA for GPU accelerated end-to-end Data Science and Analytics. Fig. 1 - Overview of the Rapids eco-system Rapids is a suite of Open Source libraries: cuDF cuML cuGraph cuXFilter I enjoied the presentation and liked the idea of this initiative, so I wanted to start playing with the Rapids libraries in Python on Colab , starting from cuDF, but the first attempt came with an issue that I eventually solved. So in this post I am going to share how I fixed it, with the hope it would be useful to someone else running into the same blocker. I am assuming here you are already familiar with Google Colab. I am using Python 3.x as Python 2 isn't supported by Rapids. Once you have created a new notebook in Colab, you need to check if the runtime for it is set to use Python 3 and uses a GPU as hardware accelerator. You...
5 comments
Read more