-
1. Re: loosing my mind, need help before i loose it completely
oglueck Nov 17, 2005 4:22 PM (in response to boost)Read this before you loose your mind: http://www.jboss.com/index.html?module=bb&op=viewtopic&t=72597
-
2. Re: loosing my mind, need help before i loose it completely
boost Nov 17, 2005 4:27 PM (in response to boost)i see it's jms, does it apply to ordinary cmp and session beans?
-
3. Re: loosing my mind, need help before i loose it completely
oglueck Nov 17, 2005 4:45 PM (in response to boost)For CMP:
* deploy a new datasource (with a name like "cmpDS")
* use the cmpDS in your persistence.xml (if you use EJB3)
or change it globally in standardjbosscmp-jdbc.xml -
4. Re: loosing my mind, need help before i loose it completely
boost Nov 18, 2005 7:15 AM (in response to boost)ok, thanks, you will have to forgive me but i have to ask, what about login.config.xml file? Do i need to change that as well? And how?
-
5. Re: loosing my mind, need help before i loose it completely
boost Nov 18, 2005 8:01 AM (in response to boost)well, i have tried what you said, but i'm not using ejb3 so i guess it's abit different.
Here is what i did:
1. copied the jdbc drivers of postgresql to server/all/lib and to server/default/lib.
2. copied the postgres-ds.xml file from docs/examples in to server/default/deploy.
3. modified that file so it now reads<datasources> <local-tx-datasource> <jndi-name>PostgresDS</jndi-name> <use-java-context>true</use-java-context> <connection-url>jdbc:postgresql://localhost:5432/boostbox</connection-url> <driver-class>org.postgresql.Driver</driver-class> <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation> <user-name>myUsername</user-name> <password>mypassword</password> <min-pool-size>1</min-pool-size> <max-pool-size>10</max-pool-size> <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> <metadata> <type-mapping>PostgreSQL 8.0</type-mapping> </metadata> </local-tx-datasource> </datasources>
4. changed server/default/conf/standardjboss-jdbc.xml so it reads:<defaults> <datasource>java:/PostgresDS</datasource> <datasource-mapping>PostgreSQL 8.0</datasource-mapping> <create-table>true</create-table> <remove-table>false</remove-table> <read-only>false</read-only> <read-time-out>300000</read-time-out> <row-locking>false</row-locking> <pk-constraint>true</pk-constraint> <fk-constraint>false</fk-constraint> <preferred-relation-mapping>foreign-key</preferred-relation-mapping> <read-ahead> <strategy>on-load</strategy> <page-size>1000</page-size> <eager-load-group>*</eager-load-group> </read-ahead> <list-cache-max>1000</list-cache-max> <clean-read-ahead-on-load>false</clean-read-ahead-on-load> <unknown-pk> <key-generator-factory>UUIDKeyGeneratorFactory</key-generator-factory> <unknown-pk-class>java.lang.String</unknown-pk-class> <jdbc-type>VARCHAR</jdbc-type> <sql-type>VARCHAR(32)</sql-type> </unknown-pk> <entity-command name="default"/> <ql-compiler>org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler</ql-compiler> <throw-runtime-exceptions>false</throw-runtime-exceptions> </defaults>
5. also changed the server/default/conf/standardjaws.xml<jaws> <datasource>java:/PostgresDS</datasource> <type-mapping>PostgreSQL 8.0</type-mapping> <debug>false</debug>
It still doesn't work, so i'm wondering if anyone can give me some pointers as to where it all goes to H***
Thanks.. -
7. Re: loosing my mind, need help before i loose it completely
boost Nov 19, 2005 8:53 AM (in response to boost)Ok. I am frustrated, but i will try to narrow down my question.
I am using netbeans to deploy and develop the application. I have constructed a very simple cmp and session bean (ejb 2.0).
PROGRESS: i fired up ethereal and sniffed up some traffic going from my computer to the remote oracle database server. it seems as my application is connecting to some random port and not the oracle port 1521 defined in my server/default/deploy/oracle-ds.xml file. The server replies with no valid data etc.
At the same time the application uses the hypersonic database... And i get a lot of errors at deployment. here are the first ones...--- MBeans waiting for other MBeans --- ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database State: CONFIGURED I Depend On: jboss.jca:service=DataSourceBinding,name=DefaultDS ObjectName: jboss.mq:service=InvocationLayer,type=HTTP State: CONFIGURED I Depend On: jboss.mq:service=Invoker jboss.web:service=WebServer ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo State: CONFIGURED I Depend On: jboss:service=TransactionManager jboss.jca:service=DataSourceBinding,name=DefaultDS
-
8. Re: loosing my mind, need help before i loose it completely
boost Nov 19, 2005 8:59 AM (in response to boost)hmm... this might give some useful information. it's from the deployment of the apllication:
--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- ObjectName: jboss.jca:service=DataSourceBinding,name=DefaultDS State: NOTYETINSTALLED Depends On Me: jboss.ejb:service=EJBTimerService,persistencePolicy=database jboss:service=KeyGeneratorFactory,type=HiLo jboss.mq:service=StateManager jboss.mq:service=PersistenceManager
I guess it's something wrong with the confiuration of the datasource, but i really don't know where i should begin..