Thomas Dudziak wrote:
Could you post the complete stack trace, as it might be an error from the JDBC driver or even the database.
Tom
Tom,
Right!
OK. I've appended two different stack traces below: one for a column name with a space and one with a "-" in that order.
In both cases the exception cuase is the same:
Caused by: java.sql.SQLException: Invalid column name
However, they begin at two different places within JTDS.
Is it possible that OJB is stripping the square brackets off of the column name? I suppose that I could try writing some JDBC code and going directly to the JTDS driver to better isolate the problem. Any other suggestions?
Final note, the repository segment provided in my original post was from an earlier version of the file. The column names ARE enclosed in []s in the actual file being used.
thanks! John
========================================================================================== Column Name with space stack trace ==========================================================================================
99389 ERROR [main] rio.Lerg7DAO - PersistenceBrokerException thrown in Lerg7DAO.findByClli8().
org.apache.ojb.broker.PersistenceBrokerSQLException: SQLException during the execution of the query (for com.ascenditsolutions.lca.model.vo.rio.Lerg7VO): Invalid column name 'eff'.
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:349)
at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:185)
at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1918)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1493)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1620)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)
at com.ascenditsolutions.lca.model.dao.rio.Lerg7DAO.findByClli8(Lerg7DAO.java:263)
at com.ascenditsolutions.lca.invoice.csr.CktCklNode.loadHVCoords(CktCklNode.java:283)
at com.ascenditsolutions.lca.invoice.csr.CktCklNode.<init>(CktCklNode.java:114)
at com.ascenditsolutions.lca.invoice.csr.CsrCircuit.addCklNode(CsrCircuit.java:460)
at com.ascenditsolutions.lca.invoice.csr.CsrCircuit.addNode(CsrCircuit.java:441)
at com.ascenditsolutions.lca.invoice.csr.CsrCircuit.extractCsrAccountRecordData(CsrCircuit.java:324)
at com.ascenditsolutions.lca.invoice.csr.CsrCircuit.initialize(CsrCircuit.java:236)
at com.ascenditsolutions.lca.invoice.csr.CsrClsCircuit.<init>(CsrClsCircuit.java:31)
at com.ascenditsolutions.lca.invoice.csr.CsrCircuitFactory.getCsrCircuit(CsrCircuitFactory.java:64)
at com.ascenditsolutions.lca.invoice.csr.CsrCircuitFactory.getCsrCircuit(CsrCircuitFactory.java:127)
at com.ascenditsolutions.lca.invoice.circuit.InvoiceCircuit.getCsrCircuit(InvoiceCircuit.java:149)
at com.ascenditsolutions.lca.invoice.circuit.InvoiceCircuit.getUsocs(InvoiceCircuit.java:192)
at com.ascenditsolutions.lca.invoice.validation.CircuitValidator.validate(CircuitValidator.java:88)
at com.ascenditsolutions.lca.invoice.validation.InvoiceValidation.validate(InvoiceValidation.java:104)
at com.ascenditsolutions.lca.invoicevalidator.InvoiceValidator.validateInvoice(InvoiceValidator.java:172)
at com.ascenditsolutions.lca.invoicevalidator.LcaQueuedInvoiceValidator.run(LcaQueuedInvoiceValidator.java:98)
at com.ascenditsolutions.lca.invoicevalidator.LcaQueuedInvoiceValidator.main(LcaQueuedInvoiceValidator.java:44)
Caused by: java.sql.SQLException: Invalid column name 'eff'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2778)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2214)
at net.sourceforge.jtds.jdbc.TdsCore.clearResponseQueue(TdsCore.java:697)
at net.sourceforge.jtds.jdbc.TdsCore.submitSQL(TdsCore.java:864)
at net.sourceforge.jtds.jdbc.TdsCore.microsoftPrepare(TdsCore.java:1093)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:537)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:664)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:312)
... 25 more
========================================================================================== Column Name with "-" stack trace ==========================================================================================
235300 ERROR [main] rio.Lerg7DAO - PersistenceBrokerException thrown in Lerg7DAO.findByClli8().
org.apache.ojb.broker.PersistenceBrokerException: Error reading class type: com.ascenditsolutions.lca.model.vo.rio.Lerg7VO from result set, current read field was vCoord
at org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.readValuesFrom(RowReaderDefaultImpl.java:231)
at org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.readObjectArrayFrom(RowReaderDefaultImpl.java:199)
at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterator.java:450)
at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:275)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1636)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)
at com.ascenditsolutions.lca.model.dao.rio.Lerg7DAO.findByClli8(Lerg7DAO.java:263)
at com.ascenditsolutions.lca.invoice.csr.CktCklNode.loadHVCoords(CktCklNode.java:283)
at com.ascenditsolutions.lca.invoice.csr.CktCklNode.<init>(CktCklNode.java:114)
at com.ascenditsolutions.lca.invoice.csr.CsrCircuit.addCklNode(CsrCircuit.java:460)
at com.ascenditsolutions.lca.invoice.csr.CsrCircuit.addNode(CsrCircuit.java:441)
at com.ascenditsolutions.lca.invoice.csr.CsrCircuit.extractCsrAccountRecordData(CsrCircuit.java:324)
at com.ascenditsolutions.lca.invoice.csr.CsrCircuit.initialize(CsrCircuit.java:236)
at com.ascenditsolutions.lca.invoice.csr.CsrRidingHighCapClsCircuit.<init>(CsrRidingHighCapClsCircuit.java:30)
at com.ascenditsolutions.lca.invoice.csr.CsrCircuitFactory.getCsrCircuit(CsrCircuitFactory.java:73)
at com.ascenditsolutions.lca.invoice.csr.CsrCircuitFactory.getCsrCircuit(CsrCircuitFactory.java:127)
at com.ascenditsolutions.lca.invoice.circuit.InvoiceCircuit.getCsrCircuit(InvoiceCircuit.java:149)
at com.ascenditsolutions.lca.invoice.circuit.InvoiceCircuit.getUsocs(InvoiceCircuit.java:192)
at com.ascenditsolutions.lca.invoice.validation.CircuitValidator.validate(CircuitValidator.java:88)
at com.ascenditsolutions.lca.invoice.validation.InvoiceValidation.validate(InvoiceValidation.java:104)
at com.ascenditsolutions.lca.invoicevalidator.InvoiceValidator.validateInvoice(InvoiceValidator.java:172)
at com.ascenditsolutions.lca.invoicevalidator.LcaQueuedInvoiceValidator.run(LcaQueuedInvoiceValidator.java:98)
at com.ascenditsolutions.lca.invoicevalidator.LcaQueuedInvoiceValidator.main(LcaQueuedInvoiceValidator.java:44)
Caused by: java.sql.SQLException: Invalid column name [v-coord].
at net.sourceforge.jtds.jdbc.JtdsResultSet.findColumn(JtdsResultSet.java:938)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getString(JtdsResultSet.java:1173)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:216)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:216)
at org.apache.ojb.broker.metadata.JdbcTypesHelper$T_Varchar.readValueFromResultSet(JdbcTypesHelper.java:404)
at org.apache.ojb.broker.metadata.JdbcTypesHelper$BaseType.getObjectFromColumn(JdbcTypesHelper.java:324)
at org.apache.ojb.broker.metadata.JdbcTypesHelper$BaseType.getObjectFromColumn(JdbcTypesHelper.java:303)
at org.apache.ojb.broker.accesslayer.RowReaderDefaultImpl.readValuesFrom(RowReaderDefaultImpl.java:224)
... 23 more
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
