Actually, I'm not sure why I pointed you to the "snapshot" jars for 10.0.2 when
there is a set of 10.0.2.1 _release_ jars that would be more appropriate:
http://incubator.apache.org/derby/derby_downloads.html#Incubator+Releases
Sorry for the miscue,
Army
Army wrote:
Wolverine wrote:
i m using cloudscape 10.0.1 on linux redhat 9. with unixODBC
apache n php
i have created a table and in mytest.php m displaying the contents of
the table.
i have successfully done it but if i go on refreshing the page several
times sometimes it gives the following error and again on the next
attempt it runs well. then again after sometime it gives the error
again. is there something wrong with my installation
Warning: SQL error: [unixODBC][IBM][CLI Driver] SQL0902C A system
error (reason code = "") occurred. Subsequent SQL statements cannot be
processed. SQLSTATE=58005 , SQL state 58005 in SQLConnect in
mytest.php on line 5
This sounds like it could be related to some protocol chaining issues
that existed in early 10.0.1 releases but were fixed in 10.0.2. The
JIRA issue for this was DERBY-35 and the fix was checked into 10.0.2
codeline back in October of last year.
If you can run:
java org.apache.derby.tools.sysinfo
and post the output here, that would allow us to check whether or not
the jars you have include the fix for the problem. I'm guessing they
don't since, as I said, the fix didn't go in until 10.0.2, but it
wouldn't hurt to see your sysinfo, just in case.
If this is a result of the problem that was fixed in DERBY-35, then I
guess your best option would be to get a more recent set of jars--there
are three sets of "snapshot" jars for 10.0.2 available from the Derby
download site (http://incubator.apache.org/derby/derby_downloads.html),
so you could just grab one of those and see if the problem goes away.
If you get the 10.0.2 jars and still see the problem, then please post
again and we can look at this more closely.
Hope that helps,
Army
