Hi Chad,
The errors were different in the different cases.
I am providing the requested information:
Kind regards:
al_shopov
1. I am using Beehive 1.0.2
2. PostgresSQL 8.2
3. Sun JDK 1.5
4. apache-tomcat-5.5.23
5. JDBC driver - postgresql-8.1-408.jdbc3.jar
Relevant JDBC control source:
-----------------------------
@SQL(statement="insert into test (id, date) values ({id}, {date})")
public void insertIntoTestString(int id, String date);
@SQL(statement="insert into test (id, date) values ({id}, {d {date}})")
public void insertIntoTestStringEscaped(int id, String date);
@SQL(statement="insert into test (id, date) values ({id}, {date})")
public void insertIntoTestDate(int id, Date date);
@SQL(statement="insert into test (id, date) values ({id}, {d {date}})")
public void insertIntoTestDateEscaped(int id, Date date);
Relevent Controller source:
------------------------------
@Jpf.Action(forwards = { @Jpf.Forward(name = "success", path =
"showDates.jsp")})
public Forward processDate(){
int i = invoiceControl.getMaxIdTest();
java.sql.Date nullDate = null;
String emptyString = "";
String nullString = null;
i++;
try {invoiceControl.insertIntoTestDate(i, nullDate);}
catch (Exception e) {log.error("insertIntoTestDate -
nullDate", e);}
i++;
try {invoiceControl.insertIntoTestDateEscaped(i, nullDate);}
catch (Exception e) {log.error("insertIntoTestDateEscaped -
nullDate", e);}
i++;
try {invoiceControl.insertIntoTestString(i, nullString);}
catch (Exception e) {log.error("insertIntoTestString -
nullString", e);}
i++;
try {invoiceControl.insertIntoTestStringEscaped(i, nullString);}
catch (Exception e) {log.error("insertIntoTestStringEscaped -
nullString", e);}
i++;
try {invoiceControl.insertIntoTestString(i, emptyString);}
catch (Exception e) {log.error("insertIntoTestString -
emptyString", e);}
i++;
try {invoiceControl.insertIntoTestStringEscaped(i,
emptyString);}
catch (Exception e) {log.error("insertIntoTestStringEscaped -
emptyString", e);}
Map[] m = invoiceControl.getAllDates();
Forward f = new Forward("success");
f.addActionOutput("list", m);
return f;
}
Relevant log messages, I've cut out some of the stactrace and have substituted
with .... ....:
--------------------------------
2007-07-18 13:57:50,314 ERROR esign.invoices.admin.Controller -
insertIntoTestDate - nullDate
java.lang.reflect.UndeclaredThrowableException
at
eu.horizon_it.invoices.controls.InvoiceControlBean.insertIntoTestDate(InvoiceControlBean.java:249)
at esign.invoices.admin.Controller.processDate(Controller.java:244)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
.... ....
Caused by: org.postgresql.util.PSQLException: ERROR: column "date" is of type
date but expression is of type character varying
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)
at
org.apache.beehive.controls.system.jdbc.JdbcControlImpl.execPreparedStatement(JdbcControlImpl.java:290)
at
org.apache.beehive.controls.system.jdbc.JdbcControlImpl.invoke(JdbcControlImpl.java:224)
at
eu.horizon_it.invoices.controls.InvoiceControlBean.insertIntoTestDate(InvoiceControlBean.java:234)
... 41 more
2007-07-18 13:57:50,317 ERROR esign.invoices.admin.Controller -
insertIntoTestDateEscaped - nullDate
java.lang.reflect.UndeclaredThrowableException
at
eu.horizon_it.invoices.controls.InvoiceControlBean.insertIntoTestDateEscaped(InvoiceControlBean.java:405)
at esign.invoices.admin.Controller.processDate(Controller.java:248)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
.... ....
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near
"$2"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)
at
org.apache.beehive.controls.system.jdbc.JdbcControlImpl.execPreparedStatement(JdbcControlImpl.java:290)
at
org.apache.beehive.controls.system.jdbc.JdbcControlImpl.invoke(JdbcControlImpl.java:224)
at
eu.horizon_it.invoices.controls.InvoiceControlBean.insertIntoTestDateEscaped(InvoiceControlBean.java:390)
... 41 more
2007-07-18 13:57:50,320 ERROR esign.invoices.admin.Controller -
insertIntoTestString - nullString
java.lang.reflect.UndeclaredThrowableException
at
eu.horizon_it.invoices.controls.InvoiceControlBean.insertIntoTestString(InvoiceControlBean.java:524)
at esign.invoices.admin.Controller.processDate(Controller.java:252)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
.... ....
Caused by: org.postgresql.util.PSQLException: ERROR: column "date" is of type
date but expression is of type character varying
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)
at
org.apache.beehive.controls.system.jdbc.JdbcControlImpl.execPreparedStatement(JdbcControlImpl.java:290)
at
org.apache.beehive.controls.system.jdbc.JdbcControlImpl.invoke(JdbcControlImpl.java:224)
at
eu.horizon_it.invoices.controls.InvoiceControlBean.insertIntoTestString(InvoiceControlBean.java:509)
... 41 more
2007-07-18 13:57:50,323 ERROR esign.invoices.admin.Controller -
insertIntoTestStringEscaped - nullString
java.lang.reflect.UndeclaredThrowableException
at
eu.horizon_it.invoices.controls.InvoiceControlBean.insertIntoTestStringEscaped(InvoiceControlBean.java:368)
at esign.invoices.admin.Controller.processDate(Controller.java:256)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
.... ....
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near
"$2"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)
at
org.apache.beehive.controls.system.jdbc.JdbcControlImpl.execPreparedStatement(JdbcControlImpl.java:290)
at
org.apache.beehive.controls.system.jdbc.JdbcControlImpl.invoke(JdbcControlImpl.java:224)
at
eu.horizon_it.invoices.controls.InvoiceControlBean.insertIntoTestStringEscaped(InvoiceControlBean.java:353)
... 41 more
2007-07-18 13:57:50,327 ERROR esign.invoices.admin.Controller -
insertIntoTestString - emptyString
java.lang.reflect.UndeclaredThrowableException
at
eu.horizon_it.invoices.controls.InvoiceControlBean.insertIntoTestString(InvoiceControlBean.java:524)
at esign.invoices.admin.Controller.processDate(Controller.java:260)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
.... ....
Caused by: org.postgresql.util.PSQLException: ERROR: column "date" is of type
date but expression is of type character varying
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)
at
org.apache.beehive.controls.system.jdbc.JdbcControlImpl.execPreparedStatement(JdbcControlImpl.java:290)
at
org.apache.beehive.controls.system.jdbc.JdbcControlImpl.invoke(JdbcControlImpl.java:224)
at
eu.horizon_it.invoices.controls.InvoiceControlBean.insertIntoTestString(InvoiceControlBean.java:509)
... 41 more
2007-07-18 13:57:50,343 ERROR esign.invoices.admin.Controller -
insertIntoTestStringEscaped - emptyString
java.lang.reflect.UndeclaredThrowableException
at
eu.horizon_it.invoices.controls.InvoiceControlBean.insertIntoTestStringEscaped(InvoiceControlBean.java:368)
at esign.invoices.admin.Controller.processDate(Controller.java:264)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
.... ....
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near
"$2"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)
at
org.apache.beehive.controls.system.jdbc.JdbcControlImpl.execPreparedStatement(JdbcControlImpl.java:290)
at
org.apache.beehive.controls.system.jdbc.JdbcControlImpl.invoke(JdbcControlImpl.java:224)
at
eu.horizon_it.invoices.controls.InvoiceControlBean.insertIntoTestStringEscaped(InvoiceControlBean.java:353)
... 41 more
