XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Can't Connect to iSeries via IBM DB2
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + XXX maps to XXX system (3)
-> + Help with extracting bookmarks... (2)
-> + Stylus Studio crashes when sou... (2)
-> + WSDL not Displaying properly (5)
-> + How to use fonts other than ba... (5)
-> + Saxon XSLT2 and FOP for XSL:FO... (3)
-> + Converting from XML to EDIFACT (5)
-> + Looping more than one time thr... (2)
-> - Need help with using XQuery in... (1)
-> + Looping - Taking the comma out (3)
-> + xslt mapper is only processing... (4)
-> - Newbie: using Saxon 9.1 with F... (1)
-> + Editing ![CDATA[]]> in the Gr... (2)
-> + Convertic EDI files into XML (7)
-> + Type2 Authentication missing D... (6)
-> + Please help in a simple conver... (5)
-> + Doc/Literal Wrapped (4)
-> + Error starting Stylus Studio (9)
-> + WYSIWYG Menu Bar and Tab Missi... (2)
-> + XML file size limits (2)
-> + XML Publisher (2)
-> + cant get namespace declaration... (5)
-> + Fixed Width to XML (3)
-> - file to xml conversion (1)
-> + Create Multiple Page (3)
-> + Flat file conversion with colu... (3)
-> + New Line character problem in ... (2)
-> + need help - stylus doesn't sta... (2)
-> + command line StylusValidator ... (3)
-> + Help unistalling (2)
-> + recurse problem analysis (3)
-> - Newbie: WSAD and file paths (1)
-> - Stylus StudioŽ 2009 XML Enterp... (1)
-> + Help with XSL to transform two... (4)
-> + connect to xhive (2)
-> - element id and name attributes... (1)
-> - http://www.w3.org/2001/XMLSche... (1)
-> + Error message when converting ... (2)
-> + XML id and anyuri datatype (2)
-> - import xml into an ms acces... (1)
-> + Change version (6)
-> + Translate two files into one (3)
-> + invalid relative uri with data... (7)
-> + My table crashes java Runtime (5)
-> + inx to pdf (3)
-> + XSD - multiple similar namespa... (7)
-> + validating many xml files (4)
-> + Stylesheet Parameters (3)
-> + create web service using Stylu... (2)
-> + connect with sql server (4)
-> + License could not be validated... (2)
-> + How to open (or decompress) a ... (3)
-> + Stylus Studio 2009 Home & Java (4)
-> + Connect to Informix DB 7.31.FD... (2)
-> + Unable to download stylus stud... (5)
-> + conversion CSV to XML (2)
-> + Please help to create a XSL to... (2)
-> + Stylus Studio 2009 unresponsiv... (3)
-> + Stylus Studio 2009 and IBM Jav... (2)
-> + separate one record to two lin... (3)
-> + error when running xquery comm... (6)
-> + Convert ebcdic-cp-us to utf-8 (8)
-> - hi urgent plz (1)
-> + Java compile problem (7)
-> + How to set pattern match on th... (3)
-> + Adobe Illustrator CS4 xml not ... (3)
-> + validating XSD with W3c stand... (2)
-> + Count function with condition ... (2)
-> + [Context] variable (4)
-> + Batch process HTML to XML docu... (2)
-> + Need help with adding logiic ... (2)
-> - BUG when editing File Types (1)
-> + Is Stylus Studio XML authoring... (2)
-> + Missing Xpath Query Editor (8)
-> + Error Connecting to DB2 9.5 (3)
-> - Tony (1)
-> + Problem trying to use your sof... (2)
-> + cannot save or associate a sch... (2)
-> + xsd to dtd (2)
-> + Can we use Stylus for our proj... (4)
-> + printing a parent node value i... (2)
-> + How to tell StylusDiff.exe to ... (4)
-> + Pipeline Messages not Consiten... (2)
-> + Custom XML conversion (2)
-> + Format date fields (3)
-> - Can't Connect to iSeries via I... (11)
-> ->Can't Connect to iSeries ...
-> ->Can't Connect to iSeries ...
-> ->Can't Connect to iSeries ...
-> ->Can't Connect to iSeries ...
-> ->Can't Connect to iSeries ...
-> ->Can't Connect to iSeries ...
-> ->Can't Connect to iSeries ...
-> ->Can't Connect to iSeries ...
-> ->Can't Connect to iSeries ...
-> ->Can't Connect to iSeries ...
-> + "application failed to start" ... (5)
-> - Can't connect to an Access DB ... (1)
-> + Unable to attach external JVM (3)
-> + Adding Numbers using XSLT (2)
-> + copy all elements and hardcode... (2)
-> + A bit confused on where to sta... (2)
-> + Application Menu Problem (14)
-> + API to retrieve 'Adapter URL' ... (2)
-> + How do I move my Stylus Studio... (6)
-> + API to retrieve 'Adapter URL' ... (2)
-> + InterPage Linking Problem in .... (2)
-> + xsl - header only once in fore... (7)
-> + StylusDiff.exe crashes when co... (5)
-> + Validation against schemas wan... (5)
-- Previous [781-800] [801-820] [821-840] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Vincent ViscontiSubject: Can't Connect to iSeries via IBM DB2
Author: Vincent Visconti
Date: 08 Jan 2009 10:00 PM
Originally Posted: 08 Jan 2009 05:07 PM
Hello,

