Hi Sha, The reference TBL_STUDENTS is contained in two Java types:
- com.example.generated.Tables.TBL_STUDENTS - com.example.generated.tables.TblStudents.TBL_STUDENTS This goes along well with what is documented in the tutorial here, where all static objects from test.generated.Tables.* are imported: // For convenience, always static import your generated tables and jOOQ functions to decrease verbosity:import static test.generated.Tables.*;import static org.jooq.impl.DSL.*; From: http://www.jooq.org/doc/3.2/manual/getting-started/tutorials/jooq-in-7-steps/jooq-in-7-steps-step4/ Cheers Lukas 2014/1/17 Sha <[email protected]> > Hi Lukas, > I have a scenario as following. > > 1) created a table TBL_STUDENTS in DB. > 2) inserted records in the table in the DB. > > Now using JOOQ code generator i generated code for that table. > > i wrote a stand alone program in java, got the connection. > But when i am trying to fetch the records using the code as below > > > Result<Record> result = ctx.select().from(TBL_STUDENTS).fetch(); > for (Record r : result) { > Long id = r.getValue(TBL_STUDENTS.ID); > String firstName = r.getValue(TBL_STUDENTS.FIRST_NAME); > String lastName = r.getValue(TBL_STUDENTS.LAST_NAME); > } > > > It is not recognizing TBL_STUDENTS. > > As did a static import of the package where the tables generated. > still it is not able to recognize the TBL_STUDENTS. > What should i do ? > > -- > 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.
