subject:"Re\: \[JBoss\-user\] mysql"

Re: [JBoss-user] MySQL datastore question

2003-11-03 Thread Adrian Brock

On Mon, 2003-11-03 at 08:20, Michael Klem wrote:
> I am running my app on JBoss 3.0.8. I have 2 servers which each run 
> an instance of my app. I use one server as a backup. It remains 
> running but receives no input until I redirect the input to this 
> server.
> 
> My app uses MySQL as a JMS datastore. I currently run an instance of 
> MySQL on each server. I was wondering if it would be better to run 
> MySQL on its own server and have each instance of my app use the same 
> MySQL database as their datastore. Since only 1 app would be 
> receiving input this should in theory work.
> 
> Has anyone done this before?
> Is the JMS datastore meant to be used like this?
> 

The JMS jdbc datastore is not a live source of data.
It is not intended to be shared by two servers. If you do this
it will break.

If one server crashes, another server can recover where the
other server left off. But only if they both have the same information
about durable subscriptions (stored in conf/jbossmq-state.xml).

Regards,
Adrian

> I have found some issues such as if the backup server is brought up 
> first, it will process any stored messages, which makes sense. If my 
> main server goes down, the only way I have found for the back up app 
> to process any stored messages is to stop and restart it. When it 
> comes up, it will then process any stored messages created by the 
> previous app instance.
> 
> When running MySQL on each server, my remaining question is should I 
> replicate the JMS datastore data to MySQL on the back up server? How 
> much extra load would this create?
> 
> Thanks
-- 
 
Adrian Brock
Director of Support
Back Office
JBoss Group, LLC 
 



---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySQL XA Configuration

2003-08-19 Thread Bruce Slawson

Thanks Ionel.  I was seeing the message you mentioned.  I thought there 
was something else I needed to configure to make it go away.

Bruce



Ionel Gardais wrote:

Hi,

I was looking for the same thing a couple of weeks ago.
I found that Connector/J (the mySQL jdbc connector) does not natively 
support XA and is only in a kind of beta state with an internal XA 
emulation.

That is, you can only use basic configuration for mySQL.
JBoss will manage the wrapping to use XA, providing the following 
warning message.

WARN  [TxConnectionManager$LocalXAResource] Prepare called on a local 
tx. Use of local transactions on a jta transaction with more than one 
branch may result in inconsistent data in some cases of failure.


Hope this could help,
ionel


---
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa0013ave/direct;at.aspnet_072303_01/01 

___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user




---
This SF.net email is sponsored by Dice.com.
Did you know that Dice has over 25,000 tech jobs available today? From
careers in IT to Engineering to Tech Sales, Dice has tech jobs from the
best hiring companies. http://www.dice.com/index.epl?rel_code=104
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySQL XA Configuration

2003-08-19 Thread Ionel Gardais

Hi,

I was looking for the same thing a couple of weeks ago.
I found that Connector/J (the mySQL jdbc connector) does not natively 
support XA and is only in a kind of beta state with an internal XA 
emulation.

That is, you can only use basic configuration for mySQL.
JBoss will manage the wrapping to use XA, providing the following 
warning message.

WARN  [TxConnectionManager$LocalXAResource] Prepare called on a local 
tx. Use of local transactions on a jta transaction with more than one 
branch may result in inconsistent data in some cases of failure.


Hope this could help,
ionel


---
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa0013ave/direct;at.aspnet_072303_01/01
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

RE: [JBoss-user] mysql jca adapter

2003-08-14 Thread Marco.Mistroni

Hi,
dunno if it solves ur problem,but if u go to mysql website they have
a jdbc connector. i m currently using it, the jar that u have to put in
jboss dir is named mysql-connector-java-2.0.14-bin.jar

regards
marco

> -Original Message-
> From: ext [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: 08 August, 2003 13:34
> To: [EMAIL PROTECTED]
> Subject: [JBoss-user] mysql jca adapter
> 
> 
> Hi,
> 
> I want to run jboss with mysql via a jca adapter. I do the 
> same already with sap. Have I to install a jca adapter, or 
> comes one with jboss? Does anyone knows a good open source 
> mysql or db jca adapter which can be used in different 
> application server?
> 
> thanks 
> Juraj 
> 
> 
> ---
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa0013ave/direct;at.aspnet
> _072303_01/01
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 


---
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa0013ave/direct;at.aspnet_072303_01/01
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

RE: [JBoss-user] MySql, Transactions and deployment

2003-04-05 Thread Rod Cope

Brian,

I'm not sure about 3.23.x, but on 4.0.x and higher you can start the
database with --default-table-type=InnoDB to do what you need.

HTH,
Rod


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian McSweeney
Sent: Saturday, April 05, 2003 4:09 AM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] MySql, Transactions and deployment

Hi all,
 
I'm using mysql version 3.23.52
 
I've read that for transactions to be supported you have to use the 
mysql process mysqld-max and have to have it set up to support 
transactions by enabling tables of type InnoDB or BDB as opposed 
to the default of type ISAM.
 
My question is, I want to be able to create tables by dropping an 
ear into JBoss using CMP, however I think the default CREATE TABLE creates 
tables as type ISAM, which does not support transaction. 
 
Is there a way to include the clause "type=InnoDB" using hot deploy 
in JBoss to enable transaction support?
 
thanks,
Brian




---
This SF.net email is sponsored by: ValueWeb:
Dedicated Hosting for just $79/mo with 500 GB of bandwidth!
No other company gives more support or power for your dedicated server
http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySql, Transactions and deployment

2003-04-05 Thread costin

Hi!

I am using the same combination (in fact I use MysqlMax 4.0.1x) which
have InnoDB by default.

