It's not a secret anymore!*
The moose likes JDBC and the fly likes timesten access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "timesten access" Watch "timesten access" New topic
Author

timesten access

Praveen Dharmavaram
Ranch Hand

Joined: Nov 05, 2002
Posts: 59
How can i access timesten DB using an odbc-jdbc driver? Can some one provide me sample code.

Thanks
Praveen
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30382
    
150

Praven,
This page shows you the connection information. The rest of the code is standard JDBC.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Praveen Dharmavaram
Ranch Hand

Joined: Nov 05, 2002
Posts: 59
I used "url jdbc:timesten:client:WebNmsDB.." to connect to the DB locally. But when I try "url jdbc:timesten irect:WebNmsDB" to connect from a remote machine, I get an error. Is there something which needs to be done when you are connecting to the DB remotely. Do we need to create an ODBC connection to the remote DB.

Thanks
Praveen
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30382
    
150

Praveen,
From the page I linked to:
The location of the database can be configured using the url field in database_params.conf. By default, the database location is set as "localhost". You can also enter the IP address or the DNS name of the machine in which the database server is running.


Most major database allow you to specify the URL. Apparently, TimesTen does not and has you specify it in a configuration file.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: timesten access