Solved

j2EE server

Posted on 2001-06-17
6
202 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
3 Use Cases for Connected Systems

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

 

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

3 Use Cases for Connected Systems

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

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
groupSum5 challenge 5 84
splitOdd10 challenge 5 106
Arrays.asList  VS  ArrayList 4 58
runtime exception 2 28
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…
Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:

770 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