This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

i am not able to know what the problem is

 
shashikanth penumadula
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi group, i guess u r all doing well.
i am learning advance java.can anyone tell me how to connect to our backend database.here in my case the backend database is oracle8i.actually i could locate microsoft odbc for oracle in systemdsn and i could give sourcename ,username(scott) also..i am not getting any compilation errors with my java program...but at the runtime its showing errors related to connection....the same i worked in my lab and everything went well........the problem is i am getting errors in my home pc.the driver i am using is sun.jdbc.odbc.JdbcOdbcDriver. and i am using j2sdk1.4.1.
is this my driver problem or connection problem.
system configuration:my ram is 63mb and hard disk is14gb.
any input will be of great help.
 
Shankar Narayana
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Your problem can be solved easily if you can post the error message also. What database are you using at your home PC?


Regards
Shankar.
 
shashikanth penumadula
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi shankar,
the database i am using is oracle8i.even i thought to put the error message in the post also but,the thing is my command.exe is not scrollable to send u the entire error message.my operating system is windows98.if you know any command to make my command.exe scrollable or copy the error message from command.exe to any text file then please tell me,so that i can send the exception trace also....
thanks
 
Shankar Narayana
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

When you catch the exception in your application , try to write it to a file. Hope this helps you to find out the error.


Regards,
Shankar.
 
shashikanth penumadula
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi shankar,
yup my jdbc is working fine.
there were error in my codes(i was using con.close() in the unwanted areas)
because of which i was getting an error(oracle not found)and because of which i was unable to make my transactions.neway thanks for ur suggestions.
bye
 
Layne Lund
Ranch Hand
Posts: 3061
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am learning how to use JDBC myself, and according to what I have read, the JDBC-ODBC bridge that you are using is intended for experimental use only. Most RDBMS manufacturers (including Oracle) have a specialized JDBC driver for their database. I strongly suggest you look into using this before you deploy your JDBC code for business purposes.

Layne
 
hatim osman
Ranch Hand
Posts: 105
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi there...
The use of ODBC bridge driver is strongly discuraged unless it's the last resrot. Most RDBMS vendors release specific drivers for use with their prodcuts. you can check the latest list of available drivers at Sun web site.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic