title: Sybase Error Implicit Conversion from datatype 'VARCHAR' to 'INT' not allowed
body: <p>I'm getting this error when trying to run a query in my application and I'm not sure why:</p>
  
  <pre><code>Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed.  Use the CONVERT function to run this query.
  
  at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
  at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
  at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
  at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
  at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
  at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
  at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
  at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source)
  at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:678)
  at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
  at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
  at org.hibernate.loader.Loader.doQuery(Loader.java:802)
  at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
  at org.hibernate.loader.Loader.doList(Loader.java:2533)
  ... 79 more
  </code></pre>
  
  <p>No where in my code am I trying to convert a VARCHAR into an INT.</p>
  
  <p>Database View Columns  --> Java type:</p>
  
  <pre><code>INT --&gt; Integer
  VARCHAR --&gt; String
  INT --&gt; Long
  VARCHAR --&gt; a POJO
  FLOAT --&gt; Double
  DATE --&gt; Date
  </code></pre>
  
  <p>Is there anything else that may cause this error??</p>