[vwnc] StoreForMySQL: getParamCountExternal fails "bad handle"

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[vwnc] StoreForMySQL: getParamCountExternal fails "bad handle"

Thomas Gagné-2
I'm trying to publish a package and have gotten to the point of
inserting data into the database.  The SQL is:

INSERT INTO store.TW_Blob ( primaryKey , blobType , blobData  )  VALUES
(:primaryKey, :getBlobType, :getBlobData)

The subsequent statement also seems to complain "bad handle" on the call
to mysql_stmt_close().  Perhaps there's a library problem?

--
Visit <http://tggagne.blogspot.com/> for more great reading.

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
Reply | Threaded
Open this post in threaded view
|

Re: [vwnc] StoreForMySQL: getParamCountExternal fails "bad handle"

Thomas Gagné-2
Turns out error from MySQL aren't being handled well--but that could be
my problem

Anyway, the original problem is "Column 'primaryKey' can not be null."  
The Blob for the package, I noticed, has a nil primaryKey.  It kind of
makes sense since this is the first package to be installed into the
empty database.

I remember reading somewhere that Store needs to be told how to handle
keys.  I need to go find that again.

--
Visit <http://tggagne.blogspot.com/> for more great reading.

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc