Questions tagged [jooq-sbt-plugin]

13 questions
5
votes
1 answer

How to configure jooq-sbt-plugin

I'm relatively new to SBT. I'd like to include the jooq-sbt-plugin (GitHub) in my SBT config. I'm using Build.scala to handle multiple projects and I'd like to include the jooq-sbt-plugin config there but I couldn't figure out where to put…
mkko
  • 4,262
  • 3
  • 25
  • 29
4
votes
1 answer

Using jooq-sbt-plugin with ojdbc

I'm using jOOQ. Solving an issue with jooq-sbt-plugin config (here) resulted in a classpath issue which I think is separate from the original one. I managed to get the configuration to work but trying to get it play with Oracle drivers seems…
mkko
  • 4,262
  • 3
  • 25
  • 29
3
votes
0 answers

Failed to execute goal org.jooq:jooq-codegen-maven:3.11.5:generate

Now I'm working with jooq library and I tried many times to solve the problem by searching here and there . This is pom.xml org.jooq jooq-codegen-maven 3.11.5
Wiwi
  • 31
  • 2
2
votes
1 answer

Jooq code generation "excludes" not working with typesafe config

I am trying to exclude two tables created by Liquibase when using TypeSafe Config. jooq { # databasechangelog = Liquibase generated tables # databasechangeloglock = Liquibase generated tables excludes = "databasechangelog,…
user1187135
1
vote
1 answer

How to add Oracle dialect to DSLContext

I'm not able to get SQLDialect.Oracle in the following version of jOOQ: org.jooq jooq 3.17.8 org.jooq
fatherazrael
  • 5,511
  • 16
  • 71
  • 155
1
vote
1 answer

Blob insert/update in jooq

Getting "error occurred during batching: ORA-00933 SQL command not properly ended. I'm trying to update/insert byte array in Oracle BLOB column using jooq syntax as follows:- Map, Object> fieldValueMap = new…
1
vote
2 answers

converting string to number inside Jooq select - Oracle

I am using jooq's DSL.select in my Java code, I have scenario where I need to determine the index from a string. Used DSL.substring("hello123",6,1) to get the desired index value as string, but no method supporting in DSL to convert it to a…
wenky
  • 471
  • 1
  • 6
  • 14
1
vote
1 answer

Convert given time to seconds in jooq framework

Suppose time is given in HH:MM:SS format.how can we convert this time to second in jooq. example- Input Time - 2:10:30 outlet- 2*60*60 + 10*60 + 30 =7830 secs
Jooqer
  • 21
  • 1
1
vote
1 answer

Get month name from Date in jooq

How can I generate the name of the month (e.g: Oct/October) from this date object in jooq? date- "2019-11-01 00:00:00" want to extract month name from date. output- November Thanks in advance.
Jooqer
  • 21
  • 1
1
vote
1 answer

org.jooq.exception.DataAccessException: SQL [select

I am developing Spring Boot JOOQ Integration example. I am using same DB schema from link: http://www.mysqltutorial.org/mysql-inner-join.aspx in my example. I am looking to perform inner join for two tables, but I am not able to achieve this yet.…
PAA
  • 1
  • 46
  • 174
  • 282
1
vote
1 answer

Sbt, local sbt plugin, using jooq code generation plugin

I'm trying to use jooq-sbt-plugin to generate some code. I downloaded the code, compiled it and copied jar into lib directory, but on sbt load i get this error: [warn] Note: Some unresolved dependencies have extra attributes. Check that th ese…
wiero
  • 2,176
  • 1
  • 19
  • 28
0
votes
1 answer

Insert Interval data using jooq

I have a PostgreSQL table with column with column name test_interval and type interval. test_interval interval I am using jooq to insert the data in the table. In my TestTable.java class, the field is of type: public final TableField
ARYA
  • 223
  • 1
  • 5
  • 15
0
votes
1 answer

Generate SQLite database scheme from Java code

Is there any way to generate SQLite database model from Java code using JOOQ?
Peter Penzov
  • 1,126
  • 134
  • 430
  • 808