Hi Danko, Thanks for getting back to me.
The answer is yes to all three questions. As I mentioned, I can connect to the database with no problem using my own java class and the ojdbc jar file. I'm wondering if the problem is that I'm using Oracle 11g or using a 64 bit version of Oracle. I also tried using Oracle express eddition 10g. I can connect to that OK but when it tries to create the necessary tables, KIM complains that partitioning is not enabled. It seems that Oracle express doesn't support partitioning. I'm trying to find an instance of the full edition of 10g and am hoping that will solve the problem. Any help appreciated. Regards, Alistair Alistair Duke Next Generation Web Research Centre for Information & Security Systems Research BT Innovate ___________________________ Office: +44(0) 1473 608192 Mobile: +44(0) 7730 426257 Fax : +44(0) 1473 606755 Email: alistair.d...@bt.com This email contains BT information, which may be privileged or confidential. It's meant only for the individual(s) or entity named above. If you're not the intended recipient, note that disclosing, copying, distributing or using this information is prohibited. If you've received this email in error, please let me know immediately on the email address above. Thank you. We monitor our email system, and may record your emails. British Telecommunications plc Registered office: 81 Newgate Street London EC1A 7AJ Registered in England no: 1800000 > -----Original Message----- > From: DanKo [mailto:da...@sirma.bg] > Sent: 29 June 2009 09:18 > To: Duke,AK,Alistair,CXR3 R; philip.alex...@sirma.bg; sil...@sirma.bg > Cc: KIM-discussion@ontotext.com > Subject: Re: [Kim-discussion] CoreDB: Issue connecting to Oracle > > Hi Aliastar, > > We are very sorry for our delay! > > Could you please check a few thing in your Oracle setup: > 1) Is the name of your Oracle service named: > ORCL > 2) Is the user created by you named: > KIM > 3) Is the user's password set to: > password > > Thanks in advance for your efforts! > > Greetings > DanKo > Senior Dev. KIM > > > ----- Original Message ----- > From: <alistair.d...@bt.com> > To: <philip.alex...@sirma.bg>; <sil...@sirma.bg> > Cc: <KIM-discussion@ontotext.com> > Sent: Tuesday, June 23, 2009 1:23 PM > Subject: [Kim-discussion] CoreDB: Issue connecting to Oracle > > > > Hi again, > > > > I'm trying to use the CoreDB feature of KIM but I'm having a problem > > connecting to the oracle database. I've created a new user and > > tablespace and pointed KIM at it using the following settings: > > > > com.ontotext.kim.KIMConstants.DOCUMENT_REPOSITORY_TYPE = coredb > > > com.ontotext.kim.KIMConstants.COREDB_CONNECTION_STRING=jdbc:or > acle:thin: > > @//localhost:1521/ORCL > > com.ontotext.kim.KIMConstants.COREDB_USER=KIM > > com.ontotext.kim.KIMConstants.COREDB_PASS=password > > > > However, when I run KIM I get the following error: > > > > Attempt to get connection failed due to: ORA-01017: invalid > > username/password; logon denied > > > > And after a few attempts the user account gets locked. The > fact that I > > can then unlock the KIM account and see the error revert to > ORA-01017 > > seems to indicate that the connection string and user details are > > correct. > > > > I've tried connecting via my own java class using the same > jar file that > > KIM uses (ojdbc14-10.2.0.4.0.jar) and it connects with no problem. > > > > I'm running Oracle Enterprise Edition Release 11.1.0.6.0 - 64bit. > > > > Hoping you can help. > > > > Regards, > > > > Alistair > > > > Alistair Duke > > Next Generation Web Research > > Centre for Information & Security Systems Research > > BT Innovate > > ___________________________ > > Office: +44(0) 1473 608192 > > Mobile: +44(0) 7730 426257 > > Fax : +44(0) 1473 606755 > > Email: alistair.d...@bt.com > > This email contains BT information, which may be privileged or > > confidential. > > It's meant only for the individual(s) or entity named > above. If you're > > not the intended > > recipient, note that disclosing, copying, distributing or using this > > information > > is prohibited. If you've received this email in error, please let me > > know immediately > > on the email address above. Thank you. > > We monitor our email system, and may record your emails. > > British Telecommunications plc > > Registered office: 81 Newgate Street London EC1A 7AJ > > Registered in England no: 1800000 > > > > _______________________________________________ > > Kim-discussion mailing list > > Kim-discussion@ontotext.com > > http://ontotext.com/mailman/listinfo/kim-discussion > _______________________________________________ Kim-discussion mailing list Kim-discussion@ontotext.com http://ontotext.com/mailman/listinfo/kim-discussion