oracle Database connection issue

tajudeen

I am using an evaluation version just downloaded for testing.

I have created two database schema for testing Aware IM system
The below comments i have executed to create 2 schemas in oracle database.

CREATE USER BASDB IDENTIFIED BY BASBD;

CREATE USER BASDBTEST IDENTIFIED BY BASDBTEST;

I have updated the system setting as

Database =oracle
username=BASDB
password=BASDB
Machine name=localhost
port=default
main database=BASDB
test database=BASDBTEST

When i try to connect using the awareIM control panel I am getting the following exception

Unable to connect to the existing database Could not establish connection with the data base org.apache.derby.impl.jdbc.EmbedSQLException Database 'BASDB' not found.

Creating main data base...

Database create is not supported for this database

Aware IM Server startup error Aware IM was unable to create or locate the databases it requires.
Error message returned by the database is:
Database create is not supported for this database exiting...

com.bas.basserver.bsmanager.StartupException: Aware IM was unable to create or locate the databases it requires.
Error message returned by the database is:
Database create is not supported for this database

at com.bas.basserver.persistence.PersistenceManager.initialise(Unknown Source)

at com.bas.basserver.bsmanager.f.a(Unknown Source)

at com.bas.basserver.bsmanager.o.if(Unknown Source)

at com.bas.basserver.bsmanager.j$c.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

INFO: BAS_PostedMessages.Controller running

TRACE: BAS_PostedMessages.Controller - Starting thread for Source OS

INFO: OS running in callback mode

Exception saving the output file java.util.ConcurrentModificationException null

Process status: Aware IM Server: Aware IM was unable to create or locate the databases it requires.
Error message returned by the database is:
Database create is not supported for this database

Overall status: Unable to start Aware IM server

Exception starting servers Aware IM was unable to create or locate the databases it requires.
Error message returned by the database is:
Database create is not supported for this database

Thanks

Regards,
Tajudeen

aware_support

It seems like the settings for Oracle in the system properties file BASServer.props are incorrect. How did you select Oracle as your database? Did you select it using the Settings button on the Control Panel or during installation?

Can you attach the contents of your BASServer.props file which is located in the BIN directory of your Aware IM installation?

tajudeen

Hi,

Please find below the contents of BASServer.properties.

#Tue Apr 28 14:22:39 GMT+04:00 2009
DriverTestURL=jdbc:oracle:thin:BASDB/BASDB@//localhost/BASDBTEST
UIProcessTimeout=1800000
ChannelTypeTimer=com.bas.basserver.channels.TimerChannelType
AwaresoftPort=8090
DirectoryServiceProvider=jnp://localhost:9650/
SystemPort=9000
DirectoryService=org.jnp.interfaces.NamingContextFactory
ChannelTypeMail=com.bas.basserver.channels.EmailChannelType
MaxNmbOfRepeats=1000
ChannelTypeSK=com.bas.basserver.channels.SocketChannelType
NotificationInQueue=queue/notifinqueue
EndRange=100000
MaxNmbOfRepeatsWithoutChange=50
AwaresoftHost=localhost
DriverURL=jdbc:oracle:thin:BASDB/BASDB@//localhost/BASDB
JMSFactory=ConnectionFactory
NotificationOutTopic=topic/notifouttopic
Hub=true
DatabaseName=BASDB
SessionTimeout=1800000
ChannelTypeWebServices=com.bas.basserver.channels.WebServicesChannelType
DatabaseComponent=com.bas.basserver.persistence.dbplugins.OracleInterface
BootstrapURL=jdbc:oracle:thin:BASDB/BASDB@//localhost/
DriverClassName=oracle.jdbc.driver.OracleDriver
LocalQueue=queue/defaultinputqueue
LocalTopic=topic/defaultoutputtopic
ChannelTypeURL=com.bas.basserver.channels.URLChannelType
DocumentEngines=com.bas.basserver.documents.JasperReportsEngine,com.bas.basserver.documents.MSWordDocumentEngine,com.bas.basserver.documents.TextDocumentEngine,com.bas.basserver.documents.HtmlDocumentEngine,com.bas.basserver.documents.MSExcelDocumentEngine
StartRange=1
DatabaseNameTest=BASDBTEST
RequestQueue=queue/skinputqueue
ReplyTopic=topic/skoutputtopic

Thanks

Taj

aware_support

The file is correct. The problem then is in the settings for Oracle database - the driver cannot connect to the database. Most probably either the machine name or the port number where Oracle is listening to is incorrect. Or the BASDB and BASDBTEST databases are not active. Please check all these settings. Please also try to connect to these databases using the Enterprise Manager.

tajudeen

Hi support,

I am able to connect throught sqlplus and Toad for this user BASDB

Please find below the oracle connecting string that we used to connect oralce from java

jdbc:oracle:thin:@localhost:1521:oracle9i

usename=BASDB
Password = BASDB

Thanks

Tajudeen

aware_support

You need to specify these settings in the Database tab of the Settings dialog in the Control Panel. It looks like port 1521 is not specified there and I can't remember whether it is the default Oracle port.

We had a similar problem which was only resolved when we started the Enterprise Manager for the BASDB database.

tajudeen

Hi support

I have tested by setting the port no 1521 still it is not connecting.
any help?

Regards
Tajudeen

aware_support

Can you see the status of BASDB database using the Enterprise Manager?

tajudeen

what is the status of BASDB? I cannot understand.

I am using evolution version for testing.
where can i find Enterprise Manager for testing?

Regards
Tajudeen

aware_support

Enterprise Manager is the tool Oracle provides. It is web driven and it reports the status of any database within Oracle - whether it is active, accessible or has any problems.

The exception you are getting is straightforward - Aware IM cannot connect to this database, which can only mean one of two things: there's something wrong with the database or the connection settings are wrong. If you are confident that the connection settings are OK, it must be the database.

tajudeen

Hi support,

I am able to connect oracle database throw sqlplus.

Once again a remainder is that I created 2 user named as BASDB and BASDBTEST in my local oracle Database. I am not able to connect oracle database thought Awareim application?
Is that I have to create 2 new database instead of 2 new users?

Regards
Tajudeen

tajudeen

As per the installation document I have created 2 new database as BASDB abd BASDBTES.

I am able to connect to the system.The next step after creating a application I am getting the following error in AwareIM Server

There was an internal problem while starting the Aware IM server. Please report the following error message to Awaresoft: Unable to initialise the database tables for testing due to the following exception

com.bas.basserver.persistence.PersistenceException Error creating database tables. SQL Exception thrown ORA-00955: name is already used by an existing object

Thank you

aware_support

Exactly when does this problem happen?

tajudeen

I was getting an exception that there is missing table BAS_IDGEN .
So i create the table BAS_IDGEN wth size 38 in my database.

CREATE TABLE BAS_IDGEN
(
MAX_ID NUMBER(38-)
)

INSERT INTO bas_idgen VALUES(1)

Now I am able to connect to the oracle database. I have imported a sample file that I have created in dozy.Now we we execute the test i am getting the below error in the log.

unable to initialise database interface com.bas.shared.dbplugins.OracleClientInterface
java.lang.NullPointerException
at com.bas.utils.c.a(Unknown Source)

I created a new CRM sample application that time also I am getting the same above exception

Please advice

Thanks

Regards
Tajudeen

tajudeen

Oops I mean to say Derby database and not dozy database

aware_support

This is a bug. We'll issue a patch to this problem ASAP.

aware_support

This should be fixed in build 1197

aware_support

Build 1197 is available for download now