jdeJDBC Driver doesn't support parameter queries

enorton

Member
jdeJDBC Driver doesn\'t support parameter queries

I've just discovered that the jdeJDBC Driver used to connect to World tables doesn't support parameterized queries. Is anyone aware of a work around to this issue? I'm told this isn't an issue with A9.3 because WW and Dreamwriters are integrated with BI Publisher.

Possible solutions I'm considering:
[*] use jt400.jar w/o jdeJDBC driver. I don't know if this is even possible.
[*] connect to Iseries directly using DB2 odbc connection. I think this will require an Enterprise license.

If anyone else has struggled with this issue, your help would be greatly appreciated.

-----
JD Edwards World A7.3 cume 11
System: Iseries
Database: DB2 UDB 6.1
 
Re: jdeJDBC Driver doesn\'t support parameter queries

Hi,
I have the same trouble.
http://www.jdelist.com/ubb/showflat.php?Cat=0&Board=W&Number=160331&Forum=All_Forums&Words=jdbc&Searchpage=0&Limit=25&Main=160331&Search=true&where=bodysub&Name=&daterange=1&newerval=1&newertype=y&olderval=&oldertype=&bodyprev=#Post160331

Worldsoftware JDBC working, but I have trouble with Codepage. It bad bad for me.

Just now I am going on way to use DB2 driver from IBM. Its working but I have little trouble with EBCDIC conversion. I hope that it is my mistake. (Yes, it is licenced.)

When it will work then I shout prepare some solution how to convert date and amount fields. Worldsoftware format is little strange. I plan use BI Publisher "extension". http://blogs.oracle.com/xmlpublisher/2007/09/26/ I am java novic. It is hard to understand how to.

It is fine to share information with you.
 
Back
Top