spring 查询出现问题 queryForMap

bjqincy 2009-04-07 04:03:31

我写了一个spring JdbcTemple

public Map<Gps, LonLat> selectLonLatByGpsId(String GpsID, String startTime,

			String endTime) {

		

		String sql = "select t.gpsid,t.x,t.y "+

                     "from gps_track t "+

                     "where t.gpsid='?' and "+

                     "t.gpstime>=to_date('?','yyyy-mm-dd hh24:mi:ss') "+

                     "and t.gpstime<=to_date('?','yyyy-mm-dd hh24:mi:ss')";

		System.out.println(sql);

		Object[] params = new Object[] { GpsID, startTime, endTime };

        return this.getJdbcTemplate().queryForMap(sql,params);

出现错误



log4j:WARN No appenders could be found for logger (org.springframework.context.support.ClassPathXmlApplicationContext).

log4j:WARN Please initialize the log4j system properly.

select t.gpsid,t.x from gps_track t where t.gpsid='?' and t.gpstime>=to_date('?','yyyy-mm-dd hh24:mi:ss') and t.gpstime<=to_date('?','yyyy-mm-dd hh24:mi:ss')

Exception in thread "main" org.springframework.jdbc.InvalidResultSetAccessException: PreparedStatementCallback; invalid ResultSet access for SQL [select t.gpsid,t.x from gps_track t where t.gpsid='?' and t.gpstime>=to_date('?','yyyy-mm-dd hh24:mi:ss') and t.gpstime<=to_date('?','yyyy-mm-dd hh24:mi:ss')]; nested exception is java.sql.SQLException: 无效的列索引

	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:224)

	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)

	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)

	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)

	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)

	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:721)

	at org.springframework.jdbc.core.JdbcTemplate.queryForMap(JdbcTemplate.java:740)

	at com.founder.gjfp.gis.track.impl.TrackDAO.selectLonLatByGpsId(TrackDAO.java:31)

	at com.founder.gjfp.gis.track.impl.TrackDAO.main(TrackDAO.java:39)

Caused by: java.sql.SQLException: 无效的列索引

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161)

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:226)

	at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:4595)

	at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:4558)

	at org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:335)

	at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:217)

	at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:145)

	at org.springframework.jdbc.core.ArgPreparedStatementSetter.setValues(ArgPreparedStatementSetter.java:51)

	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:646)

	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)

	... 7 more