SQL built-in functions in PreparedStatement?

[Antonio Giovanni]

This kind of a PreparedStatement is throwing an exception..

 INSERT INTO LIBRARYNAME.TABNAME VALUES (?,?,?,?,TIME(?),TIME(?),?,?,?,NOW(),?) 

I have never tried anything like this before,.. but curious to know if this is ok..or not..?? I appreciate your help..
At the same time, i'll also see what the cause of the exception is..

Thanks again
[ August 04, 2005: Message edited by: Bear Bibeault ]

[Makarand Parab]

What exception is it throwing? Can you please submit that so that we can know the exact problem.

Personally i feel the PreparedStatement is creating the problem
INSERT INTO LIBRARYNAME.TABNAME VALUES (?,?,?,?,TIME(?),TIME(?),?,?,?,NOW(),?)

Regards
Makarand Parab

[Antonio Giovanni]

 [8/4/05 12:12:42:481 CDT] 36aa36aa SystemErr     R java.sql.SQLException: [SQL0418] Use of parameter marker not valid.
[8/4/05 12:12:42:496 CDT] 36aa36aa SystemErr     R at java.lang.Throwable.<init>(Throwable.java:54)
[8/4/05 12:12:42:496 CDT] 36aa36aa SystemErr     R at java.lang.Throwable.<init>(Throwable.java:68)
[8/4/05 12:12:42:496 CDT] 36aa36aa SystemErr     R at java.sql.SQLException.<init>(SQLException.java:51)
[8/4/05 12:12:42:496 CDT] 36aa36aa SystemErr     R at com.ibm.as400.access.JDError.throwSQLException(JDError.java:520)
[8/4/05 12:12:42:496 CDT] 36aa36aa SystemErr     R at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1363) 

I am actually using DB2 UDB.. some casting issue.. !!..

[Makarand Parab]

Hi
That exception is because
INSERT INTO LIBRARYNAME.TABNAME VALUES (?,?,?,?,TIME(?),TIME(?),?,?,?,NOW(),?)
is not allowed
it should be
INSERT INTO LIBRARYNAME.TABNAME VALUES (?,?,?,?,?,?,?,?,?,?,?)
and then pass the value.

Regards
Makarand Parab

[Antonio Giovanni]

ohh ok.. I am just curious to see if i can do that..
and if it is possible to include SQL built-in functions in
the prepared stmt

Anyway thanks

[Antonio Giovanni]

Just to mention:

INSERT INTO LIBRARYNAME.TABNAME VALUES (?,?,?,?,?,?,?,?,?,NOW(),?)

The above Works fine... No problem.. The Time fields i am sending
java.sql.Time values..

[Jeanne Boyarsky]

Antonio,
When you call TIME(?), are you still passing it a java.sql.Time object? If so, this would explain the casting error. TIME() coverts a var char to a time and therefore expects a String.

[Antonio Giovanni]

Jeanne,

well when i am calling TIME(?), i am actually passing a String value.

Anyway atleast it confirmed to me that i can indeed call SQL built-in functions in PreparedStatement, that was my main question, since it allowed me calling a NOW() function.

Probably the TIME() was giving error because of some casting issue.. maybe it should be like CAST(? AS TIME). I will try this sometime today or in the week-end

Thanks