I'm trying to set up a client variable repository using DB2 7.1 on Red Hat Linux 7,
Apache 1.3.14. After I create and verify the datasource successfully, when I attempt
to set up the database for client variable storage and create the necessary tables, I
receive this error message:
"Unable to create client tables If they already exist, you should uncheck Create
Client Tables. DB2 Error Code = -604
[IBM][CLI Driver][DB2/LINUX] SQL0604N The length, precision, or scale attribute for
column, distinct type, structured type, attribute of structured type, function, or
type mapping "DATA" is not valid. SQLSTATE=42611"
Since the automatic creation doesn't work, I set up the 2 tables manually, with the
following fields: CDATA - cfid char 20, app char 64, data long varchar; CGLOBAL - cfid
char 20, data long varchar, lvisit timestamp (also tried date).
I attempt to use my application, and when it's time to submit a form, I receive this
error message:
"DB2 Error Code = -104
[IBM][CLI Driver][DB2/LINUX] SQL0104N An unexpected token "2001" was found following
"15:23:26''}#','{ts '". Expected tokens may include: "". SQLSTATE=42601"
At the bottom of the error page is this: "Found The document has moved here." - with
the word 'here' correctly hyperlinked to the page that the form was supposed to
return.
It looks like data is being written to the CDATA table, but not the CGLOBAL table.
The application will eventually sit on clustered servers, so that's why we're going
the database repository route.
As a workaround, we've installed MySql and are successfully using that as the client
variable repository, but ideally we'd like to use DB2 for both the data and client
variables.
Does anyone have any experience or advice with this? Thanks.
--
Nikki Woelk
Faludi Computing, Inc. (415) 512-8212
[EMAIL PROTECTED] http://www.faludicomputing.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
