[ openjms-Bugs-612764 ] Delete database before server starts

Bugs item #612764, was opened at 2002-09-22 07:32
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=612764&group_id=54559

Category: server
Group: v0.7.2b14
>Status: Closed
>Resolution: Invalid
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: Delete database before server starts

Initial Comment:
With oracle i must always delete my database
before i can start the server?
When i do not run 
'sqlplus user/[email protected] < create_oracle.sql'
before i start the server, the server crashes with a 
PersistenceException.
If there are new messages in the database, this isn't
ok when i must delete the complete messages, before 
Durable Subscribers have fetched there new messages. 

----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2002-09-27 05:17

Message:
Logged In: NO 

Problem resolved !!!
For oracle 9i it must be the jdbc-driver for oracle 9.i database
and not an 8.i jdbc-driver.

Recommend :

In all the xml scripts there must be another entry for oracle:
(An recommendation from ORACLE self)

    <RdbmsDatabaseConfiguration
      driver="oracle.jdbc.OracleDriver"
      ...
instead

   <RdbmsDatabaseConfiguration
      driver="oracle.jdbc.driver.OracleDriver"
      ...

Bye 

----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2002-09-27 03:33

Message:
Logged In: NO 

In addition:
I use the oracle thin driver(classes12.zip) and not the oci driver.


----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2002-09-27 02:23

Message:
Logged In: NO 

Also, my little java program runs with connection-pooling.
I close my ResultSet and give the reserved connection
back to the pool.

----------------------------------------------------------------------

Comment By: Tim Anderson (tanderson)
Date: 2002-09-27 02:23

Message:
Logged In: YES 
user_id=557161

What oracle JDBC drivers are you using?
Is your test program using the same driver and url as 
that used for OpenJMS?
Have you tried creating the database using dbtool.bat?


----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2002-09-27 02:15

Message:
Logged In: NO 

Yes, my small java program runs correct. 1*, 10*, 100*
(Why i close my ResultSet's and Connection's correct???)

----------------------------------------------------------------------

Comment By: Tim Anderson (tanderson)
Date: 2002-09-27 01:25

Message:
Logged In: YES 
user_id=557161

The problem is this:
java.sql.Exception: E/A-Exception: Connection refused
(DESCRIPTION=(TMP=)
(VSNNUM=15099297)(ERR=12500)(ERROR_STACK=
(ERROR=
(CODE=12500)(EMFI=4))
(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)
(EMFI=4))
(ERROR=(BUF='32-bit Windows Error: 2: No such file or 
directory'))))

Try writing a small java program and see if you can get a 
connection to your database.

----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2002-09-27 01:11

Message:
Logged In: NO 

I use oracle 8.1.7 and oracle 9.0

org.exolab.jms.persistence.PersistenceException: 
Failed to create RDBMAdapter

org.exolab.core.foundation.FailedToCreateDatabaseException: 
Failed to create RDBMSConnector
org.exolab.jms.persistence.PersistenceException: 
Error in getConnection
java.sql.Exception: E/A-Exception: Connection refused
(DESCRIPTION=(TMP=)
(VSNNUM=15099297)(ERR=12500)(ERROR_STACK=(ERROR=
(CODE=12500)(EMFI=4))
(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)
(EMFI=4))
(ERROR=(BUF='32-bit Windows Error: 2: No such file or 
directory'))))
at 
org.exolab.jms.persistence.DatabaseService.createRdbmsAdapter
(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.<init>(Unknown 
Source)
at org.exolab.jms.persistence.DatabaseService.instance
(Unknown Source)
at org.exolab.jms.server.JmsServer.<init>(Unknown Source)
at org.exolab.jms.server.JmsServer.main(Unknown Source)
org.exolab.jms.server.FailedToCreateServerException: 
JmsServer constructor failure
org.exolab.jms.persistence.PersistenceException: Failed to 
create RDBMAdapter
org.exolab.core.foundation.FailedToCreateDatabaseException: 
Failed to create RDBMSConnector
org.exolab.jms.persistence.PersistenceException: Error in 
getConnection
java.sql.Exception: E/A-Exception: Connection refused
(DESCRIPTION=(TMP=)
(VSNNUM=15099297)(ERR=12500)(ERROR_STACK=(ERROR=
(CODE=12500)(EMFI=4))
(ERROR=(CODE=12560)(EMFI=4))(ERROR=(CODE=530)
(EMFI=4))
(ERROR=(BUF='32-bit Windows Error: 2: No such file or 
directory')))) 
at org.exolab.jms.server.JmsServer.<init>(Unknown Source)
at org.exolab.jms.server.JmsServer.main(Unknown Source)

----------------------------------------------------------------------

Comment By: Tim Anderson (tanderson)
Date: 2002-09-26 00:44

Message:
Logged In: YES 
user_id=557161

Need some more detail:
. what version of oracle are you using
. what is the stack trace of the exception
. debug output


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=474136&aid=612764&group_id=54559