XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Conferences Close Tree View
+ Stylus Studio Feature Requests (1168)
- Stylus Studio Technical Forum (14398)
-> + XSD validation using XSV fails... (3)
-> + Is this really well-formed? (3)
-> + HL7 EDI to XML problems -'ORU_... (11)
-> + How do I modify the Xquery to ... (2)
-> + XML mapping difficulty (3)
-> + XLST Conversion (2)
-> + HTML TO XSL Conversion (2)
-> - Convert an EBCDIC file to XML (1)
-> + License Manager still indicate... (4)
-> + Still sometimes getting beat b... (2)
-> + What versions of MySQL are sup... (5)
-> - External XSLT processor proble... (1)
-> + DDEE0082 Erro Internal system ... (6)
-> + Calling function from .NET C# (2)
-> + Stylus studio projects bound t... (3)
-> + Report Designer mistakenly gen... (3)
-> + Choose Nodes in pipelines (3)
-> + Custom external processor and ... (2)
-> + predefined (4)
-> + translate function in java (2)
-> + XMLPipeline trouble in Linux (7)
-> + Converting Custom EDI Message ... (2)
-> + tab delimetered file with vari... (2)
-> + XML validation with XSD (2)
-> + Missing documentation: SSL_Cer... (2)
-> + Parse Xcel input file which is... (2)
-> + XML Publisher post processors (2)
-> + Alignment of table items in XM... (2)
-> + XML to PDF using XML Publisher (2)
-> + Blurry Background image / Vect... (4)
-> + URIResolver error on command l... (2)
-> + stylus studio - the (3)
-> + problem with omit from output ... (3)
-> + Maximum XML File Size and Out ... (4)
-> + 64-bit version of Stylus Studi... (2)
-> + Generate xml schema from edi s... (3)
-> + License disabled (6)
-> + Stylus is not recognizing save... (5)
-> + WINE / CrossOver (3)
-> + Problem with FOP plugin (SS200... (5)
-> - XML diff engine - how to ignor... (1)
-> + How to configure Xerces J (2)
-> + Configuring xerces-2_9_1 (4)
-> + Release license to use stylus ... (5)
-> + Sorting Repeater row (3)
-> - Browse for Pipeline Input (1)
-> + Stylus 2010 and Win 7 problem ... (6)
-> + Cannot set XSLT source files w... (3)
-> - Simple TXT to HTML Convertor! ... (1)
-> + Invoking XSLT and FOP Processe... (2)
-> - Add Node and Pattern for Mutlp... (1)
-> - How to get xsl:message output ... (1)
-> + WSDL for Cvent Web Service (5)
-> - newbie question: IS there a "f... (1)
-> + Windows 7 64-bit Java. Stylus ... (3)
-> + Stylus Studio Enterprise crash... (2)
-> - XML to Access or SQL? Newbie N... (1)
-> - xml to flat file mapping using... (1)
-> + Missing Document Wizards (2)
-> - XSLT mapping and (1)
-> + Citrix Softgrid package proble... (2)
-> - xsl:import dropping the attrib... (1)
-> + XSLT mapping between schemas (5)
-> + Modifying/Creating existing CA... (9)
-> - Creating XML Sample Stream fro... (1)
-> - Integer to hex (1)
-> - Opening from and then Saving t... (1)
-> - Please help me find time query... (1)
-> + Need access to the 2007 versio... (2)
-> + Connecting to a iSeries DB2 da... (2)
-> + Windows 7 Enterprise and Stylu... (5)
-> + How do you create a record inc... (2)
-> + How to convert lines with no i... (6)
-> + http://www.milyn.org/schema/ed... (3)
-> + Using source configuration fil... (2)
-> + Is there any way that we could... (3)
-> - Water mark problem in PDF Gene... (1)
-> + Conversion file for swift mt10... (4)
-> + Stylus Studio converter error (7)
-> + Help for upgrade (6)
-> + Conversion File for a Header D... (2)
-> + Java Heap Space (9)
-> - Export mappings as text (1)
-> + XQuery, Pipeline generated jav... (2)
-> + Conditional XML Conversion? (2)
-> + iDoc to EDI (2)
-> + Pipeline XSLT Java Problem (6)
-> - Created XSLT... Now what? (1)
-> - Can I have Or Condition in the... (1)
-> - Error??? during a pipeline! (1)
-> + Opening from and then Saving t... (6)
-> + Unable to start SS 2010 ES - R... (2)
-> + proxy server settings (2)
-> - post upgrade failures and a fr... (1)
-> + Error java heap space (2)
-> + XML to XML? (4)
-> + Base64 - Encoding icone with T... (2)
-> - Pipeline: Multiple plain data ... (1)
-> + Convert and XML file to 837P (4)
-> + How to use a pipeline output i... (3)
-- Previous [481-500] [501-520] [521-540] Next
+ Website Feedback (244)
+ XSLT Help and Discussion (7588)
+ XQuery Help and Discussion (1941)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (363)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Vincent ViscontiSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Vincent Visconti
Date: 23 Feb 2005 02:54 PM
Hello,

I am currently evaluating the Stylus Studio software, I am attempting to generate an XML document via mapping data from my AS/400 relational database to an XML schema. However, I am experiencing problems when SS attempts to connect to the AS/400.

I have an ODBC System DSN that I am referencing in the DataDirect SequeLink 5.4 Snapin (per the "Configuring an ODBC Data Source Using DataDirect SequeLink Server" Tutorial)

I receive the following message: String index out of range: 4

Details of error message:
java.lang.StringIndexOutOfBoundsException: String index out of range: 4

at java.lang.String.substring(Unknown Source)
at ZC.jxtr.JXTRLicense.getConnectionType(Unknown Source)
at ZC.jxtr.JXTRLicense.<init>(Unknown Source)
at ZC.jxtr.JXTRLicense.createJXTRLicense(Unknown Source)
at ZC.jdbc.jxtr.JXTRDriverConnection.<init>(Unknown Source)
at ZC.jdbc.jxtr.JXTRDriverConnectionSequeLink.<init>(Unknown Source)
at ZC.jdbc.jxtr.JXTRDriverLoaderSequeLink.NewJXTRDriverConnectionSequeLink(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:130)
at com.stylusstudio.DataDirectStub.getConnection(DataDirectStub.java:399)


Please advise.

Thank you,
Vincent

Postnext
Ivan PedruzziSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Ivan Pedruzzi
Date: 23 Feb 2005 03:29 PM
Hi Vincent,

Stylus Studio supports DB2(1) natively, you should't need sequelink.

Regarding the error, could you post the database URL you are using
and the Stylus Studio version?

Hope this helps
Ivan

1:http://www.stylusstudio.com/doc/jdbcug.pdf

Postnext
Vincent ViscontiSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Vincent Visconti
Date: 23 Feb 2005 03:39 PM
Thanks for the quick reply. Attached is the information you requested. Can you give me an example of a database URL I would use to connect to an AS/400. If needed, AS/400 Version is V5R2.

Thank you,
Vincent


>Hi Vincent,
>
>Stylus Studio supports DB2(1)
>natively, you should't need
>sequelink.
>
>Regarding the error, could you
>post the database URL you are
>using
>and the Stylus Studio version?
>
>Hope this helps
>Ivan
>
>1:http://www.stylusstudio.com/
>doc/jdbcug.pdf
>


DocumentStylusStudio1.doc
Stylus Studio Info

Postnext
Ivan PedruzziSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Ivan Pedruzzi
Date: 23 Feb 2005 04:14 PM
To use DB2 select IBM DB2 as Database type; the URL should look like this

//localhost:50000;locationName=;collectionId=;packageName=

Take a look to your ODBC data source settings
to figure out the parameter value to pass

In my previous post I also pointed to the JDBC user guide
to have a better understanding of Stylus Studio DB2 support.

Ivan

Postnext
Vincent ViscontiSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Vincent Visconti
Date: 24 Feb 2005 11:34 AM
Ivan,

I am still experiencing difficulty in connecting to my database on the AS/400. I have been going through the documentation you sent me yesterday, however, it really hasn't been that helpful. It references tools that I don't have (i.e. DataDirect Test, DataDirect DB2 Package Manager). I assume this is because we are only privliged to a subset of the DataDirect functionality (This makes using their documentation very difficult). So, I've being trying to establish a connection using a connection string, however I don't fully understand the the parameter meanings (documentation is not very clear with the definitions given) and what might be valid values. Below is a list of the parameters and values I am trying to use, maybe you can give me some pointers on what I might be doing wrong.

Server URL: //BIJOUX;locationName=Z_VMV;collectionId=DEFAULT;packageName=JDBCPKG;CreateDefaultPackage=TRUE
//BIJOUX; Name of my AS/400 (I tried using the IP address, specifying ports, get the same error message every time)
locationName=Z_VMV; Library on AS/400 where the tables I want to convert to XML exist?
collectionId=DEFAULT; Not really sure what this value should be?
packageName=JDBCPKG;
CreateDefaultPackage=TRUE Set to true for initial connection, set to false thereafter

I keep getting the following error message:
java.sql.SQLException: [StylusStudio][DB2 JDBC Driver]Error establishing socket. Connection refused: connect
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:130)
at com.stylusstudio.DataDirectStub.getConnection(DataDirectStub.java:399)