I am trying to connect to an iSeries DB via IBM DB2.

This is how I connected for the past couple of years without a problem. Well, actually I had a problem every year, but it was due to upgrading my java console without selecting the additional languages.

This year when I got the same error, I tried to re install java with the additional languages, but that option was no longer available. I did some looking around and tried installing the multi-language Java SE Runtime Environment 6u11. Still didn't work. That's when I started trying to find an alternative method of connecting to my iSeries, which brought me to sequeLink.

But I digress, I'm back to trying to connect via IBM DB2. I'm running Stylus Studio Version 6 Professional Edition. My connection string is:

//BIJOUX:446;locationName=BIJOUX;collectionId=VINCENT;packageName=JDBCPKG

The error message that I am getting is:

java.sql.SQLException: [StylusStudio][DB2 JDBC Driver]Unsupported VM encoding Cp835.

at ZC.jdbc.jxtr.JXTRDriverConfig.translateSQLException(Unknown Source)

at ZC.jdbc.jxtr.JXTRDriverConfig.createSQLException(Unknown Source)

at ZC.jdbc.jxtr.JXTRDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at com.stylusstudio.DataDirectStub.connect(DataDirectStub.java:142)

at com.stylusstudio.DataDirectStub.getConnection(DataDirectStub.java:438)



Please Advise, I've been going crazy the last two days trying to figure out how to connect to my DB.

Thank you,

Vincent
Postnext
Ivan PedruzziSubject: Can't Connect to iSeries via IBM DB2
Author: Ivan Pedruzzi
Date: 08 Jan 2009 10:03 PM

Hi Vincent,

This issue has been already discussed here

http://www.stylusstudio.com/ssdn/default.asp?action=9&fid=23&read=3321&FirstTopic=527&LastTopic=626

Ivan Pedruzzi
Stylus Studio Team
Postnext
Vincent ViscontiSubject: Can't Connect to iSeries via IBM DB2
Author: Vincent Visconti
Date: 08 Jan 2009 11:12 PM
Thanks Ivan,

That was my original post from a few years back. I read through it already, that's where I got the link to download the JRE with additional languages. I did that, but I am still getting that error message. I'm not sure what else to do.

Any other ideas?

Thanks,

Vincent
Postnext
Tony LavinioSubject: Can't Connect to iSeries via IBM DB2
Author: Tony Lavinio
Date: 09 Jan 2009 01:10 AM
The Custom XML Converter has an option to use different encodings,
and the drop-down list is populated from the Java version.

So, if you create a new converter and look at the available encodings,
it will tell if the JVM that Stylus Studio is pointing to has that
encoding. Look for the Cp835 encoding in that list.

Also let us know what the Help->About says about which Java edition
Stylus Studio is attached to.

