Since you have changed databases, you should get rid of all of the
serialization that orion may have saved about the old configuration
(including maybe the flag that tells orion that cmp beans have already
created their table).
The easiest way to do this is just blow away the application directory in
application-deployments (of course, after you have shutdown orion). If you
have no other applications, you can just blow away the whole
application-deployment directory.
There is also an admin.jar command to do this....but I have never used it.
Otherwise, if the table is not created....there's something under the hood
that's broken, because this works everyday and sunday.
You have done all of the checks to make sure the you can connect and create
tables from orion...so there is some other issue that is causing this. My
bet is on the bad serialization...if not, its got to be a bug.
Here's the console from a proper auto-deployment (this is from the
tutorial):
Auto-unpacking
/usr/home/ernst/addressbook/addressbook/build/addressbook.ear... done.
Auto-deploying addressbook...
Auto-deploying addressbook-ejb.jar (No previous deployment found)...
Auto-creating table: create table addressbook_ejb_AddressEntry (name char
(255) not null primary key, address char (255), city char (255))
done.
Orion/1.2.7 initialized
I noticed that your console trace didn't have the un-packing bit. It could
be that when you change databases, you have to redo the whole auto-deploy
cycle to get the table to recreate. Since the table columns are exactly the
same, orion doesn't recreate the table...even though the database has
changed. I am not sure that this functionality would be a bug, or a
undocumented *feature* ;).
Regards,
the elephantwalker
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Brynolf
Andersson
Sent: Sunday, May 06, 2001 10:44 AM
To: Orion-Interest
Subject: RE: CMP Primer and Oracle 8.1.7 deployment
Hi,
Yes scott can create tables (connect,resource and dba)
Yes I can log on to the box run sqlplus and connect as scott, both from the
development PC and locally on the box.
Yes Net8 is running properly, I wrote a small servlet that uses JDBC to
create and read tables and that on is working fine.
Yes, the port is 1521
So, perhaps someone know a way to debug whats going on ?
Thanks
>From: "elephantwalker" <[EMAIL PROTECTED]>
>Reply-To: Orion-Interest <[EMAIL PROTECTED]>
>To: Orion-Interest <[EMAIL PROTECTED]>
>Subject: RE: CMP Primer and Oracle 8.1.7 deployment
>Date: Sat, 5 May 2001 17:37:17 -0700
>
>Has user scott allowed to create tables? (usually scott is allowed to
>create
>tables). Can you log into the sun box, start sqlplus, and connect as scott?
>Is net8 running properly? Is the port for net8 listed in the service file
>on
>the sun box? Can you connect to the sun box from an oracle client on your
>win 2000 box?
>
>These are the places I would start in debugging this problem.
>
>I have been running oracle 8.1.7 and orion with no problems.
>
>the elephantwalker
> -----Original Message-----
> From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]On Behalf Of Kalle Anka
> Sent: Saturday, May 05, 2001 4:45 PM
> To: Orion-Interest
> Subject: Q:CMP Primer and Oracle 8.1.7 deployment
>
>
> Hi all,
> I'm trying to deploy the CMP Primer (running on Win2000) using an Oracle
>8.1.7 database on a Solaris box. Everything works fine if I use the default
>database provided by Orion (Hypersonic ??). The table is created according
>to the extremly good example. But when I change the data-sources.xml into
>the following, the table is not created (I removed the hypersonic and added
>the Oracle one, so only one entry).
>
> <data-source
> class="com.evermind.sql.DriverManagerDataSource"
> name="Oracle"
> schema="database-schemas/oracle.xml"
> location="jdbc/OracleCoreDS"
> xa-location="jdbc/xa/OracleXADS"
> ejb-location="jdbc/OracleDS"
> connection-driver="oracle.jdbc.driver.OracleDriver"
> username="scott"
> password="tiger"
> url="jdbc:oracle:thin:@sunprod:1521:orcl"
> inactivity-timeout="30"
> />
>
> So, I turned on the debugging information for JDBC, but no errors:
>
> C:\orion>java -Ddatasource.verbose=true -jar orion.jar Auto-deploying
>addressbook (New server version detected)...
> DataSource logwriter activated...
> jdbc:oracle:thin:@sunprod:1521:orcl: Started
> jdbc:oracle:thin:@sunprod:1521:orcl: Started
> Auto-deploying addressbook-ejb.jar (No previous deployment found)...
> Created new physical connection: XA XA Orion Pooled
>jdbc:oracle:thin:@sunprod:1521:orcl
> null: Connection XA XA Orion Pooled jdbc:oracle:thin:@sunprod:1521:orcl
>allocated (Pool size: 0)
> jdbc:oracle:thin:@sunprod:1521:orcl: Opened connection Created new
>physical connection: Pooled oracle.jdbc.driver.OracleConnection@ece70d1a
> Pooled jdbc:oracle:thin:@sunprod:1521:orcl: Connection Pooled or
> acle.jdbc.driver.OracleConnection@ece70d1a allocated (Pool size: 0)
> Pooled jdbc:oracle:thin:@sunprod:1521:orcl: Releasing connection
> Pooled oracle.jdbc.driver.OracleConnection@ece70d1a to pool (Pool size:
>1)
> null: Releasing connection XA XA Orion Pooled
>jdbc:oracle:thin:@sunprod:1521:orcl to pool (Pool size: 1)
> done.
> Orion/1.4.5 initialized
>
> Anyone got a clue why this is happening, or have I missed something ???
>
> //Kalle
>
>
>---------------------------------------------------------------------------
-
>--
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
