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…

Santosh Vadje
- 11
- 2
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