When I run this code I get the following error:
java.lang.ArrayIndexOutOfBoundsException
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.clearParameter(JdbcOdbcPreparedStatement.java:1027)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setChar(JdbcOdbcPreparedStatement.java:2788)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setString(JdbcOdbcPreparedStatement.java:775)
at com.veridian.hypergame.BeliefContext.create(BeliefContext.java:174)
at com.veridian.hypergame.Hypergame.createHypergame(Hypergame.java:352)
at com.veridian.hypergame.HypergameQueryFrame.newHypergame(HypergameQueryFrame.java:632)
at com.veridian.hypergame.HypergameQueryFrame.access$1200(HypergameQueryFrame.java:27)
at com.veridian.hypergame.HypergameQueryFrame$11.run(HypergameQueryFrame.java:599)
at java.lang.Thread.run(Thread.java:484)
Here is my code:
public int create( int hypergameId,String date)
{
int tableId = 0;
UtilSql sql = new UtilSql( getUserName(),getUserPassword());
try {
String name = "Belief Context 1 for Hypergame " + hypergameId;
// Create record for new belief context
PreparedStatement insertBeliefContext = null;
String beliefContextDbInsertPS =
"INSERT INTO BeliefContext "
+ "( "
+ "Name"
+ ",SetCount"
+ ",HypergameId"
+ ",DTG"
+ ") "
+ "VALUES"
+ "("
+ " '?'" // Name
+ ", ? " // Set Count
+ ", ? " // Hypergame Id
+ ",'?'" // DTG
+ ")" ;
try
{
insertBeliefContext =
sql.getConnection().prepareStatement(beliefContextDbInsertPS);
insertBeliefContext.setString(1,name);
insertBeliefContext.setInt(2,1); //Set Count
insertBeliefContext.setInt(3,hypergameId); /** Fails HERE
*/
insertBeliefContext.setString(4,date);
}
catch (Exception e)
{
e.printStackTrace ();
System.exit(0);
}
...
Thanks,
Monkeyman
Don't enclose your ? parameter in quotes.
However, the driver should never throw an ArrayIndexOutOfBoundsException. That is a bug.
--
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
===================================================================
* Check out Database Debunkings (http://www.firstsql.com/dbdebunk/)
* "The Forum Where Database Matters Are Set Straight"
Thanks for your help.
Monkeyman
Luck
"Monkeyman" <monkey...@yahoo.com> wrote in message
news:ef004336.01062...@posting.google.com...