I was thining this was a security issue on the AS/400 side, but my admin gave me full authority to EVERYTHING.

I'm totally stumped... Please help.

Thank you,
Vincent

>To use DB2 select IBM DB2 as
>Database type; the URL should
>look like this
>
>//localhost:50000;locationName
>=;collectionId=;packageName=
>
>Take a look to your ODBC data
>source settings
>to figure out the parameter
>value to pass
>
>In my previous post I also
>pointed to the JDBC user guide
>to have a better understanding
>of Stylus Studio DB2 support.
>
>Ivan
>

Postnext
Ivan PedruzziSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Ivan Pedruzzi
Date: 24 Feb 2005 04:44 PM
Vincent,

From the error it seems that the host adress or port is wrong (Error establishing socket. Connection refused: connect)
could you verify that host name and port are correct?

Ivan

Postnext
Vincent ViscontiSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Vincent Visconti
Date: 24 Feb 2005 05:40 PM
Ivan,

I obtained the host name from another application (see attached) that connects to the AS/400 database(succesfully), the port number is optional and left blank.

I tried to mirror these settings in the connection string, but there are certain parameters that do not relate.

Thanks,
Vincent


DocumentStylusStudio2.doc

Postnext
Ivan PedruzziSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Ivan Pedruzzi
Date: 25 Feb 2005 09:58 AM
Vincent

