first timer - can connect, but select command ends in error.
Brought to you by:
benderd
Menu
▾
▴
#3 first timer - can connect, but select command ends in error.
I just heard about this from midrange-l. I am able to make a connection, but now am getting SQ30020 - Distributed Relational Database Architecture (DRDA) protocol error. x'003' location x'01'
my global.prop settings are:
ard.url.XXXX_MYSQL=jdbc:mysql://xxxx.knapheide.com/purchase_order
ard.driver.XXXX_MYSQL=com.mysql.jdbc.Driver
my sql string is:
select * from po_notes
if you can connect, installation and configuration is fine. Mostly incompatible datatypes could cause problems. First of all try select count(*) po_notes; if this is working you should alter log4j.properties to debug (uncomment the line
log4j.logger.de.bender_dv.ardgate=DEBUG
by removing the # and restart the server. Afterwords have a look to the java log in the directory logs of your install. If you don't find the problem, drop me a mail to my well known eMail adress.
Dieter
problem solved by pm (varchar exceeding max length => cast and substring is working.