However, I have support for transaction but without any InnoDB option.
I can query CMR relations and all that which require transaction.
I don`t know how this good this is (I am open for solutions however).

So, try to just install mysql-max or whatever and start doing your
thing and see how well the database behaves


BM> Hi all,

BM> I'm using mysql version 3.23.52

BM> I've read that for transactions to be supported you have to use the 
BM> mysql process mysqld-max and have to have it set up to support 
BM> transactions by enabling tables of type InnoDB or BDB as opposed 
BM> to the default of type ISAM.

BM> My question is, I want to be able to create tables by dropping an 
BM> ear into JBoss using CMP, however I think the default CREATE TABLE creates 
BM> tables as type ISAM, which does not support transaction. 

BM> Is there a way to include the clause "type=InnoDB" using hot deploy 
BM> in JBoss to enable transaction support?

BM> thanks,
BM> Brian


-- 
 costinmailto:[EMAIL PROTECTED]



---
This SF.net email is sponsored by: ValueWeb: 
Dedicated Hosting for just $79/mo with 500 GB of bandwidth! 
No other company gives more support or power for your dedicated server
http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql auto-increment

2003-02-26 Thread Alex Loubyansky

Rene,

the driver you are using doesn't have method
java.sql.ResultSet PreparedStatement.getGeneratedKeys().
You need to upgrade the driver.

alex

Thursday, February 27, 2003, 4:55:18 AM, Rene Palad wrote:

RP> Hi,

RP> I'm following the recent discussion about PK
RP> generation in 3.2 specifically mysql auto-increment
RP> and presently I'm getting:

RP> javax.ejb.EJBException: Unexpected Error
RP> java.lang.NoSuchMethodError:
RP> com.mysql.jdbc.PreparedStatement.getGeneratedKeys()Ljava/sql/ResultSet;

RP> The detailed log error shown below.  Besides the
RP> configuration in jbosscmp-jdbc.xml are there
RP> additional steps I'm missing?

RP> Thanks in advance!
RP> Rene

RP> ==details.
RP> jbosscmp-jdbc.xml:

RP> 
RP>jsCode
RP>JS_CODE
RP>INTEGER
RP>INTEGER(11)
RP>
RP> 
RP> 

RP> entitybean ejbCreate:

RP> public java.lang.Integer ejbCreate (java.lang.String
RP> JS_NM,  java.lang.String JS_DESC, byte JS_FRZ_JRNL,
RP> byte JS_JRNL_APPRVL, char JS_EFFCTV_DT_RL)
RP> throws CreateException {

RP> setJsName(JS_NM);
RP> setJsDescription(JS_DESC);
RP> setJsFreezeJournal(JS_FRZ_JRNL);
RP> setJsJournalApproval(JS_JRNL_APPRVL);
RP> setJsEffectiveDateRule(JS_EFFCTV_DT_RL);
RP> return null;
RP> }

RP> log error:

RP> 2003-02-27 10:11:26,289 INFO  [com.ejb.txn]
RP> GlJournalSourceControllerBean addGlJsEntry
RP> 2003-02-27 10:11:26,289 INFO  [com.ejb.txn]
RP> GlJournalSourceBean ejbCreate
RP> 2003-02-27 10:11:26,539 ERROR
RP> [org.jboss.ejb.plugins.LogInterceptor]
RP> TransactionRolledbackLocalException, causedBy:
RP> javax.ejb.EJBException: Unexpected Error
RP> java.lang.NoSuchMethodError:
RP> com.mysql.jdbc.PreparedStatement.getGeneratedKeys()Ljava/sql/ResultSet;
RP> at
RP> 
org.jboss.ejb.plugins.cmp.jdbc.mysql.JDBCMySQLCreateCommand.insertEntity(JDBCMySQLCreateCommand.java:126)
RP> at
RP> 
org.jboss.ejb.plugins.cmp.jdbc.mysql.JDBCMySQLCreateCommand.execute(JDBCMySQLCreateCommand.java:75)
RP> at
RP> 
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:575)
RP> at
RP> 
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:225)
RP> at
RP> 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:270)
RP> at
RP> org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:571)
RP> at
RP> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
RP> Method)
RP> at
RP> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
RP> at
RP> 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RP> at java.lang.reflect.Method.invoke(Method.java:324)
RP> at
RP> 
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:998)
RP> at
RP> org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73)
RP> at
RP> 
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:207)
RP> at
RP> 
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)
RP> at
RP> org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73)
RP> at
RP> 
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:91)
RP> at
RP> 
org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79)
RP> at
RP> 
org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44)
RP> at
RP> 
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:112)
RP> at
RP> 
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243)
RP> at
RP> org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74)
RP> at
RP> org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:105)
RP> at
RP> org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:133)
RP> at
RP> 
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:125)
RP> at
RP> org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:477)
RP> at org.jboss.ejb.Container.invoke(Container.java:672)
RP> at
RP> 
org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272)
RP> at
RP> org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
RP> at $Proxy261.create(Unknown Source)
RP> at
RP> 
com.ejb.txn.GlJournalSourceControllerBean.addGlJsEntry(GlJournalSourceControllerBean.java:145)
RP> at
RP> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
RP> Method)
RP> at
RP> sun.reflect.N

Re: [JBoss-user] MySQL connector on 3.2.0RC2

2003-02-18 Thread David Jencks

Excuse me for my previous reply, in fact in 3.2RC2 you should use 

java:/TransactionManager

and ignore the warning.

I have just checked in the code that allows you to use

jboss:service=TransactionManager


so it is available in cvs but not in 3.2RC2.

thanks
david jencks

On 2003.02.18 05:47 Benjamin Cox wrote:
> Hello,
>   I have just downloaded 3.2.0RC2 (the zip file, after building from 
> source failed), and tried to set up two MySQL datasources.  I copied the 
> mysql-service.xml file from 
> $JBOSS_HOME/docs/examples/jca/mysql-service.xml and modified the 
> connection, etc. properties.  When I ran JBoss, it complained with the 
> following warning:
> 
> 02:37:24,418 WARN  [XATxConnectionManager] 
> --
> 02:37:24,418 WARN  [XATxConnectionManager] 
> --
> 02:37:24,418 WARN  [XATxConnectionManager] Please change your datasource 
> setup to use TransactionManagerService with object name 
> jboss.tm:service=TransactionManagerService
> 02:37:24,418 WARN  [XATxConnectionManager] instead of TransactionManager 
> with value java:/TransactionManager
> 02:37:24,419 WARN  [XATxConnectionManager] 
> --
> 02:37:24,419 WARN  [XATxConnectionManager] 
> --
> 
>   Trying to run anyway resulted in a lot of exceptions in my 
> application, all indicating I didn't set up my datasources correctly. 
>  So, I followed the advice of the warning, and changed the line:
>  name="TransactionManager">java:/TransactionManager  
> to:
>  
>name="TransactionManagerService">jboss.tm:service=TransactionManagerService
> 
>   Running again, I received four copies of the following error (2 per 
> datasource):
> 
> 02:37:25,158 INFO  [LocalTxConnectionManager] Starting
> 02:37:25,159 ERROR [LocalTxConnectionManager] Starting failed
> javax.management.InstanceNotFoundException: 
> jboss.tm:service=TransactionManagerService is not registered.
> at 
> org.jboss.mx.server.registry.BasicMBeanRegistry.get(BasicMBeanRegistry.java:354)
> at 
> org.jboss.mx.server.MBeanServerImpl.getAttribute(MBeanServerImpl.java:445)
> at 
> 
>org.jboss.resource.connectionmanager.TxConnectionManager.startService(TxConnectionManager.java:277)
> at 
> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
> at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
> at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at 
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
> at 
> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
> at $Proxy11.start(Unknown Source)
> at org.jboss.system.ServiceController.start(ServiceController.java:392)
> at org.jboss.system.ServiceController.start(ServiceController.java:408)
> at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
> at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at 
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy5.start(Unknown Source)
> at org.jboss.deployment.SARDeployer.start(SARDeployer.java:231)
> at org.jboss.deployment.MainDeployer.start(MainDeployer.java:827)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:639)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:612)
> at sun.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)
> at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at 
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy7.deploy(Unknown Source)
> at 
> 
>org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:404)
> at 
> org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:545)
> at 
> 
>org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:195)
> at 
> 
>org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:268)
> at 
> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:19

RE: [JBoss-user] MySQL connector on 3.2.0RC2

2003-02-18 Thread David Jencks

Change the entire attribute element to

jboss:service=TransactionManager

david jencks
On 2003.02.18 09:00 David Jencks wrote:
> The original warnings are just that, warnings.  The deployment should
> still
> work. 
> 
> To remove the warnings, use the object name 
> 
> jboss:service=TransactionManager
> 
> If this doesn't solve all the problems please show some stack trace from
> when the datasource is being deployed and check the jmx console to see if
> the mbeans mentioned in the *-service file are 
> 
> sorry about this, I backported a lot of stuff from head and didn't notice
> the text of this warning.
> 
> thanks
> david jencks
> 
> 
> On 2003.02.18 06:35 Egger Lothar wrote:
> > hi list, hi Benjamin
> > 
> > same here with oracle jdbc :(
> > 
> > cheers
> > 
> > Lothar
> > 
> > > -Original Message-
> > > From: Benjamin Cox [mailto:[EMAIL PROTECTED]] 
> > > 02:37:24,418 WARN  [XATxConnectionManager] Please change your 
> > > datasource 
> > > setup to use TransactionManagerService with object name 
> > > jboss.tm:service=TransactionManagerService
> > > 02:37:24,418 WARN  [XATxConnectionManager] instead of 
> > > TransactionManager 
> > > with value java:/TransactionManager
> > >  So, I followed the advice of the warning, and changed the line:
> > >  > > name="TransactionManager">java:/TransactionManager  
> > > to:
> > >  > > name="TransactionManagerService">jboss.tm:service=TransactionM
> > > anagerService
> > > 
> > >   Running again, I received four copies of the following error (2 per
> 
> > > datasource):
> > > 
> > > 02:37:25,158 INFO  [LocalTxConnectionManager] Starting
> > > 02:37:25,159 ERROR [LocalTxConnectionManager] Starting failed
> > > javax.management.InstanceNotFoundException: 
> > > jboss.tm:service=TransactionManagerService is not registered.
> > > at 
> > .
> > 
> > 
> > ---
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > ___
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/jboss-user
> > 
> > 
> 
> 
> ---
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 
> 


---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

RE: [JBoss-user] MySQL connector on 3.2.0RC2

2003-02-18 Thread David Jencks

The original warnings are just that, warnings.  The deployment should still
work. 

To remove the warnings, use the object name 

jboss:service=TransactionManager

If this doesn't solve all the problems please show some stack trace from
when the datasource is being deployed and check the jmx console to see if
the mbeans mentioned in the *-service file are 

sorry about this, I backported a lot of stuff from head and didn't notice
the text of this warning.

thanks
david jencks


On 2003.02.18 06:35 Egger Lothar wrote:
> hi list, hi Benjamin
> 
> same here with oracle jdbc :(
> 
> cheers
> 
> Lothar
> 
> > -Original Message-
> > From: Benjamin Cox [mailto:[EMAIL PROTECTED]] 
> > 02:37:24,418 WARN  [XATxConnectionManager] Please change your 
> > datasource 
> > setup to use TransactionManagerService with object name 
> > jboss.tm:service=TransactionManagerService
> > 02:37:24,418 WARN  [XATxConnectionManager] instead of 
> > TransactionManager 
> > with value java:/TransactionManager
> >  So, I followed the advice of the warning, and changed the line:
> >  > name="TransactionManager">java:/TransactionManager  
> > to:
> >  > name="TransactionManagerService">jboss.tm:service=TransactionM
> > anagerService
> > 
> >   Running again, I received four copies of the following error (2 per 
> > datasource):
> > 
> > 02:37:25,158 INFO  [LocalTxConnectionManager] Starting
> > 02:37:25,159 ERROR [LocalTxConnectionManager] Starting failed
> > javax.management.InstanceNotFoundException: 
> > jboss.tm:service=TransactionManagerService is not registered.
> > at 
> .
> 
> 
> ---
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 
> 


---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

RE: [JBoss-user] MySQL connector on 3.2.0RC2

2003-02-18 Thread Egger Lothar

hi list, hi Benjamin

same here with oracle jdbc :(

cheers

Lothar

> -Original Message-
> From: Benjamin Cox [mailto:[EMAIL PROTECTED]] 
> 02:37:24,418 WARN  [XATxConnectionManager] Please change your 
> datasource 
> setup to use TransactionManagerService with object name 
> jboss.tm:service=TransactionManagerService
> 02:37:24,418 WARN  [XATxConnectionManager] instead of 
> TransactionManager 
> with value java:/TransactionManager
>  So, I followed the advice of the warning, and changed the line:
>  name="TransactionManager">java:/TransactionManager  
> to:
>  name="TransactionManagerService">jboss.tm:service=TransactionM
> anagerService
> 
>   Running again, I received four copies of the following error (2 per 
> datasource):
> 
> 02:37:25,158 INFO  [LocalTxConnectionManager] Starting
> 02:37:25,159 ERROR [LocalTxConnectionManager] Starting failed
> javax.management.InstanceNotFoundException: 
> jboss.tm:service=TransactionManagerService is not registered.
> at 
.


---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySQL Connector J3.0.5 Gamma with JBoss...

2003-02-09 Thread Olle Hallin

Hi!

I bet 1 Euro on that you are using MySQL 3.23 or older.

There is a bug in the Connector/J 3.0.5 code for getting the isolation 
level from a 3.23 server.

The bug does not appear when accessing MySQL 4.x

Regards,
Olle Hallin


Márcio Emílio Cruz Vono de Azevedo wrote:

Hi all,
 
We've been trying to access a MySQL database by JNDI using JBoss 3.0.4 
with Connector J3.0.5 Gamma as JDBC driver. When I try to get 
connection an exception is throwed.


Follows the source code:

Context c = new InitialContext ();
javax.sql.DataSource datasource = (javax.sql.DataSource) c.lookup 
("java:/AcmeSQL");
m_connectionDB = datasource.getConnection (new String ("root"), new 
String (""));


Follows the exception:

javax.ejb.EJBException: ICCProductionEJB: Could not create connection; 
- nested throwable: (java.sql.SQLException: Could not retrieve 
transaction isolation level from server); - nested throwable: 
(org.jboss.resource.ResourceException: Could not create connection; - 
nested throwable: (java.sql.SQLException: Could not retrieve 
transaction isolation level from server))

What do I need to configure to get the connection properly?

Thanks in advance,

Márcio Azevedo.

--
Márcio Emílio Cruz Vono de Azevedo
Especialista em Sistemas
Inatel Competence Center
http://www.inatel.br 

 




---
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySQL Datasource configuration problem

2003-01-16 Thread James Cleary


Try changing the first occurence of "name" to "service" as follows.  Not
sure which version of JBoss they changed this in but it's always biting me
because we run several versions.

 jboss.secur
ity:service=JaasSecurityManager




> 
optional-attribute-name="JaasSecurityManagerService">jboss.security:service=
JaasSecurityManager
>
>




**
This e-mail and any files transmitted with it may be confidential and
may be legally privileged or otherwise exempt from disclosure under
applicable law. This e-mail and its files are intended solely for
the individual or entity to whom they are addressed and their content
is the property of Smiths Aerospace.  If you are not the intended
recipient, please do not read, copy, use or disclose this communication.
If you have received this e-mail in error please notify the e-mail 
administrator at [EMAIL PROTECTED] and then delete this e-mail, its
files and any copies.

This footnote also confirms that this e-mail message has been scanned
for the presence of known computer viruses.

Smiths addresses are changing!  The new addresses are of the form
[EMAIL PROTECTED]  Please update your address
books!  Please begin using the new form immediately.
***


---
This SF.NET email is sponsored by: Thawte.com
Understand how to protect your customers personal information by implementing
SSL on your Apache Web Server. Click here to get our FREE Thawte Apache 
Guide: http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0029en
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySQL Datasource configuration problem

2003-01-15 Thread Alex Loubyansky

The datasources can't be accessed outside the VM JBoss is running in.

alex

Thursday, January 16, 2003, 2:22:26 AM, you wrote:

PK> Hi there,

PK> I'm unable to get a MySql datasource configured and know that it's probably a dumb 
configration
PK> error on my part, but I've spent a day trying to figure it out to no avail, and am 
hoping someone
PK> can shed some light.

PK> I've configured mysql-service.xml and standardjbosscmp-jdbc.xml according to 
numerous tutorials on
PK> the web, and when JBoss boots I see the following msg:

PK> [mySQLDS] Bound connection factory for resource adapter 'JBoss LocalTransaction 
JDBC Wrapper' to
PK> JNDI name 'java:/mySQLDS'

PK> ...ie everything appears ok.

PK> It also says:
PK> [ServiceController] jboss.jca:service=LocalTxDS,name=mySQLDS does not implement 
any Service
PK> methods

PK> which I'm not sure is an error or not. However, when I try to deploy a Jar 
containing beans which
PK> need the datasource, I get the following error:

PK> 14:28:01,713 WARN  [ServiceController] Problem starting service
PK> jboss.j2ee:jndiName=MyContractBean,service=EJB
PK> org.jboss.deployment.DeploymentException: Error: can't find data source: mySQLDS; 
- nested
PK> throwable: (javax.naming.NameNotFoundException: mySQLDS not bound)

PK> I checked JNDIView in the JMX console, and mySQLDS is showing in the java: 
Namespace but not in
PK> the Global JNDI Namespace. I guess this is the problem, but I'm not sure how to 
rectify it.

PK> I'm running JBoss 3.0.4_tomcat-4.1.12 and mysqld-max-nt (3.23.54) on Win2K.

PK> Below is my mysql-service.xml and relevant extract from my 
standardjbosscmp-jdbc.xml file.

PK> Thanks in advance,
PK> -Paul

PK> __
PK> Do you Yahoo!?
PK> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
PK> http://mailplus.yahoo.com
PK> 

PK> 
PK> 
PK> 
PK> 
PK> 

PK> 

PK>   
PK>   
PK>   
PK>   

PK>name="jboss.jca:service=LocalTxCM,name=mySQLDS">


PK> 
PK> 

PK> 
PK>   
PK>name="jboss.jca:service=LocalTxDS,name=mySQLDS">

PK> mySQLDS

PK> 
PK>   
PK>  type="java.lang.String">jdbc:mysql://localhost:3306/kavo
PK>  type="java.lang.String">org.gjt.mm.mysql.Driver
PK> 
PK> kavo
PK> kavo
PK>   

PK> 

PK> 
PK> 
PK>  
optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss
PK> LocalTransaction JDBC Wrapper

PK>   
PK> 

PK> 
PK>   
PK>name="jboss.jca:service=LocalTxPool,name=mySQLDS">

PK> 0
PK> 50
PK> 5000
PK> 15
PK> 
PK> ByContainer
PK>   

PK> 
PK>  
optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager

PK>  
optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager

PK> java:/TransactionManager
PK> 
PK> jboss.jca:service=RARDeployer

PK>   


PK> 

PK> 
PK> 

PK> 
PK> 
PK> 
PK> 
PK> 

PK> 

PK> 
   
PK>
PK>   mySQLDS
PK>   mySQL
  
PK>   true
PK>   false
PK>   false
PK>   300
PK>   true
PK>   false
PK>   false
PK>   foreign-key
PK>   
PK>   on-load
PK>   1000
PK>   *
PK>   
PK>   1000
PK>




---
This SF.NET email is sponsored by: A Thawte Code Signing Certificate 
is essential in establishing user confidence by providing assurance of 
authenticity and code integrity. Download our Free Code Signing guide:
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0028en
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySql with Jboss 3.0.1

2002-08-20 Thread David Jencks


Sorry for seeming to flame you guys this morning.  Sometimes I answer posts
without drinking enough coffee first.

david jencks

On 2002.08.20 08:57:27 -0400 Alan Yost wrote:
> David - I am working with Chris on this one.  I have just tested this and
> it works a treat.  I know that Chris (and I'm sure many others) have gone
> thru many painful experiences to get everything running (in 3.0.0)
> -coming up to speed with J2EE, XDoclet, Ant, JBoss, mySQL etc in the
> space of several months.  Sometimes we may not always look in the right
> place first time around - we apologise for this, maybe it's exhaustion,
> maybe oversight but thanks for coming up with the right answer so
> quickly.  We shall try to remember "the archives, the archives"
>  
>  
> Regards
>  
>  
> Alan.
>  
> 
>   -Original Message- 
>   From: David Jencks [mailto:[EMAIL PROTECTED]] 
>   Sent: Tue 20/08/2002 8:13 PM 
>   To: [EMAIL PROTECTED] 
>   Cc: 
>   Subject: Re: [JBoss-user] MySql with Jboss 3.0.1
>   
>   
> 
>   Use the config file that comes with a release of jboss, or
> compare VERY
>   carefully, or look at the message that tells you what the problem
> is and
>   see if all the mbeans needed are actually there, or look at the
> mailing
>   list where this problem has been answered 20 or so times.
>   
>  jboss.security:name=JaasSecurityManager
>   
>   needs to be
>   
>  jboss.security:service=JaasSecurityManager
>   
>   in your mysql-service.xml
>   
>   david jencks
>   
>   
>   
>   
>   On 2002.08.20 02:06:49 -0400 Chris Pinfold wrote:
>   > I am having problems deploying mysql-service.xml (MySql
> Datasource) using
>   > Jboss 3.0.1.
>   > This worked fine in 3.0.0, but now I get the folllowing error:
>   >
>   > I have attached the mysql-service.xml file.
>   >
>   > 05:00:51,079 ERROR [URLDeploymentScanner] MBeanException:
> Exception in
>   > MBean operation 'checkIncompleteDeployments()'
>   > Cause: Incomplete Deployment listing:
>   > Packages waiting for a deployer:
>   >   
>   > Incompletely deployed packages:
>   >   
>   > MBeans waiting for classes:
>   >   
>   > MBeans waiting for other MBeans:
>   > [ObjectName: jboss.jca:service=LocalTxCM,name=MySqlDS
>   >  state: CONFIGURED
>   >  I Depend On:   jboss.jca:service=LocalTxDS,name=MySqlDS
>   >   jboss.jca:service=LocalTxPool,name=MySqlDS
>   >   jboss.jca:service=CachedConnectionManager
>   >   jboss.security:name=JaasSecurityManager
>   >   jboss.jca:service=RARDeployer
>   >
>   >  Depends On Me: ]
>   >
>   >
>   >  <>
>   >
>   > 
>   > 
>   > 
>   > 
>   > 
>   > MySql with Jboss 3.0.1
>   > 
>   > 
>   > 
>   >
>   > I am having problems deploying
>   > mysql-service.xml (MySql Datasource) using Jboss 3.0.1. 
>   >
>   > This worked fine in 3.0.0, but
> now I get
>   > the folllowing error:
>   > 
>   >
>   > I have attached the
> mysql-service.xml
>   > file.
>   > 
>   >
>   > 05:00:51,079 ERROR
> [URLDeploymentScanner]
>   > MBeanException: Exception in MBean operation
>   > 'checkIncompleteDeployments()'
>   >
>   > Cause: Incomplete Deployment
>   > listing:
>   >
>   > Packages waiting for a
> deployer:
>   >
>   >   <none>
>   >
>   > Incompletely deployed
> packages:
>   >
>   >   <none>
>   >
>   > MBeans waiting for
> classes:
>   >
>   >   <none>
>   >
>   > MBeans waiting for other
> MBeans:
>   >
>   > [ObjectName:
>   > jboss.jca:service=LocalTxCM,name=MySqlDS
>   >
>   >  state: CONFIGURED
>   >
>   >  I Depend On:  
>   > jboss.jca:service=LocalTxDS,name=MySqlDS
>   >
>   >  
>   > jboss.jca:service=LocalTxPool,name=MySqlDS
>   >
>   >  
>   > jboss.jca:service=CachedConnectionManager
>   >
>   >  
>   > jboss.security:name=JaasSecurityManager
>   >
>   >  
> jboss.jca:service=RA

RE: [JBoss-user] MySql with Jboss 3.0.1

2002-08-20 Thread Geer, Benjamin


See the section "Specifying Service Dependencies" on page 54 of the
JBoss 3.0.1  Administration and Development book.

Benjamin

-Original Message-
From: Alan Yost [mailto:[EMAIL PROTECTED]]
Sent: 20 August 2002 13:45
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] MySql with Jboss 3.0.1


Jon - Thanks for your reply.  Is there a work-around for this "bug"?

What do you do to get around it?  Is there any documentation that we can
read that may assist in resolving this?


Thanks in advance


Alan.
-Original Message- 
From: Jon Haugsand [mailto:[EMAIL PROTECTED]] 
Sent: Tue 20/08/2002 5:39 PM 
To: [EMAIL PROTECTED] 
Cc: 
Subject: Re: [JBoss-user] MySql with Jboss 3.0.1


* Chris Pinfold
> I am having problems deploying mysql-service.xml (MySql Datasource)
using
> Jboss 3.0.1.
> This worked fine in 3.0.0, but now I get the folllowing error:
>
> I have attached the mysql-service.xml file.
>
> 05:00:51,079 ERROR [URLDeploymentScanner] MBeanException: Exception in
MBean
> operation 'checkIncompleteDeployments()'
> Cause: Incomplete Deployment listing:
> Packages waiting for a deployer:
>   
> Incompletely deployed packages:
>   
> MBeans waiting for classes:
>   
> MBeans waiting for other MBeans:
> [ObjectName: jboss.jca:service=LocalTxCM,name=MySqlDS
>  state: CONFIGURED
>  I Depend On:   jboss.jca:service=LocalTxDS,name=MySqlDS
>   jboss.jca:service=LocalTxPool,name=MySqlDS
>   jboss.jca:service=CachedConnectionManager
>   jboss.security:name=JaasSecurityManager
>   jboss.jca:service=RARDeployer
>
>  Depends On Me: ]

This typically happens during startup where it seems that JBoss reads
your bean jar file before it reads the data source definition.
Somehow this must be an bug in JBoss who should read all files in
server/xx/deploy in alphabetic order or some other deterministic
fashion.

--
  Jon Haugsand, <[EMAIL PROTECTED]>
  Norges Bank, <http://www.norges-bank.no>



---
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone?  Get a new here for FREE!
https://www.inphonic.com/r.asp?r=urceforge1&refcode1=3390
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


---
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone?  Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

RE: [JBoss-user] MySql with Jboss 3.0.1

2002-08-20 Thread Alan Yost


David - I am working with Chris on this one.  I have just tested this and it works a 
treat.  I know that Chris (and I'm sure many others) have gone thru many painful 
experiences to get everything running (in 3.0.0) -coming up to speed with J2EE, 
XDoclet, Ant, JBoss, mySQL etc in the space of several months.  Sometimes we may not 
always look in the right place first time around - we apologise for this, maybe it's 
exhaustion, maybe oversight but thanks for coming up with the right answer so quickly. 
 We shall try to remember "the archives, the archives"
 
 
Regards
 
 
Alan.
 

-Original Message- 
From: David Jencks [mailto:[EMAIL PROTECTED]] 
Sent: Tue 20/08/2002 8:13 PM 
To: [EMAIL PROTECTED] 
Cc: 
    Subject: Re: [JBoss-user] MySql with Jboss 3.0.1



Use the config file that comes with a release of jboss, or compare VERY
carefully, or look at the message that tells you what the problem is and
see if all the mbeans needed are actually there, or look at the mailing
list where this problem has been answered 20 or so times.

   jboss.security:name=JaasSecurityManager

needs to be

   jboss.security:service=JaasSecurityManager

in your mysql-service.xml

david jencks




On 2002.08.20 02:06:49 -0400 Chris Pinfold wrote:
> I am having problems deploying mysql-service.xml (MySql Datasource) using
> Jboss 3.0.1.
> This worked fine in 3.0.0, but now I get the folllowing error:
>
> I have attached the mysql-service.xml file.
>
> 05:00:51,079 ERROR [URLDeploymentScanner] MBeanException: Exception in
> MBean operation 'checkIncompleteDeployments()'
> Cause: Incomplete Deployment listing:
> Packages waiting for a deployer:
>   
> Incompletely deployed packages:
>   
> MBeans waiting for classes:
>   
> MBeans waiting for other MBeans:
> [ObjectName: jboss.jca:service=LocalTxCM,name=MySqlDS
>  state: CONFIGURED
>  I Depend On:   jboss.jca:service=LocalTxDS,name=MySqlDS
>   jboss.jca:service=LocalTxPool,name=MySqlDS
>   jboss.jca:service=CachedConnectionManager
>   jboss.security:name=JaasSecurityManager
>   jboss.jca:service=RARDeployer
>
>  Depends On Me: ]
>
>
>  <>
>
> 
> 
> 
> 
> 
> MySql with Jboss 3.0.1
> 
> 
> 
>
> I am having problems deploying
> mysql-service.xml (MySql Datasource) using Jboss 3.0.1. 
>
> This worked fine in 3.0.0, but now I get
> the folllowing error:
> 
>
> I have attached the mysql-service.xml
> file.
> 
>
> 05:00:51,079 ERROR [URLDeploymentScanner]
> MBeanException: Exception in MBean operation
> 'checkIncompleteDeployments()'
>
> Cause: Incomplete Deployment
> listing:
>
> Packages waiting for a deployer:
>
>   <none>
>
> Incompletely deployed packages:
>
>   <none>
>
> MBeans waiting for classes:
>
>   <none>
>
> MBeans waiting for other MBeans:
>
> [ObjectName:
> jboss.jca:service=LocalTxCM,name=MySqlDS
>
>  state: CONFIGURED
>
>  I Depend On:  
> jboss.jca:service=LocalTxDS,name=MySqlDS
>
>  
> jboss.jca:service=LocalTxPool,name=MySqlDS
>
>  
> jboss.jca:service=CachedConnectionManager
>
>  
> jboss.security:name=JaasSecurityManager
>
>   jboss.jca:service=RARDeployer
> 
>
>  Depends On Me: ]
> 
> 
>
> 
> <<mysql-service.xml>> 
> 
>
> 
> 
>
> 
>
> 
> 
> 
> 
> 
>
> 
>
>   
>   
>   
>   
>
>name="jboss.jca:service=Loc

RE: [JBoss-user] MySql with Jboss 3.0.1

2002-08-20 Thread Alan Yost


Jon - Thanks for your reply.  Is there a work-around for this "bug"?
 
What do you do to get around it?  Is there any documentation that we can read that may 
assist in resolving this?
 
 
Thanks in advance
 
 
Alan.

-Original Message- 
From: Jon Haugsand [mailto:[EMAIL PROTECTED]] 
Sent: Tue 20/08/2002 5:39 PM 
To: [EMAIL PROTECTED] 
Cc: 
    Subject: Re: [JBoss-user] MySql with Jboss 3.0.1



* Chris Pinfold
> I am having problems deploying mysql-service.xml (MySql Datasource) using
> Jboss 3.0.1.
> This worked fine in 3.0.0, but now I get the folllowing error:
>
> I have attached the mysql-service.xml file.
>
> 05:00:51,079 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean
> operation 'checkIncompleteDeployments()'
> Cause: Incomplete Deployment listing:
> Packages waiting for a deployer:
>   
> Incompletely deployed packages:
>   
> MBeans waiting for classes:
>   
> MBeans waiting for other MBeans:
> [ObjectName: jboss.jca:service=LocalTxCM,name=MySqlDS
>  state: CONFIGURED
>  I Depend On:   jboss.jca:service=LocalTxDS,name=MySqlDS
>   jboss.jca:service=LocalTxPool,name=MySqlDS
>   jboss.jca:service=CachedConnectionManager
>   jboss.security:name=JaasSecurityManager
>   jboss.jca:service=RARDeployer
>
>  Depends On Me: ]

This typically happens during startup where it seems that JBoss reads
your bean jar file before it reads the data source definition.
Somehow this must be an bug in JBoss who should read all files in
server/xx/deploy in alphabetic order or some other deterministic
fashion.

--
  Jon Haugsand, <[EMAIL PROTECTED]>
  Norges Bank, <http://www.norges-bank.no>



---
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone?  Get a new here for FREE!
https://www.inphonic.com/r.asp?r=urceforge1&refcode1=3390
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user



<>

Re: [JBoss-user] MySql with Jboss 3.0.1

2002-08-20 Thread David Jencks


I believe jboss is set up so if you put numbers at the front of your
package names they will be deployed in that order.

david jencks

On 2002.08.20 05:39:40 -0400 Jon Haugsand wrote:
> * Chris Pinfold
> > I am having problems deploying mysql-service.xml (MySql Datasource)
> using
> > Jboss 3.0.1.
> > This worked fine in 3.0.0, but now I get the folllowing error:
> > 
> > I have attached the mysql-service.xml file.
> > 
> > 05:00:51,079 ERROR [URLDeploymentScanner] MBeanException: Exception in
> MBean
> > operation 'checkIncompleteDeployments()'
> > Cause: Incomplete Deployment listing:
> > Packages waiting for a deployer:
> >   
> > Incompletely deployed packages:
> >   
> > MBeans waiting for classes:
> >   
> > MBeans waiting for other MBeans:
> > [ObjectName: jboss.jca:service=LocalTxCM,name=MySqlDS
> >  state: CONFIGURED
> >  I Depend On:   jboss.jca:service=LocalTxDS,name=MySqlDS
> >   jboss.jca:service=LocalTxPool,name=MySqlDS
> >   jboss.jca:service=CachedConnectionManager
> >   jboss.security:name=JaasSecurityManager
> >   jboss.jca:service=RARDeployer
> > 
> >  Depends On Me: ]
> 
> This typically happens during startup where it seems that JBoss reads
> your bean jar file before it reads the data source definition.
> Somehow this must be an bug in JBoss who should read all files in
> server/xx/deploy in alphabetic order or some other deterministic
> fashion.
> 
> -- 
>   Jon Haugsand, <[EMAIL PROTECTED]>
>   Norges Bank, 
> 
> 
> 
> ---
> This sf.net email is sponsored by: OSDN - Tired of that same old
> cell phone?  Get a new here for FREE!
> https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 
> 


---
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone?  Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySql with Jboss 3.0.1

2002-08-20 Thread David Jencks


Use the config file that comes with a release of jboss, or compare VERY
carefully, or look at the message that tells you what the problem is and
see if all the mbeans needed are actually there, or look at the mailing
list where this problem has been answered 20 or so times.

   jboss.security:name=JaasSecurityManager

needs to be 

   jboss.security:service=JaasSecurityManager

in your mysql-service.xml

david jencks




On 2002.08.20 02:06:49 -0400 Chris Pinfold wrote:
> I am having problems deploying mysql-service.xml (MySql Datasource) using
> Jboss 3.0.1. 
> This worked fine in 3.0.0, but now I get the folllowing error:
> 
> I have attached the mysql-service.xml file.
> 
> 05:00:51,079 ERROR [URLDeploymentScanner] MBeanException: Exception in
> MBean operation 'checkIncompleteDeployments()'
> Cause: Incomplete Deployment listing:
> Packages waiting for a deployer:
>   
> Incompletely deployed packages:
>   
> MBeans waiting for classes:
>   
> MBeans waiting for other MBeans:
> [ObjectName: jboss.jca:service=LocalTxCM,name=MySqlDS
>  state: CONFIGURED
>  I Depend On:   jboss.jca:service=LocalTxDS,name=MySqlDS
>   jboss.jca:service=LocalTxPool,name=MySqlDS
>   jboss.jca:service=CachedConnectionManager
>   jboss.security:name=JaasSecurityManager
>   jboss.jca:service=RARDeployer
> 
>  Depends On Me: ]
> 
> 
>  <> 
> 
> 
> 
> 
> 
> 
> MySql with Jboss 3.0.1
> 
> 
> 
> 
> I am having problems deploying
> mysql-service.xml (MySql Datasource) using Jboss 3.0.1. 
> 
> This worked fine in 3.0.0, but now I get
> the folllowing error:
> 
> 
> I have attached the mysql-service.xml
> file.
> 
> 
> 05:00:51,079 ERROR [URLDeploymentScanner]
> MBeanException: Exception in MBean operation
> 'checkIncompleteDeployments()'
> 
> Cause: Incomplete Deployment
> listing:
> 
> Packages waiting for a deployer:
> 
>   
> 
> Incompletely deployed packages:
> 
>   
> 
> MBeans waiting for classes:
> 
>   
> 
> MBeans waiting for other MBeans:
> 
> [ObjectName:
> jboss.jca:service=LocalTxCM,name=MySqlDS
> 
>  state: CONFIGURED
> 
>  I Depend On:  
> jboss.jca:service=LocalTxDS,name=MySqlDS
> 
>  
> jboss.jca:service=LocalTxPool,name=MySqlDS
> 
>  
> jboss.jca:service=CachedConnectionManager
> 
>  
> jboss.security:name=JaasSecurityManager
> 
>   jboss.jca:service=RARDeployer
> 
> 
>  Depends On Me: ]
> 
> 
> 
> 
> <> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>   
>   
>   
>   
> 
>name="jboss.jca:service=LocalTxCM,name=MySqlDS">
> 
> 
> 
> 
> 
> 
>   
>name="jboss.jca:service=LocalTxDS,name=MySqlDS">
> 
> MySqlDS
> 
> 
>   
>  type="java.lang.String">jdbc:mysql://localhost:3306/mDrover
>  type="java.lang.String">org.gjt.mm.mysql.Driver
> 
>  type="java.lang.String">myusername
>  type="java.lang.String">mypassword
>   
> 
> 
> 
> 
> 
> optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss
> LocalTransaction JDBC Wrapper
> 
>   
> 
> 
> 
>   
>name="jboss.jca:service=LocalTxPool,name=MySqlDS">
> 
> 0
> 50
> 5000
> 15
> 
> ByContainer
>   
> 
> 
> optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager
> 
> optional-attribute-name="JaasSecurityManagerService">jboss.security:name=JaasSecurityManager
> 
> java:/TransactionManager
> 
> jboss.jca:service=RARDeployer
> 
>   
> 
> 
> 
> 


---
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone?  Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySql with Jboss 3.0.1

2002-08-20 Thread Jon Haugsand


* Chris Pinfold
> I am having problems deploying mysql-service.xml (MySql Datasource) using
> Jboss 3.0.1.
> This worked fine in 3.0.0, but now I get the folllowing error:
> 
> I have attached the mysql-service.xml file.
> 
> 05:00:51,079 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean
> operation 'checkIncompleteDeployments()'
> Cause: Incomplete Deployment listing:
> Packages waiting for a deployer:
>   
> Incompletely deployed packages:
>   
> MBeans waiting for classes:
>   
> MBeans waiting for other MBeans:
> [ObjectName: jboss.jca:service=LocalTxCM,name=MySqlDS
>  state: CONFIGURED
>  I Depend On:   jboss.jca:service=LocalTxDS,name=MySqlDS
>   jboss.jca:service=LocalTxPool,name=MySqlDS
>   jboss.jca:service=CachedConnectionManager
>   jboss.security:name=JaasSecurityManager
>   jboss.jca:service=RARDeployer
> 
>  Depends On Me: ]

This typically happens during startup where it seems that JBoss reads
your bean jar file before it reads the data source definition.
Somehow this must be an bug in JBoss who should read all files in
server/xx/deploy in alphabetic order or some other deterministic
fashion.

-- 
  Jon Haugsand, <[EMAIL PROTECTED]>
  Norges Bank, 



---
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone?  Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

RE: [JBoss-user] MySQL strange behaviour

2002-06-22 Thread wonder sonic


In fact, none of these trics worked...
I've got to apologize but it appeared that I was using
a 2nd CMP bean with an 'index' parameter with getIndex
and setIndex methods...

When jboss tried to create the SQL table, the SQL
statement was something like:
create table sequenceentity
(
index ...
)

and index is a keyword (at least for mysql)...

I just changed the name from index to tableIndex and
it worked :D

thank you to all who tried to help me ;)
Wonder Sonic

 --- [EMAIL PROTECTED] a écrit : > wonder sonic,
> 
> Your first problem, I think, is that you have not
> flushed the tables to make
> the new user permissions take effect.  Check out the
> docs for the mysqladmin
> tool.
> 
> As for the second, try the SQL statement from the
> command line to see where
> it is malformed.  This might help you debug the
> problem.
> From the partial SQL statement, it looks as if a
> comma is needed between the
> CONSTRAINT clause and the PRIMARY KEY clause.
> 
> Good luck,
> - Mike Hewitt
>   [EMAIL PROTECTED]
> 
> -Original Message-
> From: wonder sonic [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 07, 2002 5:27 AM
> To: [EMAIL PROTECTED]
> Subject: [JBoss-user] MySQL strange behaviour
> 
> 
> Hi,
> I've done it (mysql and jboss 3.0 communication)
> but...
> -1- I can't connect with the user/password I want
> though I've added the user/password in mysql.user
> and
> granted all on my db for this user. The only user
> who
> have access is 'root' (without password).
> 
> -2- After JBoss created the first SQL table (for the
> 1st CMP entity bean deployment), I get the following
> error:
> 
> 
> 
> 
>
___
> 
> Don't miss the 2002 Sprint PCS Application
> Developer's Conference
> August 25-28 in Las Vegas --
> http://devcon.sprintpcs.com/adp/index.cfm
> 
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
>
https://lists.sourceforge.net/lists/listinfo/jboss-user 

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com


---
Sponsored by:
ThinkGeek at http://www.ThinkGeek.com/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySQL configuration problem

2002-06-12 Thread Faisal Mahmood


I have tried this, but didn't help. Can there be any other option or
configuration I might be missing? 
  Faisal.


You have the correct pieces in the right place I think, however there is
something wrong with your config.  Double check the url, username,
password.

david jencks

On 2002.06.11 07:57:20 -0400 Faisal Mahmood wrote:
> Hi,
>  I am trying to configure MySQL with JBoss. DO I need mysql.rar
file
> in 
> the deploy folder if yea  from where I can get that?.I have modified
the 
> mysql-service.xml file by adding the connection URL and JNDI name for
the
> > data source. Also I have added the data source name in jboss.xml and
> ejb-jar.xml files.
> At deployment time I got the following exception
> > java.sql.SQLException: ResourceException
> javax.resource.ResourceException: Could not create connection
> at
>
org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:105)
> at
>
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getConnection(JDBCCommand.java:694)
> at
>
org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute(JDBCInitCommand.java:120)
> at
>
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.create(JAWSPersistenceManager.java:129)
> at
>
org.jboss.ejb.plugins.CMPPersistenceManager.create(CMPPersistenceManager.java:155)
> at
> org.jboss.ejb.EntityContainer.create(EntityContainer.java:337)
> at org.jboss.ejb.Container.invoke(Container.java:789)
> at
> org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
>
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:867)
> at $Proxy0.create(Unknown Source)
> at
> org.jboss.system.ServiceController.create(ServiceController.java:271)
> at java.lang.reflect.Method.invoke(Native Method)
> at
>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy19.create(Unknown Source)
> at org.jboss.ejb.EjbModule.createService(EjbModule.java:392)
> at
>
org.jboss.system.ServiceMBeanSupport.create(ServiceMBeanSupport.java:134)
> at java.lang.reflect.Method.invoke(Native Method)
> at
>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
>
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:867)
> at $Proxy0.create(Unknown Source)
> at
> org.jboss.system.ServiceController.create(ServiceController.java:271)
> at
> org.jboss.system.ServiceController.create(ServiceController.java:211)
> at java.lang.reflect.Method.invoke(Native Method)
> at
>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy5.create(Unknown Source)
> at org.jboss.ejb.EJBDeployer.create(EJBDeployer.java:376)
> at
> org.jboss.deployment.MainDeployer.create(MainDeployer.java:651)
> at
> org.jboss.deployment.MainDeployer.create(MainDeployer.java:645)
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:526)
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:490)
> at java.lang.reflect.Method.invoke(Native Method)
> at
>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy4.deploy(Unknown Source)
> at
>
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
> at
>
org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
> at
>
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
> at
>
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:237)
> at
>
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
> at java.lang.reflect.Method.invoke(Native Method)
> at
>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
>
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:867)
> at $Proxy0.start(Unknown Source)
> a

Re: [JBoss-user] MySql problem

2002-06-12 Thread David Jencks


Does the mysql datasource deploy ok if you remove your application?  If so
my may find it easiest to prefix your filenames with numbers to get them to
load in the correct order.

10_mysql-service.xml
20_myapp.jar

This method my work only with cvs jboss, I'm not sure.

david jencks

On 2002.06.12 07:42:09 -0400 madhu wrote:
> I am getting this error when running the jboss3.0.0 .MySqlpool not bound 
> error.
> I changed the standardjaws.xml and mysql-service.xml files with Mysql 
> datasource(MySqlpool).still it's giving error.please help me.
> Error is:
>   at java.lang.Thread.run(Thread.java:484)
> 16:53:15,051 WARN  [NestedThrowable] Duplicate throwable nesting of same 
> base type: class org.jboss.deployment.DeploymentException is assignable 
> from: class org.jboss.deployment.DeploymentException
> 16:53:15,051 ERROR [MainDeployer] could not create deployment: 
> file:/F:/jboss-3.0.0_tomcat-4.0.3/server/default/deploy/cd.jar
> org.jboss.deployment.DeploymentException: error in create of EjbModule: 
> file:/F:/jboss-3.0.0_tomcat-4.0.3/server/default/deploy/cd.jar; - nested 
> throwable: (org.jboss.deployment.DeploymentException: MySQLPool not
> bound)
> at org.jboss.ejb.EJBDeployer.create(EJBDeployer.java:384)
> at org.jboss.deployment.MainDeployer.create(MainDeployer.java:637)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:512)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
> at java.lang.reflect.Method.invoke(Native Method)
> at 
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at 
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy4.deploy(Unknown Source)
> at 
> 
>org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
> at 
> 
>org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
> at 
> org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
> at 
> 
>org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:237)
> at 
> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
> at java.lang.reflect.Method.invoke(Native Method)
> at 
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at 
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at 
> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
> at $Proxy0.start(Unknown Source)
> at 
> org.jboss.system.ServiceController.start(ServiceController.java:340)
> at java.lang.reflect.Method.invoke(Native Method)
> at 
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at 
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy3.start(Unknown Source)
> at org.jboss.deployment.SARDeployer.start(SARDeployer.java:243)
> at org.jboss.deployment.MainDeployer.start(MainDeployer.java:678)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:513)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:465)
> at java.lang.reflect.Method.invoke(Native Method)
> at 
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at 
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:314)
> at org.jboss.system.server.ServerImpl.start(ServerImpl.java:216)
> at org.jboss.Main.boot(Main.java:142)
> at org.jboss.Main$1.run(Main.java:375)
> at java.lang.Thread.run(Thread.java:484)
>  + nested throwable:
> org.jboss.deployment.DeploymentException: MySQLPool not bound
> 
> 
> ___
> 
> Sponsored by:
> ThinkGeek at http://www.ThinkGeek.com/
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 
> 

___

Sponsored by:
ThinkGeek at http://www.ThinkGeek.com/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySQL configuration problem

2002-06-11 Thread David Jencks


You have the correct pieces in the right place I think, however there is
something wrong with your config.  Double check the url, username,
password.

david jencks

On 2002.06.11 07:57:20 -0400 Faisal Mahmood wrote:
> Hi,
>  I am trying to configure MySQL with JBoss. DO I need mysql.rar file
> in 
> the deploy folder if yea  from where I can get that?.I have modified the 
> mysql-service.xml file by adding the connection URL and JNDI name for the
> 
> data source. Also I have added the data source name in jboss.xml and 
> ejb-jar.xml files.
> At deployment time I got the following exception
> 
> java.sql.SQLException: ResourceException
> javax.resource.ResourceException: Could not create connection
> at
> 
>org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:105)
> at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getConnection(JDBCCommand.java:694)
> at
> org.jboss.ejb.plugins.jaws.jdbc.JDBCInitCommand.execute(JDBCInitCommand.java:120)
> at
> 
>org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.create(JAWSPersistenceManager.java:129)
> at
> org.jboss.ejb.plugins.CMPPersistenceManager.create(CMPPersistenceManager.java:155)
> at
> org.jboss.ejb.EntityContainer.create(EntityContainer.java:337)
> at org.jboss.ejb.Container.invoke(Container.java:789)
> at
> org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:867)
> at $Proxy0.create(Unknown Source)
> at
> org.jboss.system.ServiceController.create(ServiceController.java:271)
> at java.lang.reflect.Method.invoke(Native Method)
> at
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy19.create(Unknown Source)
> at org.jboss.ejb.EjbModule.createService(EjbModule.java:392)
> at
> org.jboss.system.ServiceMBeanSupport.create(ServiceMBeanSupport.java:134)
> at java.lang.reflect.Method.invoke(Native Method)
> at
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:867)
> at $Proxy0.create(Unknown Source)
> at
> org.jboss.system.ServiceController.create(ServiceController.java:271)
> at
> org.jboss.system.ServiceController.create(ServiceController.java:211)
> at java.lang.reflect.Method.invoke(Native Method)
> at
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy5.create(Unknown Source)
> at org.jboss.ejb.EJBDeployer.create(EJBDeployer.java:376)
> at
> org.jboss.deployment.MainDeployer.create(MainDeployer.java:651)
> at
> org.jboss.deployment.MainDeployer.create(MainDeployer.java:645)
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:526)
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:490)
> at java.lang.reflect.Method.invoke(Native Method)
> at
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy4.deploy(Unknown Source)
> at
> 
>org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
> at
> 
>org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
> at
> org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
> at
> 
>org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:237)
> at
> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
> at java.lang.reflect.Method.invoke(Native Method)
> at
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:867)
> at $Proxy0.start(Unknown Source)
> at
> org.jboss.system.ServiceController.start(ServiceController.java:339)
> at java.lang.reflect.M

RE: [JBoss-user] MySQL strange behaviour

2002-06-07 Thread MHewitt


wonder sonic,

Your first problem, I think, is that you have not flushed the tables to make
the new user permissions take effect.  Check out the docs for the mysqladmin
tool.

As for the second, try the SQL statement from the command line to see where
it is malformed.  This might help you debug the problem.
>From the partial SQL statement, it looks as if a comma is needed between the
CONSTRAINT clause and the PRIMARY KEY clause.

Good luck,
- Mike Hewitt
  [EMAIL PROTECTED]

-Original Message-
From: wonder sonic [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 5:27 AM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] MySQL strange behaviour


Hi,
I've done it (mysql and jboss 3.0 communication)
but...
-1- I can't connect with the user/password I want
though I've added the user/password in mysql.user and
granted all on my db for this user. The only user who
have access is 'root' (without password).

-2- After JBoss created the first SQL table (for the
1st CMP entity bean deployment), I get the following
error:




___

Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm

___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

RE: [JBoss-user] MySQL service installation

2002-06-06 Thread JD Brennan

Title: RE: [JBoss-user] MySQL service installation





The datasource-mapping for MySQL is called mySQL - I guess
case matters.  You have MySql.  To find the datasource-mappings
look in the standardjbosscmp-jdbc.xml in server/default/conf


JD


-Original Message-
From: wonder sonic [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 1:49 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] MySQL service installation



I've done all of you said: xml file in the deploy
directory with 
name="JndiName">MySql, xxx-13.jar file in
the jboss/lib directory and here is the
jbosscmp-jdbc.xml file of my ear:
...

   
 java:/MySqlDS
 MySql
   


And I've got the following exception for each of my
entity beans:


22:47:35,746 ERROR [URLDeploymentScanner] Failed to
deploy:
org.jboss.deployment.scanner.URLDeploymentScanner$DeployedURL@4e98
de0{
url=file:/E:/jboss-3.0.0_tomcat-4.0.3/server/myrpg/deploy/myrpg-atlas.ear,
deployedLastModified=0 }
org.jboss.deployment.DeploymentException: error in
create of EjbModule:
njar:file:/E:/jboss-3.0.0_tomcat-4.0.3/server/myrpg/tm
p/deploy/server/myrpg/deploy/myrpg-atlas.ear/78.myrpg-atlas.ear^/myrpg-atlas-ejb.jar;
- nested throwable: (org.jboss.deploymen
t.DeploymentException: Error in jbosscmp-jdbc.xml :
datasource-mapping MySql not found)
    at
org.jboss.ejb.EJBDeployer.create(EJBDeployer.java:384)
    at
org.jboss.deployment.MainDeployer.create(MainDeployer.java:637)
    at
org.jboss.deployment.MainDeployer.create(MainDeployer.java:631)
    at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:512)
    at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
    at
sun.reflect.GeneratedMethodAccessor8.invoke(Unknown
Source)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at
java.lang.reflect.Method.invoke(Method.java:324)
    at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
    at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
    at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
    at $Proxy4.deploy(Unknown Source)
    at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
    at
org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
    at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
    at
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:237)
    at
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
    at
sun.reflect.GeneratedMethodAccessor6.invoke(Unknown
Source)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at
java.lang.reflect.Method.invoke(Method.java:324)
    at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
    at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
    at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
    at $Proxy0.start(Unknown Source)
    at
org.jboss.system.ServiceController.start(ServiceController.java:340)
    at
sun.reflect.GeneratedMethodAccessor5.invoke(Unknown
Source)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at
java.lang.reflect.Method.invoke(Method.java:324)
    at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
    at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
    at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
    at $Proxy3.start(Unknown Source)
    at
org.jboss.deployment.SARDeployer.start(SARDeployer.java:243)
    at
org.jboss.deployment.MainDeployer.start(MainDeployer.java:678)
    at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:513)
    at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
    at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:465)
    at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at
java.lang.reflect.Method.invoke(Method.java:324)
    at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
    at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
    at
org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:314)
    at
org.jboss.system.server.ServerImpl.start(ServerImpl.java:216)
    at org.jboss.Main.boot(Main.java:142)
    at org.jboss.Main$1.run(Main.java:375)
    at java.lang.Thr

Re: [JBoss-user] MySQL service installation

2002-06-06 Thread Greg Turner


Thats all well and good, but what about your xml file that configures mysql as a 
service.  You also need something along the lines of a mysql-service.xml in
deploy.  Take a look at the hypersonic example that I mentioned and also take a look 
at Chap10 of the JBoss3.0QuickStartGuide gotten from here:
http://prdownloads.sourceforge.net/jboss/?sort_by=date&sort=desc



wonder sonic wrote:

> I've done all of you said: xml file in the deploy
> directory with  name="JndiName">MySql, xxx-13.jar file in
> the jboss/lib directory and here is the
> jbosscmp-jdbc.xml file of my ear:
> ...
> 
>
>  java:/MySqlDS
>  MySql
>
>
> And I've got the following exception for each of my
> entity beans:
>
> 22:47:35,746 ERROR [URLDeploymentScanner] Failed to
> deploy:
> org.jboss.deployment.scanner.URLDeploymentScanner$DeployedURL@4e98
> de0{
> url=file:/E:/jboss-3.0.0_tomcat-4.0.3/server/myrpg/deploy/myrpg-atlas.ear,
> deployedLastModified=0 }
> org.jboss.deployment.DeploymentException: error in
> create of EjbModule:
> njar:file:/E:/jboss-3.0.0_tomcat-4.0.3/server/myrpg/tm
> p/deploy/server/myrpg/deploy/myrpg-atlas.ear/78.myrpg-atlas.ear^/myrpg-atlas-ejb.jar;
> - nested throwable: (org.jboss.deploymen
> t.DeploymentException: Error in jbosscmp-jdbc.xml :
> datasource-mapping MySql not found)
> at
> org.jboss.ejb.EJBDeployer.create(EJBDeployer.java:384)
> at
> org.jboss.deployment.MainDeployer.create(MainDeployer.java:637)
> at
> org.jboss.deployment.MainDeployer.create(MainDeployer.java:631)
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:512)
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
> at
> sun.reflect.GeneratedMethodAccessor8.invoke(Unknown
> Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at
> java.lang.reflect.Method.invoke(Method.java:324)
> at
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
> org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy4.deploy(Unknown Source)
> at
> 
>org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
> at
> 
>org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
> at
> org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
> at
> 
>org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:237)
> at
> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
> at
> sun.reflect.GeneratedMethodAccessor6.invoke(Unknown
> Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at
> java.lang.reflect.Method.invoke(Method.java:324)
> at
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
> at $Proxy0.start(Unknown Source)
> at
> org.jboss.system.ServiceController.start(ServiceController.java:340)
> at
> sun.reflect.GeneratedMethodAccessor5.invoke(Unknown
> Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at
> java.lang.reflect.Method.invoke(Method.java:324)
> at
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
> org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy3.start(Unknown Source)
> at
> org.jboss.deployment.SARDeployer.start(SARDeployer.java:243)
> at
> org.jboss.deployment.MainDeployer.start(MainDeployer.java:678)
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:513)
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:465)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at
> java.lang.reflect.Method.invoke(Method.java:324)
> at
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
> org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:314)
> at
> or

Re: [JBoss-user] MySQL service installation

2002-06-06 Thread Ricardo Argüello


MySql

should be:

mySQL


Other datasource mappings are listed in:
jboss-3.0.0\server\default\conf\standardjbosscmp-jdbc.xml

In this form:

   
  ...
  ...
   


Ricardo Argüello



- Original Message - 
From: "wonder sonic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 06, 2002 3:49 PM
Subject: Re: [JBoss-user] MySQL service installation


> I've done all of you said: xml file in the deploy
> directory with  name="JndiName">MySql, xxx-13.jar file in
> the jboss/lib directory and here is the
> jbosscmp-jdbc.xml file of my ear:
> ...
> 
>
>  java:/MySqlDS
>  MySql
>
> 
> And I've got the following exception for each of my
> entity beans:
> 
> 22:47:35,746 ERROR [URLDeploymentScanner] Failed to
> deploy:
> org.jboss.deployment.scanner.URLDeploymentScanner$DeployedURL@4e98
> de0{
> url=file:/E:/jboss-3.0.0_tomcat-4.0.3/server/myrpg/deploy/myrpg-atlas.ear,
> deployedLastModified=0 }
> org.jboss.deployment.DeploymentException: error in
> create of EjbModule:
> njar:file:/E:/jboss-3.0.0_tomcat-4.0.3/server/myrpg/tm
> p/deploy/server/myrpg/deploy/myrpg-atlas.ear/78.myrpg-atlas.ear^/myrpg-atlas-ejb.jar;
> - nested throwable: (org.jboss.deploymen
> t.DeploymentException: Error in jbosscmp-jdbc.xml :
> datasource-mapping MySql not found)
> at
> org.jboss.ejb.EJBDeployer.create(EJBDeployer.java:384)
> at
> org.jboss.deployment.MainDeployer.create(MainDeployer.java:637)
> at
> org.jboss.deployment.MainDeployer.create(MainDeployer.java:631)
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:512)
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
> at
> sun.reflect.GeneratedMethodAccessor8.invoke(Unknown
> Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at
> java.lang.reflect.Method.invoke(Method.java:324)
> at
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
> org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy4.deploy(Unknown Source)
> at
> 
>org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
> at
> 
>org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
> at
> org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
> at
> 
>org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:237)
> at
> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
> at
> sun.reflect.GeneratedMethodAccessor6.invoke(Unknown
> Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at
> java.lang.reflect.Method.invoke(Method.java:324)
> at
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
> at $Proxy0.start(Unknown Source)
> at
> org.jboss.system.ServiceController.start(ServiceController.java:340)
> at
> sun.reflect.GeneratedMethodAccessor5.invoke(Unknown
> Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at
> java.lang.reflect.Method.invoke(Method.java:324)
> at
> 
>org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
> at
> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
> at
> org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
> at $Proxy3.start(Unknown Source)
> at
> org.jboss.deployment.SARDeployer.start(SARDeployer.java:243)
> at
> org.jboss.deployment.MainDeployer.start(MainDeployer.java:678)
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:513)
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
> at
> org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:465)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invok

Re: [JBoss-user] MySQL service installation

2002-06-06 Thread wonder sonic


I've done all of you said: xml file in the deploy
directory with MySql, xxx-13.jar file in
the jboss/lib directory and here is the
jbosscmp-jdbc.xml file of my ear:
...

   
 java:/MySqlDS
 MySql
   

And I've got the following exception for each of my
entity beans:

22:47:35,746 ERROR [URLDeploymentScanner] Failed to
deploy:
org.jboss.deployment.scanner.URLDeploymentScanner$DeployedURL@4e98
de0{
url=file:/E:/jboss-3.0.0_tomcat-4.0.3/server/myrpg/deploy/myrpg-atlas.ear,
deployedLastModified=0 }
org.jboss.deployment.DeploymentException: error in
create of EjbModule:
njar:file:/E:/jboss-3.0.0_tomcat-4.0.3/server/myrpg/tm
p/deploy/server/myrpg/deploy/myrpg-atlas.ear/78.myrpg-atlas.ear^/myrpg-atlas-ejb.jar;
- nested throwable: (org.jboss.deploymen
t.DeploymentException: Error in jbosscmp-jdbc.xml :
datasource-mapping MySql not found)
at
org.jboss.ejb.EJBDeployer.create(EJBDeployer.java:384)
at
org.jboss.deployment.MainDeployer.create(MainDeployer.java:637)
at
org.jboss.deployment.MainDeployer.create(MainDeployer.java:631)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:512)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
at
sun.reflect.GeneratedMethodAccessor8.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy4.deploy(Unknown Source)
at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
at
org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:237)
at
org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
at
sun.reflect.GeneratedMethodAccessor6.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
at $Proxy0.start(Unknown Source)
at
org.jboss.system.ServiceController.start(ServiceController.java:340)
at
sun.reflect.GeneratedMethodAccessor5.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
at $Proxy3.start(Unknown Source)
at
org.jboss.deployment.SARDeployer.start(SARDeployer.java:243)
at
org.jboss.deployment.MainDeployer.start(MainDeployer.java:678)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:513)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
at
org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:465)
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at
java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
at
org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:314)
at
org.jboss.system.server.ServerImpl.start(ServerImpl.java:216)
at org.jboss.Main.boot(Main.java:142)
at org.jboss.Main$1.run(Main.java:375)
at java.lang.Thread.run(Thread.java:536)
Caused by: org.jboss.deployment.DeploymentException:
Error in jbosscmp-jdbc.xml : datasource-mapping MySql
not found
at
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaData.(JDBCEntityMetaData.java:365)
at
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.(JDBCApplicationMetaData.java:237)
at
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXmlFileLoader.java:67)
at
org.jboss.ejb.pl

Re: [JBoss-user] MySQL service installation

2002-06-06 Thread Greg Turner


Hmmm.  I am running RC2 and there is no jboss/server/default/lib, so I meant 
jboss/lib.  I don't clearly understand how  works, but there is an
example in the deploy/hsqldb-service.xml file for deploying the hypersonic db

wonder sonic wrote:

> The lib directory, you mean by this, the jboss/lib or
> jboss/server/default/lib?
>
> And what would be the  tag for a jar???
>
> tia,
> wonder sonic
>
>  --- Greg Turner <[EMAIL PROTECTED]> a
> écrit : > Putting the driver jar file into /lib will
> work, but
> > I don't think that is the correct place.  I think
> > the correct place is in the /deploy directory.
> > Putting it into the /deploy directory means you have
> > to put a  tag into your xml file
> > so that JBoss will not try and deploy your service
> > before it deploys the jar file.
> >
> > wonder sonic wrote:
> >
> > > I use the 3.0 final, and indeed, the version is
> > old (I
> > > use the one downloadable in the CMP 2.0 / JBoss
> > 3.0
> > > tutorial ;) instead of the one in this directory
> > :D
> > > One thing I don't know is where to put the 2.0.11
> > > driver archive :( If you know, could you please
> > tell
> > > me?
> > >
> > > TIA,
> > > Wonder Sonic
> > >
> > >  --- Ricardo_Argüello <[EMAIL PROTECTED]> a
> > écrit :
> > > > Are you using JBoss 3.0.0 final? It looks like
> > your
> > > > mysql-service.xml is an old one.
> > > >
> > > > There is an example file for MySQL
> > > > (mysql-service.xml) in the
> > > > jboss-3.0.0/docs/examples/jca/ directory.
> > > >
> > > > You should edit this file, and drop it into
> > > > server/default/deploy
> > > >
> > > > Follow the instructions in the XML file.
> > > >
> > > > Ricardo Argüello
> > > >
> > > >
> > > > - Original Message -
> > > > From: "wonder sonic" <[EMAIL PROTECTED]>
> > > > To: <[EMAIL PROTECTED]>
> > > > Sent: Thursday, June 06, 2002 11:23 AM
> > > > Subject: [JBoss-user] MySQL service installation
> > > >
> > > >
> > > > > Hi,
> > > > > I've read the tutorial document about CMR 2.0
> > with
> > > > > JBoss 3.0 and tried to install mySQL as the
> > > > default
> > > > > datasource but I encouter some errors during
> > the
> > > > > deployment of my beans:
> > > > >
> > > > > Caused by:
> > > > org.jboss.deployment.DeploymentException:
> > > > > Error: can't find data source: java:/mySQLDS;
> > -
> > > > nested
> > > > > throwable: (javax.
> > > > > naming.NameNotFoundException: mySQLDS not
> > bound)
> > > > >
> > > > > Though I've got:
> > > > > 
> > > > > 
> > > > >
> > > > >
> > > > > 
> > > > > 
> > > > > 
> > > > > 
> > > > > 
> > > > > 
> > > > >
> > > > > 
> > > > >> > > > archives="mm.mysql-2.0.11-bin.jar"/>
> > > > >
> > > > >> > > >
> > code="org.jboss.resource.ConnectionFactoryLoader"
> > > > >
> > > > >
> > > >
> > >
> >
> name="jboss.jca:service=ConnectionFactoryLoader,name=mySQLDS">
> > > > >  > > > >
> > > >
> > >
> >
> name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/myrpg
> > > > >   DriverClass=org.gjt.mm.mysql.Driver
> > > > >   UserName=myrpg
> > > > >   Password=myrpg123
> > > > > mySQLDS
> > > > >  > > > >
> > > >
> > >
> >
> name="TransactionManagerName">java:/TransactionManager
> > > > >  > > > >
> > > >
> > >
> >
> 
>optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva
> > > > > JDBC LocalTransaction
> > ResourceAdapter
> > > > >  > > > >
> > > >
> > >
> >
> 
>optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory
> > > > >  > name="ConnectionManagerProperties">#
> > > > >   #Wed Aug 15 16:17:29 EDT 2001
> > > > >   BlockingTimeoutMillis=50
> > > > >   IdleTimeoutMinutes=30
> > > > >   MaxSize=10
> > > > >   CleanupIntervalMinutes=10
> > > > >   MinSize=0
> > > > >   MaxIdleTimeoutPercent=1.0
> > > > > 
> > > > > 
> > > > >
> > > > >
> > > >
> > >
> >
> org.jboss.resource.security.ManyToOnePrincipalMapping
> > > > > 
> > > > >  > > > >
> > > >
> > >
> >
> name="PrincipalMappingProperties">UserName=
> > > > >   
> > > > > 
> > > > >
> > > > > in my server/myrpg/deploy directory including
> > > > > mm.mysql-2.0.11-bin.jar
> > > > >
> > > > > and in my .ant.properties (I use the jboss
> > > > template
> > > > > project):
> > > > > ...
> > > > > # JBoss 3.0 settings
> > > > > jboss.home=E:/jboss-3.0.0_tomcat-4.0.3
> > > > > jboss.version=3.0
> > > > > #datasource.name=java:/DefaultDS
> > > > > #type.mapping=Hypersonic SQL
> > > > > datasource.name=java:/mySQLDS
> > > > > type.mapping=mySQL
> > > > > ...
> > > > >
> > > > > And in
> > > > server/myrpg/conf/standardjbosscmp-jdbc.xml:
> > > > > ...
> > > > > 
> > > > >
> > > > >
> > > > > 
> > > > >   java:/mySQLDS
> > > > >
> > mySQL
> > > > >
> > > > >   true
> > > > > ...
> > > > >
> > > > > Did someone else encounter this error? If so,
> > can
> > > > you
> > > > > help me? (my mySQL version is 3.23.42-nt and
> > my
> >
> === message truncated ===
>
> ___

Re: [JBoss-user] MySQL service installation

2002-06-06 Thread wonder sonic


The lib directory, you mean by this, the jboss/lib or
jboss/server/default/lib?

And what would be the  tag for a jar???

tia,
wonder sonic

 --- Greg Turner <[EMAIL PROTECTED]> a
écrit : > Putting the driver jar file into /lib will
work, but
> I don't think that is the correct place.  I think
> the correct place is in the /deploy directory.
> Putting it into the /deploy directory means you have
> to put a  tag into your xml file
> so that JBoss will not try and deploy your service
> before it deploys the jar file.
> 
> wonder sonic wrote:
> 
> > I use the 3.0 final, and indeed, the version is
> old (I
> > use the one downloadable in the CMP 2.0 / JBoss
> 3.0
> > tutorial ;) instead of the one in this directory
> :D
> > One thing I don't know is where to put the 2.0.11
> > driver archive :( If you know, could you please
> tell
> > me?
> >
> > TIA,
> > Wonder Sonic
> >
> >  --- Ricardo_Argüello <[EMAIL PROTECTED]> a
> écrit :
> > > Are you using JBoss 3.0.0 final? It looks like
> your
> > > mysql-service.xml is an old one.
> > >
> > > There is an example file for MySQL
> > > (mysql-service.xml) in the
> > > jboss-3.0.0/docs/examples/jca/ directory.
> > >
> > > You should edit this file, and drop it into
> > > server/default/deploy
> > >
> > > Follow the instructions in the XML file.
> > >
> > > Ricardo Argüello
> > >
> > >
> > > - Original Message -
> > > From: "wonder sonic" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Thursday, June 06, 2002 11:23 AM
> > > Subject: [JBoss-user] MySQL service installation
> > >
> > >
> > > > Hi,
> > > > I've read the tutorial document about CMR 2.0
> with
> > > > JBoss 3.0 and tried to install mySQL as the
> > > default
> > > > datasource but I encouter some errors during
> the
> > > > deployment of my beans:
> > > >
> > > > Caused by:
> > > org.jboss.deployment.DeploymentException:
> > > > Error: can't find data source: java:/mySQLDS;
> -
> > > nested
> > > > throwable: (javax.
> > > > naming.NameNotFoundException: mySQLDS not
> bound)
> > > >
> > > > Though I've got:
> > > > 
> > > > 
> > > >
> > > >
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > >
> > > > 
> > > >> > > archives="mm.mysql-2.0.11-bin.jar"/>
> > > >
> > > >> > >
> code="org.jboss.resource.ConnectionFactoryLoader"
> > > >
> > > >
> > >
> >
>
name="jboss.jca:service=ConnectionFactoryLoader,name=mySQLDS">
> > > >  > > >
> > >
> >
>
name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/myrpg
> > > >   DriverClass=org.gjt.mm.mysql.Driver
> > > >   UserName=myrpg
> > > >   Password=myrpg123
> > > > mySQLDS
> > > >  > > >
> > >
> >
>
name="TransactionManagerName">java:/TransactionManager
> > > >  > > >
> > >
> >
>
optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva
> > > > JDBC LocalTransaction
> ResourceAdapter
> > > >  > > >
> > >
> >
>
optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory
> > > >  name="ConnectionManagerProperties">#
> > > >   #Wed Aug 15 16:17:29 EDT 2001
> > > >   BlockingTimeoutMillis=50
> > > >   IdleTimeoutMinutes=30
> > > >   MaxSize=10
> > > >   CleanupIntervalMinutes=10
> > > >   MinSize=0
> > > >   MaxIdleTimeoutPercent=1.0
> > > > 
> > > > 
> > > >
> > > >
> > >
> >
>
org.jboss.resource.security.ManyToOnePrincipalMapping
> > > > 
> > > >  > > >
> > >
> >
>
name="PrincipalMappingProperties">UserName=
> > > >   
> > > > 
> > > >
> > > > in my server/myrpg/deploy directory including
> > > > mm.mysql-2.0.11-bin.jar
> > > >
> > > > and in my .ant.properties (I use the jboss
> > > template
> > > > project):
> > > > ...
> > > > # JBoss 3.0 settings
> > > > jboss.home=E:/jboss-3.0.0_tomcat-4.0.3
> > > > jboss.version=3.0
> > > > #datasource.name=java:/DefaultDS
> > > > #type.mapping=Hypersonic SQL
> > > > datasource.name=java:/mySQLDS
> > > > type.mapping=mySQL
> > > > ...
> > > >
> > > > And in
> > > server/myrpg/conf/standardjbosscmp-jdbc.xml:
> > > > ...
> > > > 
> > > >
> > > >
> > > > 
> > > >   java:/mySQLDS
> > > >  
> mySQL
> > > >
> > > >   true
> > > > ...
> > > >
> > > > Did someone else encounter this error? If so,
> can
> > > you
> > > > help me? (my mySQL version is 3.23.42-nt and
> my
> 
=== message truncated === 

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com

___

Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm

___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySQL service installation

2002-06-06 Thread Greg Turner


Putting the driver jar file into /lib will work, but I don't think that is the correct 
place.  I think the correct place is in the /deploy directory.
Putting it into the /deploy directory means you have to put a  tag 
into your xml file so that JBoss will not try and deploy your service
before it deploys the jar file.

wonder sonic wrote:

> I use the 3.0 final, and indeed, the version is old (I
> use the one downloadable in the CMP 2.0 / JBoss 3.0
> tutorial ;) instead of the one in this directory :D
> One thing I don't know is where to put the 2.0.11
> driver archive :( If you know, could you please tell
> me?
>
> TIA,
> Wonder Sonic
>
>  --- Ricardo_Argüello <[EMAIL PROTECTED]> a écrit :
> > Are you using JBoss 3.0.0 final? It looks like your
> > mysql-service.xml is an old one.
> >
> > There is an example file for MySQL
> > (mysql-service.xml) in the
> > jboss-3.0.0/docs/examples/jca/ directory.
> >
> > You should edit this file, and drop it into
> > server/default/deploy
> >
> > Follow the instructions in the XML file.
> >
> > Ricardo Argüello
> >
> >
> > - Original Message -
> > From: "wonder sonic" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, June 06, 2002 11:23 AM
> > Subject: [JBoss-user] MySQL service installation
> >
> >
> > > Hi,
> > > I've read the tutorial document about CMR 2.0 with
> > > JBoss 3.0 and tried to install mySQL as the
> > default
> > > datasource but I encouter some errors during the
> > > deployment of my beans:
> > >
> > > Caused by:
> > org.jboss.deployment.DeploymentException:
> > > Error: can't find data source: java:/mySQLDS; -
> > nested
> > > throwable: (javax.
> > > naming.NameNotFoundException: mySQLDS not bound)
> > >
> > > Though I've got:
> > > 
> > > 
> > >
> > >
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > >
> > > 
> > >> > archives="mm.mysql-2.0.11-bin.jar"/>
> > >
> > >> > code="org.jboss.resource.ConnectionFactoryLoader"
> > >
> > >
> >
> name="jboss.jca:service=ConnectionFactoryLoader,name=mySQLDS">
> > >  > >
> >
> name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/myrpg
> > >   DriverClass=org.gjt.mm.mysql.Driver
> > >   UserName=myrpg
> > >   Password=myrpg123
> > > mySQLDS
> > >  > >
> >
> name="TransactionManagerName">java:/TransactionManager
> > >  > >
> >
> 
>optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva
> > > JDBC LocalTransaction ResourceAdapter
> > >  > >
> >
> 
>optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory
> > > #
> > >   #Wed Aug 15 16:17:29 EDT 2001
> > >   BlockingTimeoutMillis=50
> > >   IdleTimeoutMinutes=30
> > >   MaxSize=10
> > >   CleanupIntervalMinutes=10
> > >   MinSize=0
> > >   MaxIdleTimeoutPercent=1.0
> > > 
> > > 
> > >
> > >
> >
> org.jboss.resource.security.ManyToOnePrincipalMapping
> > > 
> > >  > >
> >
> name="PrincipalMappingProperties">UserName=
> > >   
> > > 
> > >
> > > in my server/myrpg/deploy directory including
> > > mm.mysql-2.0.11-bin.jar
> > >
> > > and in my .ant.properties (I use the jboss
> > template
> > > project):
> > > ...
> > > # JBoss 3.0 settings
> > > jboss.home=E:/jboss-3.0.0_tomcat-4.0.3
> > > jboss.version=3.0
> > > #datasource.name=java:/DefaultDS
> > > #type.mapping=Hypersonic SQL
> > > datasource.name=java:/mySQLDS
> > > type.mapping=mySQL
> > > ...
> > >
> > > And in
> > server/myrpg/conf/standardjbosscmp-jdbc.xml:
> > > ...
> > > 
> > >
> > >
> > > 
> > >   java:/mySQLDS
> > >   mySQL
> > >
> > >   true
> > > ...
> > >
> > > Did someone else encounter this error? If so, can
> > you
> > > help me? (my mySQL version is 3.23.42-nt and my
> > > database's name is myrpg (already created).
> > Perhaps it
> > > is the version of the mysql driver archive?
> > >
> > > Thank you in advance,
> > > Wonder Sonic
> > >
> > >
> >
> ___
> > > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite
> > et en français !
> > > Yahoo! Mail : http://fr.mail.yahoo.com
> > >
> > >
> >
> ___
> > >
> > > Don't miss the 2002 Sprint PCS Application
> > Developer's Conference
> > > August 25-28 in Las Vegas --
> > http://devcon.sprintpcs.com/adp/index.cfm
> > >
> > > ___
> > > JBoss-user mailing list
> > > [EMAIL PROTECTED]
> > >
> >
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> > >
> >
> >
> >
> ___
> >
> > Don't miss the 2002 Sprint PCS Application
> > Developer's Conference
> > August 25-28 in Las Vegas --
> > http://devcon.sprintpcs.com/adp/index.cfm
> >
> > ___
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> >
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
>

Re: [JBoss-user] MySQL service installation

2002-06-06 Thread wonder sonic


I use the 3.0 final, and indeed, the version is old (I
use the one downloadable in the CMP 2.0 / JBoss 3.0
tutorial ;) instead of the one in this directory :D
One thing I don't know is where to put the 2.0.11
driver archive :( If you know, could you please tell
me?

TIA,
Wonder Sonic

 --- Ricardo_Argüello <[EMAIL PROTECTED]> a écrit :
> Are you using JBoss 3.0.0 final? It looks like your
> mysql-service.xml is an old one.
> 
> There is an example file for MySQL
> (mysql-service.xml) in the
> jboss-3.0.0/docs/examples/jca/ directory.
> 
> You should edit this file, and drop it into
> server/default/deploy
> 
> Follow the instructions in the XML file.
> 
> Ricardo Argüello
> 
> 
> - Original Message - 
> From: "wonder sonic" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, June 06, 2002 11:23 AM
> Subject: [JBoss-user] MySQL service installation
> 
> 
> > Hi,
> > I've read the tutorial document about CMR 2.0 with
> > JBoss 3.0 and tried to install mySQL as the
> default
> > datasource but I encouter some errors during the
> > deployment of my beans:
> > 
> > Caused by:
> org.jboss.deployment.DeploymentException:
> > Error: can't find data source: java:/mySQLDS; -
> nested
> > throwable: (javax.
> > naming.NameNotFoundException: mySQLDS not bound)
> > 
> > Though I've got:
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >> archives="mm.mysql-2.0.11-bin.jar"/>
> > 
> >> code="org.jboss.resource.ConnectionFactoryLoader"
> > 
> >
>
name="jboss.jca:service=ConnectionFactoryLoader,name=mySQLDS">
> >  >
>
name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/myrpg
> >   DriverClass=org.gjt.mm.mysql.Driver
> >   UserName=myrpg
> >   Password=myrpg123
> > mySQLDS
> >  >
>
name="TransactionManagerName">java:/TransactionManager
> >  >
>
optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva
> > JDBC LocalTransaction ResourceAdapter
> >  >
>
optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory
> > #
> >   #Wed Aug 15 16:17:29 EDT 2001
> >   BlockingTimeoutMillis=50
> >   IdleTimeoutMinutes=30
> >   MaxSize=10
> >   CleanupIntervalMinutes=10
> >   MinSize=0
> >   MaxIdleTimeoutPercent=1.0
> > 
> > 
> > 
> >
>
org.jboss.resource.security.ManyToOnePrincipalMapping
> > 
> >  >
>
name="PrincipalMappingProperties">UserName=
> >   
> > 
> > 
> > in my server/myrpg/deploy directory including
> > mm.mysql-2.0.11-bin.jar
> > 
> > and in my .ant.properties (I use the jboss
> template
> > project):
> > ...
> > # JBoss 3.0 settings
> > jboss.home=E:/jboss-3.0.0_tomcat-4.0.3
> > jboss.version=3.0
> > #datasource.name=java:/DefaultDS
> > #type.mapping=Hypersonic SQL
> > datasource.name=java:/mySQLDS
> > type.mapping=mySQL
> > ...
> > 
> > And in
> server/myrpg/conf/standardjbosscmp-jdbc.xml:
> > ...
> > 
> > 
> >
> > 
> >   java:/mySQLDS
> >   mySQL
> > 
> >   true
> > ...
> > 
> > Did someone else encounter this error? If so, can
> you
> > help me? (my mySQL version is 3.23.42-nt and my
> > database's name is myrpg (already created).
> Perhaps it
> > is the version of the mysql driver archive?
> > 
> > Thank you in advance,
> > Wonder Sonic
> > 
> >
>
___
> > Do You Yahoo!? -- Une adresse @yahoo.fr gratuite
> et en français !
> > Yahoo! Mail : http://fr.mail.yahoo.com
> > 
> >
>
___
> > 
> > Don't miss the 2002 Sprint PCS Application
> Developer's Conference
> > August 25-28 in Las Vegas --
> http://devcon.sprintpcs.com/adp/index.cfm
> > 
> > ___
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> >
>
https://lists.sourceforge.net/lists/listinfo/jboss-user
> > 
> 
> 
>
___
> 
> Don't miss the 2002 Sprint PCS Application
> Developer's Conference
> August 25-28 in Las Vegas --
> http://devcon.sprintpcs.com/adp/index.cfm
> 
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
>
https://lists.sourceforge.net/lists/listinfo/jboss-user 

___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com

___

Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm

___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySQL service installation

2002-06-06 Thread Ricardo Argüello


Are you using JBoss 3.0.0 final? It looks like your mysql-service.xml is an old one.

There is an example file for MySQL (mysql-service.xml) in the 
jboss-3.0.0/docs/examples/jca/ directory.

You should edit this file, and drop it into server/default/deploy

Follow the instructions in the XML file.

Ricardo Argüello


- Original Message - 
From: "wonder sonic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 06, 2002 11:23 AM
Subject: [JBoss-user] MySQL service installation


> Hi,
> I've read the tutorial document about CMR 2.0 with
> JBoss 3.0 and tried to install mySQL as the default
> datasource but I encouter some errors during the
> deployment of my beans:
> 
> Caused by: org.jboss.deployment.DeploymentException:
> Error: can't find data source: java:/mySQLDS; - nested
> throwable: (javax.
> naming.NameNotFoundException: mySQLDS not bound)
> 
> Though I've got:
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>archives="mm.mysql-2.0.11-bin.jar"/>
> 
>code="org.jboss.resource.ConnectionFactoryLoader"
> 
> name="jboss.jca:service=ConnectionFactoryLoader,name=mySQLDS">
>  name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/myrpg
>   DriverClass=org.gjt.mm.mysql.Driver
>   UserName=myrpg
>   Password=myrpg123
> mySQLDS
>  name="TransactionManagerName">java:/TransactionManager
>  
>optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva
> JDBC LocalTransaction ResourceAdapter
>  
>optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory
> #
>   #Wed Aug 15 16:17:29 EDT 2001
>   BlockingTimeoutMillis=50
>   IdleTimeoutMinutes=30
>   MaxSize=10
>   CleanupIntervalMinutes=10
>   MinSize=0
>   MaxIdleTimeoutPercent=1.0
> 
> 
> 
> org.jboss.resource.security.ManyToOnePrincipalMapping
> 
>  name="PrincipalMappingProperties">UserName=
>   
> 
> 
> in my server/myrpg/deploy directory including
> mm.mysql-2.0.11-bin.jar
> 
> and in my .ant.properties (I use the jboss template
> project):
> ...
> # JBoss 3.0 settings
> jboss.home=E:/jboss-3.0.0_tomcat-4.0.3
> jboss.version=3.0
> #datasource.name=java:/DefaultDS
> #type.mapping=Hypersonic SQL
> datasource.name=java:/mySQLDS
> type.mapping=mySQL
> ...
> 
> And in server/myrpg/conf/standardjbosscmp-jdbc.xml:
> ...
> 
> 
>
> 
>   java:/mySQLDS
>   mySQL
> 
>   true
> ...
> 
> Did someone else encounter this error? If so, can you
> help me? (my mySQL version is 3.23.42-nt and my
> database's name is myrpg (already created). Perhaps it
> is the version of the mysql driver archive?
> 
> Thank you in advance,
> Wonder Sonic
> 
> ___
> Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
> Yahoo! Mail : http://fr.mail.yahoo.com
> 
> ___
> 
> Don't miss the 2002 Sprint PCS Application Developer's Conference
> August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
> 
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 


___

Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm

___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

RE: [JBoss-user] MySQL service

2002-04-03 Thread Eric Jain


> You might need to put the classpath element referring to
> jbosscx.jar/sar/whatever back in so the classes are sure to be available
> for the mbean.  I'm trying to find a different solution for this.

Thanks; certainly a better solution than renaming to a-mysql-service.sar,
which also solved the problem...


--
Eric Jain


___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySQL service

2002-04-03 Thread David Jencks


You might need to put the classpath element referring to
jbosscx.jar/sar/whatever back in so the classes are sure to be available
for the mbean.  I'm trying to find a different solution for this.

david jencks

On 2002.03.27 09:36:29 -0500 Eric Jain wrote:
> Sometimes my mysql-service.sar doesn't deploy at startup, however if I
> deploy it after JBoss has started up, no problem. Perhaps a dependency
> problem? JBoss 3.0b2, Windows and Linux.
> 
> 
> mysql-service.sar
> |-- mm.mysql-2.0.11-bin.jar
> |-- META-INF/
> |-- jboss-service.xml
> 
> 
> javax.management.ReflectionException: The MBean class could not be loaded
> by
> the specified loader
> at
> com.sun.management.jmx.MBeanServerImpl.createMBean(MBeanServerImpl.java:754)
> at org.jboss.system.ServiceCreator.install(ServiceCreator.java:98)
> at
> org.jboss.system.ServiceController.install(ServiceController.java:155)
> at java.lang.reflect.Method.invoke(Native Method)
> at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
> at
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:78)
> at $Proxy2.install(Unknown Source)
> at org.jboss.deployment.SARDeployer.create(SARDeployer.java:227)
> at org.jboss.deployment.MainDeployer.create(MainDeployer.java:421)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:333)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:314)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:296)
>   ...
> 
> 
> --
> Eric Jain
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>   name="jboss.jca:service=ConnectionFactoryLoader,name=MysqlDS">
> name="ManagedConnectionFactoryProperties">ConnectionURL=jdbc:mysql://localhost/jboss
>   DriverClass=org.gjt.mm.mysql.Driver
>   UserName=dcm
>   password=hallo
> MysqlDS
> java:/TransactionManager
> optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva
> JDBC LocalTransaction ResourceAdapter
> optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory
> 
> #
>   #Wed Aug 15 16:17:29 EDT 2001
>   BlockingTimeoutMillis=50
>   IdleTimeoutMinutes=30
>   MaxSize=10
>   CleanupIntervalMinutes=10
>   MinSize=0
>   MaxIdleTimeoutPercent=1.0
> 
> 
>   org.jboss.resource.security.ManyToOnePrincipalMapping
> 
> UserName=dcm
> password=hallo
>   
> 
> 
> 

___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySQL service

2002-03-28 Thread jain


> Have you tried with latest CVS?

Not yet, I'm still using a version from March 1. Anyways, the problem
dissappeared when mysql-service.sar was renamed to a-mysql-service.sar...


--
Eric Jain

-- 
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net


___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySQL service

2002-03-27 Thread Adrian Brock


Have you tried with latest CVS?

I've got an open bug report for this, but I think it has already
been fixed?

Regards,
Adrian

>From: "Eric Jain" <[EMAIL PROTECTED]>
>To: "Jboss-User" <[EMAIL PROTECTED]>
>Subject: [JBoss-user] MySQL service
>Date: Wed, 27 Mar 2002 15:36:29 +0100
>
>Sometimes my mysql-service.sar doesn't deploy at startup, however if I
>deploy it after JBoss has started up, no problem. Perhaps a dependency
>problem? JBoss 3.0b2, Windows and Linux.
>
>
>mysql-service.sar
>|-- mm.mysql-2.0.11-bin.jar
>|-- META-INF/
> |-- jboss-service.xml
>
>
>javax.management.ReflectionException: The MBean class could not be loaded 
>by
>the specified loader
> at
>com.sun.management.jmx.MBeanServerImpl.createMBean(MBeanServerImpl.java:754)
> at org.jboss.system.ServiceCreator.install(ServiceCreator.java:98)
> at
>org.jboss.system.ServiceController.install(ServiceController.java:155)
> at java.lang.reflect.Method.invoke(Native Method)
> at
>com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
> at
>com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:78)
> at $Proxy2.install(Unknown Source)
> at org.jboss.deployment.SARDeployer.create(SARDeployer.java:227)
> at org.jboss.deployment.MainDeployer.create(MainDeployer.java:421)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:333)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:314)
> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:296)
>   ...
>
>
>--
>Eric Jain
><< jboss-service.xml >>


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] Mysql ejbpassivate()

2001-10-01 Thread Dmitri Colebatch


You shouldn't be holding on to a connection.  Hold on to a reference to
the datasource object, and use datasource.getConnection() and
connection.close() to obtain/release a connection.

cheers
dim

On Tue, 2 Oct 2001, Papo Napolitano wrote:

> Hi!
> 
> I'm trying to write an EJBean with mysql. I build it and everything works
> fine, but when I make some change and redeploy I got the following error.
> I want to close the connection in the ejbPassivate(). Anybody can help me
> with this?? How can I do it ?
> 
> Regards,
> Papo
> 
> ERROR:
> 
> [Auto deploy] Auto deploy of file:/usr/jboss/deploy/usermanager.jar
> [J2EE Deployer Default] Stopping module usermanager.jar
> [Container factory]
> Undeploying:file:/usr/jboss/tmp/deploy/Default/usermanager.jar
> [Container factory] java.rmi.ServerException: Could not passivate; nested
> exception is:
> [Container factory] java.io.NotSerializableException:
> org.gjt.mm.mysql.jdbc2.Connection
> [Container factory] java.io.NotSerializableException:
> org.gjt.mm.mysql.jdbc2.Connection
> 
> 
> 
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> 


___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql and jboss

2001-09-28 Thread Nguyen Thanh Phong


You have to setup the resource reference in ejb-jar.xml and jboss.xml file.

Normally you should lookup JDBC DataSource under java:/comp/env/jdbc/...

The following configuration was for Jboss 2.2. The new version has remove
the extra indirection. See docs for details.

In ejb-jar.xml

...

jdbc/ipdomainMySQL
javax.sql.DataSource
Container

...

In jboss.xml

jdbc/ipdomainMySQL
ipdomainMySQL





ipdomainMySQL
java:/ipdomainMySQL



Let me know if it works.

Phong.

- Original Message -
From: "Daniel Ferrante" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 29, 2001 6:29 AM
Subject: RE: [JBoss-user] mysql and jboss


try without the default comp/env/ in the call lookup the datasourse so
use:
 "java:ipdomainMySQL" . This worked for me.
Dan

-Original Message-
From: Mir S Islam [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 28, 2001 6:41 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] mysql and jboss


I am trying to use mysql with jboss as described in the documentation
but
ran into some problem.

During the initialization I see the following messages on console/server
log.

[Configuration] DataSourceClass set to
org.jboss.pool.jdbc.xa.wrapper.XADataSour
ceImpl in DefaultDomain:service=XADataSource,name=ipdomainMySQL^M
[Configuration] PoolName set to ipdomainMySQL in
DefaultDomain:service=XADataSou
rce,name=ipdomainMySQL^M
[Configuration] URL set to jdbc:mysql://jupiter:3306/ipdomain in
DefaultDomain:s
ervice=XADataSource,name=ipdomainMySQL^M
[Configuration] JDBCUser set to mislam in
DefaultDomain:service=XADataSource,nam
e=ipdomainMySQL^M
[Configuration] Password set to mir in
DefaultDomain:service=XADataSource,name=i
pdomainMySQL^M

So it seems like the driver was loaded properly and a datasource called
ipdomainMySQL was setup. Later on the server log following message
confirms
(?) that ipdomainMySQL was bound to the server.

[XADataSourceLoader] Starting^M
[ipdomainMySQL] XA Connection pool ipdomainMySQL bound to
java:/ipdomainMySQL^M
[XADataSourceLoader] Started^M
[ServerDataCollector] Starting^M
[ServerDataCollector] JBoss Management Service 'servercollector' bound
to
server
collector^M

But when I invoke my ejb I get an error message on the server that:

[Default] Entering TestMysql.ejbCreate()
[Default] Error: javax.naming.NameNotFoundException: ipdomainMySQL not
bound
[Default] Leaving TestMysql.ejbCreate()


Here is relevant code from my EJB class file. Any pointer/examples will
be
appreciated. Thanks

public void ejbCreate() {
System.out.println("Entering TestMysql.ejbCreate()");
Context c = null;
if (this.jdbcFactory == null) {
try {
c = new InitialContext();
this.jdbcFactory =

(javax.sql.DataSource)c.lookup("java:comp/env/ipdomainMySQL");
} catch (Exception e){ System.out.println("Error: " + e); }
 }
 System.out.println("Leaving TestMysql.ejbCreate()");
}




___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user




___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

RE: [JBoss-user] mysql and jboss

2001-09-28 Thread Daniel Ferrante


try without the default comp/env/ in the call lookup the datasourse so
use:
 "java:ipdomainMySQL" . This worked for me.
Dan

-Original Message-
From: Mir S Islam [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 28, 2001 6:41 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] mysql and jboss


I am trying to use mysql with jboss as described in the documentation
but
ran into some problem.

During the initialization I see the following messages on console/server
log.

[Configuration] DataSourceClass set to
org.jboss.pool.jdbc.xa.wrapper.XADataSour
ceImpl in DefaultDomain:service=XADataSource,name=ipdomainMySQL^M
[Configuration] PoolName set to ipdomainMySQL in
DefaultDomain:service=XADataSou
rce,name=ipdomainMySQL^M
[Configuration] URL set to jdbc:mysql://jupiter:3306/ipdomain in
DefaultDomain:s
ervice=XADataSource,name=ipdomainMySQL^M
[Configuration] JDBCUser set to mislam in
DefaultDomain:service=XADataSource,nam
e=ipdomainMySQL^M
[Configuration] Password set to mir in
DefaultDomain:service=XADataSource,name=i
pdomainMySQL^M

So it seems like the driver was loaded properly and a datasource called
ipdomainMySQL was setup. Later on the server log following message
confirms
(?) that ipdomainMySQL was bound to the server.

[XADataSourceLoader] Starting^M
[ipdomainMySQL] XA Connection pool ipdomainMySQL bound to
java:/ipdomainMySQL^M
[XADataSourceLoader] Started^M
[ServerDataCollector] Starting^M
[ServerDataCollector] JBoss Management Service 'servercollector' bound
to
server
collector^M

But when I invoke my ejb I get an error message on the server that:

[Default] Entering TestMysql.ejbCreate()
[Default] Error: javax.naming.NameNotFoundException: ipdomainMySQL not
bound
[Default] Leaving TestMysql.ejbCreate()


Here is relevant code from my EJB class file. Any pointer/examples will
be
appreciated. Thanks

public void ejbCreate() {
System.out.println("Entering TestMysql.ejbCreate()");
Context c = null;
if (this.jdbcFactory == null) {
try {
c = new InitialContext();
this.jdbcFactory =

(javax.sql.DataSource)c.lookup("java:comp/env/ipdomainMySQL");
} catch (Exception e){ System.out.println("Error: " + e); }
 }
 System.out.println("Leaving TestMysql.ejbCreate()");
}




___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] Mysql problem

2001-09-12 Thread pifen ellwood




Hi Marcel, 
Your are right. It shall be a 5 minutes task. I 
download the new version of Jboss 3.2.2.4 and exception went 
away.
 
What a waste of time. Thanks.
Pifen Ellwood

  - Original Message - 
  From: 
  Marcel 
  Stremming 
  To: [EMAIL PROTECTED] 
  
  Sent: Wednesday, September 12, 2001 10:50 
  AM
  Subject: AW: [JBoss-user] Mysql 
  problem
  
  
   
  Try 
  to write simple JDBC Client in order to find out if a login is really 
  possible. Its Five minutes of work and otherwise You 
  never know.
   
  
  Hi,
  
  I've searched all the post mail 
  and do everything I can to make mysql work with jboss but failed. 
  
  
  If anyone got Mysql to work with 
  Jboss, please let me know which version of Mysql, mysql jdbc driver that 
  you're using and send me a sample of the jboss.jcml that 
  works.
  
   
  
  Thanks
  
   
  
  Here is my system 
  setup:
  
   
  
  Mysql version: 
  mysql-3.23.41-win.zip
  
  JDBC driver:   
  mm.mysql-2.0.4-bin.jar (stored in 
  JBOSS_HOME\lib\ext)
  
  Jboss with tomcat: 
  JBoss-3.2.2_Tomcate-3.2.2.zip
  
  OS: Windows2000 
  Professional
  
   
  
  I list only mysql jdbc driver in 
  the jboss.jcml 
  
  I have create a user name and 
  password in the MySQL server, and I've verified with the MySql admin tool that 
  the user name and password does exist and with proper previleges. The 
  exceptions that I got are very different depends on how I name the datasource 
  which I can't understand what's going on.
  
   
  
  Exerpt from 
  my jboss.jcml:
  
  
  
  org.gjt.mm.mysql.Driver
  
  mySQL"> 
  
  mySQL
  org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl 
  
  jdbc:mysql://192.168.1.152/test
  myname
  mypassword
   
  
  
  The exception I 
  got:
  
   
  
   
  
  [mySQL] Starting[mySQL] XA 
  Connection pool mySQL bound to java:/mySQL[mySQL] java.sql.SQLException: 
  Invalid authorization specification: Access denied for user: 'pifen@figgm' (Using password: YES)[mySQL] 
  Pool mySQL factory org.opentools.minerva.jdbc.xa.XAConnectionFactory@7b56b1 
  unable to create new object![mySQL] Pool mySQL [0/0/10] waiting for a free 
  object
  
   
  
  If I change the name to 
  "MySQL"
  
  
  
  org.gjt.mm.mysql.Driver
  
   
  
  MySQL
  org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl 
  
  jdbc:mysql://192.168.1.152/test
  pifen
  pifen
   
  
  
   
  
  The exception I 
  got:
  
  [MySQL] Starting[MySQL] XA 
  Connection pool MySQL bound to java:/MySQL[MySQL] Stopped[MySQL] 
  java.lang.NullPointerException[MySQL]  at 
  org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:165)[MySQL] 
   at 
  org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:330)[MySQL] 
   at 
  org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)[MySQL] 
   at java.lang.reflect.Method.invoke(Native Method)[MySQL]  at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)[MySQL] 
   at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)[MySQL] 
   at 
  org.jboss.util.ServiceControl.start(ServiceControl.java:97)[MySQL] 
   at java.lang.reflect.Method.invoke(Native Method)[MySQL]  at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)[MySQL] 
   at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)[MySQL] 
   at org.jboss.Main.(Main.java:217)[MySQL]  at 
  org.jboss.Main$1.run(Main.java:121)[MySQL]  at 
  java.security.AccessController.doPrivileged(Native Method)[MySQL]  at 
  org.jboss.Main.main(Main.java:117)[Service Control] Could not start 
  DefaultDomain:service=XADataSource,name=MySQL[Service Control] 
  java.lang.NullPointerException[Service Control]  at 
  org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:165)[Service 
  Control]  at 
  org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:330)[Service 
  Control]  at 
  org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)[Service 
  Control]  at java.lang.reflect.Method.invoke(Native Method)[Service 
  Control]  at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)[Service 
  Control]  at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)[Service 
  Control]  at 
  org.jboss.util.ServiceControl.start(ServiceControl.java:97)[Service 
  Control]  at java.lang.reflect.Method.invoke(Native Method)[Service 
  Control]  at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)[Service 
  Control]  at 
  com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)[Service 
  Control]  at org.jboss.Main.(Main.java:217)[Service 
  Control]  at org.jboss.Main$1.run(Main.java:121)[Service Control] 
   at java.security.AccessController.doPrivileged(Native 
  Method)[Service Control]  at 
  org.jboss.Main.main(Main.java:117)
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
  The strange thi

RE: [JBoss-user] MySql Not Working with JBoss

2001-08-10 Thread James Magee

Wana
rock

-Original Message-From: Jan Heise
[mailto:[EMAIL PROTECTED]]Sent: 10 August 2001
11:02To: [EMAIL PROTECTED]Subject: AW:
[JBoss-user] MySql Not Working with JBoss
hi,

does
jboss start up to:
.
.
.
[Service Control] Started 26
services[Default] JBoss 2.2.2 Started in 0m:32s
or
does it hang in the middle?
jan
--Jan Heise / Tel: +49-163-4803237 /
E-Mail: [EMAIL PROTECTED]

-Ursprüngliche Nachricht-Von:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Im Auftrag von nishar
aliGesendet: Freitag, 10. August 2001 11:26An:
[EMAIL PROTECTED]Betreff: [JBoss-user] MySql Not
Working with JBoss
Hai ,
I tryed to start mySql with connection pooling in JBoss but it fails. I
removed all the properties from JBoss.jcml except
my MySql properties and now it look like this

org.gjt.mm.mysql.Driver

">
org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl

HHDBConnectionPool
jdbc:mysql://localhost/happyhour

when the server run I dind't get consoul log which say the connection is
okai or not.
I need the help how can I get out of this problem

Do You Yahoo!?Make international calls for as low as $.04/minute
with Yahoo! Messengerhttp://phonecard.yahoo.com/

CONFIDENTIALITY NOTICE

This email is private and confidential and may contain legally privileged information. If you are not named above as an addressee it may be unlawful for you to read, copy, distribute, disclose or otherwise use the information in this email. If you are not the intended recipient of this email please contact our systems manager.

Thank you.

Any views or opinions presented are solely those of the author and do not necessarily represent those of the company or its associated companies unless otherwise specifically stated.

Re: [JBoss-user] MySQL, CMP Deployment Problem

2001-07-25 Thread Faisal Abdallah


 try to remove the deployed app ear from jboss jboss\tmp dir
and redeploy your app ..
faisal
- Original Message -
From: Scott Salisbury
To: [EMAIL PROTECTED]
Sent: Wednesday, July 25, 2001 6:45 PM
Subject: [JBoss-user] MySQL, CMP Deployment Problem


Hello,

I have a CMP bean that I have deployed.  Then, I needed to make a change to
it.  I dropped the table in MySQL.  I made changes to the Bean, the remote
interface and made an unrelated changed to the home interface.   When I
redeployed the bean, it created the table in MySQL properly but the new
methods created in the remote interface and the bean itself do not seem to
be recognized by the container.  No matter how many times I deploy the new
bean It is as if the container still sees the old version of the bean.  I
get the following message as soon as the client attempts to use one of the
new set methods:

Starting application C:\hcolab\com\src\client\PatientHeaderClient1.class
java.lang.NullPointerException: METHOD IS NOT FOUND:1805719028046769171
{-5255848813930177983=public abstract java.lang.String
com.src.entity.patientheader.PatientHeader.getPath_phone2() throws
java.rmi.RemoteException, 3163754803894080547=public abstract
javax.ejb.EJBHome javax.ejb.EJBObject.getEJBHome() throws
java.rmi.RemoteException, -5013858639939630501=public abstract void
javax.ejb.EJBObject.remove() throws
java.rmi.RemoteException,javax.ejb.RemoveException,
2853099017234602568=public abstract java.lang.String
com.src.entity.patientheader.PatientHeader.getPath_city() throws
java.rmi.RemoteException, 6036037884840400122=public abstract void
com.src.entity.patientheader.PatientHeader.setPath_address1(java.lang.String
) throws java.rmi.RemoteException, -3446593176504354005=public abstract
java.lang.String com.src.entity.patientheader.PatientHeader.getPath_zip5()
throws java.rmi.RemoteException, -1299374689989208114=public abstract
javax.ejb.Handle javax.ejb.EJBObject.getHandle() throws
java.rmi.RemoteException, 7269583083171870464=public abstract
java.lang.String com.src.entity.patientheader.PatientHeader.getPath_zip4()
throws java.rmi.RemoteException, -5000846178844685185=public abstract void
com.src.entity.patientheader.PatientHeader.setPath_address2(java.lang.String
) throws java.rmi.RemoteException, -8411450506172018100=public abstract void
com.src.entity.patientheader.PatientHeader.setPath_phone2(java.lang.String)
throws java.rmi.RemoteException, -5545972421826780573=public abstract void
com.src.entity.patientheader.PatientHeader.setPath_city(java.lang.String)
throws java.rmi.RemoteException, 4840115071604865751=public abstract
java.lang.Object javax.ejb.EJBObject.getPrimaryKey() throws
java.rmi.RemoteException, -5909123752501984271=public abstract boolean
javax.ejb.EJBObject.isIdentical(javax.ejb.EJBObject) throws
java.rmi.RemoteException, 9026218837603035593=public abstract void
com.src.entity.patientheader.PatientHeader.setPath_zip5(java.lang.String)
throws java.rmi.RemoteException, -7928200802148724701=public abstract void
com.src.entity.patientheader.PatientHeader.setPath_status(java.lang.String)
throws java.rmi.RemoteException, 2134192518985930584=public abstract void
com.src.entity.patientheader.PatientHeader.setPath_family_name(java.lang.Str
ing) throws java.rmi.RemoteException, 6283280847626038255=public abstract
void
com.src.entity.patientheader.PatientHeader.setPath_phone1(java.lang.String)
throws java.rmi.RemoteException, -3049668112836649109=public abstract
java.lang.String com.src.entity.patientheader.PatientHeader.getPath_phone1()
throws java.rmi.RemoteException, -7433864360636410658=public abstract
java.lang.String com.src.entity.patientheader.PatientHeader.getPath_status()
throws java.rmi.RemoteException, -8030792434171256968=public abstract
java.lang.String com.src.entity.patientheader.PatientHeader.getPath_state()
throws java.rmi.RemoteException, 7869734942315608452=public abstract
java.lang.String
com.src.entity.patientheader.PatientHeader.getPath_address2() throws
java.rmi.RemoteException, -6088873200954834602=public abstract void
com.src.entity.patientheader.PatientHeader.setPath_zip4(java.lang.String)
throws java.rmi.RemoteException, 1682985668773175340=public abstract
java.lang.String
com.src.entity.patientheader.PatientHeader.getPath_family_name() throws
java.rmi.RemoteException, 1224581694655521228=public abstract void
com.src.entity.patientheader.PatientHeader.setPath_state(java.lang.String)
throws java.rmi.RemoteException, -818588026533440350=public abstract
java.lang.String
com.src.entity.patientheader.PatientHeader.getPath_address1() throws
java.rmi.RemoteException}
 at
sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteC
all.java:245)
 at
sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:220)
 at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:122)
 at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker_Stub.invoke(Unknown
Source)
 at
org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.in

Re: [JBoss-user] MySQL, CMP Deployment Problem

2001-07-25 Thread David Jencks


One really silly possibility..

you don't by chance have your old ejb jar in lib/ext?? Or maybe just the
interfaces?

The MySQL table is correct by the new definition?  This might (?) happen if
interfaces jar was in lib/ext but beans themselves are deployed in deploy.

david jencks

On 2001.07.25 13:45:30 -0400 Scott Salisbury wrote:
> Hello, 
> 
> I have a CMP bean that I have deployed.  Then, I needed to make a change
> to it.  I dropped the table in MySQL.  I made changes to the Bean, the
> remote interface and made an unrelated changed to the home interface.  
> When I redeployed the bean, it created the table in MySQL properly but
> the new methods created in the remote interface and the bean itself do
> not seem to be recognized by the container.  No matter how many times I
> deploy the new bean It is as if the container still sees the old version
> of the bean.  I get the following message as soon as the client attempts
> to use one of the new set methods:
> 
> Starting application C:\hcolab\com\src\client\PatientHeaderClient1.class
> java.lang.NullPointerException: METHOD IS NOT FOUND:1805719028046769171
> {-5255848813930177983=public abstract java.lang.String
> com.src.entity.patientheader.PatientHeader.getPath_phone2() throws
> java.rmi.RemoteException, 3163754803894080547=public abstract
> javax.ejb.EJBHome javax.ejb.EJBObject.getEJBHome() throws
> java.rmi.RemoteException, -5013858639939630501=public abstract void
> javax.ejb.EJBObject.remove() throws
java.rmi.RemoteException,javax.ejb.RemoveException,
> 2853099017234602568=public abstract java.lang.String
> com.src.entity.patientheader.PatientHeader.getPath_city() throws
> java.rmi.RemoteException, 6036037884840400122=public abstract void
> com.src.entity.patientheader.PatientHeader.setPath_address1(java.lang.String)
> throws java.rmi.RemoteException, -3446593176504354005=public abstract
> java.lang.String com.src.entity.patientheader.PatientHeader.getPath_zip5()
> throws java.rmi.RemoteException, -1299374689989208114=public abstract
> javax.ejb.Handle javax.ejb.EJBObject.getHandle() throws
> java.rmi.RemoteException, 7269583083171870464=public abstract
> java.lang.String com.src.entity.patientheader.PatientHeader.getPath_zip4()
> throws java.rmi.RemoteException, -5000846178844685185=public abstract
> void com.src.entity.patientheader.PatientHeader.setPath_address2(java.lang.String)
> throws java.rmi.RemoteException, -8411450506172018100=public abstract
> void com.src.entity.patientheader.PatientHeader.setPath_phone2(java.lang.String)
> throws java.rmi.RemoteException, -5545972421826780573=public abstract
> void com.src.entity.patientheader.PatientHeader.setPath_city(java.lang.String)
> throws java.rmi.RemoteException, 4840115071604865751=public abstract
> java.lang.Object javax.ejb.EJBObject.getPrimaryKey() throws
> java.rmi.RemoteException, -5909123752501984271=public abstract boolean
> javax.ejb.EJBObject.isIdentical(javax.ejb.EJBObject) throws
> java.rmi.RemoteException, 9026218837603035593=public abstract void
> com.src.entity.patientheader.PatientHeader.setPath_zip5(java.lang.String)
> throws java.rmi.RemoteException, -7928200802148724701=public abstract
> void com.src.entity.patientheader.PatientHeader.setPath_status(java.lang.String)
> throws java.rmi.RemoteException, 2134192518985930584=public abstract void
> com.src.entity.patientheader.PatientHeader.setPath_family_name(java.lang.String)
> throws java.rmi.RemoteException, 6283280847626038255=public abstract void
> com.src.entity.patientheader.PatientHeader.setPath_phone1(java.lang.String)
> throws java.rmi.RemoteException, -3049668112836649109=public abstract
> java.lang.String com.src.entity.patientheader.PatientHeader.getPath_phone1()
> throws java.rmi.RemoteException, -7433864360636410658=public abstract
> java.lang.String com.src.entity.patientheader.PatientHeader.getPath_status()
> throws java.rmi.RemoteException, -8030792434171256968=public abstract
> java.lang.String com.src.entity.patientheader.PatientHeader.getPath_state()
> throws java.rmi.RemoteException, 7869734942315608452=public abstract
> java.lang.String com.src.entity.patientheader.PatientHeader.getPath_address2()
> throws java.rmi.RemoteException, -6088873200954834602=public abstract
> void com.src.entity.patientheader.PatientHeader.setPath_zip4(java.lang.String)
> throws java.rmi.RemoteException, 1682985668773175340=public abstract
> java.lang.String com.src.entity.patientheader.PatientHeader.getPath_family_name()
> throws java.rmi.RemoteException, 1224581694655521228=public abstract void
> com.src.entity.patientheader.PatientHeader.setPath_state(java.lang.String)
> throws java.rmi.RemoteException, -818588026533440350=public abstract
> java.lang.String com.src.entity.patientheader.PatientHeader.getPath_address1()
> throws java.rmi.RemoteException}
>  at 
>sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:245)
>  at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.j

Re: Re: Re: [JBoss-user] MySQL, BMP, Table not found

2001-07-12 Thread tim . haley




Scott,
I think your jboss.xml file is still not quite right:


>
>Here is my jboss.xml
>
>
>   
>
>  jdbc/mySQLDB
>  java:/jdbc/mySQLDB
>   
>
>

This should be:




   false

   
   

   
   
  jdbc/mySQLDB
  java:/jdbc/mySQLDB
   
   

   
 
  ShipBean
  titan/ShipHome
  
 
   



- Tim




___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: Re: Re: [JBoss-user] MySQL, BMP, Table not found

2001-07-11 Thread Scott Salisbury




Tim, 
 
Thanks again.  I was able to get rid of the 
InstantDB issue by removing the jboss-auto.jcml.  So JBOSS was able to 
finish its startup.  
   
Here is a view of the JNDIVIEW that was 
suggested.  

Application: 
file:/usr/JBoss-2.2.1_Tomcat-3.2.1/jboss/tmp/deploy/Default/ship.jar
java:comp namespace of the ShipBean bean:  +- env (class: org.jnp.interfaces.NamingContext)
  |   +- jdbc (class: org.jnp.interfaces.NamingContext)
  |   |   +- mySQLDB (class: javax.naming.LinkRef)
There is a slight difference in the mySQLDB line.  Mine does not have the link information that yours does. Here is my ejb-jar.xml file JavaBeans 1.1//EN" "http://java.sun.com/j2ee/dtds/ejb-jar_1_1.dtd">          This bean represents a cruise ship.    ShipBean  com.titan.shipbmp.ShipHome  com.titan.shipbmp.Ship  com.titan.shipbmp.ShipBean  Bean  com.titan.shipbmp.ShipPK  False     DataSource for the Titan database   jdbc/mySQLDB   javax.sql.DataSource   Container          This role represents everyone who is allowed full access  to the Ship bean.   everyone       everyone  ShipBean *            ShipBean    *  Required    Here is my jboss.xml      jdbc/mySQLDB  java:/jdbc/mySQLDB    Here is the java code...I have tried a variety of things as you can see.    try {  System.out.println("Trying to get connection!");    Context jndiCntx = new InitialContext();    DataSource ds =     /*(DataSource)jndiCntx.lookup("java:comp/env/jdbc/mySQLDB"); */   (DataSource)jndiCntx.lookup("java:jdbc/mySQLDB");   /*(DataSource)jndiCntx.lookup("java:env/jdbc/mySQLDB"); */    return ds.getConnection();  }Here is the relevant part of my jboss.jcml file.      org.gjt.mm.mysql.Driver      org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl    mySQLDS    jdbc:mysql://165.121.243.45/test            Now, here is the message I am getting...[ShipBean] Trying to get connection![ShipBean] TRANSACTION ROLLBACK EXCEPTION:null; nested exception is:     javax.ejb.EJBException[ShipBean] javax.naming.NameNotFoundException: jdbc not bound[ShipBean]  at org.jnp.server.NamingServer.getBinding(NamingServer.java:474)[ShipBean]  at org.jnp.server.NamingServer.getBinding(NamingServer.java:482)[ShipBean]  at org.jnp.server.NamingServer.getObject(NamingServer.java:488)[ShipBean]  at org.jnp.server.NamingServer.lookup(NamingServer.java:254)[ShipBean]  at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:295)[ShipBean]  at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:279)[ShipBean]  at javax.naming.InitialContext.lookup(InitialContext.java:350)[ShipBean]  at com.titan.shipbmp.ShipBean.getConnection(ShipBean.java:255)[ShipBean]  at com.titan.shipbmp.ShipBean.ejbCreate(ShipBean.java:40)Thank you again for your help.  I really appreciate it. Scott   

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  To: Scott Salisbury 
  Cc: [EMAIL PROTECTED] 
  
  Sent: Wednesday, July 11, 2001 12:54 
  PM
  Subject: Re: Re: Re: [JBoss-user] MySQL, 
  BMP, Table not found
  Scott,It sounds like the InstantDB datasource is 
  still being defined, but since youhave removed the driver, it cannot 
  load.I think that in JBoss 2.2.1 you have to delete the 
  jboss-auto.jcml file in orderto avoid having previously defined mbeans 
  from reappearing on you.  That waschanged in later versions.  
  You might want to use 2.2.2.You also say that CMP still works.  
  How is that possible when the startup hangs?In order to make the 
  Context.lookup() call like you are, I think that you needto 
  change:name="DefaultDomain:service=XADataSource,name=mySQLDB">toname="DefaultDomain:service=XADataSource,name=jdbc/mySQLDB">To 
  verify the JNDI name, Browse 
  http://localhost:8082/ Click on: 
  service=JNDIView Click on the list 
  button.Your bean will have an entry for it's java:comp 
  namespace.Make sure that it has the entry:  +- env 
  (class: org.jnp.interfaces.NamingContext)  |   +- jdbc 
  (class: org.jnp.interfaces.NamingContext)  |   
  |   +- mySQLDB[link -> java:/jdbc/mySQLDB] (class: 
  javax.naming.LinkRef)If not, either:1) fix your deployment 
  descriptors, you are missing:  
     
  jdbc/mySQLDB   
  javax.sql.DataSource   
  Container  
   in your ejb-jar.xml file 
  and:  
      
    
  jdbc/mySQLDB  
  java:/jdbc/mySQLDB    
    
   in your jboss.xml 
  file.2) Or, change your code to: 
  DataSource ds = (DataSource)jndiCntx.lookup("java:jdbc/mySQLDB");Good 
  luck!"Scott Salisbury" 
  <[EMAIL PROTECTED]> on 07/11/2001 11:56:40 
  AMTo:   Tim 
  Haley/SAR/Global@Globalcc:Subject:  Re: Re: [JBoss-user] 
  MySQL, BMP,

Re: Re: Re: [JBoss-user] MySQL, BMP, Table not found

2001-07-11 Thread tim . haley




Scott,
It sounds like the InstantDB datasource is still being defined, but since you
have removed the driver, it cannot load.

I think that in JBoss 2.2.1 you have to delete the jboss-auto.jcml file in order
to avoid having previously defined mbeans from reappearing on you.  That was
changed in later versions.  You might want to use 2.2.2.

You also say that CMP still works.  How is that possible when the startup hangs?

In order to make the Context.lookup() call like you are, I think that you need
to change:


to


To verify the JNDI name,

 Browse http://localhost:8082/

 Click on: service=JNDIView

 Click on the list button.

Your bean will have an entry for it's java:comp namespace.

Make sure that it has the entry:

  +- env (class: org.jnp.interfaces.NamingContext)
  |   +- jdbc (class: org.jnp.interfaces.NamingContext)
  |   |   +- mySQLDB[link -> java:/jdbc/mySQLDB] (class: javax.naming.LinkRef)

If not, either:

1) fix your deployment descriptors, you are missing:

  
   jdbc/mySQLDB
   javax.sql.DataSource
   Container
  
 in your ejb-jar.xml file and:

  

  jdbc/mySQLDB
  java:/jdbc/mySQLDB

  
 in your jboss.xml file.

2) Or, change your code to:

 DataSource ds = (DataSource)jndiCntx.lookup("java:jdbc/mySQLDB");
Good luck!





"Scott Salisbury" <[EMAIL PROTECTED]> on 07/11/2001 11:56:40 AM

To:   Tim Haley/SAR/Global@Global
cc:

Subject:  Re: Re: [JBoss-user] MySQL, BMP, Table not found




Thanks Tim!

I appreciate your help.   Here is what my jboss.jcml JDBC section now looks
like, after following your suggestion.


 
org.gjt.mm.mysql.Driver
 

   org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl

   mySQLDS
   jdbc:mysql://165.121.243.05/test
   
   
   

The problem is that when I start JBOSS now, it hangs when the following appears
on the log

[InstantDB] Starting
[InstantDB] XA Connection pool InstantDB bound to java:/InstantDB

It does not continue after this point.Is there somewhere besides jboss.jcml that
I must look?

my CMP beans continue to work but my BMP bean test is now giving the following
message...

[ShipBean] TRANSACTION ROLLBACK EXCEPTION:null; nested exception is:
   javax.ejb.EJBException
[ShipBean] javax.naming.NameNotFoundException: jdbc not bound
[ShipBean]  at org.jnp.server.NamingServer.getBinding(NamingServer.java:474)
[ShipBean]  at org.jnp.server.NamingServer.getBinding(NamingServer.java:482)
[ShipBean]  at org.jnp.server.NamingServer.getObject(NamingServer.java:488)
[ShipBean]  at org.jnp.server.NamingServer.lookup(NamingServer.java:254)
[ShipBean]  at org.jnp.server.NamingServer.lookup(NamingServer.java:257)

I must still be missing something.  Here is the java code that I am using

Connection con = null;
   PreparedStatement ps = null;
   try {
 con = this.getConnection();
 ps = con.prepareStatement(
  "insert into Ship (id, name, capacity, tonnage) " +
  "values (?,?,?,?)");
 ps.setInt(1, id);
 ps.setString(2, name);
 ps.setInt(3, capacity);
 ps.setDouble(4, tonnage);
...
// here is the connection methodmaybe the problem is here
private Connection getConnection() throws SQLException {
 try {
   Context jndiCntx = new InitialContext();
   DataSource ds =
   (DataSource)jndiCntx.lookup("java:comp/env/jdbc/mySQLDB");
   return ds.getConnection();
 }
 catch (NamingException ne) {
   throw new EJBException(ne);
 }
   }

Thanks again for your help!




Thanks Tim!I appreciate your help.   Here is what 
my jboss.jcml JDBC section now looks like, after following your suggestion. 
 org.gjt.mm.mysql.Driverorg.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl   mySQLDS   jdbc:mysql://165.121.243.05/test The problem is that when I 
start JBOSS now, it hangs when the following appears on the 
log[InstantDB] Starting[InstantDB] XA Connection pool InstantDB 
bound to java:/InstantDB
It does not continue after this point.Is there 
somewhere besides jboss.jcml that I must look? 
my CMP beans continue to work but my BMP bean test is now giving 
the following message...[ShipBean] TRANSACTION ROLLBACK EXCEPTION:null; 
nested exception is: 
   javax.ejb.EJBException[ShipBean] 
javax.naming.NameNotFoundException: jdbc not bound[ShipBean] 
 at 
org.jnp.server.NamingServer.getBinding(NamingServer.java:474)[ShipBean] 
 at 
org.jnp.server.NamingServer.getBinding(NamingServer.java:482)[ShipBean] 
 at 
org.jnp.server.NamingServer.getObject(NamingServer.java:488)[ShipBean] 
 at 
org.jnp.server.NamingServer.lookup(NamingServer.java:254)[ShipBean] 
 at 
org.jnp.server.NamingServer.lookup(NamingServer.java:257)I must still be 
missing something.  Here is the java code that I am usingConnection 
con = null

Re: Re: [JBoss-user] MySQL, BMP, Table not found

2001-07-10 Thread tim . haley




Scott,

I strongly suggest that you remove all JDBC Driver and DataSource information
that you are not actively using from your configuration.  IMHO, that is the
easiest way to determine if you are indeed connecting to the correct database.

When I first started trying to connect to an alternate database, I had the
datasource configuration slightly wrong.  I would get a connection to the
default datasource instead of the one I was trying to connect to, with NO
warning.

Removing the other database entries in all of your configuration files will also
speed up your test cycle since you will not have to wait for the unused database
engines to be started and run.

- Tim

- Original Message -
From: "Scott Salisbury" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 11:35 PM
Subject: [JBoss-user] MySQL, BMP, Table not found


Hello,

I am using the O'Reilly book to familiarize with EJB.  I am using JBOSS
2.2.1 with Tomcat 3.2.1.  I am able to get CMP beans to work using MySQL
without a problem however when I try to insert a row using BMP I get the
following message..

Table not found: TEST.SHIP in statement [insert into test.Ship (id, name,
capacity, tonnage) values (4,'UtopiaBMP',4500,8939.0)]

The table is there.  I am using MySQL but I have a feeling that JBOSS is
trying to write to InstantDB or Hypersonic.  I have included configuration
files below.
I have reviewed the archives but still can't figure it out.  What have I
missed?

.
.
.
JDBC section of jboss.jcml

  
  
  org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,org.
gjt.mm.mysql.Driver
  

  org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l
  mySQLDS
jdbc:mysql://165.121.243.05/test
  


.
.
.
.



___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySQL, BMP, Table not found

2001-07-10 Thread Burkhard Vogel

1 error so below:
- Original Message -
From: "Scott Salisbury" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 11:35 PM
Subject: [JBoss-user] MySQL, BMP, Table not found

Hello,

I am using the O'Reilly book to familiarize with EJB.  I am using JBOSS
2.2.1 with Tomcat 3.2.1.  I am able to get CMP beans to work using MySQL
without a problem however when I try to insert a row using BMP I get the
following message..

Table not found: TEST.SHIP in statement [insert into test.Ship (id, name,
capacity, tonnage) values (4,'UtopiaBMP',4500,8939.0)]

The table is there.  I am using MySQL but I have a feeling that JBOSS is
trying to write to InstantDB or Hypersonic.  I have included configuration
files below.
I have reviewed the archives but still can't figure it out.  What have I
missed?

[ShipBean] TRANSACTION ROLLBACK EXCEPTION:null; nested exception is:
javax.ejb.EJBException
[ShipBean] java.sql.SQLException: Table not found: TEST.SHIP in statement
[insert into test.Ship (id, name, capacity, tonnage) values
(4,'UtopiaBMP',4500,8939.
0)]
[ShipBean]  at org.hsql.Trace.getError(Trace.java:124)
[ShipBean]  at org.hsql.Result.(Result.java:70)
[ShipBean]  at
org.hsql.jdbcConnection.executeHSQL(jdbcConnection.java:644)
[ShipBean]  at org.hsql.jdbcConnection.execute(jdbcConnection.java:540)
[ShipBean]  at
org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499)
[ShipBean]  at
org.hsql.jdbcStatement.executeUpdate(jdbcStatement.java:52)
[ShipBean]  at
org.hsql.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.java:114)
[ShipBean]  at
org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpdate(PreparedSta
tementInPool.java:82)
[ShipBean]  at com.titan.shipbmp.ShipBean.ejbCreate(ShipBean.java:48)
[ShipBean]  at java.lang.reflect.Method.invoke(Native Method)
[ShipBean]  at
org.jboss.ejb.plugins.BMPPersistenceManager.createEntity(BMPPersistenceManag
er.java:121)
[ShipBean]  at
org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441)
[ShipBean]  at java.lang.reflect.Method.invoke(Native Method)
[ShipBean]  at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContaine
r.java:639)
[ShipBean]  at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySync
hronizationInterceptor.java:160)
[ShipBean]  at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInt
erceptor.java:87)

JNDI Code within the bean
  private Connection getConnection() throws SQLException {
  try {
Context jndiCntx = new InitialContext();
DataSource ds =
(DataSource)jndiCntx.lookup("java:comp/env/jdbc/mySQLDB");
return ds.getConnection();
  }
  catch (NamingException ne) {
throw new EJBException(ne);
  }
}

JDBC section of jboss.jcml

org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,org.
gjt.mm.mysql.Driver

org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l
mySQLDS
jdbc:mysql://165.121.243.05/test

ejb-jar.xml

http://java.sun.com/j2ee/dtds/ejb-jar_1_1.dtd";>

This bean represents a cruise ship.

  ShipBean
  com.titan.shipbmp.ShipHome
  com.titan.shipbmp.Ship
  com.titan.shipbmp.ShipBean
  Bean
  com.titan.shipbmp.ShipPK
  False

   DataSource for the Titan database
   jdbc/mySQLDB
   javax.sql.DataSource
   Container

 This role represents everyone who is allowed full access
 to the Ship bean.

 everyone

 everyone

 ShipBean
 *

ShipBean
*

 Required

jboss.xml

  ShipBean

jdbc:/mySQLDB
>>
jdbc/mySQLDB
without the ":" -> tooo mcuh copy&paste, right??
also, bear in mind that mySQL is case sensitive!! the table Test MUST be
named Test in mySQL NOT test or TEST!!!
<<
java:/mySQLDB

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql-Jboss ConnectionPool

2001-07-05 Thread danch (Dan Christopherson)

Rakesh Shankar Shringi wrote:

> hi,
> jboss.xml
> 
>  
> jdbc/mySQLFlirtDS 
> java:/mySQLFlirtDS 

Try 'java:/mySQLFlirtDS' here. I believe 
that works in jboss 2.2.2 or later.

If not you'll need to add a 'resource-managers' section to your 
jboss.xml file. See the jboss.dtd for more information on that.

-danch

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql-Jboss ConnectionPool

2001-07-04 Thread Toby Allsopp


On Wed, Jul 04, 2001 at 03:53:39PM +0530, Rakesh Shankar Shringi wrote:
> hi,
> 
> I am trying to use the JBOSS connectionPool 
> and i am getting the following error:
> [java]java.lang.ClassCastException:
> org.opentools.minerva.jdbc.xa.XAPoolDataSource
> 
> jboss.xml
> 
>  
> jdbc/mySQLFlirtDS 
> java:/mySQLFlirtDS 
>  

This is wrong.  I can't remember what it should be, but look in the
mailing list archives.

> in the bean:
> 
>  Context ctx = new InitialContext(); 
>  ConnectionPoolDataSource cpds =
> (ConnectionPoolDataSource)ctx.lookup("java:comp/env/jdbc/mySQLFlirtDS");
>  PooledConnection pc = cpds.getPooledConnection(); 

Ok, WTF is ConnectionPoolDataSource?  Just use javax.sql.DataSource.

Toby.

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql works

2001-07-04 Thread Richard Bottoms


>There is a pretty good example in the J2EE Tutorial PDF from Sun.
>-- 
>  Nicolai P Gubahttp://www.gnu.org http://www.frontwire.com
>mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
>GSM: +44 (0)7909 960 751   DDI: +44 (0)20 7368 9708


Thanks, I'll try that one too.

Well now that I have all the tools in place I think I'll go enjoy some
non-virtual people for a while. Happy 4th y'all.


r.b.





___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql examples

2001-07-04 Thread Richard Bottoms


Google and yea shall receive:

http://p2p.wrox.com/archive/java_databases/2001-03/7.asp


r.b.





___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql works

2001-07-04 Thread Nicolai P Guba

> "RB" == Richard Bottoms <[EMAIL PROTECTED]> writes:

>> Hmm.
>> 
>> Ours is Debian GNU/Linux and the mysql version is
>> 
>> mysql Ver 11.13 Distrib 3.23.36, for pc-linux-gnu (i586)
>> 
>> Could it be that the mysql version is older and maybe incompatible
>> with that driver?

RB> That's the thing, I went to the older version to get it to
RB> work. In any case I'm glad I can stop banging my head against the
RB> wall. Now then any help with an example of how to actually use it
RB> in a servlet and/or jsp page would be greatly appreciated.

There is a pretty good example in the J2EE Tutorial PDF from Sun.
-- 
  Nicolai P Gubahttp://www.gnu.org http://www.frontwire.com
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
GSM: +44 (0)7909 960 751   DDI: +44 (0)20 7368 9708

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql works

2001-07-04 Thread Richard Bottoms


>Hmm.  
>
>Ours is Debian GNU/Linux and the mysql version is
>
>  mysql  Ver 11.13 Distrib 3.23.36, for pc-linux-gnu (i586)
>
>Could it be that the mysql version is older and maybe incompatible
>with that driver?


That's the thing, I went to the older version to get it to work. In any
case I'm glad I can stop banging my head against the wall. Now then any
help with an example of how to actually use it in a servlet and/or jsp page
would be greatly appreciated.


r.b.





___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql works

2001-07-04 Thread Richard Bottoms


Okay, now that I have mysql functioning would any one have a servlet and/or
a http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql works

2001-07-04 Thread Nicolai P Guba


> "RB" == Richard Bottoms <[EMAIL PROTECTED]> writes:

RB> At 06:59 PM 7/4/01 +0100, you wrote:
>>> "RB" == Richard Bottoms <[EMAIL PROTECTED]> writes:


RB> Under Red Hat 6.1:

RB> [JDBC provider] Starting [JDBC provider] Started [mySQLDS]
RB> Starting [mySQLDS] XA Connection pool mySQLDS bound to
RB> java:/mySQLDS [mySQLDS] Stopped [mySQLDS]
[snip]
RB> java.security.AccessController.doPrivileged(Native Method)
RB> [mySQLDS] at org.jboss.Main.main(Main.java:117)

RB> All I did was change to the older version of mm.mysql and
RB> restarted.  Problem gone.

Hmm.  

Ours is Debian GNU/Linux and the mysql version is

  mysql  Ver 11.13 Distrib 3.23.36, for pc-linux-gnu (i586)

Could it be that the mysql version is older and maybe incompatible
with that driver?

-- 
  Nicolai P Gubahttp://www.gnu.org http://www.frontwire.com
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
GSM: +44 (0)7909 960 751   DDI: +44 (0)20 7368 9708

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql works

2001-07-04 Thread Richard Bottoms


At 06:59 PM 7/4/01 +0100, you wrote:
>> "RB" == Richard Bottoms <[EMAIL PROTECTED]> writes:


Under Red Hat 6.1:

[JDBC provider] Starting 
[JDBC provider] Started 
[mySQLDS] Starting 
[mySQLDS] XA Connection pool mySQLDS bound to java:/mySQLDS 
[mySQLDS] Stopped 
[mySQLDS] java.lang.NullPointerException 
[mySQLDS] at 
org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSourc 
e.java:165) 
[mySQLDS] at 
org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:330) 
[mySQLDS] at 
org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93) 
[mySQLDS] at java.lang.reflect.Method.invoke(Native Method) 
[mySQLDS] at 
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628) 
[mySQLDS] at 
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523) 
[mySQLDS] at org.jboss.util.ServiceControl.start(ServiceControl.java:97) 
[mySQLDS] at java.lang.reflect.Method.invoke(Native Method) 
[mySQLDS] at 
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628) 
[mySQLDS] at 
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523) 
[mySQLDS] at org.jboss.Main.(Main.java:217) 
[mySQLDS] at org.jboss.Main$1.run(Main.java:121) 
[mySQLDS] at java.security.AccessController.doPrivileged(Native Method) 
[mySQLDS] at org.jboss.Main.main(Main.java:117)

All I did was change to the older version of mm.mysql and restarted.
Problem gone.


r.b.





___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql works

2001-07-04 Thread Nicolai P Guba


> "RB" == Richard Bottoms <[EMAIL PROTECTED]> writes:

RB> At last.  Note that Jboss 2.2.2 requires
RB> mm.mysql-2.0.2-bin.jar. Version mm.mysql-2.0.4-bin.jar will not
RB> work.

H, I've been using 2.0.4 with JBoss 2.2.2 for quite some time now.
What excactly doesn't work?

-- 
  Nicolai P Gubahttp://www.gnu.org http://www.frontwire.com
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
GSM: +44 (0)7909 960 751   DDI: +44 (0)20 7368 9708

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql driver

2001-06-26 Thread Michael Bilow

I really hope not, since we took everything but PostgreSQL support out of
the "jboss.jcml" file and made that the "DefaultDS."  It may be that there
is a requirement that "DefaultDS" exist, but I don't know.  We are not
using JMS for anything special, but so far things seem to work.  Probably
one of the people on this list who knows what he is talking about could
answer your question better than I can.

-- Mike

On 2001-06-26 at 13:25 -0500, Mike Thompson wrote:

> Yikes! (Note: feel free to laugh if this is a stupid question).  Doesn't the
> JBoss JMS service use one of these DBs to persist messages?
> --m
> 
> - Original Message -
> From: "Michael Bilow" <[EMAIL PROTECTED]>
> To: "List: jBoss users" <[EMAIL PROTECTED]>
> Sent: Tuesday, June 26, 2001 1:16 PM
> Subject: Re: [JBoss-user] mysql driver
> 
> 
> > While you are perfectly correct about this, I think it is advantageous to
> > remove any of the databases which you are not using.  That is, if you are
> > talking only to MySQL, then you probably would be better off excising all
> > of the Enhydra stuff from the "jboss.jcml" file.  Hypersonic especially
> > eats memory at a prodigious rate.
> >
> > -- Mike

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql driver

2001-06-26 Thread Mike Thompson


Yikes! (Note: feel free to laugh if this is a stupid question).  Doesn't the
JBoss JMS service use one of these DBs to persist messages?
--m

- Original Message -
From: "Michael Bilow" <[EMAIL PROTECTED]>
To: "List: jBoss users" <[EMAIL PROTECTED]>
Sent: Tuesday, June 26, 2001 1:16 PM
Subject: Re: [JBoss-user] mysql driver


> While you are perfectly correct about this, I think it is advantageous to
> remove any of the databases which you are not using.  That is, if you are
> talking only to MySQL, then you probably would be better off excising all
> of the Enhydra stuff from the "jboss.jcml" file.  Hypersonic especially
> eats memory at a prodigious rate.
>
> -- Mike
>
>
> On 2001-06-26 at 08:02 -0500, Mike Thompson wrote:
>
> > Ok, think I figured it out.  The docs led me to believe that I could
have
> > more than one
> >  > name="DefaultDomain:service=JdbcProvider">
> > org.gjt.mm.mysql.Driver
> > 
> >
> > in my jboss.jcml.  I found that if I bundle all my drivers into one i.e
> >  > name="DefaultDomain:service=JdbcProvider">
> >  >
name="Drivers">org.gjt.mm.mysql.Driver,org.hsql.jdbcDriver,org.enhydra.insta
> > ntdb.jdbc.idbDriver
> > 
> >
> > that all works ok.
> > --m
>
>
>
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user


___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql driver

2001-06-26 Thread Michael Bilow

While you are perfectly correct about this, I think it is advantageous to
remove any of the databases which you are not using.  That is, if you are
talking only to MySQL, then you probably would be better off excising all
of the Enhydra stuff from the "jboss.jcml" file.  Hypersonic especially
eats memory at a prodigious rate.

-- Mike

On 2001-06-26 at 08:02 -0500, Mike Thompson wrote:

> Ok, think I figured it out.  The docs led me to believe that I could have
> more than one
>  name="DefaultDomain:service=JdbcProvider">
> org.gjt.mm.mysql.Driver
> 
> 
> in my jboss.jcml.  I found that if I bundle all my drivers into one i.e
>  name="DefaultDomain:service=JdbcProvider">
>  name="Drivers">org.gjt.mm.mysql.Driver,org.hsql.jdbcDriver,org.enhydra.insta
> ntdb.jdbc.idbDriver
> 
> 
> that all works ok.
> --m

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql driver

2001-06-26 Thread Mike Thompson


Ok, think I figured it out.  The docs led me to believe that I could have
more than one

org.gjt.mm.mysql.Driver


in my jboss.jcml.  I found that if I bundle all my drivers into one i.e

org.gjt.mm.mysql.Driver,org.hsql.jdbcDriver,org.enhydra.insta
ntdb.jdbc.idbDriver


that all works ok.
--m



- Original Message -
From: "Mike Thompson" <[EMAIL PROTECTED]>
To: "jboss" <[EMAIL PROTECTED]>
Sent: Tuesday, June 26, 2001 7:39 AM
Subject: [JBoss-user] mysql driver


> Ok, I'm trying to run JBoss with tomcat.  I've recently downloaded the
> latest\greatest bundle.  I need a datasource that points to a mysql
> database, so I added
>
>  name="DefaultDomain:service=JdbcProvider">
> org.gjt.mm.mysql.Driver
> 
>
> to my jboss.jcml in the configuration that I am running (which was just a
> copy of the \conf\tomcat dir).  Now when I do a \bin\run myconf, tomcat
does
> not start.  If I take this line out, tomcat starts just fine.  Any
thoughts?
> --m
>
> Michael R. Thompson
> http://www.instanton.com
> 512.439.3815
>
>
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user


___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

RE: [JBoss-user] MySQL Pool Error: XA Connection... NullPointerException

2001-06-22 Thread Jord Sonneveld

Title: RE: [JBoss-user] MySQL Pool Error: XA Connection... NullPointerException






Try setting your minimum pool size to 1. Had this same problem, only with oracle drivers.


In the xadatasourceloader mbean:

1


j\s


-Original Message-

From: Keith Elliott [mailto:[EMAIL PROTECTED]]

Sent: Friday, June 22, 2001 8:38 PM

To: [EMAIL PROTECTED]

Subject: [JBoss-user] MySQL Pool Error: XA Connection...

NullPointerException



Hi Folks,


We're using RHL 7.1, MySQL, Jboss 2.2.2/Tomcat 3.2.2 combo.  We get the

following error when starting jboss:


...

[JAAS Security Manager] Started

[JDBC provider] Starting

[JDBC provider] Started

[mysqlPool] Starting

[mysqlPool] XA Connection pool mysqlPool bound to java:/mysqlPool

[mysqlPool] Stopped

[mysqlPool] java.lang.NullPointerException

[mysqlPool]  at

org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:165)


[mysqlPool]  at

org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:330)


[mysqlPool]  at

org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)

[mysqlPool]  at java.lang.reflect.Method.invoke(Native Method)

[mysqlPool]  at

com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)


[mysqlPool]  at

com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)


[mysqlPool]  at

org.jboss.util.ServiceControl.start(ServiceControl.java:97)

[mysqlPool]  at java.lang.reflect.Method.invoke(Native Method)

[mysqlPool]  at

com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)


[mysqlPool]  at

com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)


[mysqlPool]  at org.jboss.Main.(Main.java:217)

[mysqlPool]  at org.jboss.Main$1.run(Main.java:121)

[mysqlPool]  at java.security.AccessController.doPrivileged(Native

Method)

[mysqlPool]  at org.jboss.Main.main(Main.java:117)

[Service Control] Could not start

DefaultDomain:service=XADataSource,name=mysqlDB

[Service Control] java.lang.NullPointerException

[Service Control]  at

org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:165)


[Service Control]  at

org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:330)


[Service Control]  at

org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)

[Service Control]  at java.lang.reflect.Method.invoke(Native Method)

[Service Control]  at

com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)


[Service Control]  at

com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)


[Service Control]  at

org.jboss.util.ServiceControl.start(ServiceControl.java:97)

[Service Control]  at java.lang.reflect.Method.invoke(Native Method)

[Service Control]  at

com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)


[Service Control]  at

com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)


[Service Control]  at org.jboss.Main.(Main.java:217)

[Service Control]  at org.jboss.Main$1.run(Main.java:121)

[Service Control]  at java.security.AccessController.doPrivileged(Native

Method)

[Service Control]  at org.jboss.Main.main(Main.java:117)

[Container factory] Starting

[Container factory] Started

[EmbeddedTomcatSX] Starting

...


Here's the relevant part of the jboss.jcml file...


  

  

  

name="DefaultDomain:service=JdbcProvider">

 org.gjt.mm.mysql.Driver

  


  

name="DefaultDomain:service=XADataSource,name=mysqlDB">

    

name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl


    mysqlPool

    jdbc:mysql://localhost/application


    username

    password

  


Strangely enough, if we change localhost to another machine name in our

internal network that is setup with MySQL in a similar fashion, it

works.  We've tried changing the URL line to..

    jdbc:mysql:/localhost/application

and also,

    jdbc:mysql:@localhost/application

but that does not work.  MySQL is running and setup fine.  We've setup

prior versions, and have not had this problem.


I've seen one other message on this list with a similar problem, but no

resolution.


Any ideas?


Muchas Gracias Amigos,


  Keith Elliott



___

JBoss-user mailing list

[EMAIL PROTECTED]

http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql

2001-06-21 Thread Nicolai P Guba

> "RB" == Richard Bottoms <[EMAIL PROTECTED]> writes:

RB> At 06:52 PM 6/16/01 +0100, you wrote:
>> The current version MySQL works fine with Jboss .

RB> Any possibility of a .ear & source tutorial? MySQL data access is
RB> the next thing I need to get working (followed by Mail). I was
RB> able to code a working demo of MySQL connectivity using the
RB> stand-alone jakarta-tomcat distro. Could you share something
RB> similar for the jboss-tomcat bundle?

H, whilst on the topic, to what extent does the lack of propper
transaction support in mySQL limit it's usefullness with EJB?  Is
PostgreSQL more suitable?

-- 
  Nicolai P Gubahttp://www.gnu.org http://www.frontwire.com
mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
GSM: +44 (0)7909 960 751   DDI: +44 (0)20 7368 9708

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql

2001-06-20 Thread Richard Bottoms


At 06:52 PM 6/16/01 +0100, you wrote:
>The  current version MySQL works   fine with Jboss .

Any possibility of a .ear & source tutorial? MySQL data access is the next
thing I need to get working (followed by Mail). I was able to code a
working demo of MySQL connectivity using the stand-alone jakarta-tomcat
distro. Could you share something similar for the jboss-tomcat bundle?


Thanks,
r.b.





___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql

2001-06-16 Thread Larry Budnick

Hello Boris -

Following is the JDBC section from jboss.jcml. I commented out a number of
the sections for InstantDB and Hypersonic, and modified the defaultDS to be
mySQL. In the mySQL sections, I made both the default and the named "mySQL"
connection pools to point to the same database, in this case it is called
"partner". Also, I left in the loading of the other (non-mySQL) drivers,
with no apparent harm. I'll probably take these out for production. I've not
tinkered with any of the other settings, and probably should just so I
understand what they all mean :-)

As to problems, older versions of mySQL did not support transactions, and
jboss complained bitterly about that. Also, I have not had any luck with CMP
using a java.sql.Timestamp field, and instead use java.util.Date, since it
is mapped to a DATETIME field in mySQL anyway. Also, the syntax in the jboss
config files has been changing a bit, and since mySQL is not one of the
"native" databases, it takes some time for the mySQL users to catch up with
examples for the latest syntax, thus some confusion always seems to ensue.

I've been using this most recently with the MVCSoft persistence manager, to
get used the V2 style of CMP, and it has been working great. (with the
exception of the Timestamp type as noted above)

Hope this helps!

Larry Budnick

org.gjt.mm.mysql.Driver,org.hsql.jdbcDriver,org.enhydra.insta
ntdb.jdbc.idbDriver

mySQL

org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l

jdbc:mysql://127.0.0.1:3306/partner

120

root

10

false

false

false

true

12

180

false

false

1.0

0

DefaultDS

org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l

jdbc:mysql://127.0.0.1:3306/partner

120

root

10

false

false

false

true

12

180

false

false

1.0

0

- Original Message -
From: "Boris Garbuzov" <[EMAIL PROTECTED]>
To: "Larry Budnick" <[EMAIL PROTECTED]>
Sent: Saturday, June 16, 2001 1:51 AM
Subject: Re: [JBoss-user] mysql

> Thanks very much, Larry. So how do I reconfiger JBoss to change default
from
> hypersonic to MySql. Also, if it is so simple, what kind of problems of
MySql
> support was discussed previously on the list?
>
> 
>
>
>
> Larry Budnick wrote:
>
> > If you still need assistance, please let me know. I use MySQL (latest
> > versions, with BDB tables) very successfully with jboss. In general,
nothing
> > fancy, just specify the database name at the end of the URL to define
the DB
> > to use for the pool.
> >
> > Larry Budnick
> >
> > - Original Message -
> > From: "Boris Garbuzov" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Friday, June 15, 2001 7:33 PM
> > Subject: [JBoss-user] mysql
> >
> > > I saw some doubts on the list about future MySQL support. Is it
currently
> > supported by JBoss' CMP? What should I tell to JBoss to use my
connection
> > URL and associated issues?
> > >
> > >
> > > ___
> > > JBoss-user mailing list
> > > [EMAIL PROTECTED]
> > > http://lists.sourceforge.net/lists/listinfo/jboss-user
>

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql

2001-06-16 Thread Faisal Abdallah


The  current version MySQL works   fine with Jboss .The latest vesion has
BERKELEY DB and  InnoDB included.
check chapter 3 JDBC of the documentation to find out  how to make the
connection url and specifying your datasource
- Original Message -
From: "Boris Garbuzov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 16, 2001 12:33 AM
Subject: [JBoss-user] mysql


> I saw some doubts on the list about future MySQL support. Is it currently
supported by JBoss' CMP? What should I tell to JBoss to use my connection
URL and associated issues?
>
>
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user


___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySQL and CMB in JBoss

2001-06-08 Thread Burkhard Vogel

Hi,
RTFM! see docu, chapter on jaws.xml + chapter on Jboss.xml its all in there.
Burkhard
- Original Message -
From: "mroosendaal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 12:43 PM
Subject: [JBoss-user] MySQL and CMB in JBoss

Hi,

This question has probably been asked more often. In the jboss.jcml i have
declared a MySQL pool to access a db called Test with two tables called
Person and Work. If i want to write an CMB how do i tell the EJB to use this
pool? Do you put it in the ejb-jar.xml or in the jboss.xml (if possible
could you provide a small example)?

If you want to create a small-webapp with a JSP, Servlet, Client, EJB and DB
i assume you have to package them all in an .ear-file (Or can you seperate
them) but is there a directory structure for this (WEB-INF)? How do the
web.xml and the jboss-web.xml fit in to this?

Thanks,
Maarten

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] " [mysql] no transcation right now", what does it mean?

2001-05-30 Thread Georg Rehfeld


Hi wizard,

>  I try to use a new version of mysql that supports transaction .
> I can do some transaction operation on BDB and InnoDB table type
> with  command BEGIN ,COMMIT and ROLLBACK successfully.

Nice to hear that! I'm VERY interested in your further results,
especially performance and reliability. Would you care to report
to this list, please?

> I got one line in the log file,
> " [mysql] no transcation right now",
> what does it mean?

The message comes from org.jboss.pool.jdbc.xa.XAConnectionFactory
in the method prepareObject. The code tries to assign a connection
to a transaction, if one exists, but seems to allow usage of
the connection outside a transaction.

I guess, you are getting a connection in a beans method with a
transaction attribute of Supports, Never or Notsupported, do you?
Or might be, you get a connection somewhere in your test code,
where no transaction at all is established (i.e. from a servlet)?

Hope this helps
Georg
 ___   ___
| + | |__Georg Rehfeld  Woltmanstr. 12 20097 Hamburg
|_|_\ |___   [EMAIL PROTECTED]   +49 (40) 23 53 27 10



___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mySQL auto increment and CMP entity beans

2001-05-22 Thread Georg Rehfeld


Hi Paul,

> The code I am using is as follows, I had thought of creating an additional
> bean to do this but was wondering if there was an easier way.
>[code cut, see Pauls mail]

> [Section] java.lang.Error: id may not be null
> [Section]   at org.jboss.ejb.CacheKey.(CacheKey.java:51)
> [Section]   at
>
org.jboss.ejb.plugins.EntityInstanceCache.createCacheKey(EntityInstanceCache
> .java:47)
>[rest of trace cut]

This exception is thrown in the container, not in JAWS. So you
only have the chance to use a KeyGenerator().

And again reading the EJB spec 1.1 section 9.4.2 paragraph six
I found:

| The container may create the representation of the entity in the
| database immediately after ejbCreate(...) returns, or it can defer it to
| a later time (for example to the time after the matching
| ejbPostCreate(...) has been called, or to the end of the transaction).

So, to remain portable to other EJB implementations, you even
havn't the chance to use ejbPostCreate to access the autoincrement
value, as the DB access might have not been done already (though
with JAWS the insert is done between ejbCreate and ejbPostCreate).

regards

Georg
 ___   ___
| + | |__Georg Rehfeld  Woltmanstr. 12 20097 Hamburg
|_|_\ |___   [EMAIL PROTECTED]   +49 (40) 23 53 27 10

PS: In one of my earlier mails (on another but similar thread in
this list) I argued against Marc Fleurys proposal of a 'mixed mode'
entity bean, where the bean is essentially CMP but the create methods
(and finders) are BMP. I must have been too tired at the time of
writing that, a 'mixed mode' would help a lot with autoincrements
and sequences. See
http://www.mail-archive.com/jboss-user@lists.sourceforge.net/msg04776.html



___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

RE: [JBoss-user] mySQL auto increment and CMP entity beans

2001-05-22 Thread Paul Austin


Georg,

The code I am using is as follows, I had thought of creating an additional
bean to do this but was wondering if there was an easier way.

  public Long ejbCreate(String name) throws CreateException, RemoteException
{
if (log.isInfoEnabled()) {
  StringBuffer s = new StringBuffer("ejbCreate\t");
  s.append(name);
  log.info(s);
}
this.name = name;
Timestamp timestamp = new Timestamp(new Date().getTime());
String user = "anonymous";
try {
  java.security.Principal p = entityContext.getCallerPrincipal();
  user = p.getName();
} catch (Exception e) {
}
this.creationDate = timestamp;
this.createdBy = user;
this.modificationDate = timestamp;
this.modifiedBy = user;
return null;
  }

The stack trace is as follows.

[Section] TRANSACTION ROLLBACK EXCEPTION:id may not be null; nested
exception is:
java.lang.Error: id may not be null
[Section] java.lang.Error: id may not be null
[Section]   at org.jboss.ejb.CacheKey.(CacheKey.java:51)
[Section]   at
org.jboss.ejb.plugins.EntityInstanceCache.createCacheKey(EntityInstanceCache
.java:47)
[Section]   at
org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManag
er.java:213)
[Section]   at
org.jboss.ejb.EntityContainer.createHome(EntityContainer.java:441)
[Section]   at java.lang.reflect.Method.invoke(Native Method)
[Section]   at
org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContaine
r.java:639)
[Section]   at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySync
hronizationInterceptor.java:160)
[Section]   at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInt
erceptor.java:87)
[Section]   at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
[Section]   at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.
java:263)
[Section]   at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
[Section]   at
org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.jav
a:164)
[Section]   at
org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
[Section]   at
org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
[Section]   at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContai
nerInvoker.java:436)
[Section]   at
org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:212)
[Section]   at $Proxy3.create(Unknown Source)
[Section]   at
com.nhigh.core.rp.data.section.ItemInsertUpdate.process(ItemInsertUpdate.jav
a:45)
[Section]   at
com.nhigh.virtualpage.VirtualPageServlet.callProcessors(VirtualPageServlet.j
ava:87)
[Section]   at
com.nhigh.virtualpage.VirtualPageServlet.processRequest(VirtualPageServlet.j
ava:68)
[Section]   at
com.nhigh.virtualpage.VirtualPageServlet.doPost(VirtualPageServlet.java:112)
[Section]   at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
[Section]   at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[Section]   at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
[Section]   at org.apache.tomcat.core.Handler.service(Handler.java:286)
[Section]   at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
[Section]   at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
7)
[Section]   at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
[Section]   at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java:166)
[Section]   at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
[Section]   at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
[Section]   at java.lang.Thread.run(Thread.java:484)

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Georg
Rehfeld
Sent: 22 May 2001 04:00
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] mySQL auto increment and CMP entity beans


Hi Paul,

> I am using jboss 2.2.1 to create a simple CMP entity bean that has two
> properties, id and name. In the database the id is an auto increment
> column. In the bean managed version of this bean I had a second sql
> (select ns.section_id from nh_section ns where ns.section_id is null)
> call to get the id of the row just added. In the CMP version I am not
> setting the id so on return from the ejbCreate method the container
> gives an exception saying the id cannot be null. Is there a way in
> container managed persistance beans to get jaws to find out the id of
> the inserted row and set the id property to this value.

Without a stack trace, I can't decide, if this really is the
container complaining about a NULL or if it i

Re: [JBoss-user] mySQL auto increment and CMP entity beans

2001-05-21 Thread Georg Rehfeld


Hi Paul,

> I am using jboss 2.2.1 to create a simple CMP entity bean that has two
> properties, id and name. In the database the id is an auto increment
> column. In the bean managed version of this bean I had a second sql
> (select ns.section_id from nh_section ns where ns.section_id is null)
> call to get the id of the row just added. In the CMP version I am not
> setting the id so on return from the ejbCreate method the container
> gives an exception saying the id cannot be null. Is there a way in
> container managed persistance beans to get jaws to find out the id of
> the inserted row and set the id property to this value.

Without a stack trace, I can't decide, if this really is the
container complaining about a NULL or if it is JAWS having
problems to insert the NULL.

But even without knowing that you might have a problem. JAWS seems
currently not to be able to do more than the default in create methods
(extracting the beans fields and executing a SQL insert from it), which
is a pitty. 

As of the EJB spec 1.1 section 9.5.2 figure 27 the CMP container
extracts the beans fields, stores them to the DB and constructs the
EJBObject (and thus the primary key object) immediately after return
from ejbCreate and before calling ejbPostCreate and so it only has the
opportunity to extract your beans public pk field at that point to fill
in the primary key classes field, which yields a NULL setting in the PK.

So ejbCreate with CMP is too early to access the DB for retrieval of
your autoincrement value (nothing is stored at that time) and
ejbPostCreate is too late, as the primary key object already is created.

If the exception is really thrown at the return of ejbCreate and isn't a
JAWS exception but a conainer exception, you don't have the opportunity
to try to set the autoincrement in ejbPostCreate into both, your beans
field and the PK objects field. Else you might try that (though I'm
totally unaware of the consequences, that looks not to be spec conform
to me).

What you might try is another approach (we use that with BMP): in
ejbCreate use some key generation mechanism to set your beans PK field,
a simple one, similar to your current approach, is to use a sequence
table with MySQL autoincrement values. The table has essentially 2
columns, one for the table name you want a new sequence value for and
another one defined to be autoincrementing and holding the next key to
use. This could be nicely hidden in some KeyGenerator class with some
method like getNextKey(String tableName). As of the EJB spec this should
be allowed, as the ejbCreate method may execute everything as a business
method may execute (except accessing EJBObject and the Primary Key).
Besides, have a look at theserverside.com for different key generation
patterns.

This key generator could be written as a BMP or as a stateless
session bean or even as a simple class.

regards

Georg
 ___   ___
| + | |__Georg Rehfeld  Woltmanstr. 12 20097 Hamburg
|_|_\ |___   [EMAIL PROTECTED]   +49 (40) 23 53 27 10




___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mySQL auto increment and CMP entity beans

2001-05-21 Thread Ivan Novick




I set the value to 0 in the create method and 
somehow MySQL makes the value the proper value uder the autoincrement.  
Seems to work, but makes me a little nervou.
 
Ivan

  - Original Message - 
  From: 
  Paul Austin 
  
  To: Jboss-User 
  Sent: Monday, May 21, 2001 9:19 AM
  Subject: [JBoss-user] mySQL auto 
  increment and CMP entity beans
  
  I am using jboss 
  2.2.1 to create a simple CMP entity bean that has two properties, id and name. 
  In the database the id is an auto increment column. In the bean managed 
  version of this bean I had a second sql (select ns.section_id from nh_section 
  ns where ns.section_id is null) call to get the id of the row just added. In 
  the CMP version I am not setting the id so on return from the ejbCreate method 
  the container gives an exception saying the id cannot be null. Is there a way 
  in container managed persistance beans to get jaws to find out the id of the 
  inserted row and set the id property to this value.
   
  Thanks,
  Paul
   
  Paul 
  Austin
  Viant
  Tel: 
  +44-20-7984-7158
  Fax: 
  +44-20-7984-7101
  AIM: PaustinViant
  YahooIM: p_d_austin
  JabberIM: paustin

Re: [JBoss-user] mysql configuration

2001-05-09 Thread Todd Chaffee


Here's the relevant parts of my jboss.jcml:




org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.id
bDriver,org.gjt.mm.mysql.Driver







EstoreDB
org.opentools.minerva.jdbc.xa.wrapper.XADa
taSourceImpl

jdbc:mysql://localhost:3306/petstore
120
root
10
parallax1
false
false
false
true
12
180
false
false
1.0
0



You'll also need to make sure that you copy the class containing
org.git.mm.mysql.Driver (or whatever driver you use) to the
$JBOSS_HOME/lib/ext directory. For example, I have a copy of
'mm.mysql-2.0.4-bin.jar' in my '/usr/local/jboss/ext/lib' 
directory.

Also, you don't need anything concerning mysql in your jboss.conf file or
jboss.properties file, so disregard anything in the docs about 
that.

Hope this helps.

- Todd Chaffee



At 04:35 PM 05/09/01 +0200, you wrote:
Anybody
have some configuration files for jboss and mysql that they would like to
share?
 
thanx in advance,
Jacob Andresen

RE: [JBoss-user] mysql configuration

2001-05-09 Thread Doyle, Steven


jboss.jcml see below
 
 


 

  
  
8083
  
 
  
  
1099
  
  
 

  
  
300
  
 
  
 
  
  
 
  
  
org.jboss.security.plugins.JaasSecurityManag
er
  
 
  
 
  
  
 org.gjt.mm.mysql.Driver
  
 
  
  
MySQLDS
org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l
jdbc:mysql://localhost/mydata
steve
password
  
 
  
 
  
true
false
true
false
  
 
  
 
  
 
  
  
  
DefaultJMSProvider
org.jboss.jms.jndi.JBossMQProvider
  
  
StdJMSPool
org.jboss.jms.asf.StdServerSessionPoolFactory
  
 

  
  
Default
:service=ContainerFactory
:service=EmbeddedTomcat
  
 
  
J2EE:service=J2eeDeployer
../deploy
  
 
  
  
  
 
  
  
MinervaNoTransCMFactory
org.opentools.minerva.connector.jboss.MinervaNoTransCMFa
ctory

  
 
  
  
MinervaSharedLocalCMFactory
org.opentools.minerva.connector.jboss.MinervaSharedLocal
CMFactory

  
 
  
  
MinervaXACMFactory
org.opentools.minerva.connector.jboss.MinervaXACMFactory


  
 
  
 
 
  
  
 
  
 
  
10

8082
  
 
  
  
Mail
mail.properties
user_id
password
  
 
  
 
  
 



-Original Message-
From: Jacob Andresen [mailto:[EMAIL PROTECTED]]
Sent: 09 May 2001 15:36
To: [EMAIL PROTECTED]
Subject: [JBoss-user] mysql configuration


Anybody have some configuration files for jboss and mysql that they would
like to share?
 
thanx in advance,
Jacob Andresen
 


___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

RE: [JBoss-user] MySQL and Minerva Exception

2001-04-23 Thread Ursini Sebastien


Hello Cory,
I had the same problem (NullPointerException) when the password is null.
Try to provide a password

Sebastien

> -Original Message-
> From: Cory Watson [SMTP:[EMAIL PROTECTED]]
> Sent: vendredi, 13. avril 2001 05:01
> To:   [EMAIL PROTECTED]
> Subject:  [JBoss-user] MySQL and Minerva Exception
> 
> Being terribly new to JBoss and all things related, I'll pre-apologize for
> 
> any stupid questions.  That said, here goes:
> 
> Carefully following the directions in the documentation, I get an
> exception 
> starting JBoss (2.2) after I setup MySQL's JDBC driver, and Minerva 
> entry.  Here's the output:
> 
> [mysqlDS] Starting
> [mysqlDS] XA Connection pool mysqlDS bound to java:/mysqlDS
> [mysqlDS] Stopped
> [mysqlDS] java.lang.NullPointerException
> [mysqlDS]   at 
> org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSou
> rce.java:165)
> [mysqlDS]   at 
> org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:330
> )
> [mysqlDS]   at 
> org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)
> [mysqlDS]   at java.lang.reflect.Method.invoke(Native Method)
> [mysqlDS]   at 
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
> [mysqlDS]   at 
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> [mysqlDS]   at
> org.jboss.util.ServiceControl.start(ServiceControl.java:97)
> [mysqlDS]   at java.lang.reflect.Method.invoke(Native Method)
> [mysqlDS]   at 
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
> [mysqlDS]   at 
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> [mysqlDS]   at org.jboss.Main.(Main.java:203)
> [mysqlDS]   at org.jboss.Main$1.run(Main.java:107)
> [mysqlDS]   at java.security.AccessController.doPrivileged(Native
> Method)
> [mysqlDS]   at org.jboss.Main.main(Main.java:103)
> [Service Control] Could not start 
> DefaultDomain:service=XADataSource,name=mySQLDB
> [Service Control] java.lang.NullPointerException
> [Service Control]   at 
> org.opentools.minerva.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSou
> rce.java:165)
> [Service Control]   at 
> org.jboss.jdbc.XADataSourceLoader.startService(XADataSourceLoader.java:330
> )
> [Service Control]   at 
> org.jboss.util.ServiceMBeanSupport.start(ServiceMBeanSupport.java:93)
> [Service Control]   at java.lang.reflect.Method.invoke(Native Method)
> [Service Control]   at 
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
> [Service Control]   at 
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> [Service Control]   at 
> org.jboss.util.ServiceControl.start(ServiceControl.java:97)
> [Service Control]   at java.lang.reflect.Method.invoke(Native Method)
> [Service Control]   at 
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
> [Service Control]   at 
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
> [Service Control]   at org.jboss.Main.(Main.java:203)
> [Service Control]   at org.jboss.Main$1.run(Main.java:107)
> [Service Control]   at 
> java.security.AccessController.doPrivileged(Native Method)
> [Service Control]   at org.jboss.Main.main(Main.java:103)
> 
> All the JDBC stuff seems to be working just fine, up to that point.  I'm 
> perusing Minerva's source to go to that exactly line, but I dead end at 
> that point ;)  Any ideas??  I've verified through other means that the 
> connection _can_ be made, the URL looks fine, the  user has connection 
> rights...
> 
> Cory 'G' Watson
> 
> 
> 
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

RE: [JBoss-user] MySql and JBoss

2001-04-02 Thread Swarr, Bob


Currently, I'm running JBoss 2.0 with the Oracle thin driver and the
mm.mysql-2.0.4 driver.
The main problem I had setting up mySQL as a datasource was setting up users
and priveleges in mySQL.  Read the mySQL documentation carefully.

Here are my configuration entries.

jboss.properities
 jdbc.drivers=org.gjt.mm.mysql.Driver,oracle.jdbc.driver.OracleDriver

jboss.conf








jboss.jcml
 
   
   jdbc:mysql://localhost/store
   120
   store
   32
   manager
   false
   false
   false
   true
   12
   180
   false
   false
   1.0
   32
 

-Original Message-
From: Steven Webster [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 31, 2001 1:34 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] MySql and JBoss


Hi all,

I'm having a real hard time trying to get JBoss working with MySQL; 
reading through the list archives, all I can really ascertain is that
the docs are not necessarily correct with regards to setting up JBoss.

Has anyone successfully setup JBoss with MySql, that could perhaps
send me the various entries they've made in the properties, conf and
jcml files, to get things working ?  I've got the driver installed ok,
and checked it works with some simple JDBC client code (non EJB code).

As an aside; in looking for the answer, I've noticed a few people
allude to the jboss.conf file being deprecated, in preference for
the jboss.jcml file - is this the case ?

Also; when I make changes for logging to the .jcml file, including 
adding the GUI Logger (I guess I'm answering my own question from
earlier today), the changes don't seem to take immediate effect...how
often are these files read, and are they parsed into a cached format
in any way, shape or form ??

Help :)

Steven

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySql and JBoss

2001-03-31 Thread danch


Brian Elliott wrote:

> Steven Webster wrote:
> 
>> I'm having a real hard time trying to get JBoss working with MySQL;
>> reading through the list archives, all I can really ascertain is that
>> the docs are not necessarily correct with regards to setting up JBoss.
>> 
>> Has anyone successfully setup JBoss with MySql, that could perhaps
>> send me the various entries they've made in the properties, conf and
>> jcml files, to get things working ?  I've got the driver installed ok,
>> and checked it works with some simple JDBC client code (non EJB code).
> 
> 
> I just got this working this week with the help of people on this list.
> I am using JBoss 2.0. For newer versions check the documentation. But
> for JBoss2.0, I made the following changes:
> 
> 1) jboss.conf:
> 
> 
>jdbc.drivers=org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,org.gjt.mm.mysql.Driver
> 
> Note: Although I just saw Danch say in his latest email that this is not
> needed, "Do Nothing to jboss.properties or jboss.conf".
Just to clarify: my earlier email was JBoss 2.1 specific. That _was_ needed under 
JBoss 2.0

-danch


___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySql and JBoss

2001-03-31 Thread Brian Elliott


Steven Webster wrote:
> I'm having a real hard time trying to get JBoss working with MySQL;
> reading through the list archives, all I can really ascertain is that
> the docs are not necessarily correct with regards to setting up JBoss.
> 
> Has anyone successfully setup JBoss with MySql, that could perhaps
> send me the various entries they've made in the properties, conf and
> jcml files, to get things working ?  I've got the driver installed ok,
> and checked it works with some simple JDBC client code (non EJB code).

I just got this working this week with the help of people on this list.
I am using JBoss 2.0. For newer versions check the documentation. But
for JBoss2.0, I made the following changes:

1) jboss.conf:

jdbc.drivers=org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,org.gjt.mm.mysql.Driver

Note: Although I just saw Danch say in his latest email that this is not
needed, "Do Nothing to jboss.properties or jboss.conf".

2) jboss.jcml:


   
   jdbc:mysql://www.host_name_here.com:3306/mls
   120
   user_goes_here
   10
   password_goes_here
   false
   false
   false
   true
   12
   180
   false
   false
   1.0
   0
 

3) In my session bean:

 // Get database connection from pool
 Connection conn = null;
 Statement stmt = null;
 ResultSet set = null;
 try {

DataSource ds = (DataSource)(new InitialContext()).lookup(
"java:/mySQL");
conn = ds.getConnection();
set = stmt.executeQuery(query);

while (set.next()) {
. sql processing
 }

 }
 catch (SQLException e){
System.out.println("SQL statement exception");
 } 
 catch (javax.naming.NamingException e){
System.out.println("NamingException");
 } 
 finally {
   if (conn != null) try {conn.close();}catch (SQLException ignore)
{}
   if (stmt != null) try {stmt.close();}catch (SQLException ignore2)
{}
   if (set != null) try {set.close();}catch (SQLException ignore3)
{}
 }

4) In mySQL make sure that you grant the right permissions to the user
and allow the right host.

Hope this helps,

Brian
-- 
Brian Elliott
Unplugged Systems
[EMAIL PROTECTED]
http://www.unpluggedsystems.com

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySql and JBoss

2001-03-31 Thread Jan Petersen


On Saturday 31 March 2001 20:33, you wrote:

Maybe it could help you see what worked for me (although this is with 
PostgreSQL). Look at Alexander Jerusalems answer: "Re: [JBoss-user] JBoss and 
PostgreSQL problems"

Regards

Jan Petersen

> Hi all,
>
> I'm having a real hard time trying to get JBoss working with MySQL;
> reading through the list archives, all I can really ascertain is that
> the docs are not necessarily correct with regards to setting up JBoss.
>
> Has anyone successfully setup JBoss with MySql, that could perhaps
> send me the various entries they've made in the properties, conf and
> jcml files, to get things working ?  I've got the driver installed ok,
> and checked it works with some simple JDBC client code (non EJB code).
>
> As an aside; in looking for the answer, I've noticed a few people
> allude to the jboss.conf file being deprecated, in preference for
> the jboss.jcml file - is this the case ?
>
> Also; when I make changes for logging to the .jcml file, including
> adding the GUI Logger (I guess I'm answering my own question from
> earlier today), the changes don't seem to take immediate effect...how
> often are these files read, and are they parsed into a cached format
> in any way, shape or form ??
>
> Help :)
>
> Steven
>
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] MySql and JBoss

2001-03-31 Thread danch


Steven Webster wrote:

> Hi all,
> 
> I'm having a real hard time trying to get JBoss working with MySQL; 
> reading through the list archives, all I can really ascertain is that
> the docs are not necessarily correct with regards to setting up JBoss.
There's some JBoss 2.0 related stuff that's no longer accurate.

> 
> Has anyone successfully setup JBoss with MySql, that could perhaps
> send me the various entries they've made in the properties, conf and
> jcml files, to get things working ?  I've got the driver installed ok,
> and checked it works with some simple JDBC client code (non EJB code).
Sorry, I'm not a MySQL person, so I can't give you precise settings, but 
in general:
1. Do Nothing to jboss.properties or jboss.conf
2. Add your driver to the JdbcProvider mbean in jboss.jcml
3. Add a XADataSource mbean (or modify an existing one) to jboss.jcml. 
Use the DefaultDS one as a template. You should only need to change the 
URL, JDBCUser, and Password attributes to get it working.

Beware, you _may_ need to delete jboss-auto.jcml, expecially if you 
chane an existing mbean.

> 
> As an aside; in looking for the answer, I've noticed a few people
> allude to the jboss.conf file being deprecated, in preference for
> the jboss.jcml file - is this the case ?
It isn't deprecated, exactly, it's just that it doesn't need to be 
modified much anymore. It's used as a bootstrap to get some of the base 
JBoss MBeans up and running, then they take over and load the mbeans 
specified in jboss.jcml, the jboss-auto.jcml (or some variant of that order)

> 
> Also; when I make changes for logging to the .jcml file, including 
> adding the GUI Logger (I guess I'm answering my own question from
> earlier today), the changes don't seem to take immediate effect...how
> often are these files read, and are they parsed into a cached format
> in any way, shape or form ??
They're only read at startup. If you point a browser at port 8082 of the 
machine JBoss is running on, however, you'll get a crude web interface 
allowing you to change things on the fly. Things changed here wind up in 
jboss-auto.jcml.

I hope this helps,
danch


___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Re: [JBoss-user] mysql naming issue

2001-03-19 Thread Tobias Frech

Hi Basit!
Did you provide a jndi.properties file ?  Place it into a directory
where it could be found via the classpath. My personal favorite is the
working directory from where I issue the client start command. Also be
careful NOT to include a JAR file into the classpath that does contain
another jndi.properties. Otherwise the order of the entries in the
classpath will matter (which jndi.properties is found first ?) which I
consider as a bad thing. E.g. j2ee.jar from SUN does contain a
jndi.properties file. So do not include this one.

My jndi.properties looks like this:

java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory
java.naming.provider.url=localhost
java.naming.factory.url.pkgs=org.jboss.naming

Did this help ?

Cheers,
Tobias

Basit wrote:
> 
> hey
> i was trying ds = (DataSource) new InitialContext().lookup("java:/mySQL");
>  conn = ds.getConnection(); in my entity bean code.
> 
> when i run client , it prompts Provider URL missing ,
> javax.naming.ConfigurationException
> 
> mysql is running smoothly ..
> my client code is as under
> 
> 
> InitialContext jndiContext = new InitialContext();
> System.out.println("Got context ..");
> Object ref = jndiContext.lookup("java:/mySQL");
> System.out.println("got reference");
> 
> it prints Got context and but at Object ref = 
> it throws NamingException - PRovider url missing
> 
> any tip ?
> 
> -=0 Basit
> 
> ___
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user

___
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

85 matches

Mail list logo