It seems like you are on to something with the version differerences, I didn't realize I have been using two library versions (stupid me :() I'm going to try and use the non-snapshot 2.5.0 release and regenerate the schema, I'll post back how it turns out.
Thanks for the help ! On Wednesday, September 12, 2012 11:43:39 AM UTC+2, Lukas Eder wrote: > > Hello, > > What's curious is this error message: > > > Caused by: org.jooq.exception.DataTypeException: Cannot convert from > 0201 (class java.lang.String) to class > nl.abbabab.tables.records.EmployeeRecord > > I don't see any reference to an EmployeeRecord in your generated POJO. > Why would jOOQ try to convert the employeeId to an EmployeeRecord? Can > you provide me with the full stack trace? > Note (maybe unrelated), your generated class was generated with jOOQ > 2.4.0, whereas your stacktrace indicates that you're using a SNAPSHOT > version of jOOQ 2.5.0 > > Cheers > Lukas > > 2012/9/12 Rick van Biljouw <[email protected] <javascript:>>: > > Hi, > > > > A sample T class would be this one: > >>> > >>> /** > >>> > >>> * This class is generated by jOOQ > >>> > >>> */ > >>> > >>> package nl.abbaba.tables.pojos; > >>> > >>> > >>> /** > >>> > >>> * This class is generated by jOOQ. > >>> > >>> */ > >>> > >>> @javax.annotation.Generated(value = {"http://www.jooq.org";, > "2.4.0"}, > >>> > >>> comments = "This class is generated by > jOOQ") > >>> > >>> public class LaborTicket implements java.io.Serializable { > >>> > >>> > >>> private static final long serialVersionUID = 1821013766; > >>> > >>> > >>> private java.lang.Integer rowid; > >>> > >>> private java.lang.Integer transactionId; > >>> > >>> private java.lang.String employeeId; > >>> > >>> private java.lang.String departmentId; > >>> > >>> > >>> public java.lang.Integer getRowid() { > >>> > >>> return this.rowid; > >>> > >>> } > >>> > >>> > >>> public void setRowid(java.lang.Integer rowid) { > >>> > >>> this.rowid = rowid; > >>> > >>> } > >>> > >>> > >>> public java.lang.Integer getTransactionId() { > >>> > >>> return this.transactionId; > >>> > >>> } > >>> > >>> > >>> public void setTransactionId(java.lang.Integer transactionId) { > >>> > >>> this.transactionId = transactionId; > >>> > >>> } > >>> > >>> > >>> public java.lang.String getEmployeeId() { > >>> > >>> return this.employeeId; > >>> > >>> } > >>> > >>> > >>> public void setEmployeeId(java.lang.String employeeId) { > >>> > >>> this.employeeId = employeeId; > >>> > >>> } > >>> > >>> > >>> public java.lang.String getDepartmentId() { > >>> > >>> return this.departmentId; > >>> > >>> } > >>> > >>> > >>> public void setDepartmentId(java.lang.String departmentId) { > >>> > >>> this.departmentId = departmentId; > >>> > >>> } > >>> > >>> } > >> > >> > > This class was generated by using jooQ's code generator with the "pojos" > > attribute enabled in the configuration. > > The field employeeId relates to a primary key column in the Employee > table > > (which isn't actually fetched in this use case, but hard-coded.) > > Whenever I create a new instance of this POJO and give it a value for > the > > employeeId which really is valid, it throws an exception whenever I try > to > > create a record from it > > by using SQLServerFactory.newRecord(Tables.LABOR_TICKET, > > instanceOfLaborTicket). > > In the sample I posted, the generic type R represents an > > UpdatableRecordImpl. > > > > I hope this gives somewhat of an idea of what I am trying to do here.. > > > > On Tuesday, September 11, 2012 4:02:55 PM UTC+2, Lukas Eder wrote: > >> > >> Hello, > >> > >> Can you post more code? E.g. a sample T class (entity). As well as the > >> code that is used to produce this problem? > >> > >> Cheers > >> Lukas > >> > >> 2012/9/11 Rick van Biljouw <[email protected]>: > >> > Hi, > >> > > >> > I'm trying to create a record using POJOs. > >> > For that purpose I have the following piece of code: > >> >>> > >> >>> /** > >> >>> > >> >>> * Creates a record from a POJO. > >> >>> > >> >>> * > >> >>> > >> >>> * @param pojo > >> >>> > >> >>> * POJO to use for record. > >> >>> > >> >>> * @return record > >> >>> > >> >>> */ > >> >>> > >> >>> @SuppressWarnings({ "unchecked" }) > >> >>> > >> >>> private <R extends Record> R newRecord(T entity) { > >> >>> > >> >>> R record = (R) getFactory().newRecord(getTable(), entity); > >> >>> > >> >>> return record; > >> >>> > >> >>> } > >> > > >> > > >> > The POJOs I have are generated by codegen, sadly enough using this > code > >> > together with one of the POJOs results in the following exception > being > >> > thrown: > >> >>> > >> >>> Caused by: org.jooq.exception.DataTypeException: Cannot convert > from > >> >>> 0201 > >> >>> (class java.lang.String) to class > >> >>> nl.abbabab.tables.records.EmployeeRecord > >> >>> > >> >>> at org.jooq.tools.Convert$ConvertAll.fail(Convert.java:610) > >> >>> ~[jooq-2.5.0-SNAPSHOT.jar:na] > >> >>> > >> >>> at org.jooq.tools.Convert$ConvertAll.from(Convert.java:564) > >> >>> ~[jooq-2.5.0-SNAPSHOT.jar:na] > >> >>> > >> >>> at org.jooq.tools.Convert.convert0(Convert.java:208) > >> >>> ~[jooq-2.5.0-SNAPSHOT.jar:na] > >> >>> > >> >>> at org.jooq.tools.Convert.convert(Convert.java:200) > >> >>> ~[jooq-2.5.0-SNAPSHOT.jar:na] > >> >>> > >> >>> at org.jooq.tools.Convert.convert(Convert.java:259) > >> >>> ~[jooq-2.5.0-SNAPSHOT.jar:na] > >> >>> > >> >>> at > >> >>> org.jooq.impl.AbstractRecord.getValue(AbstractRecord.java:569) > >> >>> ~[jooq-2.5.0-SNAPSHOT.jar:na] > >> > > >> > > >> > I'm really at a loss here as to what is causing it.. > >> > If anyone could tell me where to look to resolve this problem I would > >> > appreciate it. >
