File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes i am not able to know what the problem is Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "i am not able to know what the problem is" Watch "i am not able to know what the problem is" New topic
Author

i am not able to know what the problem is

shashikanth penumadula
Ranch Hand

Joined: May 26, 2005
Posts: 32
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

Joined: Jan 08, 2003
Posts: 134
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.


"Failure is not when you fall down; its only when you fail to get up again."
shashikanth penumadula
Ranch Hand

Joined: May 26, 2005
Posts: 32
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

Joined: Jan 08, 2003
Posts: 134
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

Joined: May 26, 2005
Posts: 32
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

Joined: Dec 06, 2001
Posts: 3061
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


Java API Documentation
The Java Tutorial
hatim osman
Ranch Hand

Joined: Jun 10, 2005
Posts: 105
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: i am not able to know what the problem is