Hello Noman, What Sybase database are you using? Adaptive Server or SQL Anywhere? Currently, source code generation is available only for SQL Anywhere, not for Adaptive Server. Specifically, the JDBCDatabase doesn't support stored procedures.
We have a pending feature request to add stored procedure support for Adaptive Server: https://github.com/jOOQ/jOOQ/issues/1507 Unfortunately, it seems as though it is non-trivial to discover them from meta data, which is why we haven't added such support yet. Hope this helps, Lukas 2015-11-05 12:21 GMT+01:00 <[email protected]>: > Hi, > > I am trying to generate a schema from a Sybase database. The tables are > able to generate just fine but none of the stored procedures generate an > equivalent routine type. > > What could be causing this? I am using Jooq 3.4.2 and > net.sourceforge.jtds.jdbc.Driver driver. Here is an extract of my pom > generation: > > <configuration> > <jdbc> > <driver>${driver}</driver> > <url>${db.url}</url> > <user>${db.username}</user> > <password>${db.password}</password> > </jdbc> > > <generator> > <database> > <name>org.jooq.util.jdbc.JDBCDatabase</name> > <includes>.*</includes> > <inputSchema>dbo</inputSchema> > </database> > <target> > > <packageName>org.jooq.example.flyway.db.h2</packageName> > > <directory>target/generated-sources/jooq-h2</directory> > </target> > </generator> > </configuration> > </plugin> > ... > > Can someone provide more insight as to what I am doing wrong? > > Thanks, > > Noman > > -- > 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
