Solved

j2EE server

Posted on 2001-06-17
6
215 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
[X]
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
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Java contains several comparison operators (e.g., <, <=, >, >=, ==, !=) that allow you to compare primitive values. However, these operators cannot be used to compare the contents of objects. Interface Comparable is used to allow objects of a cl…
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

730 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