Here is a more accurate analysis from DB2 JDBC Driver support team

When connecting to the AS/400 DataDirect DRDA driver will always connect to port 446.
There are several drivers for the AS/400 available that are not a DRDA driver and therefore
connect to a different port.

Here are some details that may be helpful when connecting to the AS/400

Tcp Port: The port number for the DRDA listener on the AS/400 is 446.
DRDA is the communicating protocol for communicating with DB2.
To verify the correct port number, execute 'NETSTAT' from an AS/400 command line.
Chose option 3 to display a list of active ports on the AS/400.
Find the entry for DRDA and press F-14 to toggle the display the port number.
If DRDA is not currently listening, the AS/400 command "CHGDDMTCPA AUTOSTART(*YES) PWDRQD(*YES)"
will start the listener and ensure that it will be active at IPL.

Location Name: The name of the relational database (RDB) on your AS/400.
The AS/400 command "WRKRDBDIRE" will provide you with a list of possible values for this setting.
The name of the relational database that is listed as *LOCAL will be what you want to provide the driver for this parameter.

Postnext
Vincent ViscontiSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Vincent Visconti
Date: 25 Feb 2005 10:48 AM
Hi Ivan,

I verified that the DRDA port (446) is listening and the local DB name is BIJOUX.
Using the connection URL: //BIJOUX:446;locationName=BIJOUX;collectionId=DEFAULT;packageName=JDBCPKG;CreateDefaultPackage=TRUE
I get the following error:

java.sql.SQLException: [StylusStudio][DB2 JDBC Driver]Unsupported VM encoding Cp500.
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:130)
at com.stylusstudio.DataDirectStub.getConnection(DataDirectStub.java:399)


I also tried substituting the ip address for the server name, I get the same error.

Thanks for your help so far, I hope we are able to resolve this issue.
Vincent

Postnext
Ivan PedruzziSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Ivan Pedruzzi
Date: 25 Feb 2005 11:04 AM

This is easy to solve

You are missing the JVM encoding libraries.
When installing the java virtual machine you need select support
for international languages.

Ivan


Postnext
Vincent ViscontiSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Vincent Visconti
Date: 25 Feb 2005 11:37 AM
Ivan,

Mission accomplished...

Thanks for all your help,
Vincent

Postnext
John pelletierSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: John pelletier
Date: 18 Oct 2007 03:46 PM
Hello, I'm having this exact same problem, except I'm not able to get to the mission accomplished stage. How do I reinstall the JVM encoding libraries?

Postnext
Ivan PedruzziSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Ivan Pedruzzi
Date: 18 Oct 2007 04:08 PM

Re-install the Java JRE and tick on "Additional Languages".

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Postnext
John pelletierSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: John pelletier
Date: 18 Oct 2007 04:27 PM
Hi Ivan, I never installed the "Java JRE". Sorry for sounding like a dope but all I did was download your software and I'm trying to get at my 400..ooops, iSeries. Are the any docs on what I need to do?

Thanks

Postnext
Ivan PedruzziSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Ivan Pedruzzi
Date: 18 Oct 2007 04:53 PM

