Comments
yourfanat wrote: I am using another tool for Oracle developers - dbForge Studio for Oracle. This IDE has lots of usefull features, among them: oracle designer, code competion and formatter, query builder, debugger, profiler, erxport/import, reports and many others. The latest version supports Oracle 12C. More information here.
Cloud Expo on Google News
SYS-CON.TV
Cloud Expo & Virtualization 2009 East
PLATINUM SPONSORS:
IBM
Smarter Business Solutions Through Dynamic Infrastructure
IBM
Smarter Insights: How the CIO Becomes a Hero Again
Microsoft
Windows Azure
GOLD SPONSORS:
Appsense
Why VDI?
CA
Maximizing the Business Value of Virtualization in Enterprise and Cloud Computing Environments
ExactTarget
Messaging in the Cloud - Email, SMS and Voice
Freedom OSS
Stairway to the Cloud
Sun
Sun's Incubation Platform: Helping Startups Serve the Enterprise
POWER PANELS:
Cloud Computing & Enterprise IT: Cost & Operational Benefits
How and Why is a Flexible IT Infrastructure the Key To the Future?
Click For 2008 West
Event Webcasts
Setting the Driver Straight
I've been working on setting up a new environment for SAP IDM 7.1 SP5

I've been working on setting up a new environment for SAP IDM 7.1 SP5 (yes I know 6 is available). This installation is notable for me since I am configuring it around:

  • Windows Server 2008R2 64Bit
  • Microsoft SQL Server 2008R2 64Bit

So it's my first pure 64-bit system.  I'm pretty excited. I got the OS installed no problem.  I got SQL installed. (I have to say, 2008R2 is probably the smoothest SQL install I've done since SQL Server 7.  Very much a fan.) I got the IDM DesignTime and Runtime installs completed with no problems. I installed Java 1.6 and installed the 3.0 SQL Server drivers. Then the skies began to darken...

I  kept getting driver not found errors when I went to test the dispatcher. Very frustrating!  I tried regenerating the dispatcher scripts, tweaking the Java configuration from MMC, and even took a look a look at the dispatcher's .prop file and jdbcdefs.xml.  Tweaking some of these shed some light on the issue, but did not bring complete success. That's when I started rethinking things and went back to basics.

First I hit up Google and did some searching on SQL Server 2008, JDBC drivers and related topics.  Based on this I decided to roll back to the 2.0 SQL Server drivers and re-create the JDBC connection string. This time I installed the SQL Server 2005 option instead and I got a little closer. It seems that when one is using Java 1.6, the level 4 driver (sqljdbc4.jar) is required rather than the level 3 driver (sqljdbc.jar).

What kept throwing me off in this is that I was reading the options, and I read them too literally. What the SQL Server 2005 option should read is SQL Server 2005 and later... The connection string syntax and the driver name that is called see different starting with 2005.

I was able to confirm the level 3/4 driver issue  when troubleshooting between the configuration on my various sandbox systems. My latest one is running 1.6 with sqljdbc4.jar and one of my older systems is using Java 1.5.

So to wrap it up, what I've found is this:

  • Use the Microsoft  SQL Server 2.0 drivers  DO NOT use the SQL Server 3.0 drivers
  • When building the JAVA connection string for an IDM Configuration DO NOT use Microsoft SQL Server option, rather, use Microsoft SQL Server 2005
  • If you are using Java 1.5, you'll need to use the sqljdbc.jar
  • If you are using Java 1.6, you'll need to use the sqljdbc4.jar

That's about it for the moment.  I still need to install a trial version of NetWeaver to get the sandbox up and running.

Read the original blog entry...

About Matthew Pollicove
Matt Pollicove is an Identity Management architect, engineer, trainer, project manager, author and blogger with experience in user account provisioning, data synchronization, virtual directory and password management solutions. As a MaXware Technical Consultant and later as a System Engineer, he worked extensively with MaXware (now SAP) software products in large customer environments. In the past Matt has worked with several leading national and international consulting firms and is currently a Sr. Principal Consultant for Commercium Technologies. He is currently the Practice Lead for SAP NetWeaver Identity Management and SailPoint IIQ.

Latest Cloud Developer Stories
Coca-Cola’s Google powered digital signage system lays the groundwork for a more valuable connection between Coke and its customers. Digital signs pair software with high-resolution displays so that a message can be changed instantly based on what the operator wants to communicat...
In his session at 21st Cloud Expo, Raju Shreewastava, founder of Big Data Trunk, provided a fun and simple way to introduce Machine Leaning to anyone and everyone. He solved a machine learning problem and demonstrated an easy way to be able to do machine learning without even cod...
Blockchain. A day doesn’t seem to go by without seeing articles and discussions about the technology. According to PwC executive Seamus Cushley, approximately $1.4B has been invested in blockchain just last year. In Gartner’s recent hype cycle for emerging technologies, blockchai...
In his keynote at 18th Cloud Expo, Andrew Keys, Co-Founder of ConsenSys Enterprise, provided an overview of the evolution of the Internet and the Database and the future of their combination – the Blockchain. Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSy...
"IBM is really all in on blockchain. We take a look at sort of the history of blockchain ledger technologies. It started out with bitcoin, Ethereum, and IBM evaluated these particular blockchain technologies and found they were anonymous and permissionless and that many companies...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021



SYS-CON Featured Whitepapers
ADS BY GOOGLE