Solved

Tomcat Datasource and MS SQL 2000

Posted on 2004-09-21
15
230 Views
Last Modified: 2013-11-24
Hi,

i'm using tomcat datasource to access a ms sql2000 server, and my account has access to more than one database (by database i mean like northwind .. not different sql servers) .

question is , how can i access both database with a single datasource ? how will my code / sql statement look like ?
0
Comment
Question by:shenlong_wc
  • 8
  • 4
  • 2
  • +1
15 Comments
 
LVL 35

Expert Comment

by:girionis
ID: 12110262
> question is , how can i access both database with a single datasource
> ? how will my code / sql statement look like ?

YOu cannot. Create one datasource for each database (conenciton pool).

0
 
LVL 35

Expert Comment

by:girionis
ID: 12110285
You can select data from different tables if you need but not from different databases with the same datasource.
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 12110294
You should not need anything special. What, if any, problems are you having?
0
 

Author Comment

by:shenlong_wc
ID: 12110321
because of the way our database is currently structured , the tables i need are scattered over different databases within the SQL server. Currently what i do now is create a seperate datasource for each database, but i'm looking for a way to access all these database ( my account has the rights to all of them ) using a single datasource if possible .
0
 
LVL 35

Expert Comment

by:girionis
ID: 12110338
What about creating a stored procedure and calling it from your Java code?
0
 
LVL 35

Expert Comment

by:girionis
ID: 12110342
http://www.onjava.com/pub/a/onjava/2003/08/13/stored_procedures.html assuming that you can call different databases from one stored procedure.
0
 

Author Comment

by:shenlong_wc
ID: 12110351
isn't there a way i can do it on java side ?
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 35

Expert Comment

by:girionis
ID: 12110381
Read the data from one database, then issue another query to the second database using the data from the previous one.
0
 
LVL 9

Expert Comment

by:Venci75
ID: 12110511
try to use fully qualified table name:
<database>.<owner>.<table>
0
 

Author Comment

by:shenlong_wc
ID: 12118543
>try to use fully qualified table name:
><database>.<owner>.<table>

how do i do that ?

>Read the data from one database, then issue another query to the second database using the >data from the previous one.

but how do i issue a second query to the second database without creating another data source ?

is it possible for me to specify the database name of the table in the sql ? like SELECT * FROM Northwind.tablename and SELECT * FROM Mydatabase.Mytable or something like that ?
0
 
LVL 35

Expert Comment

by:girionis
ID: 12120410
> but how do i issue a second query to the second database without creating another data source ?

Just use a plain statement witout a data source.
0
 

Author Comment

by:shenlong_wc
ID: 12120541
i don't understand .. how can you execute a query without a  datasource ?
apprecitae it if you can show some logic with code ?
0
 
LVL 35

Expert Comment

by:girionis
ID: 12120772
0
 
LVL 35

Expert Comment

by:girionis
ID: 12120775
A datasource is usually associated with a connection pool. You can have simple connections though that are not taken off the pool and work with them.
0
 
LVL 9

Accepted Solution

by:
Venci75 earned 50 total points
ID: 12121051
select * from [pubs].[dbo].[authors]

where 'pubs' is the database name, 'dbo' is the table owner (it is a user name) and 'authors' is the table name
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
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 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 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:

758 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

18 Experts available now in Live!

Get 1:1 Help Now