Hi John,

Stylus Studio requires the Sun Java Virtual Machine in order to use the database connectivity.

Your system has Java already installed but unfortunately the default installation doesn't contain the "Additional Languages" support.

In order to get the Sun JRE installation visit
http://java.sun.com/javase/downloads/index.jsp

The fourth link going down is where you need to click

Once you have downloaded and run the Java installer, see the screenshot in my previous message, go to Stylus Studio then click
Tools -> Options -> Java Virtual Machine and click auto-detect.

Restart Stylus Studio and at that point you should be able to connect.

Ivan Pedruzzi
Stylus Studio Team

Postnext
John pelletierSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: John pelletier
Date: 19 Oct 2007 07:55 AM
We're gaining on it, but now I have a different error:

java.sql.SQLException: [XQuery][DB2 JDBC Driver][DB2]QSYS.DEFAULT IS AN UNDEFINED NAME

at com.ddtek.xquery.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.ddtek.xquery.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.ddtek.xquery.jdbc.db2.drda.DRDARequest.processSQLCA(Unknown Source)

at com.ddtek.xquery.jdbc.db2.drda.DRDARequest.processCodePoint(Unknown Source)

at com.ddtek.xquery.jdbc.db2.drda.DRDABindRequest.processCodePoint(Unknown Source)

at com.ddtek.xquery.jdbc.db2.drda.DRDARequest.processReply(Unknown Source)

at com.ddtek.xquery.jdbc.db2.DB2PackageManager.createPackageSet(Unknown Source)

at com.ddtek.xquery.jdbc.db2.DB2PackageManager.initialize(Unknown Source)

at com.ddtek.xquery.jdbc.db2.DB2ImplConnection.open(Unknown Source)

at com.ddtek.xquery.jdbc.base.BaseConnection.connect(Unknown Source)

at com.ddtek.xquery.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)

at com.ddtek.xquery.jdbc.base.BaseConnection.open(Unknown Source)

at com.ddtek.xquery.jdbc.base.BaseDriver.connect(Unknown Source)

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

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

at com.stylusstudio.DataDirectDDXQStub.connect(DataDirectDDXQStub.java:76)

at com.stylusstudio.DataDirectDDXQStub.getConnection(DataDirectDDXQStub.java:111)



//172.16.1.2:446;locationName=INTERPAK;collectionId=DEFAULT;packageName=JDBCPKG;CreateDefaultPackage=TRUE

I'm getting to the server because I can see 446 listening, and being hit.

Thanks for your help.

Postnext
Ivan PedruzziSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Ivan Pedruzzi
Date: 19 Oct 2007 09:39 AM

John,

Could you please provide detailed information on the DB2 version you are trying to connect?

Thanks!
Ivan Pedruzzi
Stylus Studio Team

Postnext
John pelletierSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: John pelletier
Date: 19 Oct 2007 12:08 PM
Ivan, we're an iSeries running v5r3 with db2.

Also, I changed the collectionid parameter from DEFAULT to a library name and I don't get any errors. However, I'm also not able to drill into the DB and see the tables in the library. The plus sign is temporary beside the db, but when I click it is goes away and doesn't open. Does this make sense?

Thanks again

Postnext
Ivan PedruzziSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Ivan Pedruzzi
Date: 19 Oct 2007 09:45 PM
John

Please refer to this technical article on CollectionID

http://knowledgebase.datadirect.com/kbase.nsf/ce24d9443437511f85256e57006bfe2a/16767bff8eaa8e9185256be30009b646?OpenDocument&Highlight=0,collectionid

You may need to contact the DB administrator to gather to correct connection information

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Postnext
John pelletierSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: John pelletier
Date: 22 Oct 2007 08:11 AM
Hi Ivan,

The link doesn't help - it basically says that I should use DEFAULT.

This doesn't seem like it should be hard - is there any documentation on how to connect to an iseries db2 library?

I'm evaluating this product - I appreciate your help, but I'm making no progress with making this connection. Are there any fee based, face-to-face technical support options available for this product?

Thanks again

Postnext
Ivan PedruzziSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: Ivan Pedruzzi
Date: 24 Oct 2007 10:47 PM

The problem has been solved after an offline conversation

Using a simplify server URL John was able to connect to his DB2 server

//172.16.1.2:446;locationName=INTERPAK

Ivan Pedruzzi
Stylus Studio Team

Posttop
John pelletierSubject: Problems Connecting to DB2/400 via DB to XML Source
Author: John pelletier
Date: 25 Oct 2007 07:11 AM
mission accomplished!

   
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.