Oracle Varchar2

[markus.m...@gmail.com]

Hello,

what do I have to do having Oracle VARCHAR2 types as String.

Actually with jooq 3.11.11 maven plugin generates Object (unkonown type)

KR,

Markus

[Lukas Eder]

Hi Markus,

Thank you very much for your message. You don't have to do anything to support Oracle's VARCHAR2 type and treat it as a Java String. This works out of the box. Would you mind posting your code generation configuration that produced Object for you?

Thanks,

Lukas

--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/7ea4433b-ceee-419c-8335-23c58c39e2da%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[markus.m...@gmail.com]

Hello Lukas,

I am using the maven plugin with the open source version 3.11.11.

Following is my generation config:

            <plugin>
                <groupId>org.jooq</groupId>
                <artifactId>jooq-codegen-maven</artifactId>
                <version>${jooq-version}</version>
                <executions>
                    <execution>
                        <goals>
                            <goal>generate</goal>
                        </goals>
                    </execution>
                </executions>
                <dependencies>
                    <dependency>
                        <groupId>com.oracle</groupId>
                        <artifactId>ojdbc7</artifactId>
                        <version>12.1.0.2</version>
                    </dependency>
                </dependencies>

                <configuration>
                    <jdbc>
                        <driver>oracle.jdbc.OracleDriver</driver>
                        <url>jdbc:oracle:thin:@...</url>
                        <user>...</user>
                        <password>...</password>
                    </jdbc>

                    <generator>
                        <database>
                            <name>org.jooq.meta.jdbc.JDBCDatabase</name>
                            <includes>.*</includes>
                            <inputSchema>my_schema</inputSchema>
                        </database>
                        <target>
                            <packageName>com.foo</packageName>
                            <directory>target/generated-sources</directory>
                        </target>
                    </generator>
                </configuration>
            </plugin>

Thanks,

Markus

[Lukas Eder]

Hi Markus,

The jOOQ Open Source Edition does not support Oracle. Please consider this list to decide which edition is the right one for you:

https://www.jooq.org/legal/licensing#databases 

To try jOOQ for free, you can download the jOOQ Trial Edition from this website:

http://www.jooq.org/download/

I hope this helps,

Lukas 

--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/a1982925-a654-44f9-b65a-c9ca96fab461%40googlegroups.com.