Hmm, OK, but how can this Exception escape and be logged outside of
SQLServerDatabase.is2012()? A class loading issue with duplicate
org.jooq.exception.DataAccessException on the classpath? The relevant code
is this:
try {
create().selectCount()
.from(SEQUENCES)
.fetch();
is2012 = true;
}
catch (DataAccessException e) {
is2012 = false;
}
If you don't mind further investigating this, could you add log4j to your
classpath and use this configuration file here:
https://github.com/jOOQ/jOOQ/blob/master/jOOQ-test/src/log4j.xml
That should then show the log content producer
2013/9/21 Rob Nikander <[email protected]>
>
>
> On Saturday, September 21, 2013 4:01:00 AM UTC-4, Lukas Eder wrote:
>>
>>
>> The error message you have seen can be ignored, as the count(*) query
>> against the INFORMATION_SCHEMA.SEQUENCES table is used to distinguish
>> between SQL Server 2008 and SQL Server 2012. The curious thing is the fact
>> that it appears in your logs, which it shouldn't. Can you post the full
>> stack trace, please?
>>
>
>
> Sure, here it is:
>
> Sep 21, 2013 12:05:54 PM org.jooq.tools.JooqLogger error
> SEVERE: Error while fetching sequences
> org.jooq.exception.DataAccessException: SQL [select count(*) from
> [INFORMATION_SCHEMA].[SEQUENCES]]; Invalid object name
> 'INFORMATION_SCHEMA.SEQUENCES'.
> at org.jooq.impl.Utils.translate(Utils.java:1078)
> at
> org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:462)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:302)
> at
> org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:339)
> at
> org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:330)
> at org.jooq.impl.AbstractResultQuery.fetchOne(AbstractResultQuery.java:458)
> at org.jooq.impl.AbstractResultQuery.fetchOne(AbstractResultQuery.java:426)
> at org.jooq.impl.AbstractResultQuery.fetchOne(AbstractResultQuery.java:432)
> at org.jooq.impl.SelectImpl.fetchOne(SelectImpl.java:1114)
> at
> org.jooq.util.sqlserver.SQLServerDatabase.is2012(SQLServerDatabase.java:90)
> at
> org.jooq.util.sqlserver.SQLServerDatabase.getSequences0(SQLServerDatabase.java:245)
> at org.jooq.util.AbstractDatabase.getSequences(AbstractDatabase.java:347)
> at org.jooq.util.JavaGenerator.generateSchema(JavaGenerator.java:1578)
> at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:183)
> at org.jooq.util.JavaGenerator.generate(JavaGenerator.java:174)
> at org.jooq.util.GenerationTool.run(GenerationTool.java:291)
> at org.jooq.util.GenerationTool.main(GenerationTool.java:135)
> at org.jooq.util.GenerationTool.main(GenerationTool.java:122)
> Caused by: java.sql.SQLException: Invalid object name
> 'INFORMATION_SCHEMA.SEQUENCES'.
> at
> net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
> at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2893)
> at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2335)
> at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:638)
> at
> net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
> at
> net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
> at
> net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:784)
> at
> org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:189)
> at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:250)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:298)
> ... 15 more
>
> --
> 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/groups/opt_out.
>
--
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/groups/opt_out.
