Solved

j2EE server

Posted on 2001-06-17
6
191 Views
Last Modified: 2013-11-24
sorry if this is only mildly on-topic, but the question straddles many topic areas, but this one primarily

I have the J2EE server running. I want it to talk to SQL Server 7, do I definitely need a third party driver suite or can this be done without (ie ODBC) by using j2EEadmin to describe the source?  
The J2EE docs are unclear, and the only products that I have been able to find are on limited license, or pay up-front.

thanks
0
Comment
Question by:simonm99
  • 4
  • 2
6 Comments
 
LVL 3

Expert Comment

by:shyamkumarreddy
ID: 6200970
Hi simonm

You can use ODBC or third party. NO probs which every u like. If u r using third party then u need to include this in your classpath of your j2ee.
If u r using the ODBC then u don't have any probs


shyam
0
 

Author Comment

by:simonm99
ID: 6201572
thanks for answering, but that does not answer my question - can I use ODBC connections (say, to SQL server 7) WITHOUT using a third party driver?  

The docs are quite vague about this and seem to give no examples of how to configure it. Any help appreciated as Cloudscape is a trial to use, at best.


0
 
LVL 3

Accepted Solution

by:
shyamkumarreddy earned 100 total points
ID: 6201590
HI Simon
You can use your ODBC in J2EE evironment.
Your j2EE should run in Windows Environment

No configuration is required for ODBC

But if u use 3rd party then u need to configure ur environemnt according to that

*-----thanks for answering, but that does not answer my question - can I use ODBC connections (say, to SQL
server 7) WITHOUT using a third party driver?   ---*


Cheers
Shyam
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:simonm99
ID: 6203715
thanks, I'll give it a try this evening.
0
 

Author Comment

by:simonm99
ID: 6206161
Shyam,

you mean by adding something like

jdbcDriver.1.name=sun.jdbc.odbc.JdbcOdbc

(where this class is located in 1.3/jre/lib/rt.jar) ?

if my ODBC ink is called "Titan" how do I format the addition of the datasource?

j2eeadmin -addJdbcDataSource <jndiname> <something>

thanks





0
 

Author Comment

by:simonm99
ID: 6216161
i say "average" as your statement "no configuration is required" proved to be incorrect although I appreciate your confirmation that it is possible to do it.

These lines (especially the last one) need to be added to the resource.properties file to make ODBC work for a System DSN ODBC link called "Titan"

jdbcDataSource.5.name=jdbc/Titan
jdbcDataSource.5.url=jdbc:odbc:Titan
// very important below vvvvvvv
jdbcDriver.1.name=sun.jdbc.odbc.JdbcOdbcDriver

but thanks for replying anyway
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
JDeveloper 12c for 32 bit 4 68
advertisement module in core php 4 144
maven project error 5 48
reverse digits of a number using for loop 5 36
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers learn about the “while” loop and how to utilize it correctly in Java. Additionally, viewers begin exploring how to include conditional statements within a while loop and avoid an endless loop. Define While Loop: Basic Example: Explanatio…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

919 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now