Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Java Classpath for Crystral Reports 10

Posted on 2009-05-19
3
1,350 Views
Last Modified: 2013-12-11
Experts, I hope you can help me out.  I'm not a programmer, just an enduser trying to set up a JDBC database connection to an IBM DB2 v8 database through Crystal Reports 10 professional.

The instructions in the manual I'm following require an INI file to point to the jar files, drivers, etc. for Crystal Reports to reference.
https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/50b9dd07-951e-2b10-9c81-bc5d082230b0

After setting up the file and trying to select set up JDBC in Crystal Reports, I'm receiving the following error:  "Invalid argument details: Java Server Start up failure.  Please verify path, classpath, and IORFIleLocation in the ini file."

I went back and checked my typing and spelling, and cut and pasted each path into a URL line to insure I have the file locations and names typed right.   I also loaded the IBM DB2 driver (db2.jcc.DB2Driver).  Since I have 2 versions of Java on my laptop, I qualified the location of the j2rel.4.2_19\bin file.

I don't know what else to check or even where to look for errors.

Can you please look over the code below to see if I have the syntex correct or tell me what else to check or where to look for my error?

Thank you,
Steph M
[Common]
PATH = "C:\Program Files\Java\j2re1.4.2_19\bin"
CLASSPATH = "C:\Program Files\Common Files\Crystal Decisions\2.5\bin\CRDB_JavaServer.jar";
"C:\Program Files\Common Files\Crystal Decisions\2.5\java\lib\external\CRDBXMLExternal.jar";
"C:\DB2ServerJars\db2java\COM\ibm\db2"
"C:\DB2ServerJars\db2jcc.jar";
"C:\DB2ServerJars\db2jcc_license_cu.jar";
"C:\Program Files\Java\j2re1.4.2_19\bin"
 
 
IORFileLocation = ${TEMP}
JavaServerTimeout = 1800
JVMMaxHeap = 64000000
JVMMinHeap = 32000000

Open in new window

0
Comment
Question by:Steph_M
  • 2
3 Comments
 
LVL 34

Accepted Solution

by:
James0628 earned 500 total points
ID: 24428605
OK, I've no experience with this, so this is something of a guess, but it looks like there should be a ; at the end of line 5.  You need ;'s to separate each element and you don't have one there.

 It's also possible that everything after the = should be on one long line.  IOW, what you show as lines 3 - 8 should be one line.  Maybe.  I really don't know.  It just occurs to me that it's a possibility.  It's a question of whether whatever reads this will recognize values extended over multiple lines, or if it expects them all to be on one line.  If you still have problems after adding the ; to line 5, you could try combining those into one long line.

 James
0
 

Author Closing Comment

by:Steph_M
ID: 31583202
The short story: as it turns out, hitting the database directly for reporting violates our license agreement so I won't need the code after all.

Thanks fo taking time to response.

Steph M
0
 
LVL 34

Expert Comment

by:James0628
ID: 24532620
No problem.  Sorry it didn't work out.

 James
0

Featured Post

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Crystal report highlighting 5 44
Cyrstal Reports formula to check IsNull 8 37
running on tomcat not jboss eap 7.0 3 18
Parameter Values   Crystal Rep. XI release 2 6 26
-Xmx and -Xms are the two JVM options often used to tune JVM heap size.   Here are some common mistakes made when using them:   Assume BigApp is a java class file for the below examples. 1.         Missing m, M, g or G at the end …
There are numerous questions about how to setup an IBM HTTP Server to be administered from WebSphere Application Server administrative console. I do hope this article will wrap things up and become a reference for this task. You need three things…
The viewer will learn how to implement Singleton Design Pattern in Java.
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question