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

j2EE server

Posted on 2001-06-17
6
210 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
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 

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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone 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

Suggested Solutions

Title # Comments Views Activity
java stored proc example 9 45
Tomcat: Unable to run tomcat service. 2 23
Html Table Looping (part 2) 5 27
web project error add remove 1 29
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
The viewer will learn how to implement Singleton Design Pattern in Java.

829 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