Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

timesten access

 
Praveen Dharmavaram
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How can i access timesten DB using an odbc-jdbc driver? Can some one provide me sample code.

Thanks
Praveen
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Praven,
This page shows you the connection information. The rest of the code is standard JDBC.
 
Praveen Dharmavaram
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic