|
Home > Archive > WebSphere Commerce suite > December 2005 > Changing commerce developer to use DB2
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Changing commerce developer to use DB2
|
|
|
|
I am having difficulties getting Websphere Commerce-Express Developer to switch to using DB2. I have already done the 'setdbtype db2', and am trying to run createdb.db2. This seems to run fine up to the point where it is attempting to import data from the
xml files. This is when I get the error:
[IBM][CLI Driver][DB2/NT] SQL0204N "JEGSDEV.KEYS" is an undefined name. SQLSTATE=42704
followed by several:
Exception Message: [IBM][CLI Driver] CLI0116E Invalid transaction state. SQLSTATE=25000
This happens for every XML file that the MassLoader is given.
When I look at the Database it looks like the Database and all the Tables were created just fine, except there is no data in the tables that should be populated.
What do I need to do to get the MassLoader to run properly?
DB2 Express v8.1.5.449
WC v5.6.0.4
| |
| Robert Brown 2005-12-16, 6:09 pm |
| This is a schema mismatch with the load utility. When invoking the
massloader you have the option of specifying the schema name
(-schemaname) and if you opt to not include it, the user account will be
used. Check the schema name of the database tables that were created.
Ensure you are using that user to load the data and not JEGSDEV.
Hope this helps.
R
> I am having difficulties getting Websphere Commerce-Express Developer to switch to using DB2. I have already done the 'setdbtype db2', and am trying to run createdb.db2. This seems to run fine up to the point where it is attempting to import data from t
he xml files. This is when I get the error:
> [IBM][CLI Driver][DB2/NT] SQL0204N "JEGSDEV.KEYS" is an undefined name. SQLSTATE=42704
>
> followed by several:
>
> Exception Message: [IBM][CLI Driver] CLI0116E Invalid transaction state. SQLSTATE=25000
>
> This happens for every XML file that the MassLoader is given.
> When I look at the Database it looks like the Database and all the Tables were created just fine, except there is no data in the tables that should be populated.
>
> What do I need to do to get the MassLoader to run properly?
>
> DB2 Express v8.1.5.449
> WC v5.6.0.4
| |
|
| Thanks, I just needed to be pointed in the right direction.
|
|
|
|
|