Knowing this will help us know what to do next to solve your problem.
Postnext
Vincent ViscontiSubject: Can't Connect to iSeries via IBM DB2
Author: Vincent Visconti
Date: 09 Jan 2009 08:47 AM
Originally Posted: 09 Jan 2009 08:43 AM
>The Custom XML Converter has
>an option to use different
>encodings,
>and the drop-down list is
>populated from the Java
>version.
>
>So, if you create a new
>converter and look at the
>available encodings,
>it will tell if the JVM that
>Stylus Studio is pointing to
>has that
>encoding. Look for the Cp835
>encoding in that list.
>
>Also let us know what the
>Help->About says about
>which Java edition
>Stylus Studio is attached to.
>
>Knowing this will help us know
>what to do next to solve your
>problem.


I did not see an option for Cp835.

Help -> About -> Java Virtual Machine:
11.0-b16 Java HotSpot(TM) Client VM Sun Microsystems Inc.
debug mode port:8000

Thanks,
Vincent
Postnext
Ivan PedruzziSubject: Can't Connect to iSeries via IBM DB2
Author: Ivan Pedruzzi
Date: 09 Jan 2009 01:15 AM
Can you verify that Stylus Studio is using JRE 6?
Tools -> Options -> Java Virtual Machine
Help -> About -> Java Virtual Machine

Which Stylus Studio build are you running?

Ivan Pedruzzi
Stylus Studio Team
Postnext
Vincent ViscontiSubject: Can't Connect to iSeries via IBM DB2
Author: Vincent Visconti
Date: 09 Jan 2009 08:37 AM
>Can you verify that Stylus
>Studio is using JRE 6?
>Tools -> Options -> Java
>Virtual Machine
>Help -> About -> Java
>Virtual Machine
>
>Which Stylus Studio build are
>you running?
>
>Ivan Pedruzzi
>Stylus Studio Team


Tools -> Options -> Java Virtual Machine:
Runtime Library = C:\Program Files\Java\jre6\bin\client\jvm.dll

Help -> About -> Java Virtual Machine:
11.0-b16 Java HotSpot(TM) Client VM Sun Microsystems Inc.
debug mode port:8000

Stylus Studio 6 XML Professional Edition Release 3 Build 377o


Thanks,
Vincent
Postnext
Vincent ViscontiSubject: Can't Connect to iSeries via IBM DB2
Author: Vincent Visconti
Date: 20 Jan 2009 09:46 AM
So, has the SS staff given up on helping me?
Postnext
Ivan PedruzziSubject: Can't Connect to iSeries via IBM DB2
Author: Ivan Pedruzzi
Date: 20 Jan 2009 03:37 PM
Sorry Vincent,

We are still investigating the problem and we don't' have a solution yet.

Can you confirm that you have the system working in the past and it stopped working after updating your system to the JVM 1.6?

Did anything change on database side?

Thanks!
Ivan Pedruzzi
Stylus Studio Team
Postnext
Vincent ViscontiSubject: Can't Connect to iSeries via IBM DB2
Author: Vincent Visconti
Date: 20 Jan 2009 04:05 PM
>Sorry Vincent,
>
>We are still investigating the
>problem and we don't' have a
>solution yet.
>
>Can you confirm that you have
>the system working in the past
>and it stopped working after
>updating your system to the
>JVM 1.6?
>
>Did anything change on
>database side?
>
>Thanks!
>Ivan Pedruzzi
>Stylus Studio Team

Ivan,

Thanks for responding, I thought you guys forgot about me!

I can confirm that the system worked fine in the past. I use the SS software once a year in January. The only hiccup that I usually experience is with Java updates; I usually forget to select additional languages during the year, but I would normally just re-install java and select the additional languages option.

On the database side, nothing has changed, with the exception of upgrading our iSeries from V5R2 to V5R4.

Thanks for continuing your investigation on this matter.

Vincent
Posttop
Ivan PedruzziSubject: Can't Connect to iSeries via IBM DB2
Author: Ivan Pedruzzi
Date: 20 Jan 2009 05:03 PM
Vincent,

Unfortunately the data access component bundled with Stylus Studio 6, dated 2004, only supported DB2 V5R1 and V5R2 for iSeries.

The latest Stylus Studio 2009 provides support for DB2 UDB V5R2, V5R3, and V5R4 for iSeries.

Keep in mind that SQL/XML has been replace with XQuery, thefore I suggest the following:

Send your SQL/XML query to stylus-field-report @ progress.com and we will translate it to XQuery for you, then you will download the Stylus Studio 2009 evolution and test it on your system. if everything works well, you can explore the upgrade path.

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.